2 # Auxiliary file which is used to test BUG#56118
4 # Slave should apply all statements in the transaction before stop if any
5 # temporary table is created or dropped.
8 # --let $tmp_table_stm= a SQL statement
9 # --source extra/rpl_tests/rpl_stop_slave.test
12 if (`SELECT "$tmp_table_stm" = ''`)
14 --echo \$tmp_table_stm is NULL
15 --die $tmp_table_stm is NULL
24 INSERT INTO t1 VALUES (1);
25 DROP TEMPORARY TABLE tt1;
32 # To check if slave SQL thread is applying INSERT statement
33 let $show_statement= SHOW PROCESSLIST;
35 let $condition= LIKE 'INSERT%';
36 source include/wait_show_condition.inc;
38 send STOP SLAVE SQL_THREAD;
43 --echo # To resume slave SQL thread
44 SET DEBUG_SYNC= 'now SIGNAL signal.continue';
45 SET DEBUG_SYNC= 'RESET';
51 source include/wait_for_slave_sql_to_stop.inc;
53 --echo # Slave should stop after the transaction has committed.
54 --echo # So t1 on master is same to t1 on slave.
55 let diff_tables= master:t1, slave:t1;
56 source include/diff_tables.inc;
59 START SLAVE SQL_THREAD;
60 source include/wait_for_slave_sql_to_start.inc;