[teiid-issues] [JBoss JIRA] (TEIID-2747) Wrong results with merge join with a full sort that is distinct beyond the join columns
Steven Hawkins created TEIID-2747:
-------------------------------------
Summary: Wrong results with merge join with a full sort that is distinct
beyond the join columns
Key: TEIID-2747
URL: https://issues.jboss.org/browse/TEIID-2747
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.4
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Priority: Blocker
Fix For: 8.6
To speed up processing of a sort merge join we attempt to eliminate extra comparisons by
detecting if the equi-join column values are distinct. In plans where the sorted values
are distinct beyond the equi-join values such that the equi-join column values are
non-distinct, then incorrect results can be returned.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira