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.