[JBoss JIRA] (TEIID-3501) IN clause - teradata does not support "CAST( ... AS ...)" statement in "IN(...)"
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3501?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-3501.
---------------------------------
> IN clause - teradata does not support "CAST( ... AS ...)" statement in "IN(...)"
> --------------------------------------------------------------------------------
>
> Key: TEIID-3501
> URL: https://issues.jboss.org/browse/TEIID-3501
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7.1.6_2
> Environment: teradata version: 15
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
> Fix For: 8.12, 8.11.2
>
>
> The teradata DB does not support CAST statement in IN. Query (1), teradata exception (2), source specific command (3), query that teradata accepts (4).
> (1) SELECT BQT1.SmallA.IntKey FROM BQT1.SmallA WHERE BQT1.SmallA.TimeStampValue IN (convert('2000-01-01 00:00:12.0', timestamp), convert('2000-01-01 00:00:45.0', timestamp)) ORDER BY IntKey
> (2) SELECT g_0.intkey AS c_0 FROM smalla AS g_0 WHERE g_0.timestampvalue IN (cast('2000-01-01 00:00:12.0' AS TIMESTAMP(6)), cast('2000-01-01 00:00:45.0' AS TIMESTAMP(6))) ORDER BY 1
> (3) SELECT g_0.intkey AS c_0 FROM smalla AS g_0 WHERE g_0.timestampvalue IN ('2000-01-01 00:00:12.0', '2000-01-01 00:00:45.0') ORDER BY 1
> (4) Caused by: java.sql.SQLException: [Teradata Database] [TeraJDBC 15.10.00.05] [Error 3706] [SQLState 42000] Syntax error: expected something between ')' and ','.
> at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDatabaseSQLException(ErrorFactory.java:308)
> ...
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 2 months
[JBoss JIRA] (TEIID-3386) Mixed resutl with (double) full outer join and where clause
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3386?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-3386.
---------------------------------
> Mixed resutl with (double) full outer join and where clause
> -----------------------------------------------------------
>
> Key: TEIID-3386
> URL: https://issues.jboss.org/browse/TEIID-3386
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7.1
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
> Attachments: server.log
>
>
> If a query contains double FULL OUTER JOIN and WHERE clause that contains condition on column from last table, teiid returns mixed result (underlying oracle10).
> Query:
> SELECT BQT1.SmallA.IntKey AS SmallA_IntKey, BQT2.MediumB.IntKey AS MediumB_IntKey, BQT2.LargeB.IntKey AS LargeB_IntKey
> FROM (BQT1.SmallA FULL OUTER JOIN BQT2.MediumB ON BQT1.SmallA.IntKey = BQT2.MediumB.IntKey) FULL OUTER JOIN BQT2.LargeB ON BQT2.MediumB.IntKey = BQT2.LargeB.IntKey
> WHERE BQT2.LargeB.IntKey < 1500 ORDER BY LargeB_IntKey, MediumB_IntKey, SmallA_IntKey;
> Actual result:
> 0 0 0
> 1 1 1
> 2 2 2
> 3 3 3
> ... ... ...
> 49 49 49
> 50 50 50
> ... ... ...
> 999 999 999
> <null> <null> 1000
> ... ... ...
> <null> <null> 1499
> Expected result:
> 0 0 0
> 1 1 1
> 2 2 2
> 3 3 3
> ... ... ...
> 49 49 49
> <null> 50 50
> ... ... ...
> 999 999 999
> <null> <null> 1000
> ... ... ...
> <null> <null> 1499
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 2 months
[JBoss JIRA] (TEIID-3804) NPE while loading the materialized tables for pg_catalog
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3804?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-3804.
---------------------------------
> NPE while loading the materialized tables for pg_catalog
> --------------------------------------------------------
>
> Key: TEIID-3804
> URL: https://issues.jboss.org/browse/TEIID-3804
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7
> Reporter: Ramesh Reddy
> Assignee: Steven Hawkins
>
> During the ODBC testing, have seen
> {code}
> 08:07:49,526 WARN [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2) Error cleaning up.: java.lang.NullPointerException
> at org.teiid.common.buffer.impl.BufferManagerImpl.removeCacheGroup(BufferManagerImpl.java:1030) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.common.buffer.impl.BufferManagerImpl$Remover.remove(BufferManagerImpl.java:138) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.common.buffer.AutoCleanupUtil$PhantomCleanupReference.cleanup(AutoCleanupUtil.java:50) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.common.buffer.AutoCleanupUtil.doCleanup(AutoCleanupUtil.java:83) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.common.buffer.AutoCleanupUtil.setCleanupReference(AutoCleanupUtil.java:64) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.common.buffer.impl.BufferManagerImpl$BatchManagerImpl.createManagedBatch(BufferManagerImpl.java:208) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.common.buffer.TupleBuffer.saveBatch(TupleBuffer.java:250) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.common.buffer.TupleBuffer.close(TupleBuffer.java:256) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.relational.SortUtility.initialSort(SortUtility.java:315) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.relational.SortUtility.sort(SortUtility.java:202) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.tempdata.TempTable.createTupleSource(TempTable.java:515) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.tempdata.TempTable.createTupleSource(TempTable.java:498) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.tempdata.TempTableDataManager$4.createTupleSource(TempTableDataManager.java:538) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:108) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:369) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.relational.SourceState.getTupleBuffer(SourceState.java:243) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.relational.EnhancedSortMergeJoinStrategy.loadLeft(EnhancedSortMergeJoinStrategy.java:229) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:187) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.BatchCollector$BatchProducerTupleSource.nextTuple(BatchCollector.java:89) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.tempdata.TempTable$UpdateProcessor.process(TempTable.java:255) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.tempdata.TempTable$InsertUpdateProcessor.process(TempTable.java:102) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.tempdata.TempTable.insert(TempTable.java:684) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.tempdata.TempTableDataManager$7.createTupleSource(TempTableDataManager.java:659) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:108) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.tempdata.TempTableDataManager$4.load(TempTableDataManager.java:558) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.tempdata.TempTableDataManager$4.createTupleSource(TempTableDataManager.java:529) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:108) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.dqp.internal.process.TupleSourceCache$CopyOnReadTupleSource.nextTuple(TupleSourceCache.java:108) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:369) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.relational.SourceState.prefetch(SourceState.java:206) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.relational.SourceState.rowCountLE(SourceState.java:153) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.relational.EnhancedSortMergeJoinStrategy.shouldIndexIfSmall(EnhancedSortMergeJoinStrategy.java:234) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.relational.EnhancedSortMergeJoinStrategy.loadRight(EnhancedSortMergeJoinStrategy.java:243) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:208) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.relational.UnionAllNode.nextBatchDirect(UnionAllNode.java:151) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.BatchCollector$BatchProducerTupleSource.nextTuple(BatchCollector.java:89) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.tempdata.TempTable$UpdateProcessor.process(TempTable.java:255) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.tempdata.TempTable$InsertUpdateProcessor.process(TempTable.java:102) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.tempdata.TempTable.insert(TempTable.java:684) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.tempdata.TempTableDataManager$7.createTupleSource(TempTableDataManager.java:659) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:108) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.tempdata.TempTableDataManager$4.load(TempTableDataManager.java:558) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.tempdata.TempTableDataManager$4.createTupleSource(TempTableDataManager.java:529) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:108) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:369) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.relational.SourceState.getTupleBuffer(SourceState.java:243) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.relational.EnhancedSortMergeJoinStrategy.loadLeft(EnhancedSortMergeJoinStrategy.java:229) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:187) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.relational.SourceState.prefetch(SourceState.java:206) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.relational.SourceState.rowCountLE(SourceState.java:153) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.relational.EnhancedSortMergeJoinStrategy.shouldIndexIfSmall(EnhancedSortMergeJoinStrategy.java:234) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.relational.EnhancedSortMergeJoinStrategy.loadRight(EnhancedSortMergeJoinStrategy.java:241) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:208) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.BatchCollector$BatchProducerTupleSource.nextTuple(BatchCollector.java:89) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.tempdata.TempTable$UpdateProcessor.process(TempTable.java:255) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.tempdata.TempTable$InsertUpdateProcessor.process(TempTable.java:102) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.tempdata.TempTable.insert(TempTable.java:684) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.tempdata.TempTableDataManager$7.createTupleSource(TempTableDataManager.java:659) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:108) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.tempdata.TempTableDataManager$4.load(TempTableDataManager.java:558) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.tempdata.TempTableDataManager$4.createTupleSource(TempTableDataManager.java:529) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:108) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:369) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:450) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:332) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:260) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:295) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_71]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_71]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_71]
> at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_71]
> at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121) [teiid-api-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.jboss.TransportService$2.invoke(TransportService.java:225) [teiid-jboss-integration-8.7.5.redhat-1.jar:8.7.5]
> at com.sun.proxy.$Proxy18.executeRequest(Unknown Source)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_71]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_71]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_71]
> at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_71]
> at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:170) [teiid-runtime-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_71]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:258) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:168) [teiid-runtime-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at com.sun.proxy.$Proxy18.executeRequest(Unknown Source)
> at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:634) [teiid-client-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:509) [teiid-client-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:261) [teiid-client-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.odbc.ODBCServerRemoteImpl.getPgColInfo(ODBCServerRemoteImpl.java:1077) [teiid-runtime-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.odbc.ODBCServerRemoteImpl.access$100(ODBCServerRemoteImpl.java:79) [teiid-runtime-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.odbc.ODBCServerRemoteImpl$4.onCompletion(ODBCServerRemoteImpl.java:446) [teiid-runtime-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:135) [teiid-client-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:40) [teiid-client-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:79) [teiid-client-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:516) [teiid-client-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:135) [teiid-client-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:40) [teiid-client-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:79) [teiid-client-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.dqp.internal.process.RequestWorkItem.sendResultsIfNeeded(RequestWorkItem.java:924) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.dqp.internal.process.RequestWorkItem$1.flushBatchDirect(RequestWorkItem.java:648) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.BatchCollector.flushBatch(BatchCollector.java:218) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:189) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:450) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:332) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:260) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.5.redhat-1.jar:8.7.5.redhat-1]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_71]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_71]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_71]
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 2 months