Bug 1326833 - Oracle requires column alias list when using recursive CTE
Summary: Oracle requires column alias list when using recursive CTE
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: JBoss Data Virtualization 6
Classification: JBoss
Component: Teiid
Version: 6.3.0
Hardware: Unspecified
OS: Unspecified
medium
high
Target Milestone: ER3
: 6.3.0
Assignee: Van Halbert
QA Contact: Andrej Smigala
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2016-04-13 13:36 UTC by Andrej Smigala
Modified: 2016-08-24 11:40 UTC (History)
6 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2016-08-24 11:40:48 UTC
Type: Bug
Embargoed:

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker TEIID-4134 0 Major Closed Oracle requires column alias list when using recursive CTE 2016-06-05 23:43:59 UTC

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