Johnathon Lee created TEIID-1988: ------------------------------------ Summary: Getting Assertion when running Inner Merge Join query with SELECT COUNT(*) on top Key: TEIID-1988 URL: https://issues.jboss.org/browse/TEIID-1988 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.4.1 Reporter: Johnathon Lee Assignee: Steven Hawkins Fix For: 7.7, 8.0 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