[teiid-issues] [JBoss JIRA] (TEIID-2459) WITH statement translated wrongly for Oracle 10

[Filip Nguyen (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-2459?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Filip Nguyen updated TEIID-2459:
--------------------------------

    Affects Version/s: 7.7.4

    
> WITH statement translated wrongly for Oracle 10 
> ------------------------------------------------
>
>                 Key: TEIID-2459
>                 URL: https://issues.jboss.org/browse/TEIID-2459
>             Project: Teiid
>          Issue Type: Bug
>    Affects Versions: 7.7.4
>            Reporter: Filip Nguyen
>            Assignee: Steven Hawkins
>
> I am using Oracle 10g [1] and I have set the Oracle version to 9.2 in a dynamic VDB [2].
> I am running simple WITH statement against Oracle: WITH x AS (select DATEVALUE from SMALLA) select DATEVALUE from x. Which throws [3]. Probably because Oracle 10 doesn't support column aliasing "WITH x (DATEVALUE)".
> [1] Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
> With the Partitioning, OLAP and Data Mining options
> [2]   <property name="DatabaseVersion" value="9.2" /> 
> [3] Caused by: org.teiid.translator.TranslatorException: Error Code:32033 Message:Remote org.teiid.translator.jdbc.JDBCExecutionException: Error Code:32033 Message:'ORA-32033: unsupported column aliasing
> ' error executing statement(s): [Prepared Values: [] SQL: WITH x (DATEVALUE) AS (SELECT g_0."DATEVALUE" FROM "BQT2_RO"."SMALLA" g_0) SELECT g_0.DATEVALUE FROM x g_0]

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira