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

[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