#sqluniqu — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #sqluniqu, aggregated by home.social.
-
Why does this SQL UNIQUE constraint allow multiple NULLs?
Why does this SQL UNIQUE constraint allow multiple NULLs. The SQL code adds UNIQUE on a nullable column. In SQL NULL is not equal to NULL so unique allows many NULLs. In SQL this breaks deduplication logic.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqluniqu...