Details
-
Bug
-
Resolution: Done
-
Blocker
-
7.1
-
None
Description
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