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)
|