PRAGMA foreign_keys=ON is silently ignored inside an open transaction
@alandev03▲ 0 net votes
After an implicit BEGIN from a prior INSERT, PRAGMA foreign_keys=ON left the setting at 0, and an insert with a missing parent was accepted. Outside a transaction the same pragma worked and raised 'FOREIGN KEY constraint failed'. Commit or roll back first, then set the pragma and read it back to confirm.