Skip to content
Tagged articles

three-valued logic

6 articles · Page 1 of 1
Java Tech Workshop
Java Tech Workshop
Nov 1, 2026 · Databases

MySQL Unique Indexes Allow Multiple NULLs: Why It Happens and How to Enforce True Uniqueness

This article explains why MySQL unique indexes permit multiple NULL values due to SQL's three-valued logic, demonstrates how this breaks upsert statements and causes silent duplicates, compares behavior across databases, and presents solutions using NOT NULL constraints, generated columns, and functional indexes to enforce true uniqueness.

InnoDBMySQLNULL handling
0 likes · 16 min read
MySQL Unique Indexes Allow Multiple NULLs: Why It Happens and How to Enforce True Uniqueness
Java Tech Enthusiast
Java Tech Enthusiast
Oct 4, 2026 · Databases

Why SQL NULL Can't Use Equals: Three-Valued Logic & Hidden Pitfalls

This article explains why SQL NULL represents an unknown state rather than a value, how three-valued logic (TRUE, FALSE, UNKNOWN) breaks equality comparisons, and demonstrates practical pitfalls with WHERE clauses, NOT IN subqueries, aggregate functions, and MySQL's NULL-safe operator.

MySQLNOT IN pitfallNULL
0 likes · 9 min read
Why SQL NULL Can't Use Equals: Three-Valued Logic & Hidden Pitfalls
Su San Talks Tech
Su San Talks Tech
May 17, 2026 · Databases

Why Leading Companies Avoid NULL Values in MySQL

The article explains why major tech companies discourage using NULL in MySQL, covering its meaning as an unknown state, three-valued logic pitfalls such as NOT IN subqueries, index inefficiencies, aggregate function quirks, storage overhead, Java handling issues, and offers practical alternatives like NOT NULL constraints with sensible defaults.

MySQLNULLSQL
0 likes · 11 min read
Why Leading Companies Avoid NULL Values in MySQL
Laravel Tech Community
Laravel Tech Community
Jun 18, 2021 · Databases

Understanding NULL Values in Databases

This article explains the special nature of NULL in SQL, how to correctly test for NULL using IS NULL, the three‑valued logic of true/false/unknown, and the pitfalls of NOT, NOT IN, and Oracle’s handling of empty strings versus NULL.

IS NULLNULLSQL
0 likes · 6 min read
Understanding NULL Values in Databases