Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1509928

Summary:	Osisoft translator - NPE when running query with LATERAL JOIN
Product:	[JBoss] JBoss Data Virtualization 6	Reporter:	Andrej Smigala <asmigala>
Component:	Documentation	Assignee:	David Le Sage <dlesage>
Status:	CLOSED WONTFIX	QA Contact:	Jan Stastny <jstastny>
Severity:	high	Docs Contact:
Priority:	high
Version:	6.4.0	CC:	blafond, dlesage, drieden, gjospin, jolee, jschatte, thauser, vhalbert
Target Milestone:	GA	Keywords:	Documentation
Target Release:	6.4.0
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	If docs needed, set a value
Doc Text:	If you attempt to perform a lateral join in a SQL statement run against the Osisoft PI translator, you will encounter an exception. This is because Osisoft requires table value functions for lateral joins to work.	Story Points:	---
Clone Of:		Environment:
Last Closed:	2018-02-01 08:20:50 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Andrej Smigala 2017-11-06 11:09:31 UTC

Running the following query:

SELECT bqt2.smalla.intkey, g2.intkey, bqt2.smalla.bytenum FROM bqt2.smalla LEFT JOIN LATERAL (SELECT intkey FROM bqt2.mediuma WHERE bqt2.smalla.bytenum = bqt2.mediuma.bytenum) AS g2 ON true

results in a NPE in teiid (before sending source src command).

See JIRA for more details.

Comment 2 David Le Sage 2017-11-27 22:59:42 UTC

Documented as a known issue in release notes errata.