The following rules apply to using the DEFAULT function with the upsert form of UPDATE:
The resulting data type of the DEFAULT function is the data type of the constant or built-in function specified as the default unless the default is NULL. If the default is NULL, the resulting date type of the DEFAULT function is the same as the data type of the column or expression for which the default is being requested.
DEFAULT
or DEFAULT (
column_name)
. When no column name is specified, the system derives the column based on context.
If the column context cannot be derived, the request aborts and an error is returned
to the requestor.
See SQL Functions, Operators, Expressions, and Predicates for more information about the DEFAULT function.