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.