<verbatim>
  CREATE TABLE t1(a, b);
  CREATE TABLE t3(e, f);
  CREATE TRIGGER tr1 AFTER INSERT ON t1 BEGIN
    INSERT INTO t2 VALUES(new.a, new.b);
  END;
  BEGIN;
    ALTER TABLE t3 RENAME TO t4;
  COMMIT;
  SELECT * FROM sqlite_master WHERE type='table' AND name!='t1';
</verbatim>

The output of the above script is:

<verbatim>
  table|t3|t3|3|CREATE TABLE "t4"(e, f) 
</verbatim>

The schema is now corrupt - as the table name in the SQL does not match the table names in the "name" and "tbl_name" columns.

Committing a transaction with a failed ALTER TABLE may subtly corrupt schema