[teiid-issues] [JBoss JIRA] (TEIID-4112) ORA-32039: recursive WITH clause must have column alias list
[
https://issues.jboss.org/browse/TEIID-4112?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-4112.
-----------------------------------
Fix Version/s: 9.0
Resolution: Done
Added a specific translator property for this - ExcludedCommonTableExpressionName
It is currently only useful when certain with clauses are being pushed to oracle 11.2.0.2
- other later oracle versions should not be affected by this issues (we can follow up on
their undocumented bug to get a full understanding of when this can occur).
The logic will also in general allow us to remap common table expression names should we
ever need to do that more generally.
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
Components: JDBC Connector, Query Engine
Affects Versions: 8.7.2.6_2
Reporter: Debbie Steigner
Assignee: Steven Hawkins
Fix For: 9.0
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)