[teiid-issues] [JBoss JIRA] (TEIID-1988) Getting Assertion when running Inner Merge Join query with SELECT COUNT(*) on top

[Larry O'Leary (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-1988?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Larry O'Leary updated TEIID-1988:
---------------------------------

                   Issue Type: Bug  (was: Support Patch)
              Bugzilla Update:   (was: Perform)
       Support Case Reference: http://access.redhat.com  (was: https://c.na7.visual.force.com/apex/Case_View?id=500A0000009fnAE&sfdc.override=1)
    SVN / CVS Isolated Branch:   (was: https://svn.jboss.org/repos/teiid/branches/7.4.x/)
          Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=807870  (was: https://bugzilla.redhat.com/show_bug.cgi?id=807870)

    
> 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: Johnathon Lee
>
> 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