Edit File: rpl_drop_temp.result
include/master-slave.inc [connection master] create database if not exists mysqltest; use mysqltest; create temporary table mysqltest.t1 (n int)ENGINE=MyISAM; create temporary table mysqltest.t2 (n int)ENGINE=MyISAM; show status like 'Slave_open_temp_tables'; Variable_name Value Slave_open_temp_tables 0 drop database mysqltest; DROP TEMPORARY TABLE IF EXISTS tmp1; Warnings: Note 1051 Unknown table 'tmp1' CREATE TEMPORARY TABLE t1 ( a int ); DROP TEMPORARY TABLE t1, t2; ERROR 42S02: Unknown table 't2' DROP TEMPORARY TABLE tmp2; ERROR 42S02: Unknown table 'tmp2' stop slave; **** On Master **** CREATE TEMPORARY TABLE tmp3 (a int); DROP TEMPORARY TABLE tmp3; SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE; include/rpl_reset.inc CREATE TABLE t1 ( i INT ); SHOW STATUS LIKE 'Slave_open_temp_tables'; Variable_name Value Slave_open_temp_tables 0 CREATE TEMPORARY TABLE ttmp1 ( i INT ); SET SESSION binlog_format=ROW; SHOW STATUS LIKE 'Slave_open_temp_tables'; Variable_name Value Slave_open_temp_tables 0 show binlog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # use `test`; CREATE TABLE t1 ( i INT ) master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE ttmp1 ( i INT ) master-bin.000001 # Query # # use `test`; DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `ttmp1` DROP TABLE t1; include/rpl_end.inc
Back to File Manager