[teiid-issues] [JBoss JIRA] (TEIID-5668) Wrong results on left join + aggregation

Wrong results on left join + aggregation ---------------------------------------- Key: TEIID-5668 URL: https://issues.jboss.org/browse/TEIID-5668 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 12.0 Environment: teiid-12.0.0 on WildFly Full 14.0.1.Final (WildFly Core 6.0.2.Final) Reporter: dalex dalex Assignee: Steven Hawkins Priority: Blocker Fix For: 12.0.1, 12.1, 11.2.3, 8.12.18.6_4 Attachments: wrong_count_results_1.jpg, wrong_count_results_2.jpg When using a query with a left join between tables from different schemes and count it produces wrong results. The workflow for reproducing the bug contains two example queries. The only difference between these queries is the order of the counts in select clause. The first query returns wrong results (the output of the "count(b.SalesPersonID)" field). Additional info: a) the wrong count results are the distinct values b) occurs also with other aggregations.