[teiid-issues] [JBoss JIRA] (TEIID-3807) quantified comparison results dependent on null ordering

[Steven Hawkins (JIRA)]

Steven Hawkins created TEIID-3807:
-------------------------------------

             Summary: quantified comparison results dependent on null ordering
                 Key: TEIID-3807
                 URL: https://issues.jboss.org/browse/TEIID-3807
             Project: Teiid
          Issue Type: Bug
          Components: Query Engine
            Reporter: Steven Hawkins
            Assignee: Steven Hawkins
             Fix For: 8.13, 8.12.2


The handling of null and it's affect on the result is dependent upon it's position in the the subquery result.  

Specifically if null occurs before something that would otherwise evaluate to true for an all comparison the result will be true and not the expected null.  Or if null occurs before something that would be otherwise false in a some comparison, then false will be returned rather than the expected null.





--
This message was sent by Atlassian JIRA
(v6.4.11#64026)