Bug 1509928 - Osisoft translator - NPE when running query with LATERAL JOIN
Summary: Osisoft translator - NPE when running query with LATERAL JOIN
Keywords:
Status: CLOSED WONTFIX
Alias: None
Product: JBoss Data Virtualization 6
Classification: JBoss
Component: Documentation
Version: 6.4.0
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: GA
: 6.4.0
Assignee: David Le Sage
QA Contact: Jan Stastny
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2017-11-06 11:09 UTC by Andrej Smigala
Modified: 2018-02-01 08:20 UTC (History)
8 users (show)

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.
Clone Of:
Environment:
Last Closed: 2018-02-01 08:20:50 UTC
Type: Bug
Embargoed:

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker TEIID-5136 0 Major Resolved Osisoft translator - NPE when running query with inline view 2018-03-08 07:17:57 UTC

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.
Note You need to log in before you can comment on or make changes to this bug.