Following existing comparison rules, a condition with a DEFAULT function used with comparison operators other than IS NULL or IS NOT NULL is unknown if the DEFAULT function evaluates to null.
A condition other than IS NULL or IS NOT NULL with a DEFAULT function compared to a null evaluates to unknown.
Clause Used with DEFAULT Function | Comparison Result |
---|---|
IS NULL | TRUE if default is null, otherwise FALSE. |
IS NOT NULL | FALSE if default is null, otherwise TRUE. |