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.
