Steven Hawkins created TEIID-4875: ------------------------------------- Summary: Planning issue with multiple aggregate decompositions through a join tree Key: TEIID-4875 URL: https://issues.jboss.org/browse/TEIID-4875 Project: Teiid Issue Type: Bug Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 9.3, 9.2.3 The logic for determining other symbols from aggregates will not work correctly when a staged grouping is initially pushed and another staged grouping is then pushed above a join that is above that location (typically due to join predicates that pull in other groups). A query such as: SELECT max(t3.e4), max(t2.e4) as s FROM pm1.g1 as t1, pm1.g2 as t2, pm1.g3 as t3, pm1.g4 as t4, pm2.g1 as t5 WHERE t1.e1 = t2.e1 and (t2.e2 = t3.e2 and t1.e3 || t2.e3 = t3.e3) and t3.e3 = t4.e3 and t4.e4 = t5.e4 Will fail with an assertionerror that a staged grouping symbol cannot be found during the initialization of the parent join node. -- This message was sent by Atlassian JIRA (v7.2.3#72005)