[teiid-designer-issues] [JBoss JIRA] Commented: (TEIIDDES-589) Incorrect alias resolving upon validation with self-joined queries in Transformation Editor

Incorrect alias resolving upon validation with self-joined queries in Transformation Editor ------------------------------------------------------------------------------------------- Key: TEIIDDES-589 URL: https://jira.jboss.org/browse/TEIIDDES-589 Project: Teiid Designer Issue Type: Bug Components: Transformations, Validation Affects Versions: 7.1 Reporter: Carmon Hesse Fix For: 7.1.1 Upon Save/Validate of the following SQL query, the self-joined query transforms the alias.column in the WHERE clause into alias.view.model.table.column. This also occurs using the full-path to adress two tables with the same name from two different sources. Only the aliases in the WHERE clause are affected by this problem. SELECT p1.name, p1.version FROM view.model.table p1, view.model.table.p2 WHERE p1.id = p2.id AND p1.name = p2.name into SELECT p1.name, p1.version FROM view.model.table p1, view.model.table.p2 WHERE p1.view.model.table.id = p2.view.model.table.id AND p1.view.model.table.name = p2.view.model.table.name Error message is: The query is parsable but not resolvable. Resolver Error: Symbol p1.view.model.table.id is specified with an unknown group context