#nullcomparison — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #nullcomparison, aggregated by home.social.
-
NULL = NULL Is FALSE In SQL?!
STOP SCROLLING! Comparing NULL to NULL in SQL returns FALSE, not TRUE! This breaks every assumption about equality. Your mind will explode! Watch now!
#sql #sqltricks #database #sqltutorial #sqlweird #nullcomparison #sqlquiz #codingchallenge #sqlshorts #sqlwtf #databasequeries #sqlbugs
-
CASE Expression with NULL Comparison?!
CASE expressions have NULL traps! NULL = NULL is UNKNOWN, not TRUE. The CASE logic handles this differently than you expect!
#sql #sqltricks #case #nullcomparison #threevaluedlogic #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #conditionallogic #advancedsql
-
CASE Expression with NULL Comparison?!
CASE expressions have NULL traps! NULL = NULL is UNKNOWN, not TRUE. The CASE logic handles this differently than you expect!
#sql #sqltricks #case #nullcomparison #threevaluedlogic #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #conditionallogic #advancedsql