[teiid-issues] [JBoss JIRA] (TEIID-4976) criteria duplicated when criteria includes the same columns as dependent join criteria

[Marc Shirley (JIRA)]

Marc Shirley created TEIID-4976:
-----------------------------------

             Summary: 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)