July 2011 - teiid-issues - Jboss List Archives

[JBoss JIRA] Created: (TEIID-1529) LIMIT not pushed down for queries with subselects and ORDER BY

by Mark Addleman (JIRA)

LIMIT not pushed down for queries with subselects and ORDER BY -------------------------------------------------------------- Key: TEIID-1529 URL: https://issues.jboss.org/browse/TEIID-1529 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.3 Reporter: Mark Addleman Assignee: Steven Hawkins It doesn't look like the engine pushes down LIMIT in the following query: SELECT B."SYSID", B."USERID", (SELECT COUNT(*) FROM (SELECT * FROM notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT("SECURITY.BASEUSER", XMLATTRIBUTES(B."SYSID",B."USERID")) as String)) as foo) as C_notesForObject, 'SECURITY.BASEUSER' as "__objecttype__" FROM "SECURITY.BASEUSER" as B ORDER BY B."USERID" ASC LIMIT 10 However, the engine does push down the LIMIT in the same query without the ORDER BY: SELECT B."SYSID", B."USERID", (SELECT COUNT(*) FROM (SELECT * FROM notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT("SECURITY.BASEUSER", XMLATTRIBUTES(B."SYSID",B."USERID")) as String)) as foo) as C_notesForObject, 'SECURITY.BASEUSER' as "__objecttype__" FROM "SECURITY.BASEUSER" as B LIMIT 10 Another piece of relevant information is notes.RETRIEVE_NOTE is a stored procedure backed by java code in a translator. Since SECURITY.BASEER contains ~20,000 rows and each row requires a select against the RETRIEVE_NOTE stored procedure, the difference in processing time is huge: about two minutes with the ORDER BY versus a few hundred milliseconds without the ORDER BY. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 5 months

3
8
0 / 0

[JBoss JIRA] Created: (TEIID-1547) Need Java 1.5-compliant JDBC driver for Data Services

by Len DiMaggio (JIRA)

Need Java 1.5-compliant JDBC driver for Data Services ----------------------------------------------------- Key: TEIID-1547 URL: https://issues.jboss.org/browse/TEIID-1547 Project: Teiid Issue Type: Feature Request Components: JDBC Driver Affects Versions: 7.4 Reporter: Len DiMaggio Assignee: Steven Hawkins Project JIRA for: SOA-2999 -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 5 months

2
2
0 / 0

[JBoss JIRA] Created: (TEIID-1562) ArrayIndexOutOfBounds and ASSERTION FAILED in models with UNION

by Claudio Venturini (JIRA)

