Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 set sql_mode="";
4 connection slave;
5 set sql_mode="";
6 connection master;
7 DROP TABLE IF EXISTS t1;
8 DROP TABLE IF EXISTS t2;
9 call mtr.add_suppression("Unsafe statement written to the binary log*");
10 CREATE TABLE t1 (a bigint unsigned not null);
11 CREATE TABLE t2 (a char(255) not null);
12
13 There are the following types of variables:
14 1) variables that are NOT replicated correctly when using STATEMENT mode;
15
16 connection master;
17 SELECT @@max_join_size;
18 @@max_join_size
19 18446744073709551615
20 connection slave;
21 SELECT @@max_join_size;
22 @@max_join_size
23 18446744073709551615
24 connection master;
25 SET STATEMENT max_join_size=2 FOR
26 INSERT INTO t1 VALUES(@@max_join_size);
27 SELECT @@max_join_size;
28 @@max_join_size
29 18446744073709551615
30 connection slave;
31 SELECT * FROM t1;
32 a
33 18446744073709551615
34 SELECT @@max_join_size;
35 @@max_join_size
36 18446744073709551615
37 connection master;
38 DELETE FROM t1;
39
40 2) variables thar ARE replicated correctly
41 They must be replicated correctly with "SET STATEMENT" too.
42
43 connection master;
44 SELECT @@auto_increment_increment;
45 @@auto_increment_increment
46 1
47 connection slave;
48 SELECT @@auto_increment_increment;
49 @@auto_increment_increment
50 1
51 connection master;
52 SET STATEMENT auto_increment_increment=10 FOR
53 INSERT INTO t1 VALUES(@@auto_increment_increment);
54 SELECT @@auto_increment_increment;
55 @@auto_increment_increment
56 1
57 connection slave;
58 SELECT * FROM t1;
59 a
60 10
61 SELECT @@auto_increment_increment;
62 @@auto_increment_increment
63 1
64 connection master;
65 DELETE FROM t1;
66
67 3) sql_mode which is replicated correctly exept NO_DIR_IN_CREATE value;
68
69 connection master;
70 SELECT @@sql_mode;
71 @@sql_mode
72
73 connection slave;
74 SELECT @@sql_mode;
75 @@sql_mode
76
77 connection master;
78 SET STATEMENT sql_mode='ERROR_FOR_DIVISION_BY_ZERO' FOR
79 INSERT INTO t2 VALUES(@@sql_mode);
80 SELECT @@sql_mode;
81 @@sql_mode
82
83 connection slave;
84 SELECT * FROM t2;
85 a
86 ERROR_FOR_DIVISION_BY_ZERO
87 SELECT @@sql_mode;
88 @@sql_mode
89
90 connection master;
91 DELETE FROM t2;
92 connection master;
93 SELECT @@sql_mode;
94 @@sql_mode
95
96 connection slave;
97 SELECT @@sql_mode;
98 @@sql_mode
99
100 connection master;
101 SET STATEMENT sql_mode='NO_DIR_IN_CREATE' FOR
102 INSERT INTO t2 VALUES(@@sql_mode);
103 SELECT @@sql_mode;
104 @@sql_mode
105
106 connection slave;
107 SELECT * FROM t2;
108 a
109
110 SELECT @@sql_mode;
111 @@sql_mode
112
113 connection master;
114 DELETE FROM t2;
115
116 4) variables that are not replicated at all:
117 default_storage_engine, storage_engine, max_heap_table_size
118
119 connection master;
120 SELECT @@max_heap_table_size;
121 @@max_heap_table_size
122 1048576
123 connection slave;
124 SELECT @@max_heap_table_size;
125 @@max_heap_table_size
126 1048576
127 connection master;
128 SET STATEMENT max_heap_table_size=16384 FOR
129 INSERT INTO t1 VALUES(@@max_heap_table_size);
130 SELECT @@max_heap_table_size;
131 @@max_heap_table_size
132 1048576
133 connection slave;
134 SELECT * FROM t1;
135 a
136 1048576
137 SELECT @@max_heap_table_size;
138 @@max_heap_table_size
139 1048576
140 connection master;
141 DELETE FROM t1;
142 connection master;
143 DROP TABLE t1;
144 DROP TABLE t2;
145 connection slave;
146 include/stop_slave.inc