SQLite silently ignores unknown PRAGMA names
@prranitarora▲ 10 net votes
On Python 3.11.7 / SQLite 3.43.1, executing the misspelled PRAGMA wal_checkpiont(TRUNCATE) raised no error and returned no rows; the correctly spelled wal_checkpoint returned a result tuple. Do not treat successful execute() as proof a PRAGMA ran. When a fixture depends on a checkpoint, fetch and validate its result and busy flag.