ArrayIndexOutOfBounds and ASSERTION FAILED in models with UNION --------------------------------------------------------------- Key: TEIID-1562 URL: https://issues.jboss.org/browse/TEIID-1562 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.3, 7.4 Environment: Teiid 7.3/7.4 beta2 deployed on JBoss AS 5.1, installed on Ubuntu Server 10.04 LTS. Three source models, two of which in MySQL 5.1.51 (on the same machine of JBoss), and one on SQLServer 2000 (on another machine). Reporter: Claudio Venturini Assignee: Steven Hawkins I've three simple source models. Two of them (namely "support_phy" and "oasi_phy") are on MySQL, and one ("tricolore_phy") on SQL Server 2000. I also have three view models, one for each source model, named "support_log", "oasi_log" and "tricolore_log". Don't mind the names... Every model has only one table. Each of these view models reflects one of the source models. In addition I have a fourth view model, named "aop", which integrates the data from the other view models using a simple UNION ALL operation. In particular this view model is defined by the following query: {code:sql} SELECT TR_v.data AS data_fattura, TR_v.n_prog, TR_v.quantita FROM tricolore_log.misura124.tricolore.vendita_referenza AS TR_v UNION ALL SELECT OA_v.data AS data_fattura, OA_v.n_prog, OA_v.quantita FROM oasi_log.misura124.oasi.vendita_referenza AS OA_v {code} One problem is that if I execute the following query, against the integrated model: {code:sql} SELECT data_fattura, n_prog, quantita FROM aop.misura124.aop.vendita_referenza WHERE n_prog = 1 {code} I get a ArrayIndexOutOfBoundsException: {code} 2011-04-20 17:26:26,332 DEBUG [org.teiid.COMMAND_LOG] (New I/O server worker #1-1) START USER COMMAND: startTime=2011-04-20 17:26:26.332 requestID=8LzPNHldNJhu.2 txID=null sessionID=8LzPNHldNJhu applicationName=JDBC principal=admin@teiid-security vdbName=misura124 vdbVersion=1sql=SELECT data_fattura, n_prog, quantita FROM aop.misura124.aop.vendita_referenza where n_prog = 1 2011-04-20 17:26:26,373 DEBUG [org.teiid.COMMAND_LOG] (Worker163_QueryProcessorQueue7610) ERROR USER COMMAND: endTime=2011-04-20 17:26:26.373 requestID=8LzPNHldNJhu.2 txID=null sessionID=8LzPNHldNJhu principal=admin@teiid-security vdbName=misura124 vdbVersion=1 finalRowCount=null 2011-04-20 17:26:26,373 ERROR [org.teiid.PROCESSOR] (Worker163_QueryProcessorQueue7610) Unexpected exception for request 8LzPNHldNJhu.2 java.lang.ArrayIndexOutOfBoundsException {code} I've tried to swap the order of the SELECTs statements in the query as follows: {code:sql} SELECT OA_v.data AS data_fattura, OA_v.n_prog, OA_v.quantita FROM oasi_log.misura124.oasi.vendita_referenza AS OA_v UNION ALL SELECT TR_v.data AS data_fattura, TR_v.n_prog, TR_v.quantita FROM tricolore_log.misura124.tricolore.vendita_referenza AS TR_v {code} Surprisingly it works!! This was the first problem. While finding a solution to that problem, I found a second problem. The definition of the table in the "tricolore_log" model is as follows: {code:sql} SELECT TR_v.DataDocumento AS data, 1 AS n_prog, CAST(SUM(TR_v.NrPezzi) AS INTEGER) AS quantita FROM tricolore_phy.Tricolore.dbo.DISCO_Vendita_Referenza AS TR_v INNER JOIN support_log.mediator.referenza_op AS SUP_r ON TR_v.Cod_Dsc = SUP_r.codice WHERE SUP_r.codop = 1 GROUP BY TR_v.DataDocumento, COALESCE(NULLIF(RTRIM(LTRIM(TR_v.NumeroDocumento)), ''), 'N.D.') {code} The GROUP BY clause is a little bit complex, so I tried to simplify it by removing the COALESCE function, thereby maintaining in the clause only the TR_v.DataDocumento field. I've run the same query on the integrated schema, and the result is an ASSERTION FAILED error: {code} 2011-04-20 17:06:33,572 DEBUG [org.teiid.COMMAND_LOG] (New I/O server worker #1-2) START USER COMMAND: startTime=2011-04-20 17:06:33.571 requestID=iMaBNssX10Nx.0 txID=null sessionID=iMaBNssX10Nx applicationName=JDBC principal=admin@teiid-security vdbName=misura124 vdbVersion=1sql=SELECT data_fattura, n_prog, quantita FROM aop.misura124.aop.vendita_referenza where n_prog = 1 2011-04-20 17:06:33,586 DEBUG [org.teiid.COMMAND_LOG] (Worker158_QueryProcessorQueue7536) ERROR USER COMMAND: endTime=2011-04-20 17:06:33.586 requestID=iMaBNssX10Nx.0 txID=null sessionID=iMaBNssX10Nx principal=admin@teiid-security vdbName=misura124 vdbVersion=1 finalRowCount=null 2011-04-20 17:06:33,588 ERROR [org.teiid.PROCESSOR] (Worker158_QueryProcessorQueue7536) Unexpected exception for request iMaBNssX10Nx.0 java.lang.AssertionError: ASSERTION FAILED: expected reference to be not null at org.teiid.core.util.Assertion.failed(Assertion.java:73) at org.teiid.core.util.Assertion.isNotNull(Assertion.java:100) at org.teiid.core.util.Assertion.isNotNull(Assertion.java:92) at org.teiid.query.processor.relational.RelationalNode.getProjectionIndexes(RelationalNode.java:367) at org.teiid.query.processor.relational.JoinNode.initialize(JoinNode.java:129) at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:103) at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:108) at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:108) at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:108) at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:108) at org.teiid.query.processor.relational.RelationalPlan.initialize(RelationalPlan.java:98) at org.teiid.query.processor.QueryProcessor.init(QueryProcessor.java:175) at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:125) 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:305) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:233) 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:292) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) {code} Worst of all, the clients seems to not recognize the error, and thus it continues to wait for a response which will never arrive. From the client point of view, the server seems to be in a infinite loop. In addition the query works either by completely removing the GROUP BY clause, or removing the INNER JOIN and the WHERE clauses. But these can not be considered as workarounds because they change the semantics of the model. I found the two bugs using Teiid 7.3 patched with https://issues.jboss.org/browse/TEIID-1458 and https://issues.jboss.org/browse/TEIID-1465, and then I upgraded to Teiid 7.4 beta2, which doesn't solve the problem. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 5 months

