[teiid-issues] [JBoss JIRA] (TEIID-5550) DISTINCT pushed down incorrectly in some cases

DISTINCT pushed down incorrectly in some cases ---------------------------------------------- Key: TEIID-5550 URL: https://issues.jboss.org/browse/TEIID-5550 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 8.12.15.6_4 Environment: JDV 6.4.5 Reporter: Marc Shirley Assignee: Steven Hawkins Priority: Major Fix For: 11.1.2, 12.0, 11.2.1 The parent DISTINCT is being removed over joins in particular situations. This is a regression from TEIID-3063 TEIID-3062. Conditions: - basic query structure is select distinct col from a join b on a.col2 = b.col2 - a sort merge join variant must have been planned - the sort must not be pushed to one of the children - the projection related conditions of TEIID-3062 / TEIID-3063 must be met - there is a one to many relationship The result is that the parent distinct will be inappropriately removed, such that the output of the join can contain repetition of the col value when it should be distinct.