ORA-32039: recursive WITH clause must have column alias list in JDV
Issue
- running a query that defines a
WITH tbl
matching the existingschema
or an existingtable
name.
WITH < existing schema or table name collision > AS (...
server.log
entries similar to
WARN [org.teiid.PROCESSOR] (Worker1_QueryProcessorQueue20) TEIID30020 Processing exception for request JURZQH4w8DPj.9 'TEIID30504 <model>: 32039 TEIID11008:TEIID11004 Error executing statement(s): [SQL: WITH ...
...
Caused by: java.sql.SQLException: ORA-32039: recursive WITH clause must have column alias list
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:195)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:876)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1498)
at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406)
at org.jboss.jca.adapters.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:344)
at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:119)
Environment
- Red Hat JBoss Data Virtualization 6
- Oracle 11
- TEIID-4112
- Oracle BUG 18460364 - ORA-32039: RECURSIVE WITH ERROR SUBJECT TO THE NAMES USED IN DATABASE SCHEMA VER
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.