2
4
0 / 0

[JBoss JIRA] Created: (TEIID-1553) UDF Function model fails to load when it located inside a folder in the VDB

by Ramesh Reddy (JIRA)

UDF Function model fails to load when it located inside a folder in the VDB --------------------------------------------------------------------------- Key: TEIID-1553 URL: https://issues.jboss.org/browse/TEIID-1553 Project: Teiid Issue Type: Bug Components: Server Affects Versions: 7.1.1 Reporter: Ramesh Reddy When UDF is modelled under folder the VDB deployer fails to load the function model. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 5 months

2
3
0 / 0

[JBoss JIRA] Created: (TEIID-1564) Clustered Caching Not Working

by Ramesh Reddy (JIRA)

Clustered Caching Not Working ----------------------------- Key: TEIID-1564 URL: https://issues.jboss.org/browse/TEIID-1564 Project: Teiid Issue Type: Bug Components: Server Affects Versions: 7.2, 7.1.1 Reporter: Ramesh Reddy Assignee: Ramesh Reddy Fix For: 7.4 I have configured two Teiid servers in a cluster and renamed the teiid-cache-manager-jboss-beans-rename-me.xml file to enable clustered caching. I submit a query to one node and see in the log that the internal materialized view is being cached on that node. When I submit the same query to the second node, i see the following error: 12:17:12,040 INFO [MATVIEWS] Loading materialized view table #MAT_CACHED.TEIID.EDS_TAB1_MV 12:17:12,041 WARN [PROCESSOR] Processing exception 'Temporary table "#MAT_CACHED.TEIID.EDS_TAB1_MV" does not exist.' for request BBcYbxuqEAHL.5. Exception type org.teiid.api.exception.query.QueryProcessingException thrown from org.teiid.query.tempdata.TempTableStore.getOrCreateTempTable(TempTableStore.java:220). Enable more detailed logging to see the entire stacktrace. 12:17:12,165 ERROR [MATVIEWS] Failed to load materialized view table #MAT_CACHED.TEIID.EDS_TAB1_MV. [BlockedException] at org.teiid.common.buffer.BlockedException.<clinit>(BlockedException.java:34) at org.teiid.common.buffer.TupleBuffer$1.finalRow(TupleBuffer.java:290) at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:69) at org.teiid.common.buffer.AbstractTupleSource.nextTuple(AbstractTupleSource.java:48) at org.teiid.query.tempdata.TempTable$UpdateProcessor.process(TempTable.java:205) at org.teiid.query.tempdata.TempTable.insert(TempTable.java:446) at org.teiid.query.tempdata.TempTableDataManager.loadGlobalTable(TempTableDataManager.java:516) at org.teiid.query.tempdata.TempTableDataManager.access$100(TempTableDataManager.java:105) at org.teiid.query.tempdata.TempTableDataManager$2.call(TempTableDataManager.java:443) at org.teiid.query.tempdata.TempTableDataManager$2.call(TempTableDataManager.java:440) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:188) at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:116) at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:290) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:619) Case:00451425 -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 5 months

2
2
0 / 0

