Filip Nguyen created TEIID-2459:
-----------------------------------
Summary: WITH statement translated wrongly for Oracle 10
Key: TEIID-2459
URL:
https://issues.jboss.org/browse/TEIID-2459
Project: Teiid
Issue Type: Bug
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