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

[RH Bugzilla Integration (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-1899?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12680175#comment-12680175 ] 

RH Bugzilla Integration commented on TEIID-1899:
------------------------------------------------

Larry O'Leary <loleary at redhat.com> made a comment on [bug 807870|https://bugzilla.redhat.com/show_bug.cgi?id=807870]

The issue is that distinct dependent tuple buffers are being removed (previously a new tuplebuffer was always created regardless of whether the distinct operation was needed or not).

Note that this issue was also partially due to the dependent join backoff logic, since that was triggering a normal handling of the effective semi-join. 7.4.x may also benefit from change r3780 that more narrowly applies the backoff logic to only when column ndv values are known.

This issue was fixed in upstream as TEIID-1899 and needs to be back-ported for inclusion in the current release as a hot-fix patch or single-fix patch. As recommended by TEIID-1899, TEIID-1868 and TEIID-1533 should also be back-ported.



Relevant changes in upstream:

Steven Hawkins submitted changeset 3803 to 7.6.x in Teiid (2 files) - 18/Jan/12 3:04 PM

TEIID-1899 fixing assertion error during join

    * branches/7.6.x/engine/src/main/java/org/teiid/query/processor/relational/DependentCriteriaProcessor.java
    * branches/7.6.x/engine/src/test/java/org/teiid/query/processor/TestDependentJoins.java



Steven Hawkins submitted changeset 3780 to 7.6.x in Teiid (2 files) - 06/Jan/12 3:04 PM

TEIID-1868 Internal Materialized View - Load/Refresh and Assertion Failed
TEIID-1533 additional controls for dependent joins

    * branches/7.6.x/engine/src/main/java/org/teiid/query/optimizer/relational/rules/NewCalculateCostUtil.java
    * branches/7.6.x/engine/src/test/java/org/teiid/query/processor/TestDependentJoins.java
                
> 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
>             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