Steven Hawkins created TEIID-2787: ------------------------------------- Summary: Correlated grouping expression not properly replaced in pushdown subquery Key: TEIID-2787 URL: https://issues.jboss.org/browse/TEIID-2787 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 8.4 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.7 A correlated grouping expression appears in the pushdown query with the internal group name anon_grpX rather than the proper reference from the outer query. For example the user query: select x, (select avg(y) from tbl1 where x = tbl2.x) from tbl2 group by x would have where x = anon_grp0.x -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira