Nesting aliases that match the engine recontext logic can lead to
naming conflicts
----------------------------------------------------------------------------------
Key: TEIID-3311
URL:
https://issues.jboss.org/browse/TEIID-3311
Project: Teiid
Issue Type: Feature Request
Reporter: Steven Hawkins
Assignee: Steven Hawkins
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.