[teiid-issues] [JBoss JIRA] (TEIID-2787) Correlated grouping expression not properly replaced in pushdown subquery

[Steven Hawkins (JIRA)]

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