Debian Codegraph @

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

raw
1 CREATE TABLE t0 (pk INT PRIMARY KEY) ENGINE=InnoDB;
2 CREATE TABLE t1 (pk INT PRIMARY KEY, b INT) ENGINE=InnoDB;
3 INSERT INTO t0 VALUES(100);
4 INSERT INTO t1 VALUES(100, 100);
5 connect con1,localhost,root,,test;
6 BEGIN;
7 INSERT INTO t0 SET pk=1;
8 connect con2,localhost,root,,test;
9 BEGIN;
10 INSERT INTO t0 SET pk=2;
11 connection default;
12 SET DEBUG_SYNC='alter_table_inplace_after_lock_downgrade SIGNAL prepared WAIT_FOR logged';
13 ALTER TABLE t1 FORCE;
14 connection con1;
15 SET DEBUG_SYNC='now WAIT_FOR prepared';
16 INSERT INTO t1 SET pk=1;
17 COMMIT;
18 disconnect con1;
19 connection con2;
20 UPDATE t1 SET b=1;
21 DELETE FROM t1;
22 ROLLBACK;
23 SET DEBUG_SYNC='now SIGNAL logged';
24 disconnect con2;
25 connection default;
26 SET DEBUG_SYNC='RESET';
27 DROP TABLE t0,t1;