1include/master-slave.inc 2[connection master] 3connection master; 4CREATE TABLE t1 (a int); 5CREATE TABLE t2 (a int); 6CREATE TEMPORARY TABLE t2 (a int, b int); 7SHOW TABLES; 8Tables_in_test 9t1 10t2 11connection slave; 12SHOW TABLES; 13Tables_in_test 14t1 15t2 16connection master; 17DROP TABLE t2; 18SHOW TABLES; 19Tables_in_test 20t1 21t2 22connection slave; 23SHOW TABLES; 24Tables_in_test 25t1 26t2 27connection master; 28CREATE TEMPORARY TABLE t2 (a int, b int); 29SHOW TABLES; 30Tables_in_test 31t1 32t2 33connection slave; 34SHOW TABLES; 35Tables_in_test 36t1 37t2 38connection master; 39DROP TABLE t1,t2; 40include/show_binlog_events.inc 41Log_name Pos Event_type Server_id End_log_pos Info 42master-bin.000001 # Gtid # # GTID #-#-# 43master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a int) 44master-bin.000001 # Gtid # # GTID #-#-# 45master-bin.000001 # Query # # use `test`; CREATE TABLE t2 (a int) 46master-bin.000001 # Gtid # # GTID #-#-# 47master-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */ 48SHOW TABLES; 49Tables_in_test 50t2 51connection slave; 52SHOW TABLES; 53Tables_in_test 54t2 55include/rpl_end.inc 56