Bug 1326833

Summary: Oracle requires column alias list when using recursive CTE
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: medium    
Version: 6.3.0CC: aszczucz, blafond, jolee, mbaluch, thauser, vhalbert
Target Milestone: ER3   
Target Release: 6.3.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2016-08-24 11:40:48 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:

Description Andrej Smigala 2016-04-13 13:36:55 UTC 
Running a recursive common table expression query against an Oracle source removes the columns alias list, which causes

ORA-32039: recursive WITH clause must have column alias list

Note that there might be an issue with some specific versions of Oracle 11g, the columns alias list is required 11.2.0.4, but might not be in 11.2.0.2.
Comment 2 JBoss JIRA Server 2016-04-15 18:54:21 UTC 
Steven Hawkins <shawkins> updated the status of jira TEIID-4134 to Resolved
Comment 3 JBoss JIRA Server 2016-06-05 23:43:59 UTC 
Steven Hawkins <shawkins> updated the status of jira TEIID-4134 to Closed