[teiid-issues] [JBoss JIRA] (TEIID-4112) ORA-32039: recursive WITH clause must have column alias list

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4112?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13195471#comment-13195471 ] 

Steven Hawkins commented on TEIID-4112:
---------------------------------------

for 11.2.0.2 specifying the column list just results in another error, so the fix here will be to prevent or rename the cte based upon detecting the source schema name.

> ORA-32039: recursive WITH clause must have column alias list
> ------------------------------------------------------------
>
>                 Key: TEIID-4112
>                 URL: https://issues.jboss.org/browse/TEIID-4112
>             Project: Teiid
>          Issue Type: Bug
>    Affects Versions: 8.7.2.6_2
>            Reporter: Debbie Steigner
>            Assignee: Steven Hawkins
>
> If running a WITH table AS(...) query to Oracle and the query schema name is the same as the subquery name i.e. EWI.  you receive the Oracle error:
> ORA-32039: recursive WITH clause must have column alias list
> If you modify the query to 
> WITH EWI1 AS ....
> then it works.
> f.ex:
> breaking:       WITH tbl AS (
> where tbl = a common table name in the current schema and the common table definition as (...) references a view in that schema. Oracle will complain with this erroneous error.  
> work-around: WITH tbl_1 AS(
> where tbl_1 does not exist as a current schema/table name.



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)