[
https://issues.jboss.org/browse/TEIID-4976?page=com.atlassian.jira.plugin...
]
Marc Shirley commented on TEIID-4976:
-------------------------------------
This is to look into pulling back a fix to 6.2.12. So, to an effect both. My comments
towards not being able to find an original previous report for this were towards
indicating that this is resolved in 8.12 versions, but still present in 8.7 versions. So,
the intention is to identify the original issue if it exists, or explore what change fixed
the issue if a previous report for this scenario does not exist.
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.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)