home.social
Sign in Create account

#trailingspaces — Public Fediverse posts

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

  1. PrecisionSQL @[email protected] ·

    CHAR vs VARCHAR Comparison Returns ZERO Rows?!

    STRING COMPARISON IS BROKEN! CHAR pads with spaces, VARCHAR doesn't! 'test' does NOT equal 'test '! Your WHERE clause returns ZERO rows! This breaks string matching! Watch!

    #sql #sqlbug #char #varchar #trailingspaces #comparisonfails #sqlfails #productionbug #sqlshorts #sqlwtf #stringcomparison #padding

    youtube.com/watch?v=aE5TuRmO_PQ

    #sql #sqlbug #char #varchar #trailingspaces #comparisonfails
  2. PrecisionSQL @[email protected] ·

    CHAR vs VARCHAR Comparison Returns ZERO Rows?!

    STRING COMPARISON IS BROKEN! CHAR pads with spaces, VARCHAR doesn't! 'test' does NOT equal 'test '! Your WHERE clause returns ZERO rows! This breaks string matching! Watch!

    #sql #sqlbug #char #varchar #trailingspaces #comparisonfails #sqlfails #productionbug #sqlshorts #sqlwtf #stringcomparison #padding

    youtube.com/watch?v=aE5TuRmO_PQ

    #sql #sqlbug #char #varchar #trailingspaces #comparisonfails
  3. PrecisionSQL @[email protected] ·

    CHAR vs VARCHAR Comparison Returns ZERO Rows?!

    STRING COMPARISON IS BROKEN! CHAR pads with spaces, VARCHAR doesn't! 'test' does NOT equal 'test '! Your WHERE clause returns ZERO rows! This breaks string matching! Watch!

    #sql #sqlbug #char #varchar #trailingspaces #comparisonfails #sqlfails #productionbug #sqlshorts #sqlwtf #stringcomparison #padding

    youtube.com/watch?v=aE5TuRmO_PQ

    #sql #sqlbug #char #varchar #trailingspaces #comparisonfails