2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
7
CREATE TABLE t1 (C1 CHAR(1), C2 CHAR(1), INDEX (C1)) ENGINE = 'INNODB' ;
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;
22
SELECT * FROM t1 ORDER BY C1,C2;
30
DELETE FROM t1 WHERE C1 = C2;
31
SELECT * FROM t1 ORDER BY C1,C2;
37
SELECT * FROM t1 ORDER BY C1,C2;
43
UPDATE t1 SET C2 = 'I' WHERE C1 = 'A' AND C2 = 'C';
44
SELECT * FROM t1 ORDER BY C1,C2;
50
SELECT * FROM t1 ORDER BY C1,C2;
56
UPDATE t1 SET c2 = 'Q' WHERE c1 = 'A' AND c2 = 'N';
57
SELECT * FROM t1 ORDER BY c1,c2;
63
SELECT * FROM t1 ORDER BY c1,c2;
69
CREATE TABLE t2 (c1 INT, c12 char(1), c2 INT, PRIMARY KEY (c1)) ENGINE = 'INNODB' ;
71
VALUES (1,'A',2), (2,'A',4), (3,'A',9), (4,'A',15), (5,'A',25),
72
(6,'A',35), (7,'A',50), (8,'A',64), (9,'A',81);
73
SELECT * FROM t2 ORDER BY c1,c2;
84
SELECT * FROM t2 WHERE c2 = c1 * c1 ORDER BY c1,c2;
91
SELECT * FROM t2 ORDER BY c1,c2;
102
SELECT * FROM t2 WHERE c2 = c1 * c1 ORDER BY c1,c2;
109
UPDATE t2 SET c2 = c1*c1 WHERE c2 != c1*c1;
110
SELECT * FROM t2 WHERE c2 = c1 * c1 ORDER BY c1,c2;
121
SELECT * FROM t2 WHERE c2 = c1 * c1 ORDER BY c1,c2;
132
UPDATE t2 SET c12 = 'Q' WHERE c1 = 1 AND c2 = 999;
133
SELECT * FROM t2 ORDER BY c1,c2;
144
SELECT * FROM t2 ORDER BY c1,c2;
155
DELETE FROM t2 WHERE c1 % 4 = 0;
156
SELECT * FROM t2 ORDER BY c1,c2;
165
SELECT * FROM t2 ORDER BY c1,c2;
174
UPDATE t2 SET c12='X';
175
CREATE TABLE t3 (C1 CHAR(1), C2 CHAR(1), pk1 INT, C3 CHAR(1), pk2 INT, PRIMARY KEY (pk1,pk2)) ENGINE = 'INNODB' ;
176
INSERT INTO t3 VALUES ('A','B',1,'B',1), ('X','Y',2,'B',1), ('X','X',3,'B',1);
177
INSERT INTO t3 VALUES ('A','C',1,'B',2), ('X','Z',2,'B',2), ('A','A',3,'B',2);
178
SELECT * FROM t3 ORDER BY C1,C2;
186
SELECT * FROM t3 ORDER BY C1,C2;
194
DELETE FROM t3 WHERE C1 = C2;
195
SELECT * FROM t3 ORDER BY C1,C2;
201
SELECT * FROM t3 ORDER BY C1,C2;
207
UPDATE t3 SET C2 = 'I' WHERE C1 = 'A' AND C2 = 'C';
208
SELECT * FROM t3 ORDER BY C1,C2;
214
SELECT * FROM t3 ORDER BY C1,C2;
220
CREATE TABLE t6 (C1 CHAR(1), C2 CHAR(1), C3 INT) ENGINE = 'INNODB' ;
221
INSERT INTO t6 VALUES ('A','B',1), ('X','Y',2), ('X','X',3);
222
INSERT INTO t6 VALUES ('A','C',4), ('X','Z',5), ('A','A',6);
223
SELECT * FROM t6 ORDER BY C3;
231
SELECT * FROM t6 ORDER BY C3;
239
DELETE FROM t6 WHERE C1 = C2;
240
SELECT * FROM t6 ORDER BY C3;
246
SELECT * FROM t6 ORDER BY C3;
252
UPDATE t6 SET C2 = 'I' WHERE C1 = 'A' AND C2 = 'C';
253
SELECT * FROM t6 ORDER BY C3;
259
SELECT * FROM t6 ORDER BY C3;
265
CREATE TABLE t5 (C1 CHAR(1), C2 CHAR(1), C3 INT PRIMARY KEY) ENGINE = 'INNODB' ;
266
INSERT INTO t5 VALUES ('A','B',1), ('X','Y',2), ('X','X',3);
267
INSERT INTO t5 VALUES ('A','C',4), ('X','Z',5), ('A','A',6);
268
UPDATE t5,t2,t3 SET t5.C2='Q', t2.c12='R', t3.C3 ='S' WHERE t5.C1 = t2.c12 AND t5.C1 = t3.C1;
269
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;
270
C1 C2 C3 c1 c12 c2 C1 C2 pk1 C3 pk2
271
X Q 2 1 R 1 X Y 2 S 1
272
X Q 2 1 R 1 X Z 2 S 2
273
X Q 2 2 R 4 X Y 2 S 1
274
X Q 2 2 R 4 X Z 2 S 2
275
X Q 2 3 R 9 X Y 2 S 1
276
X Q 2 3 R 9 X Z 2 S 2
277
X Q 2 5 R 25 X Y 2 S 1
278
X Q 2 5 R 25 X Z 2 S 2
279
X Q 2 6 R 36 X Y 2 S 1
280
X Q 2 6 R 36 X Z 2 S 2
281
X Q 2 7 R 49 X Y 2 S 1
282
X Q 2 7 R 49 X Z 2 S 2
283
X Q 2 9 R 81 X Y 2 S 1
284
X Q 2 9 R 81 X Z 2 S 2
285
X Q 3 1 R 1 X Y 2 S 1
286
X Q 3 1 R 1 X Z 2 S 2
287
X Q 3 2 R 4 X Y 2 S 1
288
X Q 3 2 R 4 X Z 2 S 2
289
X Q 3 3 R 9 X Y 2 S 1
290
X Q 3 3 R 9 X Z 2 S 2
291
X Q 3 5 R 25 X Y 2 S 1
292
X Q 3 5 R 25 X Z 2 S 2
293
X Q 3 6 R 36 X Y 2 S 1
294
X Q 3 6 R 36 X Z 2 S 2
295
X Q 3 7 R 49 X Y 2 S 1
296
X Q 3 7 R 49 X Z 2 S 2
297
X Q 3 9 R 81 X Y 2 S 1
298
X Q 3 9 R 81 X Z 2 S 2
299
X Q 5 1 R 1 X Y 2 S 1
300
X Q 5 1 R 1 X Z 2 S 2
301
X Q 5 2 R 4 X Y 2 S 1
302
X Q 5 2 R 4 X Z 2 S 2
303
X Q 5 3 R 9 X Y 2 S 1
304
X Q 5 3 R 9 X Z 2 S 2
305
X Q 5 5 R 25 X Y 2 S 1
306
X Q 5 5 R 25 X Z 2 S 2
307
X Q 5 6 R 36 X Y 2 S 1
308
X Q 5 6 R 36 X Z 2 S 2
309
X Q 5 7 R 49 X Y 2 S 1
310
X Q 5 7 R 49 X Z 2 S 2
311
X Q 5 9 R 81 X Y 2 S 1
312
X Q 5 9 R 81 X Z 2 S 2
313
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;
314
C1 C2 C3 c1 c12 c2 C1 C2 pk1 C3 pk2
315
X Q 2 1 R 1 X Y 2 S 1
316
X Q 2 1 R 1 X Z 2 S 2
317
X Q 2 2 R 4 X Y 2 S 1
318
X Q 2 2 R 4 X Z 2 S 2
319
X Q 2 3 R 9 X Y 2 S 1
320
X Q 2 3 R 9 X Z 2 S 2
321
X Q 2 5 R 25 X Y 2 S 1
322
X Q 2 5 R 25 X Z 2 S 2
323
X Q 2 6 R 36 X Y 2 S 1
324
X Q 2 6 R 36 X Z 2 S 2
325
X Q 2 7 R 49 X Y 2 S 1
326
X Q 2 7 R 49 X Z 2 S 2
327
X Q 2 9 R 81 X Y 2 S 1
328
X Q 2 9 R 81 X Z 2 S 2
329
X Q 3 1 R 1 X Y 2 S 1
330
X Q 3 1 R 1 X Z 2 S 2
331
X Q 3 2 R 4 X Y 2 S 1
332
X Q 3 2 R 4 X Z 2 S 2
333
X Q 3 3 R 9 X Y 2 S 1
334
X Q 3 3 R 9 X Z 2 S 2
335
X Q 3 5 R 25 X Y 2 S 1
336
X Q 3 5 R 25 X Z 2 S 2
337
X Q 3 6 R 36 X Y 2 S 1
338
X Q 3 6 R 36 X Z 2 S 2
339
X Q 3 7 R 49 X Y 2 S 1
340
X Q 3 7 R 49 X Z 2 S 2
341
X Q 3 9 R 81 X Y 2 S 1
342
X Q 3 9 R 81 X Z 2 S 2
343
X Q 5 1 R 1 X Y 2 S 1
344
X Q 5 1 R 1 X Z 2 S 2
345
X Q 5 2 R 4 X Y 2 S 1
346
X Q 5 2 R 4 X Z 2 S 2
347
X Q 5 3 R 9 X Y 2 S 1
348
X Q 5 3 R 9 X Z 2 S 2
349
X Q 5 5 R 25 X Y 2 S 1
350
X Q 5 5 R 25 X Z 2 S 2
351
X Q 5 6 R 36 X Y 2 S 1
352
X Q 5 6 R 36 X Z 2 S 2
353
X Q 5 7 R 49 X Y 2 S 1
354
X Q 5 7 R 49 X Z 2 S 2
355
X Q 5 9 R 81 X Y 2 S 1
356
X Q 5 9 R 81 X Z 2 S 2
357
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' ;
358
INSERT INTO t4 SET C1 = 1;
359
SELECT C1,HEX(B1),HEX(B2) FROM t4 ORDER BY C1;
362
SELECT C1,HEX(B1),HEX(B2) FROM t4 ORDER BY C1;
365
CREATE TABLE t7 (C1 INT PRIMARY KEY, C2 INT) ENGINE = 'INNODB' ;
366
--- on slave: original values ---
367
INSERT INTO t7 VALUES (1,3), (2,6), (3,9);
368
SELECT * FROM t7 ORDER BY C1;
373
set @@global.slave_exec_mode= 'IDEMPOTENT';
374
--- on master: new values inserted ---
375
INSERT INTO t7 VALUES (1,2), (2,4), (3,6);
376
SELECT * FROM t7 ORDER BY C1;
381
set @@global.slave_exec_mode= default;
382
--- on slave: old values should be overwritten by replicated values ---
383
SELECT * FROM t7 ORDER BY C1;
389
CREATE TABLE t8 (a INT PRIMARY KEY, b INT UNIQUE, c INT UNIQUE) ENGINE = 'INNODB' ;
390
INSERT INTO t8 VALUES (99,99,99);
391
INSERT INTO t8 VALUES (99,22,33);
392
ERROR 23000: Duplicate entry '99' for key 'PRIMARY'
393
INSERT INTO t8 VALUES (11,99,33);
394
ERROR 23000: Duplicate entry '99' for key 'b'
395
INSERT INTO t8 VALUES (11,22,99);
396
ERROR 23000: Duplicate entry '99' for key 'c'
397
SELECT * FROM t8 ORDER BY a;
401
SELECT * FROM t8 ORDER BY a;
404
INSERT INTO t8 VALUES (1,2,3), (2,4,6), (3,6,9);
405
SELECT * FROM t8 ORDER BY a;
411
set @@global.slave_exec_mode= 'IDEMPOTENT';
413
INSERT INTO t8 VALUES (2,4,8);
414
set @@global.slave_exec_mode= default;
416
SELECT * FROM t8 ORDER BY a;
422
**** Test for BUG#31552 ****
425
**** Resetting master and slave ****
426
include/stop_slave.inc
429
include/start_slave.inc
431
INSERT INTO t1 VALUES ('K','K'), ('L','L'), ('M','M');
433
set @@global.slave_exec_mode= 'IDEMPOTENT';
434
DELETE FROM t1 WHERE C1 = 'L';
436
SELECT COUNT(*) FROM t1 ORDER BY c1,c2;
438
set @@global.slave_exec_mode= default;
441
SELECT COUNT(*) FROM t1 ORDER BY c1,c2;
443
**** Test for BUG#37076 ****
445
DROP TABLE IF EXISTS t1;
446
CREATE TABLE t1 (a TIMESTAMP, b DATETIME, c DATE);
447
INSERT INTO t1 VALUES(
448
'2005-11-14 01:01:01', '2005-11-14 01:01:02', '2005-11-14');
452
2005-11-14 01:01:01 2005-11-14 01:01:02 2005-11-14
453
DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7,t8;
454
CREATE TABLE t1 (i INT NOT NULL,
455
c CHAR(16) CHARACTER SET utf8 NOT NULL,
456
j INT NOT NULL) ENGINE = 'INNODB' ;
457
CREATE TABLE t2 (i INT NOT NULL,
458
c CHAR(16) CHARACTER SET utf8 NOT NULL,
459
j INT NOT NULL) ENGINE = 'INNODB' ;
460
ALTER TABLE t2 MODIFY c CHAR(128) CHARACTER SET utf8 NOT NULL;
461
CREATE TABLE t3 (i INT NOT NULL,
462
c CHAR(128) CHARACTER SET utf8 NOT NULL,
463
j INT NOT NULL) ENGINE = 'INNODB' ;
464
ALTER TABLE t3 MODIFY c CHAR(16) CHARACTER SET utf8 NOT NULL;
465
CREATE TABLE t4 (i INT NOT NULL,
466
c CHAR(128) CHARACTER SET utf8 NOT NULL,
467
j INT NOT NULL) ENGINE = 'INNODB' ;
468
CREATE TABLE t5 (i INT NOT NULL,
469
c CHAR(255) CHARACTER SET utf8 NOT NULL,
470
j INT NOT NULL) ENGINE = 'INNODB' ;
471
ALTER TABLE t5 MODIFY c CHAR(16) CHARACTER SET utf8 NOT NULL;
472
CREATE TABLE t6 (i INT NOT NULL,
473
c CHAR(255) CHARACTER SET utf8 NOT NULL,
474
j INT NOT NULL) ENGINE = 'INNODB' ;
475
ALTER TABLE t6 MODIFY c CHAR(128) CHARACTER SET utf8 NOT NULL;
476
CREATE TABLE t7 (i INT NOT NULL,
477
c CHAR(255) CHARACTER SET utf8 NOT NULL,
478
j INT NOT NULL) ENGINE = 'INNODB' ;
479
[expecting slave to replicate correctly]
480
INSERT INTO t1 VALUES (1, "", 1);
481
INSERT INTO t1 VALUES (2, repeat(_utf8'a', 16), 2);
482
Comparing tables master:test.t1 and slave:test.t1
483
[expecting slave to replicate correctly]
484
INSERT INTO t2 VALUES (1, "", 1);
485
INSERT INTO t2 VALUES (2, repeat(_utf8'a', 16), 2);
486
Comparing tables master:test.t2 and slave:test.t2
487
[expecting slave to stop]
488
INSERT INTO t3 VALUES (1, "", 1);
489
INSERT INTO t3 VALUES (2, repeat(_utf8'a', 128), 2);
491
Table definition on master and slave does not match: Column 1 size mismatch - master has size 384, test.t3 on slave has size 49. Master's column size should be <= the slave's column size.
496
[expecting slave to replicate correctly]
497
INSERT INTO t4 VALUES (1, "", 1);
498
INSERT INTO t4 VALUES (2, repeat(_utf8'a', 128), 2);
499
Comparing tables master:test.t4 and slave:test.t4
500
[expecting slave to stop]
501
INSERT INTO t5 VALUES (1, "", 1);
502
INSERT INTO t5 VALUES (2, repeat(_utf8'a', 255), 2);
504
Table definition on master and slave does not match: Column 1 size mismatch - master has size 765, test.t5 on slave has size 49. Master's column size should be <= the slave's column size.
509
[expecting slave to stop]
510
INSERT INTO t6 VALUES (1, "", 1);
511
INSERT INTO t6 VALUES (2, repeat(_utf8'a', 255), 2);
513
Table definition on master and slave does not match: Column 1 size mismatch - master has size 765, test.t6 on slave has size 385. Master's column size should be <= the slave's column size.
518
[expecting slave to replicate correctly]
519
INSERT INTO t7 VALUES (1, "", 1);
520
INSERT INTO t7 VALUES (2, repeat(_utf8'a', 255), 2);
521
Comparing tables master:test.t7 and slave:test.t7
522
drop table t1, t2, t3, t4, t5, t6, t7;
523
CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE='INNODB' ;
524
INSERT INTO t1 VALUES (1), (2), (3);
525
UPDATE t1 SET a = 10;
526
ERROR 23000: Duplicate entry '10' for key 'PRIMARY'
527
INSERT INTO t1 VALUES (4);
528
Comparing tables master:test.t1 and slave:test.t1
530
DROP TABLE IF EXISTS t1, t2;
532
`pk` int(11) NOT NULL AUTO_INCREMENT,
533
`int_nokey` int(11) NOT NULL,
534
`int_key` int(11) NOT NULL,
535
`date_key` date NOT NULL,
536
`date_nokey` date NOT NULL,
537
`time_key` time NOT NULL,
538
`time_nokey` time NOT NULL,
539
`datetime_key` datetime NOT NULL,
540
`datetime_nokey` datetime NOT NULL,
541
`varchar_key` varchar(1) NOT NULL,
542
`varchar_nokey` varchar(1) NOT NULL,
544
KEY `int_key` (`int_key`),
545
KEY `date_key` (`date_key`),
546
KEY `time_key` (`time_key`),
547
KEY `datetime_key` (`datetime_key`),
548
KEY `varchar_key` (`varchar_key`)
550
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');
552
`pk` int(11) NOT NULL AUTO_INCREMENT,
553
`int_nokey` int(11) NOT NULL,
554
`int_key` int(11) NOT NULL,
555
`date_key` date NOT NULL,
556
`date_nokey` date NOT NULL,
557
`time_key` time NOT NULL,
558
`time_nokey` time NOT NULL,
559
`datetime_key` datetime NOT NULL,
560
`datetime_nokey` datetime NOT NULL,
561
`varchar_key` varchar(1) NOT NULL,
562
`varchar_nokey` varchar(1) NOT NULL,
564
KEY `int_key` (`int_key`),
565
KEY `date_key` (`date_key`),
566
KEY `time_key` (`time_key`),
567
KEY `datetime_key` (`datetime_key`),
568
KEY `varchar_key` (`varchar_key`)
570
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');
571
DELETE FROM t2 WHERE `int_key` < 3 LIMIT 1;
572
UPDATE t1 SET `int_key` = 3 ORDER BY `pk` LIMIT 4;
573
DELETE FROM t2 WHERE `int_key` < 3 LIMIT 1;
574
DELETE FROM t2 WHERE `pk` < 6 LIMIT 1;
575
UPDATE t1 SET `int_key` = 6 ORDER BY `pk` LIMIT 3;
576
DELETE FROM t2 WHERE `pk` < 6 LIMIT 1;
577
UPDATE t1 SET `pk` = 6 ORDER BY `int_key` LIMIT 6;
578
ERROR 23000: Duplicate entry '6' for key 'PRIMARY'
579
DELETE FROM t2 WHERE `pk` < 7 LIMIT 1;
580
UPDATE t1 SET `int_key` = 4 ORDER BY `pk` LIMIT 6;
581
*** results: t2 must be consistent ****
582
Comparing tables master:test.t2 and master:test.t2
585
CREATE TABLE t1 (a int) ENGINE='INNODB' ;
586
INSERT IGNORE INTO t1 VALUES (NULL);
587
INSERT INTO t1 ( a ) VALUES ( 0 );
588
INSERT INTO t1 ( a ) VALUES ( 9 );
589
INSERT INTO t1 ( a ) VALUES ( 2 );
590
INSERT INTO t1 ( a ) VALUES ( 9 );
591
INSERT INTO t1 ( a ) VALUES ( 5 );
592
UPDATE t1 SET a = 5 WHERE a = 9;
593
DELETE FROM t1 WHERE a < 6;
594
UPDATE t1 SET a = 9 WHERE a < 3;
595
INSERT INTO t1 ( a ) VALUES ( 3 );
596
UPDATE t1 SET a = 0 WHERE a < 4;
597
UPDATE t1 SET a = 8 WHERE a < 5;
598
Comparing tables master:test.t1 and slave:test.t1
600
CREATE TABLE t1 (a bit) ENGINE='INNODB' ;
601
INSERT IGNORE INTO t1 VALUES (NULL);
602
INSERT INTO t1 ( a ) VALUES ( 0 );
603
UPDATE t1 SET a = 0 WHERE a = 1 LIMIT 3;
604
INSERT INTO t1 ( a ) VALUES ( 5 );
605
DELETE FROM t1 WHERE a < 2 LIMIT 4;
606
DELETE FROM t1 WHERE a < 9 LIMIT 4;
607
INSERT INTO t1 ( a ) VALUES ( 9 );
608
UPDATE t1 SET a = 8 WHERE a = 0 LIMIT 6;
609
INSERT INTO t1 ( a ) VALUES ( 8 );
610
UPDATE t1 SET a = 0 WHERE a < 6 LIMIT 0;
611
INSERT INTO t1 ( a ) VALUES ( 4 );
612
INSERT INTO t1 ( a ) VALUES ( 3 );
613
UPDATE t1 SET a = 0 WHERE a = 7 LIMIT 6;
614
DELETE FROM t1 WHERE a = 4 LIMIT 7;
615
UPDATE t1 SET a = 9 WHERE a < 2 LIMIT 9;
616
UPDATE t1 SET a = 0 WHERE a < 9 LIMIT 2;
617
DELETE FROM t1 WHERE a < 0 LIMIT 5;
618
INSERT INTO t1 ( a ) VALUES ( 5 );
619
UPDATE t1 SET a = 4 WHERE a < 6 LIMIT 4;
620
INSERT INTO t1 ( a ) VALUES ( 5 );
621
UPDATE t1 SET a = 9 WHERE a < 5 LIMIT 8;
622
DELETE FROM t1 WHERE a < 8 LIMIT 8;
623
INSERT INTO t1 ( a ) VALUES ( 6 );
624
DELETE FROM t1 WHERE a < 6 LIMIT 7;
625
UPDATE t1 SET a = 7 WHERE a = 3 LIMIT 7;
626
UPDATE t1 SET a = 8 WHERE a = 0 LIMIT 6;
627
INSERT INTO t1 ( a ) VALUES ( 7 );
628
DELETE FROM t1 WHERE a < 9 LIMIT 4;
629
INSERT INTO t1 ( a ) VALUES ( 7 );
630
INSERT INTO t1 ( a ) VALUES ( 6 );
631
UPDATE t1 SET a = 8 WHERE a = 3 LIMIT 4;
632
DELETE FROM t1 WHERE a = 2 LIMIT 9;
633
DELETE FROM t1 WHERE a = 1 LIMIT 4;
634
UPDATE t1 SET a = 4 WHERE a = 2 LIMIT 7;
635
INSERT INTO t1 ( a ) VALUES ( 0 );
636
DELETE FROM t1 WHERE a < 3 LIMIT 0;
637
UPDATE t1 SET a = 8 WHERE a = 5 LIMIT 2;
638
INSERT INTO t1 ( a ) VALUES ( 1 );
639
UPDATE t1 SET a = 9 WHERE a < 5 LIMIT 3;
640
Comparing tables master:test.t1 and slave:test.t1