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

[Steven Hawkins (JIRA)]

Steven Hawkins created TEIID-3310:
-------------------------------------

             Summary: 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: Feature Request
          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)