[JBoss JIRA] Created: (TEIID-1531) ODBC charset issues

by Steven Hawkins (JIRA)

ODBC charset issues ------------------- Key: TEIID-1531 URL: https://issues.jboss.org/browse/TEIID-1531 Project: Teiid Issue Type: Bug Components: Server Affects Versions: 7.1.1 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.4 In testing odbc using the postgres jdbc issue I can see that we are not consistently handling the conversion of client encodings to charsets. Also later postgres clients can use the key UNICODE to refer to UTF-8. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 5 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-1164) Getting the Procedure Parameter metadata is not supported in ODBC

by Ramesh Reddy (JIRA)

Getting the Procedure Parameter metadata is not supported in ODBC ----------------------------------------------------------------- Key: TEIID-1164 URL: https://jira.jboss.org/browse/TEIID-1164 Project: Teiid Issue Type: Bug Components: ODBC Affects Versions: 7.1 Reporter: Ramesh Reddy Currently postgreSQL uses the JDBC array types in issuing the query to read the Procedure parameters. However, Teiid does not support the Array types yet in the JDBC layer, thus this is currently not implemented. This needs to be fixed to correctly return the metadata about the procedures. -- 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

13 years, 5 months

2
7
0 / 0

[JBoss JIRA] Created: (TEIID-1570) pg catalog transformation issues

by Steven Hawkins (JIRA)

pg catalog transformation issues -------------------------------- Key: TEIID-1570 URL: https://issues.jboss.org/browse/TEIID-1570 Project: Teiid Issue Type: Bug Components: ODBC Affects Versions: 7.1.1 Reporter: Steven Hawkins Assignee: Steven Hawkins pg_class and pg_index view definitions have type mismatches. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 5 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-1538) Invalid conversion from type class java.lang.Object with value 'oracle.sql.ROWID@1379cbd' to type class java.lang.String

by Russell Steel (JIRA)

Invalid conversion from type class java.lang.Object with value 'oracle.sql.ROWID@1379cbd' to type class java.lang.String ------------------------------------------------------------------------------------------------------------------------ Key: TEIID-1538 URL: https://issues.jboss.org/browse/TEIID-1538 Project: Teiid Issue Type: Bug Components: Query Engine, Server Affects Versions: 7.3 Reporter: Russell Steel Assignee: Steven Hawkins Attachments: O2_Teiid.vdb, server.log I have a VDB with 3 queries that select direct from an Oracle table, where a SUBSTRING function is being used on the ROWID column. I can successfully SELECT from the 3 queries without error, but when selecting from a 4th view that is join 2 of the 3 tables that I can successfully SELECT from via SQL SquirreL, the 4th view query is failing with; 2011-03-31 11:35:14,968 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2) [Ljava.lang.Object;@168fb5a [TransformationException]Invalid conversion from type class java.lang.Object with value 'oracle.sql.ROWID@1379cbd' to type class java.lang.String at org.teiid.core.types.basic.ObjectToAnyTransform.transformDirect(ObjectToAnyTransform.java:59) at org.teiid.core.types.Transform.transform(Transform.java:47) at org.teiid.core.types.DataTypeManager.transformValue(DataTypeManager.java:781) at org.teiid.dqp.internal.process.DataTierTupleSource.correctTypes(DataTierTupleSource.java:155) at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:227) at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:154) at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:274) 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.relational.MergeJoinStrategy.process(MergeJoinStrategy.java:158) at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:196) at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:274) at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:162) at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:274) at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:161) at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:150) at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:115) at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:250) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:184) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:188) at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:116) at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:290) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 5 months

2
5
0 / 0

[JBoss JIRA] Created: (TEIID-1535) pg/odbc support should report rel oid with column metadata

by Steven Hawkins (JIRA)

pg/odbc support should report rel oid with column metadata ---------------------------------------------------------- Key: TEIID-1535 URL: https://issues.jboss.org/browse/TEIID-1535 Project: Teiid Issue Type: Quality Risk Components: Server Affects Versions: 7.1 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.4 describe columns should return the proper table oid and attnum for each column. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 5 months

1
2
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues July 2011