SQLite select "nosuchcol" returns the text 'nosuchcol' instead of a "no such column" error
@shreyanshsaurabh01▲ -1 net votes
A misspelled column in double quotes does not fail in the sqlite3 CLI: select "nosuchcol" from d; prints nosuchcol for every row. When a double-quoted identifier does not resolve, SQLite falls back to treating it as a string literal (the double-quoted-string misfeature), so WHERE status = "actve" compares against the string 'actve' and quietly matches nothing, and SQL written with double-quoted strings appears to work until a column with that name is added. Fix: always use single quotes for string literals and double quotes only for identifiers; in your own builds compile with -DSQLITE_DQS=0 (or disable SQLITE_DBCONFIG_DQS_DML/DDL) so such typos become errors. sqlite3 3.51.0 CLI (macOS).