Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 connection slave;
4 connection slave;
5 connection master;
6 CREATE TABLE t1 (C1 CHAR(1), C2 CHAR(1), INDEX (C1)) ENGINE = 'INNODB' ;
7 SELECT * FROM t1;
8 C1 C2
9 connection slave;
10 SELECT * FROM t1;
11 C1 C2
12 connection master;
13 INSERT INTO t1 VALUES ('A','B'), ('X','Y'), ('X','X');
14 INSERT INTO t1 VALUES ('A','C'), ('X','Z'), ('A','A');
15 SELECT * FROM t1 ORDER BY C1,C2;
16 C1 C2
17 A A
18 A B
19 A C
20 X X
21 X Y
22 X Z
23 connection slave;
24 SELECT * FROM t1 ORDER BY C1,C2;
25 C1 C2
26 A A
27 A B
28 A C
29 X X
30 X Y
31 X Z
32 connection master;
33 DELETE FROM t1 WHERE C1 = C2;
34 SELECT * FROM t1 ORDER BY C1,C2;
35 C1 C2
36 A B
37 A C
38 X Y
39 X Z
40 connection slave;
41 SELECT * FROM t1 ORDER BY C1,C2;
42 C1 C2
43 A B
44 A C
45 X Y
46 X Z
47 connection master;
48 UPDATE t1 SET C2 = 'I' WHERE C1 = 'A' AND C2 = 'C';
49 SELECT * FROM t1 ORDER BY C1,C2;
50 C1 C2
51 A B
52 A I
53 X Y
54 X Z
55 connection slave;
56 SELECT * FROM t1 ORDER BY C1,C2;
57 C1 C2
58 A B
59 A I
60 X Y
61 X Z
62 connection slave;
63 include/assert.inc [Counter for COM_COMMIT is consistent with the number of actual commits]
64 include/assert.inc [Counter for COM_INSERT is consistent with the number of actual inserts]
65 include/assert.inc [Counter for COM_DELETE is consistent with the number of actual deletes]
66 include/assert.inc [Counter for COM_UPDATE is consistent with the number of actual updates]
67 connection master;
68 UPDATE t1 SET c2 = 'Q' WHERE c1 = 'A' AND c2 = 'N';
69 SELECT * FROM t1 ORDER BY c1,c2;
70 C1 C2
71 A B
72 A I
73 X Y
74 X Z
75 connection slave;
76 SELECT * FROM t1 ORDER BY c1,c2;
77 C1 C2
78 A B
79 A I
80 X Y
81 X Z
82 connection master;
83 CREATE TABLE t2 (c1 INT, c12 char(1), c2 INT, PRIMARY KEY (c1)) ENGINE = 'INNODB' ;
84 INSERT INTO t2
85 VALUES (1,'A',2), (2,'A',4), (3,'A',9), (4,'A',15), (5,'A',25),
86 (6,'A',35), (7,'A',50), (8,'A',64), (9,'A',81);
87 SELECT * FROM t2 ORDER BY c1,c2;
88 c1 c12 c2
89 1 A 2
90 2 A 4
91 3 A 9
92 4 A 15
93 5 A 25
94 6 A 35
95 7 A 50
96 8 A 64
97 9 A 81
98 SELECT * FROM t2 WHERE c2 = c1 * c1 ORDER BY c1,c2;
99 c1 c12 c2
100 2 A 4
101 3 A 9
102 5 A 25
103 8 A 64
104 9 A 81
105 connection slave;
106 SELECT * FROM t2 ORDER BY c1,c2;
107 c1 c12 c2
108 1 A 2
109 2 A 4
110 3 A 9
111 4 A 15
112 5 A 25
113 6 A 35
114 7 A 50
115 8 A 64
116 9 A 81
117 SELECT * FROM t2 WHERE c2 = c1 * c1 ORDER BY c1,c2;
118 c1 c12 c2
119 2 A 4
120 3 A 9
121 5 A 25
122 8 A 64
123 9 A 81
124 connection master;
125 UPDATE t2 SET c2 = c1*c1 WHERE c2 != c1*c1;
126 SELECT * FROM t2 WHERE c2 = c1 * c1 ORDER BY c1,c2;
127 c1 c12 c2
128 1 A 1
129 2 A 4
130 3 A 9
131 4 A 16
132 5 A 25
133 6 A 36
134 7 A 49
135 8 A 64
136 9 A 81
137 connection slave;
138 SELECT * FROM t2 WHERE c2 = c1 * c1 ORDER BY c1,c2;
139 c1 c12 c2
140 1 A 1
141 2 A 4
142 3 A 9
143 4 A 16
144 5 A 25
145 6 A 36
146 7 A 49
147 8 A 64
148 9 A 81
149 connection master;
150 UPDATE t2 SET c12 = 'Q' WHERE c1 = 1 AND c2 = 999;
151 SELECT * FROM t2 ORDER BY c1,c2;
152 c1 c12 c2
153 1 A 1
154 2 A 4
155 3 A 9
156 4 A 16
157 5 A 25
158 6 A 36
159 7 A 49
160 8 A 64
161 9 A 81
162 connection slave;
163 SELECT * FROM t2 ORDER BY c1,c2;
164 c1 c12 c2
165 1 A 1
166 2 A 4
167 3 A 9
168 4 A 16
169 5 A 25
170 6 A 36
171 7 A 49
172 8 A 64
173 9 A 81
174 connection master;
175 DELETE FROM t2 WHERE c1 % 4 = 0;
176 SELECT * FROM t2 ORDER BY c1,c2;
177 c1 c12 c2
178 1 A 1
179 2 A 4
180 3 A 9
181 5 A 25
182 6 A 36
183 7 A 49
184 9 A 81
185 connection slave;
186 SELECT * FROM t2 ORDER BY c1,c2;
187 c1 c12 c2
188 1 A 1
189 2 A 4
190 3 A 9
191 5 A 25
192 6 A 36
193 7 A 49
194 9 A 81
195 connection master;
196 UPDATE t2 SET c12='X';
197 connection master;
198 CREATE TABLE t3 (C1 CHAR(1), C2 CHAR(1), pk1 INT, C3 CHAR(1), pk2 INT, PRIMARY KEY (pk1,pk2)) ENGINE = 'INNODB' ;
199 INSERT INTO t3 VALUES ('A','B',1,'B',1), ('X','Y',2,'B',1), ('X','X',3,'B',1);
200 INSERT INTO t3 VALUES ('A','C',1,'B',2), ('X','Z',2,'B',2), ('A','A',3,'B',2);
201 SELECT * FROM t3 ORDER BY C1,C2;
202 C1 C2 pk1 C3 pk2
203 A A 3 B 2
204 A B 1 B 1
205 A C 1 B 2
206 X X 3 B 1
207 X Y 2 B 1
208 X Z 2 B 2
209 connection slave;
210 SELECT * FROM t3 ORDER BY C1,C2;
211 C1 C2 pk1 C3 pk2
212 A A 3 B 2
213 A B 1 B 1
214 A C 1 B 2
215 X X 3 B 1
216 X Y 2 B 1
217 X Z 2 B 2
218 connection master;
219 DELETE FROM t3 WHERE C1 = C2;
220 SELECT * FROM t3 ORDER BY C1,C2;
221 C1 C2 pk1 C3 pk2
222 A B 1 B 1
223 A C 1 B 2
224 X Y 2 B 1
225 X Z 2 B 2
226 connection slave;
227 SELECT * FROM t3 ORDER BY C1,C2;
228 C1 C2 pk1 C3 pk2
229 A B 1 B 1
230 A C 1 B 2
231 X Y 2 B 1
232 X Z 2 B 2
233 connection master;
234 UPDATE t3 SET C2 = 'I' WHERE C1 = 'A' AND C2 = 'C';
235 SELECT * FROM t3 ORDER BY C1,C2;
236 C1 C2 pk1 C3 pk2
237 A B 1 B 1
238 A I 1 B 2
239 X Y 2 B 1
240 X Z 2 B 2
241 connection slave;
242 SELECT * FROM t3 ORDER BY C1,C2;
243 C1 C2 pk1 C3 pk2
244 A B 1 B 1
245 A I 1 B 2
246 X Y 2 B 1
247 X Z 2 B 2
248 connection master;
249 CREATE TABLE t6 (C1 CHAR(1), C2 CHAR(1), C3 INT) ENGINE = 'INNODB' ;
250 INSERT INTO t6 VALUES ('A','B',1), ('X','Y',2), ('X','X',3);
251 INSERT INTO t6 VALUES ('A','C',4), ('X','Z',5), ('A','A',6);
252 SELECT * FROM t6 ORDER BY C3;
253 C1 C2 C3
254 A B 1
255 X Y 2
256 X X 3
257 A C 4
258 X Z 5
259 A A 6
260 connection slave;
261 SELECT * FROM t6 ORDER BY C3;
262 C1 C2 C3
263 A B 1
264 X Y 2
265 X X 3
266 A C 4
267 X Z 5
268 A A 6
269 connection master;
270 DELETE FROM t6 WHERE C1 = C2;
271 SELECT * FROM t6 ORDER BY C3;
272 C1 C2 C3
273 A B 1
274 X Y 2
275 A C 4
276 X Z 5
277 connection slave;
278 SELECT * FROM t6 ORDER BY C3;
279 C1 C2 C3
280 A B 1
281 X Y 2
282 A C 4
283 X Z 5
284 connection master;
285 UPDATE t6 SET C2 = 'I' WHERE C1 = 'A' AND C2 = 'C';
286 SELECT * FROM t6 ORDER BY C3;
287 C1 C2 C3
288 A B 1
289 X Y 2
290 A I 4
291 X Z 5
292 connection slave;
293 SELECT * FROM t6 ORDER BY C3;
294 C1 C2 C3
295 A B 1
296 X Y 2
297 A I 4
298 X Z 5
299 connection master;
300 CREATE TABLE t5 (C1 CHAR(1), C2 CHAR(1), C3 INT PRIMARY KEY) ENGINE = 'INNODB' ;
301 INSERT INTO t5 VALUES ('A','B',1), ('X','Y',2), ('X','X',3);
302 INSERT INTO t5 VALUES ('A','C',4), ('X','Z',5), ('A','A',6);
303 UPDATE t5,t2,t3 SET t5.C2='Q', t2.c12='R', t3.C3 ='S' WHERE t5.C1 = t2.c12 AND t5.C1 = t3.C1;
304 SELECT * FROM t5,t2,t3 WHERE t5.C2='Q' AND t2.c12='R' AND t3.C3 ='S' ORDER BY t5.C3,t2.c1,t3.pk1,t3.pk2;
305 C1 C2 C3 c1 c12 c2 C1 C2 pk1 C3 pk2
306 X Q 2 1 R 1 X Y 2 S 1
307 X Q 2 1 R 1 X Z 2 S 2
308 X Q 2 2 R 4 X Y 2 S 1
309 X Q 2 2 R 4 X Z 2 S 2
310 X Q 2 3 R 9 X Y 2 S 1
311 X Q 2 3 R 9 X Z 2 S 2
312 X Q 2 5 R 25 X Y 2 S 1
313 X Q 2 5 R 25 X Z 2 S 2
314 X Q 2 6 R 36 X Y 2 S 1
315 X Q 2 6 R 36 X Z 2 S 2
316 X Q 2 7 R 49 X Y 2 S 1
317 X Q 2 7 R 49 X Z 2 S 2
318 X Q 2 9 R 81 X Y 2 S 1
319 X Q 2 9 R 81 X Z 2 S 2
320 X Q 3 1 R 1 X Y 2 S 1
321 X Q 3 1 R 1 X Z 2 S 2
322 X Q 3 2 R 4 X Y 2 S 1
323 X Q 3 2 R 4 X Z 2 S 2
324 X Q 3 3 R 9 X Y 2 S 1
325 X Q 3 3 R 9 X Z 2 S 2
326 X Q 3 5 R 25 X Y 2 S 1
327 X Q 3 5 R 25 X Z 2 S 2
328 X Q 3 6 R 36 X Y 2 S 1
329 X Q 3 6 R 36 X Z 2 S 2
330 X Q 3 7 R 49 X Y 2 S 1
331 X Q 3 7 R 49 X Z 2 S 2
332 X Q 3 9 R 81 X Y 2 S 1
333 X Q 3 9 R 81 X Z 2 S 2
334 X Q 5 1 R 1 X Y 2 S 1
335 X Q 5 1 R 1 X Z 2 S 2
336 X Q 5 2 R 4 X Y 2 S 1
337 X Q 5 2 R 4 X Z 2 S 2
338 X Q 5 3 R 9 X Y 2 S 1
339 X Q 5 3 R 9 X Z 2 S 2
340 X Q 5 5 R 25 X Y 2 S 1
341 X Q 5 5 R 25 X Z 2 S 2
342 X Q 5 6 R 36 X Y 2 S 1
343 X Q 5 6 R 36 X Z 2 S 2
344 X Q 5 7 R 49 X Y 2 S 1
345 X Q 5 7 R 49 X Z 2 S 2
346 X Q 5 9 R 81 X Y 2 S 1
347 X Q 5 9 R 81 X Z 2 S 2
348 connection slave;
349 SELECT * FROM t5,t2,t3 WHERE t5.C2='Q' AND t2.c12='R' AND t3.C3 ='S' ORDER BY t5.C3,t2.c1,t3.pk1,t3.pk2;
350 C1 C2 C3 c1 c12 c2 C1 C2 pk1 C3 pk2
351 X Q 2 1 R 1 X Y 2 S 1
352 X Q 2 1 R 1 X Z 2 S 2
353 X Q 2 2 R 4 X Y 2 S 1
354 X Q 2 2 R 4 X Z 2 S 2
355 X Q 2 3 R 9 X Y 2 S 1
356 X Q 2 3 R 9 X Z 2 S 2
357 X Q 2 5 R 25 X Y 2 S 1
358 X Q 2 5 R 25 X Z 2 S 2
359 X Q 2 6 R 36 X Y 2 S 1
360 X Q 2 6 R 36 X Z 2 S 2
361 X Q 2 7 R 49 X Y 2 S 1
362 X Q 2 7 R 49 X Z 2 S 2
363 X Q 2 9 R 81 X Y 2 S 1
364 X Q 2 9 R 81 X Z 2 S 2
365 X Q 3 1 R 1 X Y 2 S 1
366 X Q 3 1 R 1 X Z 2 S 2
367 X Q 3 2 R 4 X Y 2 S 1
368 X Q 3 2 R 4 X Z 2 S 2
369 X Q 3 3 R 9 X Y 2 S 1
370 X Q 3 3 R 9 X Z 2 S 2
371 X Q 3 5 R 25 X Y 2 S 1
372 X Q 3 5 R 25 X Z 2 S 2
373 X Q 3 6 R 36 X Y 2 S 1
374 X Q 3 6 R 36 X Z 2 S 2
375 X Q 3 7 R 49 X Y 2 S 1
376 X Q 3 7 R 49 X Z 2 S 2
377 X Q 3 9 R 81 X Y 2 S 1
378 X Q 3 9 R 81 X Z 2 S 2
379 X Q 5 1 R 1 X Y 2 S 1
380 X Q 5 1 R 1 X Z 2 S 2
381 X Q 5 2 R 4 X Y 2 S 1
382 X Q 5 2 R 4 X Z 2 S 2
383 X Q 5 3 R 9 X Y 2 S 1
384 X Q 5 3 R 9 X Z 2 S 2
385 X Q 5 5 R 25 X Y 2 S 1
386 X Q 5 5 R 25 X Z 2 S 2
387 X Q 5 6 R 36 X Y 2 S 1
388 X Q 5 6 R 36 X Z 2 S 2
389 X Q 5 7 R 49 X Y 2 S 1
390 X Q 5 7 R 49 X Z 2 S 2
391 X Q 5 9 R 81 X Y 2 S 1
392 X Q 5 9 R 81 X Z 2 S 2
393 connection slave;
394 SET @saved_slave_type_conversions = @@SLAVE_TYPE_CONVERSIONS;
395 SET GLOBAL SLAVE_TYPE_CONVERSIONS = 'ALL_LOSSY';
396 connection master;
397 CREATE TABLE t4 (C1 CHAR(1) PRIMARY KEY, B1 BIT(1), B2 BIT(1) NOT NULL DEFAULT 0, C2 CHAR(1) NOT NULL DEFAULT 'A') ENGINE = 'INNODB' ;
398 INSERT INTO t4 SET C1 = 1;
399 SELECT C1,HEX(B1),HEX(B2) FROM t4 ORDER BY C1;
400 C1 HEX(B1) HEX(B2)
401 1 NULL 0
402 connection slave;
403 SELECT C1,HEX(B1),HEX(B2) FROM t4 ORDER BY C1;
404 C1 HEX(B1) HEX(B2)
405 1 NULL 0
406 SET GLOBAL SLAVE_TYPE_CONVERSIONS = @saved_slave_type_conversions;
407 connection master;
408 CREATE TABLE t7 (C1 INT PRIMARY KEY, C2 INT) ENGINE = 'INNODB' ;
409 connection slave;
410 --- original values ---
411 INSERT INTO t7 VALUES (1,3), (2,6), (3,9);
412 SELECT * FROM t7 ORDER BY C1;
413 C1 C2
414 1 3
415 2 6
416 3 9
417 set @@global.slave_exec_mode= 'IDEMPOTENT';
418 connection master;
419 --- new values inserted ---
420 INSERT INTO t7 VALUES (1,2), (2,4), (3,6);
421 SELECT * FROM t7 ORDER BY C1;
422 C1 C2
423 1 2
424 2 4
425 3 6
426 connection slave;
427 set @@global.slave_exec_mode= default;
428 --- old values should be overwritten by replicated values ---
429 SELECT * FROM t7 ORDER BY C1;
430 C1 C2
431 1 2
432 2 4
433 3 6
434 connection master;
435 CREATE TABLE t8 (a INT PRIMARY KEY, b INT UNIQUE, c INT UNIQUE) ENGINE = 'INNODB' ;
436 INSERT INTO t8 VALUES (99,99,99);
437 INSERT INTO t8 VALUES (99,22,33);
438 ERROR 23000: Duplicate entry '99' for key 'PRIMARY'
439 INSERT INTO t8 VALUES (11,99,33);
440 ERROR 23000: Duplicate entry '99' for key 'b'
441 INSERT INTO t8 VALUES (11,22,99);
442 ERROR 23000: Duplicate entry '99' for key 'c'
443 SELECT * FROM t8 ORDER BY a;
444 a b c
445 99 99 99
446 connection slave;
447 SELECT * FROM t8 ORDER BY a;
448 a b c
449 99 99 99
450 INSERT INTO t8 VALUES (1,2,3), (2,4,6), (3,6,9);
451 SELECT * FROM t8 ORDER BY a;
452 a b c
453 1 2 3
454 2 4 6
455 3 6 9
456 99 99 99
457 set @@global.slave_exec_mode= 'IDEMPOTENT';
458 connection master;
459 INSERT INTO t8 VALUES (2,4,8);
460 connection slave;
461 set @@global.slave_exec_mode= default;
462 SELECT * FROM t8 ORDER BY a;
463 a b c
464 1 2 3
465 2 4 8
466 3 6 9
467 99 99 99
468 **** Test for BUG#31552 ****
469 connection master;
470 DELETE FROM t1;
471 connection slave;
472 include/rpl_reset.inc
473 connection master;
474 INSERT INTO t1 VALUES ('K','K'), ('L','L'), ('M','M');
475 connection slave;
476 set @@global.slave_exec_mode= 'IDEMPOTENT';
477 DELETE FROM t1 WHERE C1 = 'L';
478 connection master;
479 DELETE FROM t1;
480 SELECT COUNT(*) FROM t1 ORDER BY c1,c2;
481 COUNT(*) 0
482 connection slave;
483 set @@global.slave_exec_mode= default;
484 include/check_slave_is_running.inc
485 SELECT COUNT(*) FROM t1 ORDER BY c1,c2;
486 COUNT(*) 0
487 **** Test for BUG#37076 ****
488 connection master;
489 DROP TABLE IF EXISTS t1;
490 CREATE TABLE t1 (a TIMESTAMP, b DATETIME, c DATE);
491 INSERT INTO t1 VALUES(
492 '2005-11-14 01:01:01', '2005-11-14 01:01:02', '2005-11-14');
493 connection slave;
494 SELECT * FROM t1;
495 a b c
496 2005-11-14 01:01:01 2005-11-14 01:01:02 2005-11-14
497 connection master;
498 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7,t8;
499 connection slave;
500 connection master;
501 CREATE TABLE t1 (i INT NOT NULL,
502 c CHAR(16) CHARACTER SET utf8 NOT NULL,
503 j INT NOT NULL) ENGINE = 'INNODB' ;
504 CREATE TABLE t2 (i INT NOT NULL,
505 c CHAR(16) CHARACTER SET utf8 NOT NULL,
506 j INT NOT NULL) ENGINE = 'INNODB' ;
507 connection slave;
508 ALTER TABLE t2 MODIFY c CHAR(128) CHARACTER SET utf8 NOT NULL;
509 connection master;
510 CREATE TABLE t3 (i INT NOT NULL,
511 c CHAR(128) CHARACTER SET utf8 NOT NULL,
512 j INT NOT NULL) ENGINE = 'INNODB' ;
513 connection slave;
514 ALTER TABLE t3 MODIFY c CHAR(16) CHARACTER SET utf8 NOT NULL;
515 connection master;
516 CREATE TABLE t4 (i INT NOT NULL,
517 c CHAR(128) CHARACTER SET utf8 NOT NULL,
518 j INT NOT NULL) ENGINE = 'INNODB' ;
519 CREATE TABLE t5 (i INT NOT NULL,
520 c CHAR(255) CHARACTER SET utf8 NOT NULL,
521 j INT NOT NULL) ENGINE = 'INNODB' ;
522 connection slave;
523 ALTER TABLE t5 MODIFY c CHAR(16) CHARACTER SET utf8 NOT NULL;
524 connection master;
525 CREATE TABLE t6 (i INT NOT NULL,
526 c CHAR(255) CHARACTER SET utf8 NOT NULL,
527 j INT NOT NULL) ENGINE = 'INNODB' ;
528 connection slave;
529 ALTER TABLE t6 MODIFY c CHAR(128) CHARACTER SET utf8 NOT NULL;
530 connection master;
531 CREATE TABLE t7 (i INT NOT NULL,
532 c CHAR(255) CHARACTER SET utf8 NOT NULL,
533 j INT NOT NULL) ENGINE = 'INNODB' ;
534 connection slave;
535 SET @saved_slave_type_conversions = @@slave_type_conversions;
536 SET GLOBAL SLAVE_TYPE_CONVERSIONS = 'ALL_NON_LOSSY';
537 [expecting slave to replicate correctly]
538 connection master;
539 INSERT INTO t1 VALUES (1, "", 1);
540 INSERT INTO t1 VALUES (2, repeat(_utf8'a', 16), 2);
541 connection slave;
542 include/diff_tables.inc [master:t1, slave:t1]
543 [expecting slave to replicate correctly]
544 connection master;
545 INSERT INTO t2 VALUES (1, "", 1);
546 INSERT INTO t2 VALUES (2, repeat(_utf8'a', 16), 2);
547 connection slave;
548 include/diff_tables.inc [master:t2, slave:t2]
549 connection slave;
550 SET GLOBAL SLAVE_TYPE_CONVERSIONS = @saved_slave_type_conversions;
551 call mtr.add_suppression("Slave SQL.*Table definition on master and slave does not match: Column 1 size mismatch.* error.* 1535");
552 call mtr.add_suppression("Slave SQL.*Could not execute Delete_rows event on table test.t1.* error.* 1032");
553 call mtr.add_suppression("Slave SQL.*Column 1 of table .test.t.. cannot be converted from type.*, error.* 1677");
554 call mtr.add_suppression("Can't find record in 't1'");
555 include/rpl_reset.inc
556 [expecting slave to replicate correctly]
557 connection master;
558 INSERT INTO t4 VALUES (1, "", 1);
559 INSERT INTO t4 VALUES (2, repeat(_utf8'a', 128), 2);
560 connection slave;
561 include/diff_tables.inc [master:t4, slave:t4]
562 [expecting slave to stop]
563 connection master;
564 INSERT INTO t5 VALUES (1, "", 1);
565 INSERT INTO t5 VALUES (2, repeat(_utf8'a', 255), 2);
566 connection slave;
567 include/wait_for_slave_sql_error.inc [errno=1677]
568 Last_SQL_Error = 'Column 1 of table 'test.t5' cannot be converted from type 'char(765 octets)' to type 'char(48 octets) character set utf8mb3''
569 include/rpl_reset.inc
570 [expecting slave to stop]
571 connection master;
572 INSERT INTO t6 VALUES (1, "", 1);
573 INSERT INTO t6 VALUES (2, repeat(_utf8'a', 255), 2);
574 connection slave;
575 include/wait_for_slave_sql_error.inc [errno=1677]
576 Last_SQL_Error = 'Column 1 of table 'test.t6' cannot be converted from type 'char(765 octets)' to type 'char(384 octets) character set utf8mb3''
577 include/rpl_reset.inc
578 [expecting slave to replicate correctly]
579 connection master;
580 INSERT INTO t7 VALUES (1, "", 1);
581 INSERT INTO t7 VALUES (2, repeat(_utf8'a', 255), 2);
582 connection slave;
583 include/diff_tables.inc [master:t7, slave:t7]
584 connection master;
585 drop table t1, t2, t3, t4, t5, t6, t7;
586 connection slave;
587 connection master;
588 CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE='INNODB' ;
589 INSERT INTO t1 VALUES (1), (2), (3);
590 UPDATE t1 SET a = 10;
591 ERROR 23000: Duplicate entry '10' for key 'PRIMARY'
592 INSERT INTO t1 VALUES (4);
593 connection slave;
594 include/diff_tables.inc [master:t1, slave:t1]
595 connection master;
596 drop table t1;
597 connection slave;
598 connection master;
599 DROP TABLE IF EXISTS t1, t2;
600 CREATE TABLE t1 (
601 `pk` int(11) NOT NULL AUTO_INCREMENT,
602 `int_nokey` int(11) NOT NULL,
603 `int_key` int(11) NOT NULL,
604 `date_key` date NOT NULL,
605 `date_nokey` date NOT NULL,
606 `time_key` time NOT NULL,
607 `time_nokey` time NOT NULL,
608 `datetime_key` datetime NOT NULL,
609 `datetime_nokey` datetime NOT NULL,
610 `varchar_key` varchar(1) NOT NULL,
611 `varchar_nokey` varchar(1) NOT NULL,
612 PRIMARY KEY (`pk`),
613 KEY `int_key` (`int_key`),
614 KEY `date_key` (`date_key`),
615 KEY `time_key` (`time_key`),
616 KEY `datetime_key` (`datetime_key`),
617 KEY `varchar_key` (`varchar_key`)
618 ) ENGINE='INNODB' ;
619 INSERT INTO t1 VALUES (1,8,5,'0000-00-00','0000-00-00','10:37:38','10:37:38','0000-00-00 00:00:00','0000-00-00 00:00:00','p','p'),(2,0,9,'0000-00-00','0000-00-00','00:00:00','00:00:00','2007-10-14 00:00:00','2007-10-14 00:00:00','d','d');
620 CREATE TABLE t2 (
621 `pk` int(11) NOT NULL AUTO_INCREMENT,
622 `int_nokey` int(11) NOT NULL,
623 `int_key` int(11) NOT NULL,
624 `date_key` date NOT NULL,
625 `date_nokey` date NOT NULL,
626 `time_key` time NOT NULL,
627 `time_nokey` time NOT NULL,
628 `datetime_key` datetime NOT NULL,
629 `datetime_nokey` datetime NOT NULL,
630 `varchar_key` varchar(1) NOT NULL,
631 `varchar_nokey` varchar(1) NOT NULL,
632 PRIMARY KEY (`pk`),
633 KEY `int_key` (`int_key`),
634 KEY `date_key` (`date_key`),
635 KEY `time_key` (`time_key`),
636 KEY `datetime_key` (`datetime_key`),
637 KEY `varchar_key` (`varchar_key`)
638 ) ENGINE='INNODB' ;
639 INSERT INTO t2 VALUES (1,1,6,'2005-12-23','2005-12-23','02:24:28','02:24:28','0000-00-00 00:00:00','0000-00-00 00:00:00','g','g'),(2,0,3,'2009-09-14','2009-09-14','00:00:00','00:00:00','2000-01-30 16:39:40','2000-01-30 16:39:40','q','q'),(3,0,3,'0000-00-00','0000-00-00','00:00:00','00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','c','c'),(4,1,6,'2007-03-29','2007-03-29','15:49:00','15:49:00','0000-00-00 00:00:00','0000-00-00 00:00:00','m','m'),(5,4,0,'2002-12-04','2002-12-04','00:00:00','00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','o','o'),(6,9,0,'2005-01-28','2005-01-28','00:00:00','00:00:00','2001-05-18 00:00:00','2001-05-18 00:00:00','w','w'),(7,6,0,'0000-00-00','0000-00-00','06:57:25','06:57:25','0000-00-00 00:00:00','0000-00-00 00:00:00','m','m'),(8,0,0,'0000-00-00','0000-00-00','00:00:00','00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','z','z'),(9,4,6,'2006-08-15','2006-08-15','00:00:00','00:00:00','2002-04-12 14:44:25','2002-04-12 14:44:25','j','j'),(10,0,5,'2006-12-20','2006-12-20','10:13:53','10:13:53','2008-07-22 00:00:00','2008-07-22 00:00:00','y','y'),(11,9,7,'0000-00-00','0000-00-00','00:00:00','00:00:00','2004-07-05 00:00:00','2004-07-05 00:00:00','{','{'),(12,4,3,'2007-01-26','2007-01-26','23:00:51','23:00:51','2001-05-16 00:00:00','2001-05-16 00:00:00','f','f'),(13,7,0,'2004-03-27','2004-03-27','00:00:00','00:00:00','2005-01-24 03:30:37','2005-01-24 03:30:37','',''),(14,6,0,'2006-07-26','2006-07-26','18:43:57','18:43:57','0000-00-00 00:00:00','0000-00-00 00:00:00','{','{'),(15,0,6,'2000-01-14','2000-01-14','00:00:00','00:00:00','2000-09-21 00:00:00','2000-09-21 00:00:00','o','o'),(16,9,8,'0000-00-00','0000-00-00','21:15:08','21:15:08','0000-00-00 00:00:00','0000-00-00 00:00:00','a','a'),(17,2,0,'2004-10-27','2004-10-27','00:00:00','00:00:00','2004-03-24 22:13:43','2004-03-24 22:13:43','',''),(18,7,4,'0000-00-00','0000-00-00','08:38:27','08:38:27','2002-03-18 19:51:44','2002-03-18 19:51:44','t','t'),(19,5,3,'2008-03-07','2008-03-07','03:29:07','03:29:07','2007-12-01 18:44:44','2007-12-01 18:44:44','t','t'),(20,0,0,'2002-04-09','2002-04-09','16:06:03','16:06:03','2009-04-22 00:00:00','2009-04-22 00:00:00','n','n');
640 DELETE FROM t2 WHERE `int_key` < 3 LIMIT 1;
641 UPDATE t1 SET `int_key` = 3 ORDER BY `pk` LIMIT 4;
642 DELETE FROM t2 WHERE `int_key` < 3 LIMIT 1;
643 DELETE FROM t2 WHERE `pk` < 6 LIMIT 1;
644 UPDATE t1 SET `int_key` = 6 ORDER BY `pk` LIMIT 3;
645 DELETE FROM t2 WHERE `pk` < 6 LIMIT 1;
646 UPDATE t1 SET `pk` = 6 ORDER BY `int_key` LIMIT 6;
647 ERROR 23000: Duplicate entry '6' for key 'PRIMARY'
648 DELETE FROM t2 WHERE `pk` < 7 LIMIT 1;
649 UPDATE t1 SET `int_key` = 4 ORDER BY `pk` LIMIT 6;
650 connection slave;
651 *** results: t2 must be consistent ****
652 include/diff_tables.inc [master:t2, slave:t2]
653 connection master;
654 DROP TABLE t1, t2;
655 EOF OF TESTS
656 connection master;
657 CREATE TABLE t1 (a int) ENGINE='INNODB' ;
658 INSERT IGNORE INTO t1 VALUES (NULL);
659 INSERT INTO t1 ( a ) VALUES ( 0 );
660 INSERT INTO t1 ( a ) VALUES ( 9 );
661 INSERT INTO t1 ( a ) VALUES ( 2 );
662 INSERT INTO t1 ( a ) VALUES ( 9 );
663 INSERT INTO t1 ( a ) VALUES ( 5 );
664 UPDATE t1 SET a = 5 WHERE a = 9;
665 DELETE FROM t1 WHERE a < 6;
666 UPDATE t1 SET a = 9 WHERE a < 3;
667 INSERT INTO t1 ( a ) VALUES ( 3 );
668 UPDATE t1 SET a = 0 WHERE a < 4;
669 UPDATE t1 SET a = 8 WHERE a < 5;
670 connection slave;
671 include/diff_tables.inc [master:t1, slave:t1]
672 connection master;
673 drop table t1;
674 connection slave;
675 connection master;
676 connection slave;
677 SET @saved_slave_type_conversions = @@SLAVE_TYPE_CONVERSIONS;
678 SET GLOBAL SLAVE_TYPE_CONVERSIONS = 'ALL_LOSSY';
679 connection master;
680 CREATE TABLE t1 (a bit) ENGINE='INNODB' ;
681 INSERT IGNORE INTO t1 VALUES (NULL);
682 INSERT INTO t1 ( a ) VALUES ( 0 );
683 UPDATE t1 SET a = 0 WHERE a = 1 LIMIT 3;
684 INSERT IGNORE INTO t1 ( a ) VALUES ( 5 );
685 DELETE FROM t1 WHERE a < 2 LIMIT 4;
686 DELETE FROM t1 WHERE a < 9 LIMIT 4;
687 INSERT IGNORE INTO t1 ( a ) VALUES ( 9 );
688 UPDATE t1 SET a = 8 WHERE a = 0 LIMIT 6;
689 INSERT IGNORE INTO t1 ( a ) VALUES ( 8 );
690 UPDATE t1 SET a = 0 WHERE a < 6 LIMIT 0;
691 INSERT IGNORE INTO t1 ( a ) VALUES ( 4 );
692 INSERT IGNORE INTO t1 ( a ) VALUES ( 3 );
693 UPDATE t1 SET a = 0 WHERE a = 7 LIMIT 6;
694 DELETE FROM t1 WHERE a = 4 LIMIT 7;
695 UPDATE IGNORE t1 SET a = 9 WHERE a < 2 LIMIT 9;
696 UPDATE t1 SET a = 0 WHERE a < 9 LIMIT 2;
697 DELETE FROM t1 WHERE a < 0 LIMIT 5;
698 INSERT IGNORE INTO t1 ( a ) VALUES ( 5 );
699 UPDATE IGNORE t1 SET a = 4 WHERE a < 6 LIMIT 4;
700 INSERT IGNORE INTO t1 ( a ) VALUES ( 5 );
701 UPDATE IGNORE t1 SET a = 9 WHERE a < 5 LIMIT 8;
702 DELETE FROM t1 WHERE a < 8 LIMIT 8;
703 INSERT IGNORE INTO t1 ( a ) VALUES ( 6 );
704 DELETE FROM t1 WHERE a < 6 LIMIT 7;
705 UPDATE t1 SET a = 7 WHERE a = 3 LIMIT 7;
706 UPDATE t1 SET a = 8 WHERE a = 0 LIMIT 6;
707 INSERT IGNORE INTO t1 ( a ) VALUES ( 7 );
708 DELETE FROM t1 WHERE a < 9 LIMIT 4;
709 INSERT IGNORE INTO t1 ( a ) VALUES ( 7 );
710 INSERT IGNORE INTO t1 ( a ) VALUES ( 6 );
711 UPDATE t1 SET a = 8 WHERE a = 3 LIMIT 4;
712 DELETE FROM t1 WHERE a = 2 LIMIT 9;
713 DELETE FROM t1 WHERE a = 1 LIMIT 4;
714 UPDATE t1 SET a = 4 WHERE a = 2 LIMIT 7;
715 INSERT INTO t1 ( a ) VALUES ( 0 );
716 DELETE FROM t1 WHERE a < 3 LIMIT 0;
717 UPDATE t1 SET a = 8 WHERE a = 5 LIMIT 2;
718 INSERT INTO t1 ( a ) VALUES ( 1 );
719 UPDATE IGNORE t1 SET a = 9 WHERE a < 5 LIMIT 3;
720 connection slave;
721 SET GLOBAL SLAVE_TYPE_CONVERSIONS = @saved_slave_type_conversions;
722 include/diff_tables.inc [master:t1, slave:t1]
723 connection master;
724 drop table t1;
725 connection slave;
726 include/rpl_end.inc