[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'
4:29 p.m.
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
4:56 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1630) XQT queries failing with: [TeiidProcessingException] 1054: Error Code:1054 Message:Source: Error Code:1054 Message:'Unknown column 'c_2' in 'order clause'
[
https://issues.jboss.org/browse/TEIID-1630?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-1630:
---------------------------------------
can you attach the vdb?
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
5:26 p.m.
New subject: [JBoss JIRA] Updated: (TEIID-1630) XQT queries failing with: [TeiidProcessingException] 1054: Error Code:1054 Message:Source: Error Code:1054 Message:'Unknown column 'c_2' in 'order clause'
[
https://issues.jboss.org/browse/TEIID-1630?page=com.atlassian.jira.plugin...
]
Warren Gibson updated TEIID-1630:
---------------------------------
Attachment: QT_MySql50_Push.vdb
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
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
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:28 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1630) XQT queries failing with: [TeiidProcessingException] 1054: Error Code:1054 Message:Source: Error Code:1054 Message:'Unknown column 'c_2' in 'order clause'
[
https://issues.jboss.org/browse/TEIID-1630?page=com.atlassian.jira.plugin...
]
Warren Gibson commented on TEIID-1630:
--------------------------------------
MySql50 vdb attached.
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
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
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
6:28 p.m.
New subject: [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'
[
https://issues.jboss.org/browse/TEIID-1630?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-1630.
-----------------------------------
Fix Version/s: 7.4.1
Resolution: Done
This was due to final project minimization not correcting the order by 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
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:12 p.m.
New subject: [JBoss JIRA] Updated: (TEIID-1630) XQT queries failing with: [TeiidProcessingException] 1054: Error Code:1054 Message:Source: Error Code:1054 Message:'Unknown column 'c_2' in 'order clause'
[
https://issues.jboss.org/browse/TEIID-1630?page=com.atlassian.jira.plugin...
]
Steven Hawkins updated TEIID-1630:
----------------------------------
Fix Version/s: 7.5
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, 7.5
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
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:24 p.m.
New subject: [JBoss JIRA] (TEIID-1630) XQT queries failing with: [TeiidProcessingException] 1054: Error Code:1054 Message:Source: Error Code:1054 Message:'Unknown column 'c_2' in 'order clause'
[
https://issues.jboss.org/browse/TEIID-1630?page=com.atlassian.jira.plugin...
]
Steven Hawkins closed TEIID-1630.
---------------------------------
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, 7.5
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
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
4595
days inactive
4769
days old
6 comments
3 participants
participants (3)
-
Steven Hawkins (Closed) (JIRA) -
Steven Hawkins (JIRA)
-
Warren Gibson (JIRA)