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

• Type: Improvement
• Status: Closed
• Priority: Trivial
• Resolution: Fixed
• Fix Version/s: 1.33.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Jasmin Trada
• Reporter: Jasmin Trada
• Created: 18/Oct/22 01:19
• Updated: 07/Feb/23 22:33
• Resolved: 22/Nov/22 06:37

Description

Whenever we have IS NOT DISTINCT FROM operator in a predicate, the predicateConstants method in RexUtil 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 this:

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

Issue Links

• links to: GitHub Pull Request #2961