Tell HN: Cast('abc' AS INTEGER) returns 0 in SQLite

5 comments

• hans_castorp 11 hours ago

  There is more: https://dbfiddle.uk/FDkqamR_

  (Some examples there no longer work with the current version - so they are improving :) )

  This is by design and well documented though.

• vconnor 5 hours ago

  What do you want it to return? You should really RTFM of SQLite. It's by design.

  [-]
  • prmph 4 hours ago

    It is not a good design. It should throw an error.

    [-]
    • stefanos82 3 hours ago

      Then declare your table(s) as strict; that should solve your issues.

      https://sqlite.org/stricttables.html

      [-]
      • prmph 2 hours ago

        Even with STRICT, explicit CAST() has the same problem.