1include/master-slave.inc
2[connection master]
3#
4# Bug#50124 Rpl failure on DROP table with concurrent txn/non-txn
5#           DML flow and SAVEPOINT
6#
7connection master;
8DROP TABLE IF EXISTS tt, nt;
9CREATE TABLE tt (i INT) ENGINE = InnoDB;
10CREATE TABLE nt (i INT) ENGINE = MyISAM;
11FLUSH LOGS;
12START TRANSACTION;
13INSERT INTO nt VALUES (1);
14SAVEPOINT insert_statement;
15INSERT INTO tt VALUES (1);
16connection master1;
17# Sending:
18DROP TABLE tt;
19connection master;
20ROLLBACK TO SAVEPOINT insert_statement;
21Warnings:
22Warning	1196	Some non-transactional changed tables couldn't be rolled back
23COMMIT;
24connection master1;
25# Reaping: DROP TABLE tt
26FLUSH LOGS;
27connection master;
28DROP TABLE nt;
29include/rpl_end.inc
30