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
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
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira