News for hackers. Stuff that matters.
Re:SQL Design Patterns by chasil on Saturday August 30, 2025 @10:37PM (#45079856)
> Also, in no way does SQL hide anything - it’s a declarative language, and will produce exactly what you tell it to.

Ha ha, no, SQL implementations can conform to the standard in unexpected ways.

NULL = NULL

Is that true or false? We didn't know until 2003.

https://en.wikipedia.org/wiki/Null_(SQL)#Criticisms

Re:SQL Design Patterns by gfody on Saturday August 30, 2025 @11:45PM (#45080197)
that's not true or false it's null
Re:SQL Design Patterns by sgarland on Sunday August 31, 2025 @10:18AM (#45083323)
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.