Debian Codegraph @

mysql-test/suite/rpl/t/rpl_row_inexist_tbl.test

raw
1 # ==== Purpose ====
2 #
3 # Verify that slave gives an error message if master updates a table
4 # that slave does not have.
5 #
6 # ==== Method ====
7 #
8 # Create a table on master, wait till it's on slave, remove it from
9 # slave. Then update the table on master.
10
11 --source include/have_binlog_format_row.inc
12
13 source include/master-slave.inc;
14
15 --echo ==== Setup table on master but not on slave ====
16 CREATE TABLE t1 (a INT);
17
18 sync_slave_with_master;
19 DROP TABLE t1;
20
21 --echo ==== Modify table on master ====
22 connection master;
23 INSERT INTO t1 VALUES (1);
24
25 --echo ==== Verify error on slave ====
26 connection slave;
27 # slave should have stopped because can't find table t1
28 # 1146 = ER_NO_SUCH_TABLE
29 call mtr.add_suppression("Slave SQL.*Error executing row event: .Table .test.t1. doesn.t exist., error.* 1146");
30 --let $slave_sql_errno= 1146
31 --source include/wait_for_slave_sql_error.inc
32
33 --echo ==== Clean up ====
34 source include/stop_slave_io.inc;
35 RESET SLAVE;
36
37 connection master;
38 DROP TABLE t1;
39 --let $rpl_only_running_threads= 1
40 --source include/rpl_end.inc