dalex dalex created TEIID-4727:
----------------------------------
Summary: 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)