[teiid-issues] [JBoss JIRA] (TEIID-4727) Aggregation is performed incorrectly for JOIN queries

[Steven Hawkins (JIRA)]

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

Steven Hawkins updated TEIID-4727:
----------------------------------

I still see this behavior on master.  The handling of count or other cardinality dependent aggregates assumes a join predicate to relate the sides of the join.  Without that in many circumstances we should not be pushing the staged grouping. 

> Aggregation is performed incorrectly for JOIN queries
> -----------------------------------------------------
>
>                 Key: TEIID-4727
>                 URL: https://issues.jboss.org/browse/TEIID-4727
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 9.0.3
>         Environment: teiid-9.0.3 on WildFly Full 9.0.2.Final (WildFly Core 1.0.2.Final)
>            Reporter: dalex dalex
>            Assignee: Steven Hawkins
>            Priority: Blocker
>
> Aggregation is performed incorrectly for JOIN queries, like this
> {code:sql}
> select count(v2.b) from views.v1 right join views.v2 on true group by v1.b;
> select count(v2.b) from views.v1 join (call procs.pr()) v2 on true group by v1.b;
> select count(v2.b) from views.v1 left join (call procs.pr()) v2 on true group by v1.b;
> select count(v2.b) from views.v1 right join (call procs.pr()) v2 on true group by v1.b;
> {code}
> showing as a result:
> {code}
> 1
> 1
> 1
> {code}
> though these ones work correctly:
> {code:sql}
> select count(v2.b) from views.v1 join views.v2 on true group by v1.b;
> select count(v2.b) from views.v1 left join views.v2 on true group by v1.b;
> {code}
> showing
> {code}
> 1
> 1
> 2
> {code}



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)