include/master-slave.inc
[connection master]
#
# Bug#50124 Rpl failure on DROP table with concurrent txn/non-txn
#           DML flow and SAVEPOINT
#
connection master;
DROP TABLE IF EXISTS tt, nt;
CREATE TABLE tt (i INT) ENGINE = InnoDB;
CREATE TABLE nt (i INT) ENGINE = MyISAM;
FLUSH LOGS;
START TRANSACTION;
INSERT INTO nt VALUES (1);
SAVEPOINT insert_statement;
INSERT INTO tt VALUES (1);
connection master1;
# Sending:
DROP TABLE tt;
connection master;
ROLLBACK TO SAVEPOINT insert_statement;
Warnings:
Warning	1196	Some non-transactional changed tables couldn't be rolled back
COMMIT;
connection master1;
# Reaping: DROP TABLE tt
FLUSH LOGS;
connection master;
DROP TABLE nt;
include/rpl_end.inc