March 2012 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-1943) Create a JDBC Wrapper that will enable the creation of tables from a Java API via importing

by Van Halbert (JIRA)

Van Halbert created TEIID-1943: ---------------------------------- Summary: Create a JDBC Wrapper that will enable the creation of tables from a Java API via importing Key: TEIID-1943 URL: https://issues.jboss.org/browse/TEIID-1943 Project: Teiid Issue Type: Feature Request Components: Tools Reporter: Van Halbert Assignee: Van Halbert Create a JDBC wrapper that will enable someone to create tables from their Java API. This will assist in the modeling effort in order to use the Coherence translator. Additionally, this could be useful when Infinispan is supported. -- 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

12 years, 4 months

2
4
0 / 0

[JBoss JIRA] (TEIID-1977) Prepared Statements on ODBC ending with failure

by Ramesh Reddy (JIRA)

Ramesh Reddy created TEIID-1977: ----------------------------------- Summary: Prepared Statements on ODBC ending with failure Key: TEIID-1977 URL: https://issues.jboss.org/browse/TEIID-1977 Project: Teiid Issue Type: Bug Affects Versions: 7.7 Reporter: Ramesh Reddy Assignee: Steven Hawkins When a preprared statement executed on the ODBC transport, the below error occurs. This is with the PG's latest ODBC driver, not 8.4.200 that been validate current code against. Message: Error Code:ERR.015.008.0039 Message:The function 'pg_get_expr(d.adbin, d.adrelid)' is an unknown form. Check that the function name and number of arguments is correct. -- 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

12 years, 4 months

2
5
0 / 0

[JBoss JIRA] Created: (TEIID-1560) Add support for user defined / pushdown aggregate functions

by Steven Hawkins (JIRA)

Add support for user defined / pushdown aggregate functions ----------------------------------------------------------- Key: TEIID-1560 URL: https://issues.jboss.org/browse/TEIID-1560 Project: Teiid Issue Type: Feature Request Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.0 Add support for user defined aggregate functions. This would also affect the function model metadata. Our aggregate handling logic will need to be generalized to make this possible. Starting with the parser we've got special handling for built-in aggregates. for user defined aggregate handling just a static method will not work as the function needs to retain state across each group. Could require that the implementing class extends AggregateFunction. Could also allow user defined aggregates to take an order by clause. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 4 months

2
4
0 / 0

[JBoss JIRA] (TEIID-1982) When packaging the rhq admin console jar for the jboss kit, add the teiid-client.jar contents to it

by Van Halbert (JIRA)

Van Halbert created TEIID-1982: ---------------------------------- Summary: When packaging the rhq admin console jar for the jboss kit, add the teiid-client.jar contents to it Key: TEIID-1982 URL: https://issues.jboss.org/browse/TEIID-1982 Project: Teiid Issue Type: Task Components: Build/Kits Affects Versions: 7.4.1, 7.7.1, 8.0 Reporter: Van Halbert Assignee: Van Halbert This is a fix being pushed up stream. When the admin console rhq jar is being packaged into the jboss kit, it needs the teiid-client.jar added to it. Here's the pom.xml changes being submitted as an example: <mkdir dir="target/work/rhqrepackage" />  <jar destfile="target/work/rhqrepackage/rhq-teiid-plugin-SOA-${project.version}.jar"> <zipfileset src="target/work/teiid/resources/runtime/deploy/admin-console.war/plugins/rhq-teiid-plugin-SOA-${project.version}.jar" excludes="META-INF/**.RSA,META-INF/**.SF"/> <zipfileset src="target/work/teiid/client/teiid-client.jar" excludes="META-INF/**.RSA,META-INF/**.SF"/> </jar> <copy file="target/work/rhqrepackage/rhq-teiid-plugin-SOA-${project.version}.jar" tofile="target/work/teiid/resources/runtime/deploy/admin-console.war/plugins/rhq-teiid-plugin-SOA-${project.version}.jar" overwrite="true" /> -- 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

12 years, 4 months

3
3
0 / 0

[JBoss JIRA] (TEIID-1899) Getting Assertion when running running Inner Merge Join

by Van Halbert (JIRA)

