[teiid-issues] [JBoss JIRA] (TEIID-3310) Nesting aliases that match the engine recontext logic can lead to naming conflicts

[Steven Hawkins (JIRA)]

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

Steven Hawkins updated TEIID-3310:
----------------------------------
    Issue Type: Bug  (was: Feature Request)


> Nesting aliases that match the engine recontext logic can lead to naming conflicts
> ----------------------------------------------------------------------------------
>
>                 Key: TEIID-3310
>                 URL: https://issues.jboss.org/browse/TEIID-3310
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 7.7
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 8.10
>
>
> A query such as:
> select (select e4 from pm1.g1 X__1), pm1.g1.e2 from pm1.g1, /*+ makeind */ (select e1 from pm2.g1) AS X__1, (select distinct e2, e3 from pm3.g1) X__2 where pm1.g1.e3 = X__1.e1 and pm1.g1.e2 = year(X__2.e3)
> Will fail to process correctly as the X__1 and X__2 aliases are already in use, which will cause an AssertionError during processing attempting to reference X__1.e1.



--
This message was sent by Atlassian JIRA
(v6.3.11#6341)