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

[Steven Hawkins (Jira)]

     [ https://issues.jboss.org/browse/TEIID-5668?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Work on TEIID-5668 started by Steven Hawkins.
---------------------------------------------
> 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: Major
>         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)