]
Van Halbert updated TEIID-4976:
-------------------------------
Fix Version/s: 8.12.x-6.4
(was: 8.12.12.6_3)
criteria duplicated when criteria includes the same columns as
dependent join criteria
--------------------------------------------------------------------------------------
Key: TEIID-4976
URL:
https://issues.jboss.org/browse/TEIID-4976
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 8.7.11.6_2
Reporter: Marc Shirley
Assignee: Steven Hawkins
Fix For: 10.0, 8.12.x-6.4, 8.7.13.6_2
Submitting a query that uses the same column for the join condition and criteria results
in the criteria being duplicated on the dependent side of the join.
For example:
SELECT * FROM A, B
WHERE B.id = A.id AND A.id IN ('1','2','3') OPTION MAKEDEP B;
Results in the dependent side query looking like:
SELECT ... FROM B WHERE B.id IN ('1','2','3') AND B.id IN
('1','2','3');
This looks to have already been resolved in later versions, but I was not able to find
the original JIRA that would have addressed this issue.