[
https://issues.apache.org/jira/browse/TRAFODION-3190?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16593323#comment-16593323
]
ASF GitHub Bot commented on TRAFODION-3190:
-------------------------------------------
GitHub user wenjun-zhu opened a pull request:
https://github.com/apache/trafodion/pull/1705
[TRAFODION-3190] expression involving NULL should be treated as FALSE, not
TRUE.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/wenjun-zhu/trafodion null-in-case-when
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/trafodion/pull/1705.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #1705
----
commit 31af53058c92bbeeeffd299feade475781d40925
Author: wenjun.zhu <wenjun.zhu@...>
Date: 2018-08-23T03:39:10Z
expression involving NULL should be treated as FALSE, not TRUE.
----
> expression involving NULL treated as TRUE.
> ------------------------------------------
>
> Key: TRAFODION-3190
> URL: https://issues.apache.org/jira/browse/TRAFODION-3190
> Project: Apache Trafodion
> Issue Type: Bug
> Components: -exe
> Affects Versions: 2.2.0
> Reporter: Wenjun Zhu
> Assignee: Wenjun Zhu
> Priority: Minor
> Fix For: 2.3
>
>
> expression involving NULL should be treated as FALSE, not TRUE.
>
> like this:
>
> {code:java}
> select case when cast(null as int) > 0 then 1/0 else 0 end from dual;{code}
>
> should output 0, not a Division by zero error.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
