SQLite Forum

Removing not null constraint doesn't behave correctly
Login
Without speaking for the OP, I can report:

That snapshot (timestamped 202007011619) runs the OP's "misbehaving" repro steps without any misbehavior that I can see with my limited testing. (applying them to an on-disk DB, opening it again, integrity check, selects, inserts)