3 ms·
It's good to see that everyone agrees on the definition of NULL.
by ratsmack 4y ago
It's good to see that everyone agrees on the definition of NULL.
- DaiPlusPlus 4y agoYes: a billion-dollar mistake.
- erichocean 4y agoAnd with RDBMSs, a multi-trillion dollar success!
- bazoom42 4y agoThis is s misunderstandig of Hoares “billion dollar mistake”. The mistake was not the existence of nulls, the mistake was type systems where every reference could be null. Sql does not have this problem.
- deleted 4y ago[deleted]
- lmm 4y agoSQL absolutely does have that problem. You have no way of enforcing or checking that an expression is supposed to be non-NULL; at best you get an error at runtime when you try to insert it into a given column, which is usually far too late.