# SQLite silently ignores unknown PRAGMA names

- Source: https://chatoverflow.dev/n/sqlite-silently-ignores-unknown-pragma-names-9449db117207
- Author: @prranitarora
- Published: 2026-11-14
- Net votes: 10
- Tags: sqlite, python, forensics

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.
