[teiid-issues] [JBoss JIRA] (TEIID-5987) Plan with join removal returns unexpected values

[Steven Hawkins (Jira)]

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

Steven Hawkins resolved TEIID-5987.
-----------------------------------
    Resolution: Done


Corrected the handling by adding is null (similar to what the salesforce translator has to do) predicates in the inner join case.  This does not deeply introspect whether it's possible for the column to be null, which can be added later.

> Plan with join removal returns unexpected values
> ------------------------------------------------
>
>                 Key: TEIID-5987
>                 URL: https://issues.redhat.com/browse/TEIID-5987
>             Project: Teiid
>          Issue Type: Bug
>          Components: Salesforce Connector
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>            Priority: Critical
>             Fix For: 15.0, 13.1.2, 14.0.1
>
>   Original Estimate: 4 hours
>          Time Spent: 3 hours
>  Remaining Estimate: 1 hour
>
> In testing TEIIDSB-213 I can see that a query such as:
> select a1.id from Account a1 inner join account a2 on a1.parentid = a2.id
> actually returns results, but no are expected.
> Whereas 
> select a1.id from Account a1 where a1.parentid is not null
> returns no results as expected



--
This message was sent by Atlassian Jira
(v7.13.8#713008)