Edit File: rpl_stm_flsh_tbls.result
include/master-slave.inc [connection master] create table t1 (a int); insert into t1 values (10); create table t2 (a int); create table t3 (a int) engine=merge union(t1); create table t4 (a int); insert into t4 select * from t3; rename table t1 to t5, t2 to t1; flush no_write_to_binlog tables; show binlog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # use `test`; rename table t1 to t5, t2 to t1 select * from t3; a flush tables; select * from t3; a stop slave; include/wait_for_slave_to_stop.inc drop table t1; flush tables with read lock; start slave; include/wait_for_slave_to_start.inc stop slave; ERROR HY000: Can't execute the given command because you have active locked tables or an active transaction unlock tables; drop table t3, t4, t5; include/rpl_end.inc
Back to File Manager