[CALCITE-5036] `RelMetadataQuery#getPulledUpPredicates` support to analyze constant key for the operator of IS_NOT_DISTINCT_FROM

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.31.0
• Labels: pull-request-available
• Assignee: Xurenhe
• Reporter: Xurenhe
• Created: 09/Mar/22 08:58
• Updated: 24/Dec/24 10:43
• Resolved: 02/Apr/22 06:04

Description

As we know, `IS NOT DISTINCT FROM` is NULL-Safe equal operator.

The expression of "`a` IS NOT DISTINCT FROM 10" is equal to "(`a` = 10) IS TRUE".

Currently, `RelMetadataQuery#getPulledUpPredicates` could analyze the constant from the constant's equal condition in the filter, not support `IS NOT DISTINCT FROM`

-- sql
SELECT deptno,
       mgr,
       ename
FROM emp
WHERE deptno IS NOT DISTINCT FROM 10

By the way, `deptno` need be rewritten to the constant project with number of 10, when applying the rule of CoreRules#PROJECT_REDUCE_EXPRESSIONS

Issue Links

• fixes: CALCITE-4663 And predicate in one subtree of Join causes JoinPushTransitivePredicatesRule pulls up predicates infinitely and StackOverflowError
• is related to: CALCITE-6467 Performance of RelMdUtil.checkInputForCollationAndLimit when using `where col in (large literal set)`
• relates to: CALCITE-6649 Enhance RelMdPredicates pull up predicate from PROJECT
• links to: GitHub Pull Request #2743
• links to: GitHub Pull Request #4104