Debian Codegraph @

mysql-test/suite/rpl/r/rpl_replicate_do.result

raw
1 include/master-slave.inc
2 [connection master]
3 drop table if exists t11;
4 connection slave;
5 drop table if exists t11;
6 create table t2 (n int);
7 insert into t2 values(4);
8 connection master;
9 create table t2 (s char(20));
10 load data infile '../../std_data/words.dat' into table t2;
11 insert into t2 values('five');
12 create table t1 (m int);
13 insert into t1 values(15),(16),(17);
14 update t1 set m=20 where m=16;
15 delete from t1 where m=17;
16 create table t11 select * from t1;
17 connection slave;
18 select * from t1 ORDER BY m;
19 m
20 15
21 20
22 select * from t2;
23 n
24 4
25 select * from t11;
26 ERROR 42S02: Table 'test.t11' doesn't exist
27 connection master;
28 drop table if exists t1,t2,t11;
29 connection slave;
30 Replicate_Do_Table = 'test.t1'
31 connection master;
32 create table t1 (a int, b int);
33 create trigger trg1 before insert on t1 for each row set new.b=2;
34 create table t2 (a int, b int);
35 create trigger trg2 before insert on t2 for each row set new.b=2;
36 show tables;
37 Tables_in_test
38 t1
39 t2
40 show triggers;
41 Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation
42 trg1 INSERT t1 set new.b=2 BEFORE # STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION root@localhost latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
43 trg2 INSERT t2 set new.b=2 BEFORE # STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION root@localhost latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
44 connection slave;
45 connection slave;
46 show tables;
47 Tables_in_test
48 t1
49 show triggers;
50 Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation
51 trg1 INSERT t1 set new.b=2 BEFORE # STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION root@localhost latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
52 connection master;
53 drop trigger trg1;
54 drop trigger trg2;
55 show triggers;
56 Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation
57 connection slave;
58 connection slave;
59 show tables;
60 Tables_in_test
61 t1
62 show triggers;
63 Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation
64 connection master;
65 drop table t1;
66 drop table t2;
67 connection slave;
68 include/rpl_end.inc