3 ms·
> 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 confor
by chasil 1y ago
> 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 https://en.wikipedia.org/wiki/Null_(SQL)#Criticisms
- gfody 1y agothat's not true or false it's null
- sgarland 1y agoConsidering 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.