[
https://issues.jboss.org/browse/TEIID-5094?page=com.atlassian.jira.plugin...
]
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/d0f6217824b0c4d64b1d166e8f7c69529acdf...
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)