ORA-32039: recursive WITH clause must have column alias list in JDV
Issue
- running a query that defines a
WITH tblmatching the existingschemaor an existingtablename.
WITH < existing schema or table name collision > AS (...
server.logentries 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 of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
