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

Steven Hawkins (JIRA) issues at jboss.org
Wed Oct 11 09:54:00 EDT 2017


    [ https://issues.jboss.org/browse/TEIID-5094?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13475407#comment-13475407 ] 

Steven Hawkins commented on TEIID-5094:
---------------------------------------

> What is the expectation for update count here?

No the update count is unaffected by trigger logic, it is only based upon upon the number of rows affected from the view - https://teiid.gitbooks.io/documents/content/reference/Update_Procedures_Triggers.html

> 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)


More information about the teiid-issues mailing list