[teiid-issues] [JBoss JIRA] (TEIID-3990) Issues with nested correlated references

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-3990?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins updated TEIID-3990:
----------------------------------
    Fix Version/s: 8.12.6.6_3


> Issues with nested correlated references
> ----------------------------------------
>
>                 Key: TEIID-3990
>                 URL: https://issues.jboss.org/browse/TEIID-3990
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 8.4
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 9.0, 8.12.5, 8.13.2
>
>
> There are several issues with nested correlated reference handling generally around having the same table name/alias in several levels of the query.  For example with a having c1, c2 columns, b having c3, c4, and c having c5, c6:
> SELECT (select c2 from b where c3 = (select c5 from c as x where c6 = c1)) FROM a as x group by c1, c2
> Results in an exception since the inner most reference to c1 is seen as actually resolving to c as x - rather than the outer a as x.



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)