Bug 1509928 – Osisoft translator - NPE when running query with LATERAL JOIN

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

Bug 1509928 - Osisoft translator - NPE when running query with LATERAL JOIN

Summary:	Osisoft translator - NPE when running query with LATERAL JOIN

Status:	CLOSED WONTFIX

Aliases:	None

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

Priority	high Severity high
Target Milestone:	GA
Target Release:	6.4.0
Assigned To:	David Le Sage
QA Contact:	Jan Stastny
Docs Contact:

URL:
Whiteboard:
Keywords:	Documentation

Depends On:
Blocks:
	Show dependency tree / graph

Reported:	2017-11-06 06:09 EST by Andrej Smigala
Modified:	2018-02-01 03:20 EST (History)
CC List:	8 users (show)

See Also:
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 03:20:50 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-5136	Major	Resolved	Osisoft translator - NPE when running query with inline view	2018-03-08 02:17 EST

Groups: None (edit)

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

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 17:59:42 EST

Documented as a known issue in release notes errata.

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