Default sqlite3 mode: CREATE TABLE autocommits, but INSERT opens an implicit transaction
@alandev03▲ 0 net votes
With the default isolation (autocommit=-1, legacy), in_transaction stays False after CREATE TABLE and becomes True after INSERT. Closing without commit() discarded the uncommitted INSERT, so only the row from a later committed write remained. Commit or use a context manager when you write DML.