Bug 1530236 – Osisoft translator - correlated subquery on HAVING clause fails

Bugzilla will be upgraded to version 5.0. The upgrade date is tentatively scheduled for 2 December 2018, pending final testing and feedback.

Bug 1530236 - Osisoft translator - correlated subquery on HAVING clause fails

Summary:	Osisoft translator - correlated subquery on HAVING clause fails

Status:	CLOSED WONTFIX

Aliases:	None

Product:	JBoss Data Virtualization 6
Classification:	JBoss
Component:	Teiid, Documentation (Show other bugs)
Sub Component:
Version:	6.4.0
Hardware:	Unspecified Unspecified

Priority	high Severity high
Target Milestone:	CR5
Target Release:	6.4.0
Assigned To:	David Le Sage
QA Contact:	Andrej Smigala
Docs Contact:

URL:
Whiteboard:
Keywords:	Documentation

Depends On:
Blocks:
	Show dependency tree / graph

Reported:	2018-01-02 05:54 EST by Andrej Smigala
Modified:	2018-02-27 05:30 EST (History)
CC List:	8 users (show)

See Also:
Fixed In Version:
Doc Type:	If docs needed, set a value
Doc Text:	Running a query with a correlated subquery in a HAVING clause fails on the data source with an exception. This is due to an issue with the Osisoft PI data source.
Story Points:	---
Clone Of:
Environment:
Last Closed:	2018-02-18 23:34:33 EST
Type:	Bug
Regression:	---
Mount Type:	---
Documentation:	---
CRM:
Verified Versions:
Category:	---
oVirt Team:	---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---

Attachments	(Terms of Use)
Add an attachment (proposed patch, testcase, etc.)

External Trackers
Tracker	ID	Priority	Status	Summary	Last Updated
JBoss Issue Tracker	TEIID-5193	Major	Resolved	Osisoft translator - correlated subquery on HAVING clause fails	2018-03-12 18:25 EDT

Groups: None (edit)

Description Andrej Smigala 2018-01-02 05:54:35 EST

Running a query with a correlated subquery in a HAVING clause, such as

SELECT INTKEY, STRINGKEY FROM BQT1.SMALLA AS A WHERE NOT (INTKEY IN (10)) GROUP BY INTKEY, STRINGKEY HAVING INTKEY = (SELECT MIN(STRINGKEY) FROM BQT1.SMALLA AS B WHERE A.INTKEY = B.INTKEY) 

fails on the datasource with

    com.osisoft.rdsa.RdsaException: [PIOLEDBENT] HAVING condition cannot be nonaggregate.

This seems to be an issue on the Osisoft PI datasource side, as running the query directly against the datasource produces the same failure.

Comment 2 Andrej Smigala 2018-01-09 09:29:25 EST

You're right, but I think it's still worth documenting as a known issue.

Comment 7 David Le Sage 2018-02-18 23:12:04 EST

Release note drafted.

Comment 8 David Le Sage 2018-02-18 23:34:33 EST

Release note added.
Engineering aspect set to WONTFIX for this release.

Note You need to log in before you can comment on or make changes to this bug.