Van Halbert created TEIID-1899: ---------------------------------- Summary: Getting Assertion when running running Inner Merge Join Key: TEIID-1899 URL: https://issues.jboss.org/browse/TEIID-1899 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.4.1 Reporter: Van Halbert Assignee: Steven Hawkins When running the following query, it causing an ASSERTION (see attached log): SELECT COUNT(*) AS CNT FROM (SELECT ORDERS.O_ORDERKEY, ORDERS.O_ORDERDATE, ORDERS.O_CLERK, CUSTOMER.C_CUSTKEY, CUSTOMER.C_NAME, CUSTOMER.C_ACCTBAL FROM TPCR01_PostgreSQLVirt.ORDERS, TPCR01_OracleVirt.CUSTOMER WHERE (CUSTOMER.C_CUSTKEY = ORDERS.O_CUSTKEY) AND (ORDERS.O_ORDERDATE < '1992-01-05 00:00:00') AND (CUSTOMER.C_ACCTBAL < 9514.5)) AS T Note: this doesn't fail when SELECT COUNT(*) is added -- 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

12 years, 4 months

5
19
0 / 0

[JBoss JIRA] (TEIID-1960) Client recieving java.lang.IndexOutOfBoundsException in

by Tim Bruce (JIRA)

Tim Bruce created TEIID-1960: -------------------------------- Summary: Client recieving java.lang.IndexOutOfBoundsException in Key: TEIID-1960 URL: https://issues.jboss.org/browse/TEIID-1960 Project: Teiid Issue Type: Bug Environment: JBoss 5.1.0.GA Teiid Engine 7.6.0.Final 64-bit Java 1.7.0 Reporter: Tim Bruce Assignee: Steven Hawkins 01 Mar 2012 21:37:21,891 GMT ERROR [org.teiid.TRANSPORT] (Worker225_QueryProcessorQueue13539) Unhandled exception, closing client instance java.lang.IndexOutOfBoundsException: Index: 3, Size: 3 at java.util.ArrayList.rangeCheck(ArrayList.java:615) at java.util.ArrayList.get(ArrayList.java:393) at org.teiid.client.BatchSerializer.writeIsNullData(BatchSerializer.java:226) at org.teiid.client.BatchSerializer$ColumnSerializer.writeColumn(BatchSerializer.java:262) at org.teiid.client.BatchSerializer.writeBatch(BatchSerializer.java:542) at org.teiid.client.ResultsMessage.writeExternal(ResultsMessage.java:277) at java.io.ObjectOutputStream.writeExternalData(ObjectOutputStream.java:1463) at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1434) at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1194) at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:363) at org.teiid.net.socket.Message.writeExternal(Message.java:56) at java.io.ObjectOutputStream.writeExternalData(ObjectOutputStream.java:1463) at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1434) at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1194) at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:363) at org.teiid.transport.ObjectEncoder.handleDownstream(ObjectEncoder.java:115) at org.jboss.netty.channel.Channels.write(Channels.java:611) at org.jboss.netty.channel.Channels.write(Channels.java:578) at org.jboss.netty.channel.AbstractChannel.write(AbstractChannel.java:258) at org.teiid.transport.SSLAwareChannelHandler$ObjectChannelImpl.write(SSLAwareChannelHandler.java:94) at org.teiid.transport.SocketClientInstance.send(SocketClientInstance.java:82) at org.teiid.transport.ServerWorkItem.sendResult(ServerWorkItem.java:127) at org.teiid.transport.ServerWorkItem$1.onCompletion(ServerWorkItem.java:99) at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:130) at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:37) at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:75) at org.teiid.dqp.internal.process.RequestWorkItem.sendResultsIfNeeded(RequestWorkItem.java:674) at org.teiid.dqp.internal.process.RequestWorkItem$1.flushBatchDirect(RequestWorkItem.java:528) at org.teiid.query.processor.BatchCollector.flushBatch(BatchCollector.java:174) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:149) at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:370) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:287) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49) at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:215) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:232) 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:1121) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:614) at java.lang.Thread.run(Thread.java:769) -- 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

12 years, 4 months

4
15
0 / 0

[JBoss JIRA] (TEIID-1980) JDBC connection QueryTimeout property appears to be ignored

by Paul Nittel (JIRA)

