home.social

#sqlbugs — Public Fediverse posts

Live and recent posts from across the Fediverse tagged #sqlbugs, aggregated by home.social.

fetched live
  1. Subquery Returns Multiple Rows In Comparison?!

    Using subquery that returns multiple rows in = comparison crashes! SQL doesn't know which row to use. This breaks subqueries! Watch!

    #sql #sqltricks #database #sqltutorial #subqueries #multiplerows #sqlquiz #codingchallenge #sqlshorts #sqlbugs #subqueryerrors #sqlwtf

    youtube.com/watch?v=x15LSXR-uVM

  2. 0.1 + 0.2 In SQL = 0.30000000000000004?!

    SQL floating point precision is broken! Adding 0.1 + 0.2 creates a number with precision errors. This breaks financial calculations! Watch!

    #sql #sqltricks #database #sqltutorial #floatingpoint #precision #sqlquiz #codingchallenge #sqlshorts #sqlbugs #numericprecision #sqlwtf

    youtube.com/watch?v=C53FQIhge3U

  3. COUNT(*) vs COUNT(column) Are DIFFERENT?!

    COUNT(*) and COUNT(column) behave completely differently with NULLs! One counts NULLs, one doesn't. This breaks aggregate logic! Watch!

    #sql #sqltricks #database #sqltutorial #count #aggregate #sqlquiz #codingchallenge #sqlshorts #sqlbugs #nullhandling #sqlwtf

    youtube.com/watch?v=lCeAps3FTGg

  4. JOIN With NULL Keys Returns ZERO Rows?!

    JOINing tables with NULL keys returns ZERO rows! NULL = NULL in JOIN is FALSE. This breaks all join logic! Watch!

    #sql #sqltricks #database #sqltutorial #join #nullkeys #sqlquiz #codingchallenge #sqlshorts #sqlbugs #joins #sqlwtf

    youtube.com/watch?v=4PlkdCq4KnE

  5. ROW_NUMBER() OVER (ORDER BY NULL) Does WHAT?!

    ROW_NUMBER with ORDER BY NULL creates non-deterministic ordering! All rows get random numbers. This breaks window functions! Watch!

    #sql #sqltricks #database #sqltutorial #rownumber #windowfunctions #sqlquiz #codingchallenge #sqlshorts #sqlbugs #ordering #sqlwtf

    youtube.com/watch?v=MVixOi9e8zE

  6. LEN('') vs LEN(NULL) vs LEN(' ') Are DIFFERENT?!

    LEN of empty string, NULL, and space are all different! Empty = 0, NULL = NULL, Space = 1. This breaks string length logic! Watch!

    #sql #sqltricks #database #sqltutorial #len #stringlength #sqlquiz #codingchallenge #sqlshorts #sqlbugs #stringfunctions #sqlwtf

    youtube.com/watch?v=mvXKvslW08w

  7. '10' + 5 In SQL Does WHAT?!

    SQL implicit type conversion will shock you! Adding string '10' to number 5 creates something unexpected. This breaks type safety! Watch!

    #sql #sqltricks #database #sqltutorial #typeconversion #implicitcast #sqlquiz #codingchallenge #sqlshorts #sqlbugs #typesafety #sqlwtf

    youtube.com/watch?v=21ggk4VvFvM

  8. 10 % 0 Modulo By Zero Returns WHAT?!

    Modulo by zero in SQL doesn't always crash! Some databases return NULL, others error. This breaks math operations! Watch the chaos!

    #sql #sqltricks #database #sqltutorial #modulo #divisionbyzero #sqlquiz #codingchallenge #sqlshorts #sqlbugs #mathoperations #sqlwtf

    youtube.com/watch?v=S-r3m92XI70

  9. NULL IN (1,2,3) Is NOT What You Think!

    Your brain will explode! Checking if NULL is IN a list returns something that makes NO sense. This breaks every query! Watch the chaos!

    #sql #sqltricks #database #sqltutorial #nullin #sqlquiz #codingchallenge #sqlshorts #sqlbugs #inclause #sqlwtf #threevaluedlogic

    youtube.com/watch?v=5FqLSPXnieA

  10. Three-Valued Logic: AND - OR With NULL?!

    SQL has THREE truth values: TRUE, FALSE, and UNKNOWN (NULL)! AND/OR with NULL creates logic that breaks everything! Watch!

    #sql #sqltricks #database #sqltutorial #threevaluedlogic #null #sqlquiz #codingchallenge #sqlshorts #sqlbugs #booleanlogic #sqlwtf

    youtube.com/watch?v=Dg3yabp9sa4

  11. GROUP BY NULLs Are Treated As ONE?!

    GROUP BY treats all NULLs as the same group! Multiple NULL rows get grouped together. This breaks grouping logic! Watch now!

    #sql #sqltricks #database #sqltutorial #groupby #nullhandling #sqlquiz #codingchallenge #sqlshorts #sqlbugs #grouping #sqlwtf

    youtube.com/watch?v=KCBZwLbAF8Y

  12. 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

    youtube.com/watch?v=5x89cEbWuPg

  13. COALESCE(NULL, NULL, NULL) Returns WHAT?!

    COALESCE with all NULLs returns something that defies logic! This function is supposed to return first non-NULL but what if all are NULL? Watch!

    #sql #sqltricks #database #sqltutorial #coalesce #nullhandling #sqlquiz #codingchallenge #sqlshorts #sqlbugs #nullfunctions #sqlwtf

    youtube.com/watch?v=85Dkogn0mPY

  14. EXISTS vs IN With NULL Breaks Logic!

    EXISTS and IN behave completely differently with NULL! One works, one doesn't. This breaks subquery logic! Watch the chaos!

    #sql #sqltricks #database #sqltutorial #existsin #subqueries #sqlquiz #codingchallenge #sqlshorts #sqlbugs #nullhandling #sqlwtf

    youtube.com/watch?v=dwtsETOcH2Q

  15. NULLIF(5, 5) Returns NULL?!

    NULLIF with same values returns NULL instead of the value! This function behavior will break your brain. Watch the reveal!

    #sql #sqltricks #database #sqltutorial #nullif #nullhandling #sqlquiz #codingchallenge #sqlshorts #sqlbugs #nullfunctions #sqlwtf

    youtube.com/watch?v=Srv4R_xD-do

  16. Empty String '' vs NULL Are DIFFERENT?!

    SQL treats empty strings and NULL completely differently! This hidden difference breaks string logic. Your mind will short-circuit! Watch!

    #sql #sqltricks #database #sqltutorial #emptystring #null #sqlquiz #codingchallenge #sqlshorts #sqlbugs #stringcomparison #sqlwtf

    youtube.com/watch?v=MwxAtMuqq3g

  17. ORDER BY NULLs Go WHERE?!

    ORDER BY with NULLs creates chaos! NULLs can go first or last depending on database. This breaks sorting logic! Watch!

    #sql #sqltricks #database #sqltutorial #orderby #nullhandling #sqlquiz #codingchallenge #sqlshorts #sqlbugs #sorting #sqlwtf

    youtube.com/watch?v=TvSwjgh3tw4

  18. SUM - AVG With Zero Rows Returns WHAT?!

    Aggregate functions with zero rows return NULL, not zero! SUM of nothing is NULL, not 0. This breaks aggregate logic! Watch!

    #sql #sqltricks #database #sqltutorial #aggregate #zerorows #sqlquiz #codingchallenge #sqlshorts #sqlbugs #aggregatefunctions #sqlwtf

    youtube.com/watch?v=fPdWHWUDZDs

  19. CAST('ABC' AS INT) Crashes Or Returns NULL?!

    CASTing non-numeric string to INT doesn't always error! Some databases return NULL, others crash. This breaks type safety! Watch!

    #sql #sqltricks #database #sqltutorial #cast #stringtoint #sqlquiz #codingchallenge #sqlshorts #sqlbugs #typeconversion #sqlwtf

    youtube.com/watch?v=y1lNC0b_Hbc

  20. 'Hello' = 'HELLO' Is TRUE Or FALSE?!

    SQL string comparison case sensitivity depends on collation! Same strings can be equal or not. This breaks string matching! Watch!

    #sql #sqltricks #database #sqltutorial #stringcomparison #casesensitivity #sqlquiz #codingchallenge #sqlshorts #sqlbugs #collation #sqlwtf

    youtube.com/watch?v=Qd2Qw5nRsAI

  21. NULL In WHERE Clause Returns WHAT?!

    STOP SCROLLING! Using NULL in WHERE clause creates something impossible! WHERE col = NULL returns ZERO rows. This breaks all logic! Watch now!

    #sql #sqltricks #database #sqltutorial #nullwhere #sqlquiz #codingchallenge #sqlshorts #sqlbugs #whereclause #sqlwtf #hiddenbehavior

    youtube.com/watch?v=-KaTp1Cv5HA

  22. SUM Of Empty Set Returns WHAT?!

    SUM of an empty set or all NULLs returns something unexpected! This breaks all math assumptions. Your mind will explode! Watch now!

    #sql #sqltricks #database #sqltutorial #sum #aggregate #sqlquiz #codingchallenge #sqlshorts #sqlbugs #nullhandling #sqlwtf

    youtube.com/watch?v=Z-94Yr5vElY

  23. AVG Ignores NULL Values?!

    AVG function silently ignores NULL values! This creates averages that are mathematically wrong. This breaks financial calculations! Watch!

    #sql #sqltricks #database #sqltutorial #avg #aggregate #sqlquiz #codingchallenge #sqlshorts #sqlbugs #nullhandling #sqlwtf

    youtube.com/watch?v=5tbIlazlcGI

  24. String Functions With NULL Return NULL?!

    LEN, SUBSTRING, and other string functions with NULL return NULL, not error! This breaks string processing logic! Watch the reveal!

    #sql #sqltricks #database #sqltutorial #stringfunctions #null #sqlquiz #codingchallenge #sqlshorts #sqlbugs #stringoperations #sqlwtf

    youtube.com/watch?v=FXql2wP0kmg

  25. MAX - MIN With All NULLs Returns WHAT?!

    MAX and MIN with all NULL values return something impossible! These functions are supposed to find extremes but what about NULLs? Watch!

    #sql #sqltricks #database #sqltutorial #maxmin #aggregate #sqlquiz #codingchallenge #sqlshorts #sqlbugs #nullhandling #sqlwtf

    youtube.com/watch?v=8o4s0DK1sNM

  26. DATEADD(month, 1, '2024-01-31') Returns WHAT?!

    Adding 1 month to Jan 31 creates something impossible! February doesn't have 31 days. SQL handles this in a weird way! Watch!

    #sql #sqltricks #database #sqltutorial #datearithmetic #edgecases #sqlquiz #codingchallenge #sqlshorts #sqlbugs #datefunctions #sqlwtf

    youtube.com/watch?v=ScnzvIGxeEQ

  27. Date Functions With NULL Return NULL?!

    DATEADD and DATEDIFF with NULL return NULL instead of error! Date arithmetic with NULL breaks all date logic! Watch now!

    #sql #sqltricks #database #sqltutorial #datefunctions #null #sqlquiz #codingchallenge #sqlshorts #sqlbugs #dateoperations #sqlwtf

    youtube.com/watch?v=y3khe0jfXKg

  28. NOT IN With NULL Returns FALSE Always?!

    NOT IN with NULL in the list ALWAYS returns FALSE! Even if value is not in list, NULL breaks NOT IN logic completely! Watch!

    #sql #sqltricks #database #sqltutorial #notin #null #sqlquiz #codingchallenge #sqlshorts #sqlbugs #setoperations #sqlwtf

    youtube.com/watch?v=XM1TxcJSNXg

  29. DISTINCT With Multiple NULLs?!

    DISTINCT treats all NULLs as the same value! Multiple NULLs become one. This breaks uniqueness logic. Watch the reveal!

    #sql #sqltricks #database #sqltutorial #distinct #nullhandling #sqlquiz #codingchallenge #sqlshorts #sqlbugs #setoperations #sqlwtf

    youtube.com/watch?v=IYcu56DmqdE

  30. Window Function SUM() With NULL Partition?!

    Window functions with NULL partitions create chaos! SUM OVER (PARTITION BY NULL) behaves unexpectedly. This breaks analytics! Watch!

    #sql #sqltricks #database #sqltutorial #windowfunctions #nullpartition #sqlquiz #codingchallenge #sqlshorts #sqlbugs #analytics #sqlwtf

    youtube.com/watch?v=66BfdH3qLsg

  31. UNION Removes NULL Duplicates?!

    UNION treats multiple NULLs as duplicates and removes them! This breaks set theory. NULL = NULL in UNION? Watch the chaos!

    #sql #sqltricks #database #sqltutorial #union #setoperations #sqlquiz #codingchallenge #sqlshorts #sqlbugs #nullhandling #sqlwtf

    youtube.com/watch?v=Kj-oqaZrEFM

  32. Correlated Subquery With NULL Returns WHAT?!

    Correlated subquery with NULL comparison returns something impossible! NULL = NULL in subquery breaks correlation logic! Watch!

    #sql #sqltricks #database #sqltutorial #correlatedsubquery #null #sqlquiz #codingchallenge #sqlshorts #sqlbugs #subqueries #sqlwtf

    youtube.com/watch?v=0gi1cUqrgA4

Share on Mastodon

Enter the server where you have an account.