Debian Codegraph @

mysql-test/suite/innodb/t/ddl_purge.test

raw
1 --source innodb_default_row_format.inc
2 --source include/have_debug.inc
3 --source include/have_debug_sync.inc
4
5 CREATE TABLE t0 (pk INT PRIMARY KEY) ENGINE=InnoDB;
6 CREATE TABLE t1 (pk INT PRIMARY KEY, b INT) ENGINE=InnoDB;
7 # MDEV-515 takes X-lock on the table for the first insert.
8 # So concurrent insert won't happen on the table
9 INSERT INTO t0 VALUES(100);
10
11 INSERT INTO t1 VALUES(100, 100);
12
13 --connect (con1,localhost,root,,test)
14 BEGIN;
15 INSERT INTO t0 SET pk=1;
16
17 --connect (con2,localhost,root,,test)
18 BEGIN;
19 INSERT INTO t0 SET pk=2;
20
21 --connection default
22 SET DEBUG_SYNC='alter_table_inplace_after_lock_downgrade SIGNAL prepared WAIT_FOR logged';
23 send ALTER TABLE t1 FORCE;
24
25 --connection con1
26 SET DEBUG_SYNC='now WAIT_FOR prepared';
27 INSERT INTO t1 SET pk=1;
28 COMMIT;
29 --disconnect con1
30
31 --connection con2
32 UPDATE t1 SET b=1;
33 DELETE FROM t1;
34 ROLLBACK;
35 SET DEBUG_SYNC='now SIGNAL logged';
36 --disconnect con2
37
38 --connection default
39 reap;
40 SET DEBUG_SYNC='RESET';
41 DROP TABLE t0,t1;