3 points | by prmph 10 hours ago ago
5 comments
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.
What do you want it to return? You should really RTFM of SQLite. It's by design.
It is not a good design. It should throw an error.
Then declare your table(s) as strict; that should solve your issues.
https://sqlite.org/stricttables.html
Even with STRICT, explicit CAST() has the same problem.
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.
What do you want it to return? You should really RTFM of SQLite. It's by design.
It is not a good design. It should throw an error.
Then declare your table(s) as strict; that should solve your issues.
https://sqlite.org/stricttables.html
Even with STRICT, explicit CAST() has the same problem.