Debian Codegraph @

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

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 call mtr.add_suppression("Replica: Can\'t find record in \'t\' Error_code: MY-001032");
7 call mtr.add_suppression("Replica SQL for channel '': .*Could not execute Update_rows event on table test.t; Can.t find record in .t.* Error_code: MY-001032");
8 call mtr.add_suppression("The replica coordinator and worker threads are stopped, possibly leaving data in inconsistent state");
9 SHOW VARIABLES LIKE 'binlog_row_image';
10 Variable_name Value
11 binlog_row_image FULL
12 SET @old_binlog_row_image= @@binlog_row_image;
13 SET @old_binlog_row_image= @@binlog_row_image;
14 #####################################################
15 # basic assertion that binlog_row_image='FULL' is the
16 # default
17 #####################################################
18 CON: 'master', IMG: 'FULL', RESTART SLAVE: 'N'
19 SET SESSION binlog_row_image= 'FULL';
20 SET GLOBAL binlog_row_image= 'FULL';
21 FLUSH TABLES;
22 SHOW VARIABLES LIKE 'binlog_row_image';
23 Variable_name Value
24 binlog_row_image FULL
25 CON: 'slave', IMG: 'FULL', RESTART SLAVE: 'Y'
26 SET SESSION binlog_row_image= 'FULL';
27 SET GLOBAL binlog_row_image= 'FULL';
28 include/stop_slave.inc
29 include/start_slave.inc
30 FLUSH TABLES;
31 SHOW VARIABLES LIKE 'binlog_row_image';
32 Variable_name Value
33 binlog_row_image FULL
34 CREATE TABLE t (c1 int, c2 int, c3 blob, primary key(c1));
35 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
36 INSERT INTO t(c1,c3) VALUES (1, 'a');
37 SET sql_mode = default;
38 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
39 UPDATE t SET c1=2 WHERE c1=1;;
40 SET sql_mode = default;
41 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
42 DELETE FROM t;;
43 SET sql_mode = default;
44 DROP TABLE t;
45 include/sync_slave_sql_with_master.inc
46 SET @img_types= 'MINIMAL NOBLOB FULL';
47 CON: 'master', IMG: 'MINIMAL', RESTART SLAVE: 'N'
48 Variable_name Value
49 binlog_row_image MINIMAL
50 CON: 'slave', IMG: 'MINIMAL', RESTART SLAVE: 'Y'
51 include/stop_slave.inc
52 include/start_slave.inc
53 Variable_name Value
54 binlog_row_image MINIMAL
55 ITERATIONS: row_img: MINIMAL, indexes: UK-NOT-NULL
56 include/rpl_reset.inc
57 CREATING TABLE IN master WITH INDEX 'UK-NOT-NULL'
58 CREATE TABLE t (c1 int NOT NULL, c2 int, c3 blob, unique key(c1));
59 include/sync_slave_sql_with_master.inc
60 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
61 INSERT INTO t VALUES (1,2,"a");
62 SET sql_mode = default;
63 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
64 INSERT INTO t(c1,c3) VALUES (10,"a");
65 SET sql_mode = default;
66 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
67 INSERT INTO t(c1) VALUES (1000);
68 SET sql_mode = default;
69 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
70 UPDATE t SET c1=2 WHERE c1=1;
71 SET sql_mode = default;
72 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
73 DELETE FROM t WHERE c2=2;
74 SET sql_mode = default;
75 DROP TABLE t;
76 include/sync_slave_sql_with_master.inc
77 ITERATIONS: row_img: MINIMAL, indexes: PK
78 include/rpl_reset.inc
79 CREATING TABLE IN master WITH INDEX 'PK'
80 CREATE TABLE t (c1 int, c2 int, c3 blob, primary key(c1));
81 include/sync_slave_sql_with_master.inc
82 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
83 INSERT INTO t VALUES (1,2,"a");
84 SET sql_mode = default;
85 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
86 INSERT INTO t(c1,c3) VALUES (10,"a");
87 SET sql_mode = default;
88 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
89 INSERT INTO t(c1) VALUES (1000);
90 SET sql_mode = default;
91 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
92 UPDATE t SET c1=2 WHERE c1=1;
93 SET sql_mode = default;
94 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
95 DELETE FROM t WHERE c2=2;
96 SET sql_mode = default;
97 DROP TABLE t;
98 include/sync_slave_sql_with_master.inc
99 ITERATIONS: row_img: MINIMAL, indexes: UK
100 include/rpl_reset.inc
101 CREATING TABLE IN master WITH INDEX 'UK'
102 CREATE TABLE t (c1 int, c2 int, c3 blob, unique key(c1));
103 include/sync_slave_sql_with_master.inc
104 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
105 INSERT INTO t VALUES (1,2,"a");
106 SET sql_mode = default;
107 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
108 INSERT INTO t(c1,c3) VALUES (10,"a");
109 SET sql_mode = default;
110 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
111 INSERT INTO t(c1) VALUES (1000);
112 SET sql_mode = default;
113 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
114 UPDATE t SET c1=2 WHERE c1=1;
115 SET sql_mode = default;
116 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
117 DELETE FROM t WHERE c2=2;
118 SET sql_mode = default;
119 DROP TABLE t;
120 include/sync_slave_sql_with_master.inc
121 ITERATIONS: row_img: MINIMAL, indexes: K
122 include/rpl_reset.inc
123 CREATING TABLE IN master WITH INDEX 'K'
124 CREATE TABLE t (c1 int, c2 int, c3 blob, key(c1));
125 include/sync_slave_sql_with_master.inc
126 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
127 INSERT INTO t VALUES (1,2,"a");
128 SET sql_mode = default;
129 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
130 INSERT INTO t(c1,c3) VALUES (10,"a");
131 SET sql_mode = default;
132 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
133 INSERT INTO t(c1) VALUES (1000);
134 SET sql_mode = default;
135 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
136 UPDATE t SET c1=2 WHERE c1=1;
137 SET sql_mode = default;
138 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
139 DELETE FROM t WHERE c2=2;
140 SET sql_mode = default;
141 DROP TABLE t;
142 include/sync_slave_sql_with_master.inc
143 ITERATIONS: row_img: MINIMAL, indexes: NONE
144 include/rpl_reset.inc
145 CREATING TABLE IN master WITH INDEX 'NONE'
146 CREATE TABLE t (c1 int, c2 int, c3 blob);
147 include/sync_slave_sql_with_master.inc
148 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
149 INSERT INTO t VALUES (1,2,"a");
150 SET sql_mode = default;
151 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
152 INSERT INTO t(c1,c3) VALUES (10,"a");
153 SET sql_mode = default;
154 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
155 INSERT INTO t(c1) VALUES (1000);
156 SET sql_mode = default;
157 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
158 UPDATE t SET c1=2 WHERE c1=1;
159 SET sql_mode = default;
160 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
161 DELETE FROM t WHERE c2=2;
162 SET sql_mode = default;
163 DROP TABLE t;
164 include/sync_slave_sql_with_master.inc
165 CON: 'master', IMG: 'NOBLOB', RESTART SLAVE: 'N'
166 Variable_name Value
167 binlog_row_image NOBLOB
168 CON: 'slave', IMG: 'NOBLOB', RESTART SLAVE: 'Y'
169 include/stop_slave.inc
170 include/start_slave.inc
171 Variable_name Value
172 binlog_row_image NOBLOB
173 ITERATIONS: row_img: NOBLOB, indexes: UK-NOT-NULL
174 include/rpl_reset.inc
175 CREATING TABLE IN master WITH INDEX 'UK-NOT-NULL'
176 CREATE TABLE t (c1 int NOT NULL, c2 int, c3 blob, unique key(c1));
177 include/sync_slave_sql_with_master.inc
178 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
179 INSERT INTO t VALUES (1,2,"a");
180 SET sql_mode = default;
181 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
182 INSERT INTO t(c1,c3) VALUES (10,"a");
183 SET sql_mode = default;
184 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
185 INSERT INTO t(c1) VALUES (1000);
186 SET sql_mode = default;
187 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
188 UPDATE t SET c1=2 WHERE c1=1;
189 SET sql_mode = default;
190 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
191 DELETE FROM t WHERE c2=2;
192 SET sql_mode = default;
193 DROP TABLE t;
194 include/sync_slave_sql_with_master.inc
195 ITERATIONS: row_img: NOBLOB, indexes: PK
196 include/rpl_reset.inc
197 CREATING TABLE IN master WITH INDEX 'PK'
198 CREATE TABLE t (c1 int, c2 int, c3 blob, primary key(c1));
199 include/sync_slave_sql_with_master.inc
200 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
201 INSERT INTO t VALUES (1,2,"a");
202 SET sql_mode = default;
203 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
204 INSERT INTO t(c1,c3) VALUES (10,"a");
205 SET sql_mode = default;
206 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
207 INSERT INTO t(c1) VALUES (1000);
208 SET sql_mode = default;
209 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
210 UPDATE t SET c1=2 WHERE c1=1;
211 SET sql_mode = default;
212 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
213 DELETE FROM t WHERE c2=2;
214 SET sql_mode = default;
215 DROP TABLE t;
216 include/sync_slave_sql_with_master.inc
217 ITERATIONS: row_img: NOBLOB, indexes: UK
218 include/rpl_reset.inc
219 CREATING TABLE IN master WITH INDEX 'UK'
220 CREATE TABLE t (c1 int, c2 int, c3 blob, unique key(c1));
221 include/sync_slave_sql_with_master.inc
222 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
223 INSERT INTO t VALUES (1,2,"a");
224 SET sql_mode = default;
225 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
226 INSERT INTO t(c1,c3) VALUES (10,"a");
227 SET sql_mode = default;
228 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
229 INSERT INTO t(c1) VALUES (1000);
230 SET sql_mode = default;
231 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
232 UPDATE t SET c1=2 WHERE c1=1;
233 SET sql_mode = default;
234 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
235 DELETE FROM t WHERE c2=2;
236 SET sql_mode = default;
237 DROP TABLE t;
238 include/sync_slave_sql_with_master.inc
239 ITERATIONS: row_img: NOBLOB, indexes: K
240 include/rpl_reset.inc
241 CREATING TABLE IN master WITH INDEX 'K'
242 CREATE TABLE t (c1 int, c2 int, c3 blob, key(c1));
243 include/sync_slave_sql_with_master.inc
244 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
245 INSERT INTO t VALUES (1,2,"a");
246 SET sql_mode = default;
247 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
248 INSERT INTO t(c1,c3) VALUES (10,"a");
249 SET sql_mode = default;
250 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
251 INSERT INTO t(c1) VALUES (1000);
252 SET sql_mode = default;
253 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
254 UPDATE t SET c1=2 WHERE c1=1;
255 SET sql_mode = default;
256 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
257 DELETE FROM t WHERE c2=2;
258 SET sql_mode = default;
259 DROP TABLE t;
260 include/sync_slave_sql_with_master.inc
261 ITERATIONS: row_img: NOBLOB, indexes: NONE
262 include/rpl_reset.inc
263 CREATING TABLE IN master WITH INDEX 'NONE'
264 CREATE TABLE t (c1 int, c2 int, c3 blob);
265 include/sync_slave_sql_with_master.inc
266 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
267 INSERT INTO t VALUES (1,2,"a");
268 SET sql_mode = default;
269 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
270 INSERT INTO t(c1,c3) VALUES (10,"a");
271 SET sql_mode = default;
272 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
273 INSERT INTO t(c1) VALUES (1000);
274 SET sql_mode = default;
275 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
276 UPDATE t SET c1=2 WHERE c1=1;
277 SET sql_mode = default;
278 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
279 DELETE FROM t WHERE c2=2;
280 SET sql_mode = default;
281 DROP TABLE t;
282 include/sync_slave_sql_with_master.inc
283 CON: 'master', IMG: 'FULL', RESTART SLAVE: 'N'
284 Variable_name Value
285 binlog_row_image FULL
286 CON: 'slave', IMG: 'FULL', RESTART SLAVE: 'Y'
287 include/stop_slave.inc
288 include/start_slave.inc
289 Variable_name Value
290 binlog_row_image FULL
291 ITERATIONS: row_img: FULL, indexes: UK-NOT-NULL
292 include/rpl_reset.inc
293 CREATING TABLE IN master WITH INDEX 'UK-NOT-NULL'
294 CREATE TABLE t (c1 int NOT NULL, c2 int, c3 blob, unique key(c1));
295 include/sync_slave_sql_with_master.inc
296 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
297 INSERT INTO t VALUES (1,2,"a");
298 SET sql_mode = default;
299 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
300 INSERT INTO t(c1,c3) VALUES (10,"a");
301 SET sql_mode = default;
302 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
303 INSERT INTO t(c1) VALUES (1000);
304 SET sql_mode = default;
305 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
306 UPDATE t SET c1=2 WHERE c1=1;
307 SET sql_mode = default;
308 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
309 DELETE FROM t WHERE c2=2;
310 SET sql_mode = default;
311 DROP TABLE t;
312 include/sync_slave_sql_with_master.inc
313 ITERATIONS: row_img: FULL, indexes: PK
314 include/rpl_reset.inc
315 CREATING TABLE IN master WITH INDEX 'PK'
316 CREATE TABLE t (c1 int, c2 int, c3 blob, primary key(c1));
317 include/sync_slave_sql_with_master.inc
318 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
319 INSERT INTO t VALUES (1,2,"a");
320 SET sql_mode = default;
321 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
322 INSERT INTO t(c1,c3) VALUES (10,"a");
323 SET sql_mode = default;
324 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
325 INSERT INTO t(c1) VALUES (1000);
326 SET sql_mode = default;
327 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
328 UPDATE t SET c1=2 WHERE c1=1;
329 SET sql_mode = default;
330 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
331 DELETE FROM t WHERE c2=2;
332 SET sql_mode = default;
333 DROP TABLE t;
334 include/sync_slave_sql_with_master.inc
335 ITERATIONS: row_img: FULL, indexes: UK
336 include/rpl_reset.inc
337 CREATING TABLE IN master WITH INDEX 'UK'
338 CREATE TABLE t (c1 int, c2 int, c3 blob, unique key(c1));
339 include/sync_slave_sql_with_master.inc
340 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
341 INSERT INTO t VALUES (1,2,"a");
342 SET sql_mode = default;
343 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
344 INSERT INTO t(c1,c3) VALUES (10,"a");
345 SET sql_mode = default;
346 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
347 INSERT INTO t(c1) VALUES (1000);
348 SET sql_mode = default;
349 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
350 UPDATE t SET c1=2 WHERE c1=1;
351 SET sql_mode = default;
352 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
353 DELETE FROM t WHERE c2=2;
354 SET sql_mode = default;
355 DROP TABLE t;
356 include/sync_slave_sql_with_master.inc
357 ITERATIONS: row_img: FULL, indexes: K
358 include/rpl_reset.inc
359 CREATING TABLE IN master WITH INDEX 'K'
360 CREATE TABLE t (c1 int, c2 int, c3 blob, key(c1));
361 include/sync_slave_sql_with_master.inc
362 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
363 INSERT INTO t VALUES (1,2,"a");
364 SET sql_mode = default;
365 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
366 INSERT INTO t(c1,c3) VALUES (10,"a");
367 SET sql_mode = default;
368 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
369 INSERT INTO t(c1) VALUES (1000);
370 SET sql_mode = default;
371 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
372 UPDATE t SET c1=2 WHERE c1=1;
373 SET sql_mode = default;
374 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
375 DELETE FROM t WHERE c2=2;
376 SET sql_mode = default;
377 DROP TABLE t;
378 include/sync_slave_sql_with_master.inc
379 ITERATIONS: row_img: FULL, indexes: NONE
380 include/rpl_reset.inc
381 CREATING TABLE IN master WITH INDEX 'NONE'
382 CREATE TABLE t (c1 int, c2 int, c3 blob);
383 include/sync_slave_sql_with_master.inc
384 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
385 INSERT INTO t VALUES (1,2,"a");
386 SET sql_mode = default;
387 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
388 INSERT INTO t(c1,c3) VALUES (10,"a");
389 SET sql_mode = default;
390 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
391 INSERT INTO t(c1) VALUES (1000);
392 SET sql_mode = default;
393 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
394 UPDATE t SET c1=2 WHERE c1=1;
395 SET sql_mode = default;
396 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
397 DELETE FROM t WHERE c2=2;
398 SET sql_mode = default;
399 DROP TABLE t;
400 include/sync_slave_sql_with_master.inc
401 SET @img_types= 'MINIMAL NOBLOB FULL';
402 CON: 'master', IMG: 'MINIMAL', RESTART SLAVE: 'N'
403 Variable_name Value
404 binlog_row_image MINIMAL
405 CON: 'slave', IMG: 'MINIMAL', RESTART SLAVE: 'Y'
406 include/stop_slave.inc
407 include/start_slave.inc
408 Variable_name Value
409 binlog_row_image MINIMAL
410 ITERATIONS: row_img: MINIMAL
411 include/rpl_reset.inc
412 include/sync_slave_sql_with_master.inc
413 include/sync_slave_sql_with_master.inc
414 include/rpl_reset.inc
415 ####### MINIMAL PARTICULAR SCENARIO ######
416 include/sync_slave_sql_with_master.inc
417 ####### MINIMAL OTHER PARTICULAR SCENARIO ######
418 include/sync_slave_sql_with_master.inc
419 CON: 'master', IMG: 'NOBLOB', RESTART SLAVE: 'N'
420 Variable_name Value
421 binlog_row_image NOBLOB
422 CON: 'slave', IMG: 'NOBLOB', RESTART SLAVE: 'Y'
423 include/stop_slave.inc
424 include/start_slave.inc
425 Variable_name Value
426 binlog_row_image NOBLOB
427 ITERATIONS: row_img: NOBLOB
428 include/rpl_reset.inc
429 include/sync_slave_sql_with_master.inc
430 include/sync_slave_sql_with_master.inc
431 include/rpl_reset.inc
432 ####### NOBLOB PARTICULAR SCENARIO ######
433 include/sync_slave_sql_with_master.inc
434 CON: 'master', IMG: 'FULL', RESTART SLAVE: 'N'
435 Variable_name Value
436 binlog_row_image FULL
437 CON: 'slave', IMG: 'FULL', RESTART SLAVE: 'Y'
438 include/stop_slave.inc
439 include/start_slave.inc
440 Variable_name Value
441 binlog_row_image FULL
442 ITERATIONS: row_img: FULL
443 include/rpl_reset.inc
444 include/sync_slave_sql_with_master.inc
445 include/sync_slave_sql_with_master.inc
446 include/rpl_reset.inc
447 ################## SPECIAL CASES #########################
448 include/rpl_reset.inc
449 CON: 'master', IMG: 'NOBLOB', RESTART SLAVE: 'N'
450 SET SESSION binlog_row_image= 'NOBLOB';
451 SET GLOBAL binlog_row_image= 'NOBLOB';
452 FLUSH TABLES;
453 SHOW VARIABLES LIKE 'binlog_row_image';
454 Variable_name Value
455 binlog_row_image NOBLOB
456 CON: 'slave', IMG: 'NOBLOB', RESTART SLAVE: 'Y'
457 SET SESSION binlog_row_image= 'NOBLOB';
458 SET GLOBAL binlog_row_image= 'NOBLOB';
459 include/stop_slave.inc
460 include/start_slave.inc
461 FLUSH TABLES;
462 SHOW VARIABLES LIKE 'binlog_row_image';
463 Variable_name Value
464 binlog_row_image NOBLOB
465 ###################################
466 # PK (contains blob)
467 ###################################
468 CREATE TABLE t (c1 int, c2 int, c3 blob, primary key(c1,c3(512)));
469 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
470 INSERT INTO t VALUES (1,2,"a");
471 SET sql_mode = default;
472 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
473 INSERT INTO t(c1,c3) VALUES (10,"a");
474 SET sql_mode = default;
475 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
476 INSERT INTO t(c1) VALUES (1000);
477 Warnings:
478 Warning 1364 Field 'c3' doesn't have a default value
479 SET sql_mode = default;
480 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
481 UPDATE t SET c1=2 WHERE c1=1;
482 SET sql_mode = default;
483 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
484 DELETE FROM t WHERE c2=2;
485 SET sql_mode = default;
486 DROP TABLE t;
487 include/sync_slave_sql_with_master.inc
488 ###################################
489 # PK (does not contain blob, but blob is updated)
490 ###################################
491 include/rpl_reset.inc
492 CREATE TABLE t (c1 int, c2 int, c3 blob, primary key(c1,c2));
493 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
494 INSERT INTO t VALUES (1,2,"a");
495 SET sql_mode = default;
496 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
497 INSERT INTO t(c1,c3) VALUES (10,"a");
498 Warnings:
499 Warning 1364 Field 'c2' doesn't have a default value
500 SET sql_mode = default;
501 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
502 INSERT INTO t(c1) VALUES (1000);
503 Warnings:
504 Warning 1364 Field 'c2' doesn't have a default value
505 SET sql_mode = default;
506 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
507 UPDATE t SET c3='b' WHERE c1=1;
508 SET sql_mode = default;
509 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
510 DELETE FROM t WHERE c2=2;
511 SET sql_mode = default;
512 DROP TABLE t;
513 include/sync_slave_sql_with_master.inc
514 ###################################
515 # AUTOINC columns
516 ###################################
517 include/rpl_reset.inc
518 CON: 'master', IMG: 'MINIMAL', RESTART SLAVE: 'N'
519 SET SESSION binlog_row_image= 'MINIMAL';
520 SET GLOBAL binlog_row_image= 'MINIMAL';
521 FLUSH TABLES;
522 SHOW VARIABLES LIKE 'binlog_row_image';
523 Variable_name Value
524 binlog_row_image MINIMAL
525 CON: 'slave', IMG: 'MINIMAL', RESTART SLAVE: 'Y'
526 SET SESSION binlog_row_image= 'MINIMAL';
527 SET GLOBAL binlog_row_image= 'MINIMAL';
528 include/stop_slave.inc
529 include/start_slave.inc
530 FLUSH TABLES;
531 SHOW VARIABLES LIKE 'binlog_row_image';
532 Variable_name Value
533 binlog_row_image MINIMAL
534 CREATE TABLE t (c1 int NOT NULL AUTO_INCREMENT, c2 int, c3 blob, primary key(c1,c2));
535 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
536 INSERT INTO t(c2) VALUES (2);
537 SET sql_mode = default;
538 DROP TABLE t;
539 include/sync_slave_sql_with_master.inc
540 ##################################################################
541 # Test that slave does not write more columns than the ones it has
542 ##################################################################
543 include/rpl_reset.inc
544 CON: 'master', IMG: 'MINIMAL', RESTART SLAVE: 'N'
545 SET SESSION binlog_row_image= 'MINIMAL';
546 SET GLOBAL binlog_row_image= 'MINIMAL';
547 FLUSH TABLES;
548 SHOW VARIABLES LIKE 'binlog_row_image';
549 Variable_name Value
550 binlog_row_image MINIMAL
551 CON: 'slave', IMG: 'MINIMAL', RESTART SLAVE: 'Y'
552 SET SESSION binlog_row_image= 'MINIMAL';
553 SET GLOBAL binlog_row_image= 'MINIMAL';
554 include/stop_slave.inc
555 include/start_slave.inc
556 FLUSH TABLES;
557 SHOW VARIABLES LIKE 'binlog_row_image';
558 Variable_name Value
559 binlog_row_image MINIMAL
560 SET SQL_LOG_BIN=0;
561 CREATE TABLE t (c1 int NOT NULL AUTO_INCREMENT, c2 int, c3 blob, primary key(c1,c2));
562 SET SQL_LOG_BIN=1;
563 CREATE TABLE t (c1 int, c2 int, primary key(c1));
564 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
565 INSERT INTO t(c2,c3) VALUES (2,'aaaaa');
566 SET sql_mode = default;
567 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
568 UPDATE t SET c2=3, c3='bbbbb' WHERE c2=2;
569 SET sql_mode = default;
570 DROP TABLE t;
571 include/sync_slave_sql_with_master.inc
572 ##################################################################
573 # Test that slave fills default columns in its own columns
574 ##################################################################
575 include/rpl_reset.inc
576 CON: 'master', IMG: 'FULL', RESTART SLAVE: 'N'
577 SET SESSION binlog_row_image= 'FULL';
578 SET GLOBAL binlog_row_image= 'FULL';
579 FLUSH TABLES;
580 SHOW VARIABLES LIKE 'binlog_row_image';
581 Variable_name Value
582 binlog_row_image FULL
583 CON: 'slave', IMG: 'FULL', RESTART SLAVE: 'Y'
584 SET SESSION binlog_row_image= 'FULL';
585 SET GLOBAL binlog_row_image= 'FULL';
586 include/stop_slave.inc
587 include/start_slave.inc
588 FLUSH TABLES;
589 SHOW VARIABLES LIKE 'binlog_row_image';
590 Variable_name Value
591 binlog_row_image FULL
592 SET SQL_LOG_BIN=0;
593 CREATE TABLE t (c1 int, c2 int);
594 SET SQL_LOG_BIN=1;
595 CREATE TABLE t (c1 int, c2 int, c3 int DEFAULT 2005);
596 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
597 INSERT INTO t(c1) VALUES (1);
598 SET sql_mode = default;
599 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
600 INSERT INTO t(c1) VALUES (2);
601 SET sql_mode = default;
602 SELECT * FROM t;
603 c1 c2 c3
604 1 NULL 2005
605 2 NULL 2005
606 SELECT * FROM t;
607 c1 c2
608 1 NULL
609 2 NULL
610 DROP TABLE t;
611 include/sync_slave_sql_with_master.inc
612 ##################################################################
613 # Test that slave uses partial BI when master contains more columns
614 ##################################################################
615 include/rpl_reset.inc
616 CON: 'master', IMG: 'MINIMAL', RESTART SLAVE: 'N'
617 SET SESSION binlog_row_image= 'MINIMAL';
618 SET GLOBAL binlog_row_image= 'MINIMAL';
619 FLUSH TABLES;
620 SHOW VARIABLES LIKE 'binlog_row_image';
621 Variable_name Value
622 binlog_row_image MINIMAL
623 CON: 'slave', IMG: 'MINIMAL', RESTART SLAVE: 'Y'
624 SET SESSION binlog_row_image= 'MINIMAL';
625 SET GLOBAL binlog_row_image= 'MINIMAL';
626 include/stop_slave.inc
627 include/start_slave.inc
628 FLUSH TABLES;
629 SHOW VARIABLES LIKE 'binlog_row_image';
630 Variable_name Value
631 binlog_row_image MINIMAL
632 SET SQL_LOG_BIN=0;
633 CREATE TABLE t (c1 int NOT NULL, c2 int, c3 int, primary key(c1, c3), unique key(c1));
634 SET SQL_LOG_BIN=1;
635 CREATE TABLE t (c1 int NOT NULL, c2 int, unique key(c1));
636 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
637 INSERT INTO t VALUES (1, 2, 3);
638 SET sql_mode = default;
639 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
640 UPDATE t SET c2= 4 WHERE c1=1;
641 SET sql_mode = default;
642 SELECT * FROM t;
643 c1 c2
644 1 4
645 SELECT * FROM t;
646 c1 c2 c3
647 1 4 3
648 DROP TABLE t;
649 include/sync_slave_sql_with_master.inc
650 ##################################################################
651 # Test that if master has binlog_row_image=MINIMAL and slave has
652 # NOBLOB or FULL, it will log the expected columns
653 ##################################################################
654 include/rpl_reset.inc
655 CON: 'master', IMG: 'MINIMAL', RESTART SLAVE: 'N'
656 SET SESSION binlog_row_image= 'MINIMAL';
657 SET GLOBAL binlog_row_image= 'MINIMAL';
658 FLUSH TABLES;
659 SHOW VARIABLES LIKE 'binlog_row_image';
660 Variable_name Value
661 binlog_row_image MINIMAL
662 CON: 'slave', IMG: 'FULL', RESTART SLAVE: 'Y'
663 SET SESSION binlog_row_image= 'FULL';
664 SET GLOBAL binlog_row_image= 'FULL';
665 include/stop_slave.inc
666 include/start_slave.inc
667 FLUSH TABLES;
668 SHOW VARIABLES LIKE 'binlog_row_image';
669 Variable_name Value
670 binlog_row_image FULL
671 SET SQL_LOG_BIN=0;
672 CREATE TABLE t (c1 int NOT NULL, c2 int, c3 int, primary key(c1));
673 SET SQL_LOG_BIN=1;
674 CREATE TABLE t (c1 int NOT NULL, c2 int, c3 int, c4 blob, unique key(c1));
675 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
676 INSERT INTO t VALUES (1, 2, 3);
677 SET sql_mode = default;
678 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
679 UPDATE t SET c2= 4 WHERE c1=1;
680 SET sql_mode = default;
681 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
682 DELETE FROM t WHERE c2=4;
683 SET sql_mode = default;
684 DROP TABLE t;
685 include/sync_slave_sql_with_master.inc
686 include/rpl_reset.inc
687 CON: 'master', IMG: 'MINIMAL', RESTART SLAVE: 'N'
688 SET SESSION binlog_row_image= 'MINIMAL';
689 SET GLOBAL binlog_row_image= 'MINIMAL';
690 FLUSH TABLES;
691 SHOW VARIABLES LIKE 'binlog_row_image';
692 Variable_name Value
693 binlog_row_image MINIMAL
694 CON: 'slave', IMG: 'NOBLOB', RESTART SLAVE: 'Y'
695 SET SESSION binlog_row_image= 'NOBLOB';
696 SET GLOBAL binlog_row_image= 'NOBLOB';
697 include/stop_slave.inc
698 include/start_slave.inc
699 FLUSH TABLES;
700 SHOW VARIABLES LIKE 'binlog_row_image';
701 Variable_name Value
702 binlog_row_image NOBLOB
703 SET SQL_LOG_BIN=0;
704 CREATE TABLE t (c1 int NOT NULL, c2 int, c3 int, primary key(c1));
705 SET SQL_LOG_BIN=1;
706 CREATE TABLE t (c1 int NOT NULL, c2 int, c3 int, c4 blob, unique key(c1));
707 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
708 INSERT INTO t VALUES (1, 2, 3);
709 SET sql_mode = default;
710 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
711 UPDATE t SET c2= 4 WHERE c1=1;
712 SET sql_mode = default;
713 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
714 DELETE FROM t WHERE c2=4;
715 SET sql_mode = default;
716 DROP TABLE t;
717 include/sync_slave_sql_with_master.inc
718 ################################################################
719 # Test that the slave stop with error if no usable data is on BI
720 ################################################################
721 include/rpl_reset.inc
722 CON: 'master', IMG: 'MINIMAL', RESTART SLAVE: 'N'
723 SET SESSION binlog_row_image= 'MINIMAL';
724 SET GLOBAL binlog_row_image= 'MINIMAL';
725 FLUSH TABLES;
726 SHOW VARIABLES LIKE 'binlog_row_image';
727 Variable_name Value
728 binlog_row_image MINIMAL
729 CON: 'slave', IMG: 'NOBLOB', RESTART SLAVE: 'Y'
730 SET SESSION binlog_row_image= 'NOBLOB';
731 SET GLOBAL binlog_row_image= 'NOBLOB';
732 include/stop_slave.inc
733 include/start_slave.inc
734 FLUSH TABLES;
735 SHOW VARIABLES LIKE 'binlog_row_image';
736 Variable_name Value
737 binlog_row_image NOBLOB
738 SET SQL_LOG_BIN=0;
739 CREATE TABLE t (c1 int NOT NULL, c2 int, c3 int, primary key(c3));
740 SET SQL_LOG_BIN=1;
741 CREATE TABLE t (c1 int NOT NULL, c2 int, primary key(c1));
742 INSERT INTO t VALUES (1,2,3);
743 UPDATE t SET c2=4 WHERE c2=2;
744 DROP TABLE t;
745 include/wait_for_slave_sql_error.inc [errno=1032]
746 DROP TABLE t;
747 include/stop_slave_io.inc
748 RESET REPLICA;
749 include/rpl_reset.inc
750 CON: 'master', IMG: 'FULL', RESTART SLAVE: 'N'
751 SET SESSION binlog_row_image= 'FULL';
752 SET GLOBAL binlog_row_image= 'FULL';
753 FLUSH TABLES;
754 SHOW VARIABLES LIKE 'binlog_row_image';
755 Variable_name Value
756 binlog_row_image FULL
757 CON: 'slave', IMG: 'FULL', RESTART SLAVE: 'Y'
758 SET SESSION binlog_row_image= 'FULL';
759 SET GLOBAL binlog_row_image= 'FULL';
760 include/stop_slave.inc
761 include/start_slave.inc
762 FLUSH TABLES;
763 SHOW VARIABLES LIKE 'binlog_row_image';
764 Variable_name Value
765 binlog_row_image FULL
766 CREATE TABLE t1(id INT PRIMARY KEY, a INT) ENGINE = INNODB;
767 include/sync_slave_sql_with_master.inc
768 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
769 INSERT INTO t1 (id, a) VALUES (1, 1);
770 SET sql_mode = default;
771 "Case: FULL - EXPLAIN output should not display Using temporary"
772 EXPLAIN UPDATE t1 SET a=a+1 WHERE id < 2;
773 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
774 1 UPDATE t1 NULL range PRIMARY PRIMARY 4 const 1 100.00 Using where
775 Warnings:
776 Note 1003 update `test`.`t1` set `test`.`t1`.`a` = (`test`.`t1`.`a` + 1) where (`test`.`t1`.`id` < 2)
777 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
778 UPDATE t1 SET a=a+1 WHERE id < 2;
779 SET sql_mode = default;
780 CON: 'master', IMG: 'NOBLOB', RESTART SLAVE: 'N'
781 SET SESSION binlog_row_image= 'NOBLOB';
782 SET GLOBAL binlog_row_image= 'NOBLOB';
783 FLUSH TABLES;
784 SHOW VARIABLES LIKE 'binlog_row_image';
785 Variable_name Value
786 binlog_row_image NOBLOB
787 CON: 'slave', IMG: 'NOBLOB', RESTART SLAVE: 'Y'
788 SET SESSION binlog_row_image= 'NOBLOB';
789 SET GLOBAL binlog_row_image= 'NOBLOB';
790 include/stop_slave.inc
791 include/start_slave.inc
792 FLUSH TABLES;
793 SHOW VARIABLES LIKE 'binlog_row_image';
794 Variable_name Value
795 binlog_row_image NOBLOB
796 "Case: NOBLOB - EXPLAIN output should not display Using temporary"
797 EXPLAIN UPDATE t1 SET a=a+1 WHERE id < 2;
798 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
799 1 UPDATE t1 NULL range PRIMARY PRIMARY 4 const 1 100.00 Using where
800 Warnings:
801 Note 1003 update `test`.`t1` set `test`.`t1`.`a` = (`test`.`t1`.`a` + 1) where (`test`.`t1`.`id` < 2)
802 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
803 UPDATE t1 SET a=a+1 WHERE id < 2;
804 SET sql_mode = default;
805 CON: 'master', IMG: 'MINIMAL', RESTART SLAVE: 'N'
806 SET SESSION binlog_row_image= 'MINIMAL';
807 SET GLOBAL binlog_row_image= 'MINIMAL';
808 FLUSH TABLES;
809 SHOW VARIABLES LIKE 'binlog_row_image';
810 Variable_name Value
811 binlog_row_image MINIMAL
812 CON: 'slave', IMG: 'MINIMAL', RESTART SLAVE: 'Y'
813 SET SESSION binlog_row_image= 'MINIMAL';
814 SET GLOBAL binlog_row_image= 'MINIMAL';
815 include/stop_slave.inc
816 include/start_slave.inc
817 FLUSH TABLES;
818 SHOW VARIABLES LIKE 'binlog_row_image';
819 Variable_name Value
820 binlog_row_image MINIMAL
821 EXPLAIN UPDATE t1 SET a=a+1 WHERE id < 2;
822 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
823 1 UPDATE t1 NULL range PRIMARY PRIMARY 4 const 1 100.00 Using where
824 Warnings:
825 Note 1003 update `test`.`t1` set `test`.`t1`.`a` = (`test`.`t1`.`a` + 1) where (`test`.`t1`.`id` < 2)
826 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
827 UPDATE t1 SET a=a+1 WHERE id < 2;
828 SET sql_mode = default;
829 DROP TABLE t1;
830 include/sync_slave_sql_with_master.inc
831 SET GLOBAL binlog_row_image= @old_binlog_row_image;
832 SET SESSION binlog_row_image= @old_binlog_row_image;
833 SET GLOBAL binlog_row_image= @old_binlog_row_image;
834 SET SESSION binlog_row_image= @old_binlog_row_image;
835 include/rpl_end.inc