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

[Marc Shirley (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4976?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13429917#comment-13429917 ] 

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)