[teiid-issues] [JBoss JIRA] (TEIID-1899) Getting Assertion when running Inner Merge Join query with SELECT COUNT(*) on top
[
https://issues.jboss.org/browse/TEIID-1899?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-1899:
------------------------------------------------
Larry O'Leary <loleary(a)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