[jira] [Created] (CALCITE-5336) Support inferring constants from predicates with IS NOT DISTINCT FROM operator

["Jasmin Trada (Jira)" <ji...@apache.org>]

Jasmin Trada created CALCITE-5336:
-------------------------------------

             Summary: Support inferring constants from predicates with IS NOT DISTINCT FROM operator
                 Key: CALCITE-5336
                 URL: https://issues.apache.org/jira/browse/CALCITE-5336
             Project: Calcite
          Issue Type: Improvement
          Components: core
            Reporter: Jasmin Trada


Whenever we have IS NOT DISTINCT FROM operator in a predicate RexUtil's 

predicateConstants method is not able to identify the constants.

E.g., If we make a predicate as given below,

//dec20 = IS_NOT_DISTINCT_FROM($0, CAST(2020-12-11):DATE)

RexNode dec20 = rexB.makeCall(IS_NOT_DISTINCT_FROM,
            rexB.makeInputRef(dateColumnType, 0),
            rexB.makeLiteral(new DateString(2020, 12, 11), dateColumnType, false));

and if we call 

RexUtil.predicateConstants(RexNode.class, rexB, Arrays.asList(dec20)),

it will return an empty map, but it should have returned something like

{ "$0" -> "CAST(2020-12-11):DATE"}.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)