内层已经 RELEASE，为什么整批数据还是没了？

"""SQLite savepoints on temporary databases; Python 3.10+, standard library only."""
from contextlib import closing
from pathlib import Path
from tempfile import TemporaryDirectory
import json
import sqlite3
import sys


def connect(path):
    options = {"isolation_level": None}
    if sys.version_info >= (3, 12):
        options["autocommit"] = sqlite3.LEGACY_TRANSACTION_CONTROL
    return sqlite3.connect(path, **options)


def names(db):
    return [row[0] for row in db.execute("SELECT name FROM item ORDER BY name")]


def put(db, name):
    db.execute("INSERT INTO item(name) VALUES (?)", (name,))


def observe(trace, case, stage, db, expected, active):
    row = {"case": case, "stage": stage, "names": names(db), "in_transaction": db.in_transaction}
    assert row["names"] == expected, row
    assert row["in_transaction"] is active, row
    trace.append(row)


def missing_mark(db, statement):
    before = names(db)
    try:
        db.execute(statement)
    except sqlite3.OperationalError as error:
        assert "no such savepoint" in str(error), error
    else:
        raise AssertionError("missing savepoint was accepted")
    assert names(db) == before and db.in_transaction


def make_table(db):
    db.execute("CREATE TABLE item(name TEXT PRIMARY KEY)")
    assert not db.in_transaction


def main():
    trace = []
    with TemporaryDirectory(prefix="sqlite-savepoint-") as directory:
        root = Path(directory)
        rollback_path = root / "outer-rollback.db"
        with closing(connect(rollback_path)) as db:
            make_table(db)
            db.execute("BEGIN")
            put(db, "outer")
            db.execute("SAVEPOINT part")
            put(db, "inner")
            db.execute("RELEASE part")
            observe(trace, "outer_rollback", "after_inner_release", db, ["inner", "outer"], True)
            db.execute("ROLLBACK")
            observe(trace, "outer_rollback", "after_outer_rollback", db, [], False)
        with closing(connect(rollback_path)) as db:
            observe(trace, "outer_rollback", "reopened", db, [], False)

        partial_path = root / "partial-retry.db"
        with closing(connect(partial_path)) as db:
            make_table(db)
            db.execute("BEGIN")
            put(db, "base")
            db.execute("SAVEPOINT part")
            put(db, "discard_first")
            db.execute("SAVEPOINT deeper")
            put(db, "discard_second")
            db.execute("ROLLBACK TO part")
            observe(trace, "partial_retry", "after_rollback_to", db, ["base"], True)
            missing_mark(db, "RELEASE deeper")
            put(db, "discard_retry")
            db.execute("ROLLBACK TO part")  # The target mark remains usable.
            observe(trace, "partial_retry", "after_second_rollback_to", db, ["base"], True)
            put(db, "replacement")
            db.execute("RELEASE part")
            missing_mark(db, "ROLLBACK TO part")
            observe(trace, "partial_retry", "after_release_before_commit", db, ["base", "replacement"], True)
            db.execute("COMMIT")
            observe(trace, "partial_retry", "after_commit", db, ["base", "replacement"], False)
        with closing(connect(partial_path)) as db:
            observe(trace, "partial_retry", "reopened", db, ["base", "replacement"], False)

        standalone_path = root / "outermost-release.db"
        with closing(connect(standalone_path)) as db:
            make_table(db)
            db.execute("SAVEPOINT whole")  # No surrounding BEGIN in this control.
            put(db, "standalone")
            observe(trace, "outermost_release", "before_release", db, ["standalone"], True)
            db.execute("RELEASE whole")
            observe(trace, "outermost_release", "after_release", db, ["standalone"], False)
        with closing(connect(standalone_path)) as db:
            observe(trace, "outermost_release", "reopened", db, ["standalone"], False)
    assert not root.exists()
    print(json.dumps({"python": sys.version.split()[0], "sqlite": sqlite3.sqlite_version,
                      "trace": trace, "temporary_directory_removed": True}, indent=2))
    print("PASS: inner release, partial rollback, retained/removed marks, outer commit, reopen and cleanup")


if __name__ == "__main__":
    main()