Edit File: rpl_row_drop.result
stop slave; drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; reset master; reset slave; drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; start slave; **** On Master **** CREATE TABLE t1 (a int); CREATE TABLE t2 (a int); CREATE TEMPORARY TABLE t2 (a int, b int); SHOW TABLES; Tables_in_test t1 t2 **** On Slave **** SHOW TABLES; Tables_in_test t1 t2 **** On Master **** DROP TABLE t2; SHOW TABLES; Tables_in_test t1 t2 **** On Slave **** SHOW TABLES; Tables_in_test t1 t2 **** On Master **** CREATE TEMPORARY TABLE t2 (a int, b int); SHOW TABLES; Tables_in_test t1 t2 **** On Slave **** SHOW TABLES; Tables_in_test t1 t2 **** On Master **** DROP TABLE t1,t2; SHOW BINLOG EVENTS; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 4 Format_desc 1 107 Server ver: VERSION, Binlog ver: 4 master-bin.000001 107 Query 1 193 use `test`; CREATE TABLE t1 (a int) master-bin.000001 193 Query 1 279 use `test`; CREATE TABLE t2 (a int) master-bin.000001 279 Query 1 403 use `test`; DROP TEMPORARY TABLE IF EXISTS `t2` /* generated by server */ master-bin.000001 403 Query 1 527 use `test`; DROP TEMPORARY TABLE IF EXISTS `t2` /* generated by server */ master-bin.000001 527 Query 1 631 use `test`; DROP TABLE `t1` /* generated by server */ SHOW TABLES; Tables_in_test t2 **** On Slave **** SHOW TABLES; Tables_in_test t2
Back to File Manager