Debian Codegraph @

mysql-test/suite/rpl_nogtid/t/rpl_replicate_do.test

raw
1 # This test assumes we are ignoring updates on table t2, but doing
2 # updates on t1
3 --source include/not_group_replication_plugin.inc
4 source include/set_privilege_checks_user_as_system_user.inc;
5 source include/master-slave.inc;
6
7 --disable_warnings
8 drop table if exists t11;
9 connection slave;
10 drop table if exists t11;
11 --enable_warnings
12
13 create table t2 (n int);
14 insert into t2 values(4);
15 connection master;
16 create table t2 (s char(20));
17 load data infile '../../std_data/words.dat' into table t2;
18 insert into t2 values('five');
19 create table t1 (m int);
20 insert into t1 values(15),(16),(17);
21 update t1 set m=20 where m=16;
22 delete from t1 where m=17;
23 create table t11 select * from t1;
24 --source include/sync_slave_sql_with_master.inc
25 select * from t1 ORDER BY m;
26 select * from t2;
27 --error 1146
28 select * from t11;
29 connection master;
30 drop table if exists t1,t2,t11;
31 --source include/sync_slave_sql_with_master.inc
32 # show slave status, just to see of it prints replicate-do-table
33 let $status_items= Replicate_Do_Table;
34 source include/show_slave_status.inc;
35
36 # End of 4.1 tests
37
38 #
39 # Bug#24478 DROP TRIGGER is not caught by replicate-*-table filters
40 #
41 --echo *** master ***
42 connection master;
43 create table t1 (a int, b int);
44 create trigger trg1 before insert on t1 for each row set new.b=2;
45 create table t2 (a int, b int);
46 create trigger trg2 before insert on t2 for each row set new.b=2;
47 show tables;
48 --replace_column 6 #
49 show triggers;
50 --source include/sync_slave_sql_with_master.inc
51 --echo *** slave ***
52 connection slave;
53 show tables;
54 --replace_column 6 #
55 show triggers;
56 --echo *** master ***
57 connection master;
58 drop trigger trg1;
59 drop trigger trg2;
60 --replace_column 6 #
61 show triggers;
62 --source include/sync_slave_sql_with_master.inc
63 --echo *** slave ***
64 connection slave;
65 show tables;
66 --replace_column 6 #
67 show triggers;
68 --echo *** master ***
69 connection master;
70 drop table t1;
71 drop table t2;
72 --source include/sync_slave_sql_with_master.inc
73 --source include/rpl_end.inc