August 2011 - teiid-issues - Jboss List Archives

[JBoss JIRA] Created: (TEIID-1495) Validate the TeraData Translator

by Ramesh Reddy (JIRA)

Validate the TeraData Translator -------------------------------- Key: TEIID-1495 URL: https://issues.jboss.org/browse/TEIID-1495 Project: Teiid Issue Type: Task Components: JDBC Connector Affects Versions: 7.3 Reporter: Ramesh Reddy Fix For: 7.4 Currently the Teiid does provide a Teradata translator, however it has been taken from the old MMX code, however it was never validated with Teiid to make sure this works correctly with the data source. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 9 months

2
3
0 / 0

[JBoss JIRA] Created: (TEIID-1323) Add support for pushdown of non-literal procedure parameter expressions.

by Steven Hawkins (JIRA)

Add support for pushdown of non-literal procedure parameter expressions. ------------------------------------------------------------------------ Key: TEIID-1323 URL: https://jira.jboss.org/browse/TEIID-1323 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 7.2 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.0 We are forcing all push-down procedure arguments to be literals (for simplicity), when all expressions should be allowed. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 10 months

2
3
0 / 0

[JBoss JIRA] Created: (TEIID-1679) The parser should parse identifier parts separately

by Steven Hawkins (JIRA)

The parser should parse identifier parts separately --------------------------------------------------- Key: TEIID-1679 URL: https://issues.jboss.org/browse/TEIID-1679 Project: Teiid Issue Type: Quality Risk Components: Query Engine Affects Versions: 8.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Minor Fix For: 8.0 The parser currently uses tokens to represent identifiers and all in group. Technically . should be a token. This would be a breaking change - something like order.*, would be forced to be entered as "order".* -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 10 months

3
2
0 / 0

[JBoss JIRA] Created: (TEIID-1450) The weather example test queries for SOAP/REST are unexecutable, as is, in README.txt file.

by Van Halbert (JIRA)

The weather example test queries for SOAP/REST are unexecutable, as is, in README.txt file. ------------------------------------------------------------------------------------------- Key: TEIID-1450 URL: https://issues.jboss.org/browse/TEIID-1450 Project: Teiid Issue Type: Bug Components: Build/Kits Affects Versions: 7.1.1 Reporter: Van Halbert Assignee: Steven Hawkins Priority: Blocker The test queries in the README.txt are invalid for execution, as is. And when the new line and tab characters are removed, they still don't work. Need queries that can be cut and pasted (without editing) for a RHEL OS shell script. -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 10 months

4
7
0 / 0

[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'

by Warren Gibson (JIRA)

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

12 years, 10 months

3
6
0 / 0

[JBoss JIRA] Created: (TEIID-1717) NPE with texttable join

by Steven Hawkins (JIRA)

NPE with texttable join ----------------------- Key: TEIID-1717 URL: https://issues.jboss.org/browse/TEIID-1717 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.1.1 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.4.1, 7.5 A non-correlated texttable (for example using a literal as the text) joined against another table will produce an NPE in RuleImplementJoinStrategy by expecting a non-existent child node. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 10 months

2
2
0 / 0

[JBoss JIRA] Created: (TEIID-1705) Encountered NPE in SQLStringVisitor for TIMESTAMPADD and TIMESTAMPDIFF

by Mark Drilling (JIRA)

Encountered NPE in SQLStringVisitor for TIMESTAMPADD and TIMESTAMPDIFF ---------------------------------------------------------------------- Key: TEIID-1705 URL: https://issues.jboss.org/browse/TEIID-1705 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.4 Reporter: Mark Drilling Assignee: Steven Hawkins I was using expression builder in Designer when I encountered this NPE. java.lang.NullPointerException at org.teiid.query.sql.visitor.SQLStringVisitor.visit(SQLStringVisitor.java:1280) at org.teiid.query.sql.symbol.Function.acceptVisitor(Function.java:182) at org.teiid.query.sql.visitor.SQLStringVisitor.getSQLString(SQLStringVisitor.java:164) at com.metamatrix.query.internal.ui.builder.util.LanguageObjectLabelProvider.getText(LanguageObjectLabelProvider.java:129) I think the visit method for FUNCTION in SQLStringVisitor just needs to do a null check on the first arg. I'm attaching a code patch. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 10 months

3
7
0 / 0

[JBoss JIRA] Created: (TEIID-832) Support calling oracle stored functions returning result sets as stored procedures

by Steven Hawkins (JIRA)

Support calling oracle stored functions returning result sets as stored procedures ---------------------------------------------------------------------------------- Key: TEIID-832 URL: https://jira.jboss.org/jira/browse/TEIID-832 Project: Teiid Issue Type: Feature Request Components: JDBC Connector Affects Versions: 6.0.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Minor Fix For: 6.3.0 This is only an issue with oracle native drivers, which need to have the returned result set explicitly called as a return parameter. For this to work we'll need to ensure that the import metadata on a procedure is being set to isFunction appropriately and then use that metadata in the Oracle connector. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 10 months

5
7
0 / 0

[JBoss JIRA] Created: (TEIID-1732) Native PG Connector does not pass back errors to client

by Graeme Gillies (JIRA)

Native PG Connector does not pass back errors to client ------------------------------------------------------- Key: TEIID-1732 URL: https://issues.jboss.org/browse/TEIID-1732 Project: Teiid Issue Type: Bug Affects Versions: 7.5 Environment: Red Hat Enterprise Linux Server release 5.7 (Tikanga) JBoss EAP 5.1.1 java version "1.6.0_20" OpenJDK Runtime Environment (IcedTea6 1.9.8) (rhel-1.22.1.9.8.el5_6-x86_64) OpenJDK 64-Bit Server VM (build 19.0-b09, mixed mode) Reporter: Graeme Gillies Assignee: Steven Hawkins Hi, When we have people connecting to the native postgres emulation component of teiid (port 35432) using say, perl, or python, they can connect and query stuff fine, but if they give it a bad query (for exammple, the statement "selectx * from table.name") we see an error in the server side long saying the syntax is incorrect, but this error is never passed back to the client. The client just sits there waiting for a response that never comes. Can we please have any and all errors returned back to the client correctly? Thanks, Graeme -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 10 months

4
5
0 / 0

[JBoss JIRA] Created: (TEIID-1665) Optimize SELECT of all constants

by Mark Addleman (JIRA)

Optimize SELECT of all constants -------------------------------- Key: TEIID-1665 URL: https://issues.jboss.org/browse/TEIID-1665 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 7.4 Reporter: Mark Addleman Assignee: Steven Hawkins Priority: Minor If a translator supports LIMIT but does not support select expressions, SELECT 'A' as A, 'B' as B FROM xyz GROUP BY A, B should be written as SELECT * FROM xyz LIMIT 1 -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 10 months

3
5
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues August 2011