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?