Debian Codegraph @

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

raw
1 # This one assumes we are ignoring updates on table mysqltest_foo, but doing
2 # the ones on all other tables
3 --source include/not_group_replication_plugin.inc
4 source include/master-slave.inc;
5 connection slave;
6
7 #
8 # For this test we must be in the test database
9 #
10 use test;
11
12 --disable_warnings
13 drop table if exists mysqltest_foo;
14 drop table if exists mysqltest_bar;
15 --enable_warnings
16
17 create table mysqltest_foo (n int);
18 insert into mysqltest_foo values(4);
19 connection master;
20 use test;
21 create table mysqltest_foo (n int);
22 insert into mysqltest_foo values(5);
23 create table mysqltest_bar (m int);
24 insert into mysqltest_bar values(15);
25 create table t1 (k int);
26 insert into t1 values(55);
27 save_master_pos;
28 connection slave;
29 sync_with_master;
30 select mysqltest_foo.n,mysqltest_bar.m,t1.k from mysqltest_foo,mysqltest_bar,t1;
31 connection master;
32 drop table mysqltest_foo,mysqltest_bar,t1;
33 save_master_pos;
34 connection slave;
35 sync_with_master;
36 drop table mysqltest_foo,mysqltest_bar,t1;
37
38 # End of 4.1 tests
39 --source include/rpl_end.inc