Runkang He created CALCITE-5759: ----------------------------------- Summary: SEARCH operator with special sarg is not fully simplified Key: CALCITE-5759 URL: https://issues.apache.org/jira/browse/CALCITE-5759 Project: Calcite Issue Type: Improvement Components: core Affects Versions: 1.34.0 Reporter: Runkang He
The minimal reproducer is to construct a RexCall with RexUnknownAs.FALSE as below: {code:sql} SEARCH(1, Sarg[IS NOT NULL]) {code} After RexSimplify#simplifySearch, the final simplified result is IS NOT NULL(1), which should be TRUE more thoroughly. Also, the following RexCall with RexUnknownAs.TRUE: {code:sql} SEARCH(1, Sarg[IS NULL]) {code} Is simplified to IS NULL(1), which should be FALSE. Note that current simplified result is inconsistent with RexCall.isAlwaysFalse and isAlwaysTrue. Therefore, for the above two reasons, I think we need to simplify SEARCH operator with special sarg more thoroughly. -- This message was sent by Atlassian Jira (v8.20.10#820010)