[
https://issues.apache.org/jira/browse/TRAFODION-3190?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16683453#comment-16683453
]
ASF GitHub Bot commented on TRAFODION-3190:
-------------------------------------------
Github user wenjun-zhu closed the pull request at:
https://github.com/apache/trafodion/pull/1705
> 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)
