Debian Codegraph @

mysql-test/suite/rpl/t/rpl_savepoint.test

raw
1 --source include/have_innodb.inc
2 --source include/master-slave.inc
3
4 --echo #
5 --echo # Bug#50124 Rpl failure on DROP table with concurrent txn/non-txn
6 --echo # DML flow and SAVEPOINT
7 --echo #
8
9 connection master;
10
11 --disable_warnings
12 DROP TABLE IF EXISTS tt, nt;
13 --enable_warnings
14
15 CREATE TABLE tt (i INT) ENGINE = InnoDB;
16 CREATE TABLE nt (i INT) ENGINE = MyISAM;
17 FLUSH LOGS;
18 START TRANSACTION;
19 INSERT INTO nt VALUES (1);
20 SAVEPOINT insert_statement;
21 INSERT INTO tt VALUES (1);
22
23 connection master1;
24 --echo # Sending:
25 --send DROP TABLE tt
26
27 connection master;
28 let $wait_condition=
29 SELECT COUNT(*) = 1 FROM information_schema.processlist
30 WHERE state = "Waiting for table metadata lock" AND info = "DROP TABLE tt";
31 --source include/wait_condition.inc
32 ROLLBACK TO SAVEPOINT insert_statement;
33 COMMIT;
34
35 connection master1;
36 --echo # Reaping: DROP TABLE tt
37 --reap
38 FLUSH LOGS;
39
40 connection master;
41 DROP TABLE nt;
42
43 --source include/rpl_end.inc