Wenjun Zhu created TRAFODION-3190:
-------------------------------------
Summary: 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
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)
