ORA-32039: recursive WITH clause must have column alias list in JDV

Solution Verified - Updated -

Issue

  • running a query that defines a WITH tbl matching the existing schema or an existing table 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.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content