[CALCITE-6592] Add test for RelMdPredicates pull up predicate from UNION when it's input predicates include NULL VALUE

• 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: 24/Sep/24 11:37
• Updated: 24/Oct/24 05:38
• Resolved: 24/Oct/24 05:38

Description

The RelNode:

LogicalUnion(all=[true])
  LogicalValues(tuples=[[{ NULL }]])
  LogicalValues(tuples=[[{ 131 }]])

 The predicate is '$0 == 131'

LogicalUnion(all=[true])
  LogicalValues(tuples=[[{ 11 }]])
  LogicalValues(tuples=[[{ 131 }]])
{pulled[SEARCH($0, Sarg[11, 131])]}

The Predicate is SEARCH($0, Sarg[11, 131]).

So the first RelNode's Predicate should be NONE or SEARCH($0, Sarg[null, 131]) or (NULL, =($0, 5)).

Issue Links

• blocks: CALCITE-5156 Support implicit integer type cast for IN Sub-query
• is blocked by: CALCITE-6599 RelMdPredicates should pull up more predicates from VALUES when there are several literals
• links to: GitHub Pull Request #3975