Enhanced sort join produces duplicate results --------------------------------------------- Key: TEIID-2942 URL: https://issues.jboss.org/browse/TEIID-2942 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 8.4 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Critical Fix For: 8.7.1, 8.8 In a plan where an enhanced sort join chooses to create an index on a child that should be SORT_DISTINCT, the distinct processing does not occur. For example this would occur with a query such as: select a.e1, b.e2 from pm1.g1 as a, (select e1, e2 from pm2.g2 union select e1, e2 from pm2.g2) as b where a.e1 = b.e1 where the source does not support union.