[teiid-issues] [JBoss JIRA] (TEIID-5094) Is DISTINCT FROM evaluation with two null values

[Steven Hawkins (JIRA)]

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

Steven Hawkins updated TEIID-5094:
----------------------------------
           Description: 'row(null) is distinct from row(null)" evaluates to true when false is expected.  (was: 'row(null) is distinct from row(null)" evaluates to true when true is expected.)
    Steps to Reproduce: 
See https://github.com/teiid/teiid/blob/d0f6217824b0c4d64b1d166e8f7c69529acdface/engine/src/test/java/org/teiid/query/processor/TestTriggerActions.java#L277

Given that IS DISTINCT prior to 10.0 is restricted to IF statements in procedures, this needs to should be tested using an update trigger.  See the test case, both the new and the old row value contain a column with a value of null - as the GX view is defined with the second branch as "select null as x" and the user update "update gx set x = x || 'a' where y = 2" expression for the x value evaluates to null for that row.


> Is DISTINCT FROM evaluation with two null values
> ------------------------------------------------
>
>                 Key: TEIID-5094
>                 URL: https://issues.jboss.org/browse/TEIID-5094
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 8.12
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>            Priority: Critical
>             Fix For: 10.0, 8.12.x-6.4, 9.3.4, 9.2.7
>
>
> 'row(null) is distinct from row(null)" evaluates to true when false is expected.



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)