Ensure that if a deferred FK constraint is violated by a statement that creates its own implicit transaction, the statement is not an "active-write" after sqlite3_step() returns.

FossilOrigin-Name: 8063197ef141c0c62ba710efdd2b3421fbee4e5d