[ https://issues.apache.org/jira/browse/CALCITE-3049?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Julian Hyde updated CALCITE-3049: --------------------------------- Component/s: core > 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 > Components: core > Reporter: Julian Hyde > Priority: Major > > 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|https://github.com/julianhyde/calcite/tree/3049-simplify-is-null], 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)