[teiid-issues] [JBoss JIRA] (TEIID-1899) Getting Assertion when running Inner Merge Join query with SELECT COUNT(*) on top
Van Halbert (JIRA)
jira-events at lists.jboss.org
Wed Jan 18 12:01:18 EST 2012
[ https://issues.jboss.org/browse/TEIID-1899?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12660240#comment-12660240 ]
Van Halbert commented on TEIID-1899:
------------------------------------
Also seeing it with this query:
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)
Each table, with its where clause, works. But combine the ASSERTION occurs:
10:58:11,842 ERROR [PROCESSOR] Unexpected exception for request LV4pMCDmToOE.11
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.common.buffer.TupleBuffer.getBatch(TupleBuffer.java:224)
at org.teiid.common.buffer.TupleBuffer$1.getBatch(TupleBuffer.java:335)
at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:61)
> Getting Assertion when running Inner Merge Join query with SELECT COUNT(*) on top
> ---------------------------------------------------------------------------------
>
> 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
> Attachments: oracle11-ds.xml, postgres-8.4-tpcr01-ds.xml, server_with_error.log, TPC.vdb
>
>
> 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(*) isn't used
--
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
More information about the teiid-issues
mailing list