[teiid-issues] [JBoss JIRA] Resolved: (TEIID-1630) XQT queries failing with: [TeiidProcessingException] 1054: Error Code:1054 Message:Source: Error Code:1054 Message:'Unknown column 'c_2' in 'order clause'

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 Fix For: 7.4.1 Attachments: QT_MySql50_Push.vdb 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