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.