[CALCITE-6649] Enhance RelMdPredicates pull up predicate from PROJECT

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.39.0
• Labels: pull-request-available
• Assignee: xiong duan
• Reporter: xiong duan
• Created: 29/Oct/24 00:38
• Updated: 26/Dec/24 02:56
• Resolved: 26/Dec/24 02:56

Description

select comm = 2 from emp where comm = 2 can pull up =($0, true)
select comm = 3 from emp where comm = 2 can pull up =($0, false)
select comm = 2 from emp where comm = 2 and empno = 1 can pull up =($0, true)
select comm = 2  empno = 1 and from emp where comm = 2 and empno = 1 can pull up =($0, true)
Now the pull up predicate is nothing. 

Issue Links

• is blocked by: CALCITE-1048 Make metadata more robust
• is fixed by: CALCITE-6586 Some Rules not firing due to RelMdPredicates returning null in VolcanoPlanner
• is related to: CALCITE-5036 `RelMetadataQuery#getPulledUpPredicates` support to analyze constant key for the operator of IS_NOT_DISTINCT_FROM
• links to: GitHub Pull Request #4021