[
https://issues.jboss.org/browse/TEIID-2747?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-2747.
-----------------------------------
Fix Version/s: 8.4.1
Resolution: Done
Ensured that the proper distinct index is checked for dup_remove_sort.
Wrong results with merge join SORT_DISTINCT 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.4.1, 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