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

[Johnathon Lee (JIRA)]

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

Johnathon Lee commented on TEIID-4976:
--------------------------------------

I'm going to provide the pre-QE version to the customer for them to fully
vet their use case.  We can go from the results of that.

Thanks,
JLee




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