-
Notifications
You must be signed in to change notification settings - Fork 1.9k
Open
Labels
enhancementNew feature or requestNew feature or request
Description
Is your feature request related to a problem or challenge?
When simplifying expressions in general, care must be taken with nulls. For example it seems like this expression can be simplified to false:
A AND !Ahowever, if A is null then the expression actually evaluates to null and not false
The existing simplification code handles these cases by checking is_nullable:
However, if we are using A AND !A as a filter, we can actually simplify the whole thing to false because for filtering:
true--> row is keptfalse--> row is not keptnull--> row is not kept (same as false)
Describe the solution you'd like
I would like someone to figure out how to take advantage of the above observation to apply more simplification rules when simplifying predicates
Describe alternatives you've considered
No response
Additional context
No response
wjones127
Metadata
Metadata
Assignees
Labels
enhancementNew feature or requestNew feature or request