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

[RH Bugzilla Integration (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-4976?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

RH Bugzilla Integration updated TEIID-4976:
-------------------------------------------
    Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1492802, https://bugzilla.redhat.com/show_bug.cgi?id=1468368, https://bugzilla.redhat.com/show_bug.cgi?id=1466507  (was: https://bugzilla.redhat.com/show_bug.cgi?id=1468368, https://bugzilla.redhat.com/show_bug.cgi?id=1466507)


> 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.12.12.6_3, 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.



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)