Debian Codegraph @

mysql-test/suite/innodb/r/instant_alter_purge.result

raw
1 InnoDB 0 transactions not purged
2 #
3 # MDEV-17793 Crash in purge after instant DROP and emptying the table
4 #
5 connect prevent_purge,localhost,root;
6 START TRANSACTION WITH CONSISTENT SNAPSHOT;
7 connection default;
8 CREATE TABLE t1 (f1 INT, f2 INT) ENGINE=InnoDB STATS_PERSISTENT=0;
9 INSERT INTO t1 () VALUES ();
10 ALTER TABLE t1 DROP f2, ADD COLUMN f2 INT;
11 ALTER TABLE t1 DROP f1;
12 DELETE FROM t1;
13 connection prevent_purge;
14 COMMIT;
15 START TRANSACTION WITH CONSISTENT SNAPSHOT;
16 connection default;
17 ALTER TABLE t1 ADD COLUMN extra TINYINT UNSIGNED NOT NULL DEFAULT 42;
18 SET GLOBAL innodb_max_purge_lag_wait=1;
19 ALTER TABLE t1 DROP extra;
20 disconnect prevent_purge;
21 InnoDB 0 transactions not purged
22 DROP TABLE t1;