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

[dalex dalex (Jira)]

dalex dalex created TEIID-5668:
----------------------------------

             Summary: 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
         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.



--
This message was sent by Atlassian Jira
(v7.12.1#712002)