Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
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)).
Attachments
Issue Links
- blocks
-
CALCITE-5156 Support implicit number type cast for IN Sub-query
- In Progress
- is blocked by
-
CALCITE-6599 RelMdPredicates should pull up more predicates from VALUES when there are several literals
- Open
- links to