Debian Codegraph @

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

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