Paul Nittel created TEIID-1980: ---------------------------------- Summary: JDBC connection QueryTimeout property appears to be ignored Key: TEIID-1980 URL: https://issues.jboss.org/browse/TEIID-1980 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.4 Reporter: Paul Nittel Assignee: Steven Hawkins While testing an EDS patch, I tried to constrain a query by adding ;QueryTimeout=1 to my JDBC connection string. This had no apparent effect. (The query--a repeated UNION ALL of huge tables, followed by a descending ORDER BY--takes over 30 seconds.) I also tried 3 and 10 second timeouts, but all allowed the query to continue to completion. -- 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

12 years, 4 months

4
11
0 / 0

[JBoss JIRA] (TEIID-1986) Exception on the slave node during materialization table load

by Ramesh Reddy (JIRA)

Ramesh Reddy created TEIID-1986: ----------------------------------- Summary: Exception on the slave node during materialization table load Key: TEIID-1986 URL: https://issues.jboss.org/browse/TEIID-1986 Project: Teiid Issue Type: Bug Components: Server Affects Versions: 8.0 Reporter: Ramesh Reddy Assignee: Steven Hawkins Fix For: 8.0 I am consistently seeing the below exception, when the slave node trying to refresh the cache. After the failed attempt the cache seems to be getting TTL refreshed, so it keeps serving the old results until the cache time expires again. Next time it loads fine. er:server-slave] 16:40:01,677 ERROR [org.teiid.PROCESSOR.MATVIEWS] (Worker1_QueryProcessorQueue11) TEIID30015 Failed to load materialized view table #MAT_PARTSVIRTUAL.SUPPLIERINFO.: [TeiidProcessingException] TEIID30495: Error Code:TEIID30495 Message:TEIID30495 The request lqd0bkjp5nY2.5 has been closed. [Server:server-slave] at org.teiid.dqp.internal.process.DQPCore.getRequestWorkItem(DQPCore.java:503) [teiid-engine-8.0.0.Beta2.jar:8.0.0.Beta2] [Server:server-slave] at org.teiid.dqp.internal.process.DataTierManagerImpl.registerRequest(DataTierManagerImpl.java:179) [teiid-engine-8.0.0.Beta2.jar:8.0.0.Beta2] [Server:server-slave] at org.teiid.query.tempdata.TempTableDataManager.registerRequest(TempTableDataManager.java:125) [teiid-engine-8.0.0.Beta2.jar:8.0.0.Beta2] [Server:server-slave] at org.teiid.query.processor.relational.AccessNode.registerRequest(AccessNode.java:365) [teiid-engine-8.0.0.Beta2.jar:8.0.0.Beta2] [Server:server-slave] at org.teiid.query.processor.relational.AccessNode.open(AccessNode.java:154) [teiid-engine-8.0.0.Beta2.jar:8.0.0.Beta2] [Server:server-slave] at org.teiid.query.processor.relational.JoinStrategy.openLeft(JoinStrategy.java:95) [teiid-engine-8.0.0.Beta2.jar:8.0.0.Beta2] [Server:server-slave] at org.teiid.query.processor.relational.JoinNode.open(JoinNode.java:140) [teiid-engine-8.0.0.Beta2.jar:8.0.0.Beta2] [Server:server-slave] at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:254) [teiid-engine-8.0.0.Beta2.jar:8.0.0.Beta2] [Server:server-slave] at org.teiid.query.processor.relational.RelationalPlan.open(RelationalPlan.java:167) [teiid-engine-8.0.0.Beta2.jar:8.0.0.Beta2] [Server:server-slave] at org.teiid.query.processor.QueryProcessor.init(QueryProcessor.java:196) [teiid-engine-8.0.0.Beta2.jar:8.0.0.Beta2] [Server:server-slave] at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:128) [teiid-engine-8.0.0.Beta2.jar:8.0.0.Beta2] [Server:server-slave] at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:107) [teiid-engine-8.0.0.Beta2.jar:8.0.0.Beta2] [Server:server-slave] at org.teiid.query.processor.BatchCollector$BatchProducerTupleSource.nextTuple(BatchCollector.java:86) [teiid-engine-8.0.0.Beta2.jar:8.0.0.Beta2] [Server:server-slave] at org.teiid.query.tempdata.TempTable$UpdateProcessor.process(TempTable.java:227) [teiid-engine-8.0.0.Beta2.jar:8.0.0.Beta2] [Server:server-slave] at org.teiid.query.tempdata.TempTable$InsertUpdateProcessor.process(TempTable.java:89) [teiid-engine-8.0.0.Beta2.jar:8.0.0.Beta2] [Server:server-slave] at org.teiid.query.tempdata.TempTable.insert(TempTable.java:582) [teiid-engine-8.0.0.Beta2.jar:8.0.0.Beta2] [Server:server-slave] at org.teiid.query.tempdata.TempTableDataManager.loadGlobalTable(TempTableDataManager.java:449) [teiid-engine-8.0.0.Beta2.jar:8.0.0.Beta2] [Server:server-slave] at org.teiid.query.tempdata.TempTableDataManager.access$0(TempTableDataManager.java:432) [teiid-engine-8.0.0.Beta2.jar:8.0.0.Beta2] [Server:server-slave] at org.teiid.query.tempdata.TempTableDataManager$2.call(TempTableDataManager.java:425) [teiid-engine-8.0.0.Beta2.jar:8.0.0.Beta2] [Server:server-slave] at org.teiid.query.tempdata.TempTableDataManager$2.call(TempTableDataManager.java:1) [teiid-engine-8.0.0.Beta2.jar:8.0.0.Beta2] [Server:server-slave] at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [rt.jar:1.6.0_26] [Server:server-slave] at java.util.concurrent.FutureTask.run(FutureTask.java:138) [rt.jar:1.6.0_26] [Server:server-slave] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:239) [teiid-engine-8.0.0.Beta2.jar:8.0.0.Beta2] [Server:server-slave] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) [teiid-engine-8.0.0.Beta2.jar:8.0.0.Beta2] [Server:server-slave] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) [teiid-engine-8.0.0.Beta2.jar:8.0.0.Beta2] [Server:server-slave] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [rt.jar:1.6.0_26] [Server:server-slave] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [rt.jar:1.6.0_26] [Server:server-slave] at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_26] -- 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

