Considering that all implementations I’m aware of have evaluated that expression to NULL, this isn’t a very pragmatic example. NULL is unknown, and every type has it as a possibility.
The SQL2003 changes were more about how constraints should treat NULL than anything intrinsic about NULL itself.
Comments
Considering that all implementations I’m aware of have evaluated that expression to NULL, this isn’t a very pragmatic example. NULL is unknown, and every type has it as a possibility.
The SQL2003 changes were more about how constraints should treat NULL than anything intrinsic about NULL itself.