[
https://issues.apache.org/jira/browse/TRAFODION-3190?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Selvaganesan Govindarajan updated TRAFODION-3190:
-------------------------------------------------
Fix Version/s: (was: 2.3)
2.4
> 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.4
>
>
> 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
(v8.3.4#803005)
