The following rules apply to the use of the DEFAULT function as part of a RESET WHEN condition:
- You can specify a DEFAULT function with a column name argument within a predicate. The system evaluates the DEFAULT function to the default value of the column specified as its argument. After the system evaluates the DEFAULT function, it treats it like a literal in the predicate.
- You can specify a DEFAULT function without a column name argument within a predicate only if there is one column specification and one DEFAULT function as the terms on each side of the comparison operator within the expression.
- Following existing comparison rules, a condition with a DEFAULT function used with comparison operators other than IS [NOT] NULL is unknown if the DEFAULT function evaluates to null.
A condition other than IS [NOT]NULL with a DEFAULT function compared with a null evaluates to unknown.
|IF a DEFAULT function is used with...||THEN the comparison is...|
|IS NULL||TRUE if the default is null,
else it is FALSE.
|IS NOT NULL||FALSE if the default is null,
else it is TRUE.