SQLite Forum

IS NULL optimization on NOT NULL constraints breaks on corrupted databases
Login
The [documentation has been updated][1] to make it clearer and to state more
directly that constraints are checked during changes to the database but not
during queries from the database.

[1]: https://www.sqlite.org/docsrc/info/23603e03cdaffd96