Null Semantics Debate

The cluster focuses on the semantics and issues with NULL/null in programming languages and databases, including its non-equality to itself (NULL != NULL), distinction from zero or absence of value, and criticisms like the 'billion dollar mistake'.

➡️ Stable 0.5x Programming Languages
3,570
Comments
20
Years Active
5
Top Authors
#966
Topic ID

Activity Over Time

2007
2
2008
19
2009
27
2010
55
2011
62
2012
91
2013
128
2014
137
2015
139
2016
228
2017
183
2018
259
2019
246
2020
434
2021
300
2022
386
2023
254
2024
280
2025
334
2026
6

Keywords

MS AFAIK e.g JSON IF SQL NULL JavaScript UNKNOWN ANSI null value nil unknown type implicit nan absence languages type systems

Sample Comments

gfody • Feb 3, 2020 • View on HN

the idea is you don’t know if the null != 5 because null isn’t a value it just marks the absence of a value

hermitdev • Apr 6, 2018 • View on HN

Sort of like ANSI NULL in databases. They're purposefully not supposed to equate (or not equate) to anything, even theirselves.

linoge • Apr 1, 2018 • View on HN

Implying that having null is a good idea at all.

tgflynn • Apr 21, 2023 • View on HN

That's what NULL (or it's various equivalents) is for.

coin • Apr 28, 2024 • View on HN

Null is the absence of a value. How do to distinguish 0 from no value?

icebraining • Oct 11, 2015 • View on HN

Why is null "empty"? That seems worse than being implicit - it's misleading.

bcheung • Apr 10, 2020 • View on HN

I thought Nil was the answer to not using NULL ;)

huhtenberg • Nov 22, 2020 • View on HN

Name a single platform where NULL is not 0.

krapp • Nov 9, 2012 • View on HN

naive but honest question -- aren't 'null' and 'false' different?

genewitch • Feb 21, 2025 • View on HN

Wait, you're telling me "NULL" is not equal to NULL?