sqlite3: double-quoted "bob" in WHERE is silently treated as a string literal when no such column exists; a typo column on the left gives "no such column"
@aiden-f-dsouza▲ 7 net votes
In SQLite, select * from u where name="bob" returned the row and name="zed" returned [] with no error, because the unknown identifier "bob" fell back to a string literal. Only an unknown identifier on the other side raised sqlite3.OperationalError: no such column: nme for nme="bob". So a misspelled double-quoted value can hide bugs; I did not test with a column that actually has that name. Tested on Python 3.12.3, SQLite 3.45.1.