[ https://issues.jboss.org/browse/TEIID-2787?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-2787: ---------------------------------- Description: 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 was: 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 Workaround Description: Use an inline view to correlated on a projected column. For example rather than: select x, (select avg\(y) from tbl1 where x = tbl2.x) from tbl2 group by x use: select x, (select avg\(y) from tbl1 where x = v.x) from (select x from tbl2 group by x) as v was: Use an inline view to correlated on a projected column. For example rather than: select x, (select avg(y) from tbl1 where x = tbl2.x) from tbl2 group by x use: select x, (select avg(y) from tbl1 where x = v.x) from (select x from tbl2 group by x) as v -- 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