pruning support cast/try_cast expr #3414
Description
Is your feature request related to a problem or challenge? Please describe what you are trying to do.
In many case with the filter expr like c1 < 1, the filter expr many be cast to other data type through the type coercion logic.
After the optimizer, the filter may be added the cast/try_cast expr, but it can't be pruned with statistical data
Describe the solution you'd like
A clear and concise description of what you want to happen.
Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.
Additional context
Add any other context or screenshots about the feature request here.
Activity
liukun4515 commentedon Sep 9, 2022
This also resolve the failed case in #3396
alamb commentedon Sep 9, 2022
I think this is a dupe of #3377
liukun4515 commentedon Sep 10, 2022
Thank, I think i missing the issue in the list.
This issue are just inspired from the test case #3396
liukun4515 commentedon Sep 10, 2022
in order to make the correctness described in #3377, we should make the sure the type of value has order.
Now we will have the plan to support them:
liukun4515 commentedon Sep 13, 2022
it is mentioned in the #3442
I will close this issue