This is the expected behavior when there is no journal available to
rollback a partially completed operation that fails due to a constraint.
The documentation has been strengthened to try to make this clear.
And PRAGMA journal_mode=OFF is now disallowed if
SQLITE_DBCONFIG_DEFENSIVE is turned on.