Julian Hyde created CALCITE-3049:
------------------------------------
Summary: When simplifying expressions, revisit "IS NULL" if its
argument has been simplified
Key: CALCITE-3049
URL: https://issues.apache.org/jira/browse/CALCITE-3049
Project: Calcite
Issue Type: Bug
Reporter: Julian Hyde
When simplifying expressions, revisit "IS NULL" if its argument has been
simplified. For example, we currently simplify {code}(CASE WHEN FALSE THEN
+(v0) ELSE -1 END) IS UNKNOWN{code} to {code}-1 IS UNKNOWN{code} but we should
further simplify that to {{FALSE}}.
I have a preliminary dev branch, but it needs a little more debugging. I'd be
grateful if someone could finish it.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
