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

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 Fix For: 9.0.6, 9.2, 9.1.3, 8.7.12.6_2 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}