Debian Codegraph @

mysql-test/suite/galera/r/galera_forced_binlog_format_ctas.result

raw
1 connection node_2;
2 connection node_1;
3 call mtr.add_suppression("Unsafe statement written to the binary log using statement format since ");
4 SET GLOBAL wsrep_forced_binlog_format=ROW;
5 connection node_1;
6 CREATE TABLE t1(a int not null primary key auto_increment, b int) ENGINE=InnoDB;
7 CREATE TABLE t2(a int not null primary key, b int) ENGINE=InnoDB;
8 INSERT INTO t1 VALUES (NULL,1),(NULL,2);
9 INSERT INTO t1(b) SELECT b+1 from t1;
10 INSERT INTO t1(b) SELECT b+1 from t1;
11 INSERT INTO t1(b) SELECT b+1 from t1;
12 INSERT INTO t1(b) SELECT b+1 from t1;
13 CREATE TABLE t3 AS SELECT * FROM t1;
14 CREATE TABLE t4 AS SELECT * FROM t2;
15 CREATE TABLE t5 (a INT UNIQUE) AS SELECT 1 AS a;
16 CREATE TABLE t6 (a INT UNIQUE) REPLACE SELECT 1 AS a;
17 CREATE TABLE t7 (a INT UNIQUE) REPLACE SELECT 1 AS a,2 AS b UNION SELECT 1 AS a,
18 3 AS c;
19 SELECT COUNT(*) AS EXPECT_32 FROM t1;
20 EXPECT_32
21 32
22 SELECT COUNT(*) AS EXPECT_0 FROM t2;
23 EXPECT_0
24 0
25 SELECT COUNT(*) AS EXPECT_32 FROM t3;
26 EXPECT_32
27 32
28 SELECT * FROM t4;
29 a b
30 SELECT * FROM t5;
31 a
32 1
33 SELECT * FROM t6;
34 a
35 1
36 SELECT * FROM t7;
37 a b
38 1 3
39 connection node_2;
40 # Veryfy CTAS replication
41 SELECT COUNT(*) AS EXPECT_32 FROM t1;
42 EXPECT_32
43 32
44 SELECT COUNT(*) AS EXPECT_0 FROM t2;
45 EXPECT_0
46 0
47 SELECT COUNT(*) AS EXPECT_32 FROM t3;
48 EXPECT_32
49 32
50 SELECT * FROM t4;
51 a b
52 SELECT * FROM t5;
53 a
54 1
55 SELECT * FROM t6;
56 a
57 1
58 SELECT * FROM t7;
59 a b
60 1 3
61 connection node_1;
62 DROP TABLE t1,t2,t3,t4,t5,t6,t7;
63 SET GLOBAL wsrep_forced_binlog_format=STATEMENT;
64 connection node_1;
65 CREATE TABLE t1(a int not null primary key auto_increment, b int) ENGINE=InnoDB;
66 CREATE TABLE t2(a int not null primary key, b int) ENGINE=InnoDB;
67 INSERT INTO t1 VALUES (NULL,1),(NULL,2);
68 Warnings:
69 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the slave
70 INSERT INTO t1(b) SELECT b+1 from t1;
71 Warnings:
72 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statements writing to a table with an auto-increment column after selecting from another table are unsafe because the order in which rows are retrieved determines what (if any) rows will be written. This order cannot be predicted and may differ on master and the slave
73 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the slave
74 INSERT INTO t1(b) SELECT b+1 from t1;
75 Warnings:
76 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statements writing to a table with an auto-increment column after selecting from another table are unsafe because the order in which rows are retrieved determines what (if any) rows will be written. This order cannot be predicted and may differ on master and the slave
77 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the slave
78 INSERT INTO t1(b) SELECT b+1 from t1;
79 Warnings:
80 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statements writing to a table with an auto-increment column after selecting from another table are unsafe because the order in which rows are retrieved determines what (if any) rows will be written. This order cannot be predicted and may differ on master and the slave
81 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the slave
82 INSERT INTO t1(b) SELECT b+1 from t1;
83 Warnings:
84 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statements writing to a table with an auto-increment column after selecting from another table are unsafe because the order in which rows are retrieved determines what (if any) rows will be written. This order cannot be predicted and may differ on master and the slave
85 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the slave
86 CREATE TABLE t3 AS SELECT * FROM t1;
87 Warnings:
88 Warning 1105 Galera does not support wsrep_forced_binlog_format = STMT in CREATE TABLE AS SELECT
89 CREATE TABLE t4 AS SELECT * FROM t2;
90 Warnings:
91 Warning 1105 Galera does not support wsrep_forced_binlog_format = STMT in CREATE TABLE AS SELECT
92 CREATE TABLE t5 (a INT UNIQUE) AS SELECT 1 AS a;
93 Warnings:
94 Warning 1105 Galera does not support wsrep_forced_binlog_format = STMT in CREATE TABLE AS SELECT
95 CREATE TABLE t6 (a INT UNIQUE) REPLACE SELECT 1 AS a;
96 Warnings:
97 Warning 1105 Galera does not support wsrep_forced_binlog_format = STMT in CREATE TABLE AS SELECT
98 CREATE TABLE t7 (a INT UNIQUE) REPLACE SELECT 1 AS a,2 AS b UNION SELECT 1 AS a,
99 3 AS c;
100 Warnings:
101 Warning 1105 Galera does not support wsrep_forced_binlog_format = STMT in CREATE TABLE AS SELECT
102 SELECT COUNT(*) AS EXPECT_32 FROM t1;
103 EXPECT_32
104 32
105 SELECT COUNT(*) AS EXPECT_0 FROM t2;
106 EXPECT_0
107 0
108 SELECT COUNT(*) AS EXPECT_32 FROM t3;
109 EXPECT_32
110 32
111 SELECT * FROM t4;
112 a b
113 SELECT * FROM t5;
114 a
115 1
116 SELECT * FROM t6;
117 a
118 1
119 SELECT * FROM t7;
120 a b
121 1 3
122 connection node_2;
123 # Veryfy CTAS replication
124 SELECT COUNT(*) AS EXPECT_32 FROM t1;
125 EXPECT_32
126 32
127 SELECT COUNT(*) AS EXPECT_0 FROM t2;
128 EXPECT_0
129 0
130 SELECT COUNT(*) AS EXPECT_32 FROM t3;
131 EXPECT_32
132 32
133 SELECT * FROM t4;
134 a b
135 SELECT * FROM t5;
136 a
137 1
138 SELECT * FROM t6;
139 a
140 1
141 SELECT * FROM t7;
142 a b
143 1 3
144 connection node_1;
145 DROP TABLE t1,t2,t3,t4,t5,t6,t7;
146 SET GLOBAL wsrep_forced_binlog_format=MIXED;
147 connection node_1;
148 CREATE TABLE t1(a int not null primary key auto_increment, b int) ENGINE=InnoDB;
149 CREATE TABLE t2(a int not null primary key, b int) ENGINE=InnoDB;
150 INSERT INTO t1 VALUES (NULL,1),(NULL,2);
151 INSERT INTO t1(b) SELECT b+1 from t1;
152 INSERT INTO t1(b) SELECT b+1 from t1;
153 INSERT INTO t1(b) SELECT b+1 from t1;
154 INSERT INTO t1(b) SELECT b+1 from t1;
155 CREATE TABLE t3 AS SELECT * FROM t1;
156 Warnings:
157 Warning 1105 Galera does not support wsrep_forced_binlog_format = MIXED in CREATE TABLE AS SELECT
158 CREATE TABLE t4 AS SELECT * FROM t2;
159 Warnings:
160 Warning 1105 Galera does not support wsrep_forced_binlog_format = MIXED in CREATE TABLE AS SELECT
161 CREATE TABLE t5 (a INT UNIQUE) AS SELECT 1 AS a;
162 Warnings:
163 Warning 1105 Galera does not support wsrep_forced_binlog_format = MIXED in CREATE TABLE AS SELECT
164 CREATE TABLE t6 (a INT UNIQUE) REPLACE SELECT 1 AS a;
165 Warnings:
166 Warning 1105 Galera does not support wsrep_forced_binlog_format = MIXED in CREATE TABLE AS SELECT
167 CREATE TABLE t7 (a INT UNIQUE) REPLACE SELECT 1 AS a,2 AS b UNION SELECT 1 AS a,
168 3 AS c;
169 Warnings:
170 Warning 1105 Galera does not support wsrep_forced_binlog_format = MIXED in CREATE TABLE AS SELECT
171 SELECT COUNT(*) AS EXPECT_32 FROM t1;
172 EXPECT_32
173 32
174 SELECT COUNT(*) AS EXPECT_0 FROM t2;
175 EXPECT_0
176 0
177 SELECT COUNT(*) AS EXPECT_32 FROM t3;
178 EXPECT_32
179 32
180 SELECT * FROM t4;
181 a b
182 SELECT * FROM t5;
183 a
184 1
185 SELECT * FROM t6;
186 a
187 1
188 SELECT * FROM t7;
189 a b
190 1 3
191 connection node_2;
192 # Veryfy CTAS replication
193 SELECT COUNT(*) AS EXPECT_32 FROM t1;
194 EXPECT_32
195 32
196 SELECT COUNT(*) AS EXPECT_0 FROM t2;
197 EXPECT_0
198 0
199 SELECT COUNT(*) AS EXPECT_32 FROM t3;
200 EXPECT_32
201 32
202 SELECT * FROM t4;
203 a b
204 SELECT * FROM t5;
205 a
206 1
207 SELECT * FROM t6;
208 a
209 1
210 SELECT * FROM t7;
211 a b
212 1 3
213 connection node_1;
214 DROP TABLE t1,t2,t3,t4,t5,t6,t7;
215 SET GLOBAL wsrep_forced_binlog_format=NONE;
216 connection node_1;
217 CREATE TABLE t1(a int not null primary key auto_increment, b int) ENGINE=InnoDB;
218 CREATE TABLE t2(a int not null primary key, b int) ENGINE=InnoDB;
219 INSERT INTO t1 VALUES (NULL,1),(NULL,2);
220 INSERT INTO t1(b) SELECT b+1 from t1;
221 INSERT INTO t1(b) SELECT b+1 from t1;
222 INSERT INTO t1(b) SELECT b+1 from t1;
223 INSERT INTO t1(b) SELECT b+1 from t1;
224 CREATE TABLE t3 AS SELECT * FROM t1;
225 CREATE TABLE t4 AS SELECT * FROM t2;
226 CREATE TABLE t5 (a INT UNIQUE) AS SELECT 1 AS a;
227 CREATE TABLE t6 (a INT UNIQUE) REPLACE SELECT 1 AS a;
228 CREATE TABLE t7 (a INT UNIQUE) REPLACE SELECT 1 AS a,2 AS b UNION SELECT 1 AS a,
229 3 AS c;
230 SELECT COUNT(*) AS EXPECT_32 FROM t1;
231 EXPECT_32
232 32
233 SELECT COUNT(*) AS EXPECT_0 FROM t2;
234 EXPECT_0
235 0
236 SELECT COUNT(*) AS EXPECT_32 FROM t3;
237 EXPECT_32
238 32
239 SELECT * FROM t4;
240 a b
241 SELECT * FROM t5;
242 a
243 1
244 SELECT * FROM t6;
245 a
246 1
247 SELECT * FROM t7;
248 a b
249 1 3
250 connection node_2;
251 # Veryfy CTAS replication
252 SELECT COUNT(*) AS EXPECT_32 FROM t1;
253 EXPECT_32
254 32
255 SELECT COUNT(*) AS EXPECT_0 FROM t2;
256 EXPECT_0
257 0
258 SELECT COUNT(*) AS EXPECT_32 FROM t3;
259 EXPECT_32
260 32
261 SELECT * FROM t4;
262 a b
263 SELECT * FROM t5;
264 a
265 1
266 SELECT * FROM t6;
267 a
268 1
269 SELECT * FROM t7;
270 a b
271 1 3
272 connection node_1;
273 DROP TABLE t1,t2,t3,t4,t5,t6,t7;