[teiid-issues] [JBoss JIRA] Created: (TEIID-1630) XQT queries failing with: [TeiidProcessingException] 1054: Error Code:1054 Message:Source: Error Code:1054 Message:'Unknown column 'c_2' in 'order clause'
Warren Gibson (JIRA)
jira-events at lists.jboss.org
Thu Jun 9 10:29:59 EDT 2011
XQT queries failing with: [TeiidProcessingException] 1054: Error Code:1054 Message:Source: Error Code:1054 Message:'Unknown column 'c_2' in 'order clause'
-----------------------------------------------------------------------------------------------------------------------------------------------------------
Key: TEIID-1630
URL: https://issues.jboss.org/browse/TEIID-1630
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.5
Environment: Teiid 7.5-Alpha1
Reporter: Warren Gibson
Assignee: Steven Hawkins
The following 4 XQT queries are failing query testing in MySQL50 and Teradata. I suspect they are failing in all sources.
SELECT * FROM XQTDoc.defaultValueTestDocument ORDER BY XQTDoc.defaultValueTestDocument.defaultValueTest.wrapper.data,
XQTDoc.defaultValueTestDocument.defaultValueTest.wrapper.key
SELECT * FROM XQTDoc.defaultValueTestDocument ORDER BY XQTDoc.defaultValueTestDocument.defaultValueTest.wrapper.data
DESC,XQTDoc.defaultValueTestDocument.defaultValueTest.wrapper.key
SELECT * FROM XQTDoc.defaultValueTestDocument ORDER BY XQTDoc.defaultValueTestDocument.defaultValueTest.wrapper.key,
XQTDoc.defaultValueTestDocument.defaultValueTest.wrapper.data
SELECT * FROM XQTDoc.defaultValueTestDocument ORDER BY XQTDoc.defaultValueTestDocument.defaultValueTest.wrapper.key ASC,
XQTDoc.defaultValueTestDocument.defaultValueTest.wrapper.data DESC
2011-06-09 09:16:20,342 DEBUG [org.teiid.PROCESSOR] (Worker8_QueryProcessorQueue24551) Sending error to client 9G7rbfezeXon.0
[TeiidProcessingException] 1054: Error Code:1054 Message:Source: Error Code:1054 Message:'Unknown column 'c_2' in 'order clause'' error executing statement(s): [Prepared Values: [] SQL: SELECT cast(g_1.INTNUM AS signed) AS c_0, cast(g_0.INTKEY AS signed) AS c_1 FROM smalla AS g_0, smallb AS g_1 WHERE cast(g_0.INTKEY AS signed) = cast(g_1.INTKEY AS signed) ORDER BY c_2, c_1]
1 [JDBCExecutionException] 1054: Error Code:1054 Message:'Unknown column 'c_2' in 'order clause'' error executing statement(s): [Prepared Values: [] SQL: SELECT cast(g_1.INTNUM AS signed) AS c_0, cast(g_0.INTKEY AS signed) AS c_1 FROM smalla AS g_0, smallb AS g_1 WHERE cast(g_0.INTKEY AS signed) = cast(g_1.INTKEY AS signed) ORDER BY c_2, c_1]
2 [MySQLSyntaxErrorException]Unknown column 'c_2' in 'order clause'
at org.teiid.dqp.internal.process.DataTierTupleSource.exceptionOccurred(DataTierTupleSource.java:414)
at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:241)
at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:262)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:275)
at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:162)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:138)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:104)
at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:70)
at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:69)
at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:82)
at org.teiid.common.buffer.AbstractTupleSource.hasNext(AbstractTupleSource.java:91)
at org.teiid.query.processor.xml.RelationalPlanExecutor.execute(RelationalPlanExecutor.java:98)
at org.teiid.query.processor.xml.ExecSqlInstruction.process(ExecSqlInstruction.java:59)
at org.teiid.query.processor.xml.XMLPlan.nextBatch(XMLPlan.java:161)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:138)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:104)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146)
at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:306)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:234)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:56)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:636)
Caused by: [JDBCExecutionException] 1054: Error Code:1054 Message:'Unknown column 'c_2' in 'order clause'' error executing statement(s): [Prepared Values: [] SQL: SELECT cast(g_1.INTNUM AS signed) AS c_0, cast(g_0.INTKEY AS signed) AS c_1 FROM smalla AS g_0, smallb AS g_1 WHERE cast(g_0.INTKEY AS signed) = cast(g_1.INTKEY AS signed) ORDER BY c_2, c_1]
1 [MySQLSyntaxErrorException]Unknown column 'c_2' in 'order clause'
at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:90)
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:264)
at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:340)
at org.teiid.dqp.internal.process.DataTierTupleSource.access$000(DataTierTupleSource.java:82)
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:140)
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:137)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
... 6 more
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'c_2' in 'order clause'
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1467)
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:342)
at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:86)
... 13 more
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
More information about the teiid-issues
mailing list