Steven Hawkins created TEIID-3311: ------------------------------------- Summary: 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 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)