Bug 1347309

Summary: NPE when CTE and subuquery without a WITH clause are pushed together
Product: [JBoss] JBoss Data Virtualization 6 Reporter: Andrej Smigala <asmigala>
Component: TeiidAssignee: Van Halbert <vhalbert>
Status: CLOSED CURRENTRELEASE QA Contact: Andrej Smigala <asmigala>
Severity: high Docs Contact:
Priority: high    
Version: 6.3.0CC: aszczucz, blafond, jolee, lfabriko, mbaluch, thauser, vhalbert
Target Milestone: ER5   
Target Release: 6.3.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2016-08-24 11:42:13 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 2016-06-16 13:45:44 UTC 
With a query such as:

WITH qry_0 as /*+ no_inline */ (SELECT e2 AS a1, e1 as str FROM pm1.g1 AS t) select (select e1 from pm1.g1) as x, a1 from qry_0

that is pushed together to the source, the relationalplanner will throw an NPE when pulling up any nested with clauses because there is no with clause assigned to the subquery.
Comment 2 JBoss JIRA Server 2016-06-16 15:21:11 UTC 
Steven Hawkins <shawkins> updated the status of jira TEIID-4272 to Resolved
Comment 3 JBoss JIRA Server 2016-07-03 23:47:25 UTC 
Steven Hawkins <shawkins> updated the status of jira TEIID-4272 to Closed