]
Steven Hawkins commented on TEIID-4976:
---------------------------------------
Are you asking to track down the original issue, or just to document that the issue
existed on the given version?
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
Affects Versions: 8.7.11.6_2
Reporter: Marc Shirley
Assignee: Steven Hawkins
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.