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

[Johnathon Lee (JIRA)]

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

Johnathon Lee updated TEIID-3807:
---------------------------------
    Fix Version/s: 8.7.9.6_2


> 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.12.2, 8.13, 8.7.9.6_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)