pengzhiwei created CALCITE-2393:
-----------------------------------
Summary: RexSimplify optimization error for expression 'x is not
null and x <> 5'
Key: CALCITE-2393
URL: https://issues.apache.org/jira/browse/CALCITE-2393
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.16.0
Reporter: pengzhiwei
Assignee: Julian Hyde
Fix For: 1.17.0
After the optimization of RexSimplify,the expression 'x is not null and x <>
5' (x is nullable) is optimized to 'x<> 5' (RexSimplify#unknownAsFalse is
true). I think it is not a correct result because when x is null, null<> 5
should return true,while 'x is not null and x <> 5' return false.
I think the optimization for "is not null" in
RexSimplify#simplifyAnd2ForUnknownAsFalse should exclude the case of not-equal
operator.
I really confused with this optimization, can you give some suggestion,thanks!
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
