]
RH Bugzilla Integration commented on TEIID-4134:
------------------------------------------------
Andrej Smigala <asmigala(a)redhat.com> changed the Status of [bug
Oracle requires column alias list when using recursive CTE
----------------------------------------------------------
Key: TEIID-4134
URL:
https://issues.jboss.org/browse/TEIID-4134
Project: Teiid
Issue Type: Bug
Components: JDBC Connector
Affects Versions: 8.12.x
Reporter: Andrej Šmigala
Assignee: Steven Hawkins
Fix For: 9.0, 8.12.5
Running a recursive common table expression query against an Oracle source removes the
columns alias list, which causes {noformat}ORA-32039: recursive WITH clause must have
column alias list{noformat}
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.