[
https://issues.jboss.org/browse/TEIID-4112?page=com.atlassian.jira.plugin...
]
Johnathon Lee updated TEIID-4112:
---------------------------------
Workaround Description: change the name of the table defined via 'WITH tbl' to
a table/schema name that does not exist in the current schema (was: change the name of
the table defined via 'WITH tb' to a table/schema name that does not exist in the
current schema)
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)