列名后面写着 INTEGER，为什么还能存进一段文字？

"""Observe SQLite storage classes, coercion, STRICT, and business constraints."""
from contextlib import closing
import sqlite3


def main():
    if sqlite3.sqlite_version_info < (3, 37, 0):
        raise SystemExit("This experiment requires SQLite 3.37.0 or later.")
    checks = 0

    def check(condition, message):
        nonlocal checks
        if not condition:
            raise AssertionError(message)
        checks += 1

    with closing(sqlite3.connect(":memory:", isolation_level=None)) as db:
        db.execute("CREATE TABLE ordinary(qty INTEGER)")
        db.execute("CREATE TABLE strict_qty(qty INTEGER) STRICT")
        db.execute("CREATE TABLE contract(qty INTEGER NOT NULL CHECK(qty >= 0)) STRICT")

        def insert(table, value):
            # Table names are fixed program constants, not user input.
            try:
                db.execute(f"INSERT INTO {table}(qty) VALUES(?)", (value,))
            except sqlite3.IntegrityError:
                return "rejected"
            row = db.execute(
                f"SELECT qty, typeof(qty) FROM {table} ORDER BY rowid DESC LIMIT 1"
            ).fetchone()
            return row

        cases = [
            ("012", (12, "integer"), (12, "integer"), (12, "integer")),
            ("12.0", (12, "integer"), (12, "integer"), (12, "integer")),
            ("many", ("many", "text"), "rejected", "rejected"),
            (None, (None, "null"), (None, "null"), "rejected"),
            (-2, (-2, "integer"), (-2, "integer"), "rejected"),
        ]
        for value, expected_plain, expected_strict, expected_contract in cases:
            ordinary = insert("ordinary", value)
            strict = insert("strict_qty", value)
            contract = insert("contract", value)
            check(ordinary == expected_plain, f"ordinary case {value!r}")
            check(strict == expected_strict, f"strict case {value!r}")
            check(contract == expected_contract, f"business contract case {value!r}")
            print(f"input={value!r}: ordinary={ordinary}; strict={strict}; contract={contract}")

        db.execute("CREATE TABLE any_plain(value ANY)")
        db.execute("CREATE TABLE any_strict(value ANY) STRICT")
        for table in ("any_plain", "any_strict"):
            db.execute(f"INSERT INTO {table} VALUES(?)", ("00123",))
        any_plain = db.execute("SELECT value, typeof(value) FROM any_plain").fetchone()
        any_strict = db.execute("SELECT value, typeof(value) FROM any_strict").fetchone()
        check(any_plain == (123, "integer"), "ordinary ANY applies numeric affinity")
        check(any_strict == ("00123", "text"), "STRICT ANY preserves the input storage class")
        print(f"ANY input='00123': ordinary={any_plain}; strict={any_strict}")
        check(db.execute("PRAGMA integrity_check").fetchone()[0] == "ok", "integrity check")
    print(f"PASS checks={checks}")


if __name__ == "__main__":
    main()