Runkang He created CALCITE-5798: ----------------------------------- Summary: '(10 < x) IS NOT TRUE' when x is not nullable should be simplified to '10 >= x' Key: CALCITE-5798 URL: https://issues.apache.org/jira/browse/CALCITE-5798 Project: Calcite Issue Type: Improvement Components: core Affects Versions: 1.34.0 Reporter: Runkang He
Currently '(10 < x) IS NOT TRUE' when pulled up predicates contain 'x IS NOT NULL' is not simplified, and keep it as it is. It can and should be simplified to '10 >= x', which is more concise and useful for further simplification, such as CALCITE-5780 Note that this Jira is splited from CALCITE-5780, which make this part of codes more clear. -- This message was sent by Atlassian Jira (v8.20.10#820010)