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

[Johnathon Lee (Jira)]

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

Johnathon Lee updated TEIID-5668:
---------------------------------
    Fix Version/s: 8.12.18.6_4


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



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