[teiid-issues] [JBoss JIRA] (TEIID-5987) salesforce self join involving implicit null check on parentid field not working

[Steven Hawkins (Jira)]

Steven Hawkins created TEIID-5987:
-------------------------------------

             Summary: salesforce self join involving implicit null check on parentid field not working
                 Key: TEIID-5987
                 URL: https://issues.redhat.com/browse/TEIID-5987
             Project: Teiid
          Issue Type: Bug
            Reporter: Steven Hawkins
            Assignee: Steven Hawkins


I'm not sure about the full scope of this issue.  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

which results in the source query with the implicit null check:

SELECT Id FROM Account WHERE ParentId != NULL

actually returns results, but no are expected.

The explicit non-join query query

select a1.id from Account a1 where a1.parentid is not null

result in:

SELECT Id FROM Account WHERE ParentId != NULL

but returns no results

So there is something in the join handling that is not working as expected.





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