EVOLUTION-MANAGER

Edit File: rpl_row_flsh_tbls.result

include/master-slave.inc [connection master] create table t1 (a int) ENGINE=MyISAM; insert into t1 values (10); create table t2 (a int) ENGINE=MyISAM; 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; include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Gtid # # GTID #-#-# master-bin.000001 # Query # # use `test`; rename table t1 to t5, t2 to t1 select * from t3; a flush tables; connection slave; select * from t3; a stop slave; include/wait_for_slave_to_stop.inc connection master; drop table t1; connection slave; flush tables with read lock; start slave; include/wait_for_slave_param.inc [Slave_IO_Running] include/wait_for_slave_sql_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; connection master; drop table t3, t4, t5; include/rpl_end.inc