12 years, 4 months

2
7
0 / 0

[JBoss JIRA] (TEIID-1965) Ingres10 as a Teiid Source - correlated subquery failing with Error Code 2118 Message:'Invalid qualifier

by Warren Gibson (JIRA)

Warren Gibson created TEIID-1965: ------------------------------------ Summary: Ingres10 as a Teiid Source - correlated subquery failing with Error Code 2118 Message:'Invalid qualifier Key: TEIID-1965 URL: https://issues.jboss.org/browse/TEIID-1965 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.1.1 Reporter: Warren Gibson Assignee: Steven Hawkins The following query is failing in BQT testing: SELECT TIMEVALUE, BYTENUM, (SELECT B.FLOATNUM FROM BQT1.SMALLA AS B WHERE (B.INTKEY = (SELECT A.INTKEY FROM BQT1.SMALLA AS A WHERE (A.STRINGNUM > 10) AND (A.INTKEY = B.INTKEY))) AND (B.INTKEY = A.INTKEY)) FROM bqt1.smalla AS a Error Code:2118 Message:Remote org.teiid.core.TeiidProcessingException: Error Code:2118 Message:Source: Error Code:2118 Message:'Invalid qualifier 'g_1'. 'g_1' must be declared in the FROM clause or equivalent. If used in a target list, 'g_1' must be declared at the current scope.' error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.timevalue, cast(g_0.bytenum AS tinyint), (SELECT g_1.floatnum FROM smalla AS g_1 WHERE g_1.intkey = g_0.intkey AND g_1.intkey = (SELECT g_2.intkey FROM smalla AS g_2 WHERE g_2.stringnum > '10' AND g_2.intkey = g_1.intkey)) FROM smalla AS g_0] -- 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

12 years, 4 months

3
8
0 / 0

[JBoss JIRA] Created: (TEIID-1328) API request: Programatically modify the VDB

by Mark Addleman (JIRA)

API request: Programatically modify the VDB -------------------------------------------- Key: TEIID-1328 URL: https://jira.jboss.org/browse/TEIID-1328 Project: Teiid Issue Type: Feature Request Components: AdminApi Affects Versions: 7.1 Reporter: Mark Addleman Assignee: Steven Hawkins Priority: Minor I'd like an API to programatically modify the VDB. It would be ideal to modify the VDB using DDL through Teiid. Our primary use case is accessing a dynamic set of datasources through Teiid. When a datasource is added, we would INSERT the appropriate entries into MODEL, PROPERTIES, DATASOURCES tables. Teiid would reread the appropriate metadata from the associated translators. -- 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, 6 months

6
35
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues March 2012