- Notifications
You must be signed in to change notification settings - Fork 25.6k
Closed
Description
Both IS NULL and IS NOT NULL get translated to the latter form as this maps nicely to the exists query.
However for scripting this ends up with double methods which is inconvenient as it's a negation of a negation.
Having a proper IS NULL would simplify this, allow a shortcut optimization of negating is not null and overall be more intuitive internally-wise.