1
DROP TABLE IF EXISTS t1,t2,t3;
2
CREATE TABLE t1(c1 CHAR(10) NOT NULL PRIMARY KEY);
3
CREATE TABLE t2(c1 CHAR(10) NOT NULL PRIMARY KEY);
4
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
5
CREATE TABLE t3(c1 CHAR(10) NOT NULL PRIMARY KEY);
6
INSERT INTO t3 (c1) VALUES('a');
7
SELECT COUNT(c1) FROM t1;
10
SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
13
REPLACE t1 SET c1='a';
14
SELECT COUNT(c1) FROM t1;
17
SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
21
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
22
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
23
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
24
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
25
INSERT INTO t3 (c1) VALUES('a');
26
SELECT COUNT(c1) FROM t1;
29
SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
32
REPLACE t1 SET c1='a';
33
SELECT COUNT(c1) FROM t1;
36
SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
40
CREATE TABLE t1(c1 BINARY(10) NOT NULL PRIMARY KEY);
41
CREATE TABLE t2(c1 BINARY(10) NOT NULL PRIMARY KEY);
42
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
43
CREATE TABLE t3(c1 BINARY(10) NOT NULL PRIMARY KEY);
44
INSERT INTO t3 (c1) VALUES('a');
45
SELECT COUNT(c1) FROM t1;
48
SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
51
REPLACE t1 SET c1='a';
52
SELECT COUNT(c1) FROM t1;
55
SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
59
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
60
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
61
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
62
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
63
INSERT INTO t3 (c1) VALUES('a');
64
SELECT COUNT(c1) FROM t1;
67
SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
70
REPLACE t1 SET c1='a';
71
SELECT COUNT(c1) FROM t1;
74
SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
78
CREATE TABLE t1(c1 CHAR(10) NOT NULL PRIMARY KEY);
79
CREATE TABLE t2(c1 CHAR(10) NOT NULL PRIMARY KEY);
80
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
81
CREATE TABLE t3(c1 CHAR(10) NOT NULL PRIMARY KEY);
82
INSERT INTO t3 (c1) VALUES('a');
83
SELECT COUNT(c1) FROM t2;
86
SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
89
REPLACE t2 SET c1='a';
90
SELECT COUNT(c1) FROM t2;
93
SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
97
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
98
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
99
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
100
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
101
INSERT INTO t3 (c1) VALUES('a');
102
SELECT COUNT(c1) FROM t2;
105
SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
108
REPLACE t2 SET c1='a';
109
SELECT COUNT(c1) FROM t2;
112
SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
116
CREATE TABLE t1(c1 BINARY(10) NOT NULL PRIMARY KEY);
117
CREATE TABLE t2(c1 BINARY(10) NOT NULL PRIMARY KEY);
118
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
119
CREATE TABLE t3(c1 BINARY(10) NOT NULL PRIMARY KEY);
120
INSERT INTO t3 (c1) VALUES('a');
121
SELECT COUNT(c1) FROM t2;
124
SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
127
REPLACE t2 SET c1='a';
128
SELECT COUNT(c1) FROM t2;
131
SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
135
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
136
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
137
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
138
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
139
INSERT INTO t3 (c1) VALUES('a');
140
SELECT COUNT(c1) FROM t2;
143
SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
146
REPLACE t2 SET c1='a';
147
SELECT COUNT(c1) FROM t2;
150
SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
154
CREATE TABLE t1(c1 CHAR(10) NOT NULL PRIMARY KEY);
155
CREATE TABLE t2(c1 CHAR(10) NOT NULL PRIMARY KEY);
156
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
157
CREATE TABLE t3(c1 CHAR(10) NOT NULL PRIMARY KEY);
158
INSERT INTO t3 (c1) VALUES('a');
159
SELECT COUNT(c1) FROM t3;
162
SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
165
REPLACE t3 SET c1='a';
166
SELECT COUNT(c1) FROM t3;
169
SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
173
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
174
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
175
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
176
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
177
INSERT INTO t3 (c1) VALUES('a');
178
SELECT COUNT(c1) FROM t3;
181
SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
184
REPLACE t3 SET c1='a';
185
SELECT COUNT(c1) FROM t3;
188
SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
192
CREATE TABLE t1(c1 BINARY(10) NOT NULL PRIMARY KEY);
193
CREATE TABLE t2(c1 BINARY(10) NOT NULL PRIMARY KEY);
194
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
195
CREATE TABLE t3(c1 BINARY(10) NOT NULL PRIMARY KEY);
196
INSERT INTO t3 (c1) VALUES('a');
197
SELECT COUNT(c1) FROM t3;
200
SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
203
REPLACE t3 SET c1='a';
204
SELECT COUNT(c1) FROM t3;
207
SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
211
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
212
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
213
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
214
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
215
INSERT INTO t3 (c1) VALUES('a');
216
SELECT COUNT(c1) FROM t3;
219
SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
222
REPLACE t3 SET c1='a';
223
SELECT COUNT(c1) FROM t3;
226
SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
230
CREATE TABLE t1(c1 CHAR(10) NOT NULL PRIMARY KEY);
231
CREATE TABLE t2(c1 CHAR(10) NOT NULL PRIMARY KEY);
232
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
233
CREATE TABLE t3(c1 CHAR(10) NOT NULL PRIMARY KEY);
234
INSERT INTO t3 (c1) VALUES('a');
235
SELECT COUNT(c1) FROM t1;
238
SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
241
REPLACE t1 SET c1='a';
242
SELECT COUNT(c1) FROM t1;
245
SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
249
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
250
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
251
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
252
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
253
INSERT INTO t3 (c1) VALUES('a');
254
SELECT COUNT(c1) FROM t1;
257
SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
260
REPLACE t1 SET c1='a';
261
SELECT COUNT(c1) FROM t1;
264
SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
268
CREATE TABLE t1(c1 BINARY(10) NOT NULL PRIMARY KEY);
269
CREATE TABLE t2(c1 BINARY(10) NOT NULL PRIMARY KEY);
270
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
271
CREATE TABLE t3(c1 BINARY(10) NOT NULL PRIMARY KEY);
272
INSERT INTO t3 (c1) VALUES('a');
273
SELECT COUNT(c1) FROM t1;
276
SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
279
REPLACE t1 SET c1='a';
280
SELECT COUNT(c1) FROM t1;
283
SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
287
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
288
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
289
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
290
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
291
INSERT INTO t3 (c1) VALUES('a');
292
SELECT COUNT(c1) FROM t1;
295
SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
298
REPLACE t1 SET c1='a';
299
SELECT COUNT(c1) FROM t1;
302
SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
306
CREATE TABLE t1(c1 CHAR(10) NOT NULL PRIMARY KEY);
307
CREATE TABLE t2(c1 CHAR(10) NOT NULL PRIMARY KEY);
308
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
309
CREATE TABLE t3(c1 CHAR(10) NOT NULL PRIMARY KEY);
310
INSERT INTO t3 (c1) VALUES('a');
311
SELECT COUNT(c1) FROM t2;
314
SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
317
REPLACE t2 SET c1='a';
318
SELECT COUNT(c1) FROM t2;
321
SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
325
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
326
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
327
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
328
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
329
INSERT INTO t3 (c1) VALUES('a');
330
SELECT COUNT(c1) FROM t2;
333
SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
336
REPLACE t2 SET c1='a';
337
SELECT COUNT(c1) FROM t2;
340
SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
344
CREATE TABLE t1(c1 BINARY(10) NOT NULL PRIMARY KEY);
345
CREATE TABLE t2(c1 BINARY(10) NOT NULL PRIMARY KEY);
346
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
347
CREATE TABLE t3(c1 BINARY(10) NOT NULL PRIMARY KEY);
348
INSERT INTO t3 (c1) VALUES('a');
349
SELECT COUNT(c1) FROM t2;
352
SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
355
REPLACE t2 SET c1='a';
356
SELECT COUNT(c1) FROM t2;
359
SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
363
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
364
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
365
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
366
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
367
INSERT INTO t3 (c1) VALUES('a');
368
SELECT COUNT(c1) FROM t2;
371
SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
374
REPLACE t2 SET c1='a';
375
SELECT COUNT(c1) FROM t2;
378
SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
382
CREATE TABLE t1(c1 CHAR(10) NOT NULL PRIMARY KEY);
383
CREATE TABLE t2(c1 CHAR(10) NOT NULL PRIMARY KEY);
384
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
385
CREATE TABLE t3(c1 CHAR(10) NOT NULL PRIMARY KEY);
386
INSERT INTO t3 (c1) VALUES('a');
387
SELECT COUNT(c1) FROM t3;
390
SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
393
REPLACE t3 SET c1='a';
394
SELECT COUNT(c1) FROM t3;
397
SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
401
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
402
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
403
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
404
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
405
INSERT INTO t3 (c1) VALUES('a');
406
SELECT COUNT(c1) FROM t3;
409
SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
412
REPLACE t3 SET c1='a';
413
SELECT COUNT(c1) FROM t3;
416
SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
420
CREATE TABLE t1(c1 BINARY(10) NOT NULL PRIMARY KEY);
421
CREATE TABLE t2(c1 BINARY(10) NOT NULL PRIMARY KEY);
422
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
423
CREATE TABLE t3(c1 BINARY(10) NOT NULL PRIMARY KEY);
424
INSERT INTO t3 (c1) VALUES('a');
425
SELECT COUNT(c1) FROM t3;
428
SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
431
REPLACE t3 SET c1='a';
432
SELECT COUNT(c1) FROM t3;
435
SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
439
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
440
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
441
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
442
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
443
INSERT INTO t3 (c1) VALUES('a');
444
SELECT COUNT(c1) FROM t3;
447
SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
450
REPLACE t3 SET c1='a';
451
SELECT COUNT(c1) FROM t3;
454
SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
458
CREATE TABLE t1(c1 CHAR(10) NOT NULL PRIMARY KEY);
459
CREATE TABLE t2(c1 CHAR(10) NOT NULL PRIMARY KEY);
460
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
461
CREATE TABLE t3(c1 CHAR(10) NOT NULL PRIMARY KEY);
462
INSERT INTO t3 (c1) VALUES('a');
463
SELECT COUNT(c1) FROM t1;
466
SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
469
REPLACE t1 SET c1='a';
470
SELECT COUNT(c1) FROM t1;
473
SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
477
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
478
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
479
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
480
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
481
INSERT INTO t3 (c1) VALUES('a');
482
SELECT COUNT(c1) FROM t1;
485
SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
488
REPLACE t1 SET c1='a';
489
SELECT COUNT(c1) FROM t1;
492
SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
496
CREATE TABLE t1(c1 BINARY(10) NOT NULL PRIMARY KEY);
497
CREATE TABLE t2(c1 BINARY(10) NOT NULL PRIMARY KEY);
498
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
499
CREATE TABLE t3(c1 BINARY(10) NOT NULL PRIMARY KEY);
500
INSERT INTO t3 (c1) VALUES('a');
501
SELECT COUNT(c1) FROM t1;
504
SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
507
REPLACE t1 SET c1='a';
508
SELECT COUNT(c1) FROM t1;
511
SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
515
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
516
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
517
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
518
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
519
INSERT INTO t3 (c1) VALUES('a');
520
SELECT COUNT(c1) FROM t1;
523
SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
526
REPLACE t1 SET c1='a';
527
SELECT COUNT(c1) FROM t1;
530
SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
534
CREATE TABLE t1(c1 CHAR(10) NOT NULL PRIMARY KEY);
535
CREATE TABLE t2(c1 CHAR(10) NOT NULL PRIMARY KEY);
536
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
537
CREATE TABLE t3(c1 CHAR(10) NOT NULL PRIMARY KEY);
538
INSERT INTO t3 (c1) VALUES('a');
539
SELECT COUNT(c1) FROM t2;
542
SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
545
REPLACE t2 SET c1='a';
546
SELECT COUNT(c1) FROM t2;
549
SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
553
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
554
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
555
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
556
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
557
INSERT INTO t3 (c1) VALUES('a');
558
SELECT COUNT(c1) FROM t2;
561
SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
564
REPLACE t2 SET c1='a';
565
SELECT COUNT(c1) FROM t2;
568
SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
572
CREATE TABLE t1(c1 BINARY(10) NOT NULL PRIMARY KEY);
573
CREATE TABLE t2(c1 BINARY(10) NOT NULL PRIMARY KEY);
574
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
575
CREATE TABLE t3(c1 BINARY(10) NOT NULL PRIMARY KEY);
576
INSERT INTO t3 (c1) VALUES('a');
577
SELECT COUNT(c1) FROM t2;
580
SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
583
REPLACE t2 SET c1='a';
584
SELECT COUNT(c1) FROM t2;
587
SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
591
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
592
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
593
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
594
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
595
INSERT INTO t3 (c1) VALUES('a');
596
SELECT COUNT(c1) FROM t2;
599
SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
602
REPLACE t2 SET c1='a';
603
SELECT COUNT(c1) FROM t2;
606
SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
610
CREATE TABLE t1(c1 CHAR(10) NOT NULL PRIMARY KEY);
611
CREATE TABLE t2(c1 CHAR(10) NOT NULL PRIMARY KEY);
612
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
613
CREATE TABLE t3(c1 CHAR(10) NOT NULL PRIMARY KEY);
614
INSERT INTO t3 (c1) VALUES('a');
615
SELECT COUNT(c1) FROM t3;
618
SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
621
REPLACE t3 SET c1='a';
622
SELECT COUNT(c1) FROM t3;
625
SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
629
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
630
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
631
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
632
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
633
INSERT INTO t3 (c1) VALUES('a');
634
SELECT COUNT(c1) FROM t3;
637
SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
640
REPLACE t3 SET c1='a';
641
SELECT COUNT(c1) FROM t3;
644
SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
648
CREATE TABLE t1(c1 BINARY(10) NOT NULL PRIMARY KEY);
649
CREATE TABLE t2(c1 BINARY(10) NOT NULL PRIMARY KEY);
650
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
651
CREATE TABLE t3(c1 BINARY(10) NOT NULL PRIMARY KEY);
652
INSERT INTO t3 (c1) VALUES('a');
653
SELECT COUNT(c1) FROM t3;
656
SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
659
REPLACE t3 SET c1='a';
660
SELECT COUNT(c1) FROM t3;
663
SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
667
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
668
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
669
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
670
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
671
INSERT INTO t3 (c1) VALUES('a');
672
SELECT COUNT(c1) FROM t3;
675
SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
678
REPLACE t3 SET c1='a';
679
SELECT COUNT(c1) FROM t3;
682
SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
686
CREATE TABLE t1(c1 CHAR(10) NOT NULL PRIMARY KEY);
687
CREATE TABLE t2(c1 CHAR(10) NOT NULL PRIMARY KEY);
688
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
689
CREATE TABLE t3(c1 CHAR(10) NOT NULL PRIMARY KEY);
690
INSERT INTO t3 (c1) VALUES('a');
691
SELECT COUNT(c1) FROM t1;
694
SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
697
REPLACE t1 SET c1='a';
698
SELECT COUNT(c1) FROM t1;
701
SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
705
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
706
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
707
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
708
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
709
INSERT INTO t3 (c1) VALUES('a');
710
SELECT COUNT(c1) FROM t1;
713
SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
716
REPLACE t1 SET c1='a';
717
SELECT COUNT(c1) FROM t1;
720
SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
724
CREATE TABLE t1(c1 BINARY(10) NOT NULL PRIMARY KEY);
725
CREATE TABLE t2(c1 BINARY(10) NOT NULL PRIMARY KEY);
726
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
727
CREATE TABLE t3(c1 BINARY(10) NOT NULL PRIMARY KEY);
728
INSERT INTO t3 (c1) VALUES('a');
729
SELECT COUNT(c1) FROM t1;
732
SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
735
REPLACE t1 SET c1='a';
736
SELECT COUNT(c1) FROM t1;
739
SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
743
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
744
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
745
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
746
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
747
INSERT INTO t3 (c1) VALUES('a');
748
SELECT COUNT(c1) FROM t1;
751
SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
754
REPLACE t1 SET c1='a';
755
SELECT COUNT(c1) FROM t1;
758
SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
762
CREATE TABLE t1(c1 CHAR(10) NOT NULL PRIMARY KEY);
763
CREATE TABLE t2(c1 CHAR(10) NOT NULL PRIMARY KEY);
764
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
765
CREATE TABLE t3(c1 CHAR(10) NOT NULL PRIMARY KEY);
766
INSERT INTO t3 (c1) VALUES('a');
767
SELECT COUNT(c1) FROM t2;
770
SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
773
REPLACE t2 SET c1='a';
774
SELECT COUNT(c1) FROM t2;
777
SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
781
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
782
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
783
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
784
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
785
INSERT INTO t3 (c1) VALUES('a');
786
SELECT COUNT(c1) FROM t2;
789
SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
792
REPLACE t2 SET c1='a';
793
SELECT COUNT(c1) FROM t2;
796
SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
800
CREATE TABLE t1(c1 BINARY(10) NOT NULL PRIMARY KEY);
801
CREATE TABLE t2(c1 BINARY(10) NOT NULL PRIMARY KEY);
802
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
803
CREATE TABLE t3(c1 BINARY(10) NOT NULL PRIMARY KEY);
804
INSERT INTO t3 (c1) VALUES('a');
805
SELECT COUNT(c1) FROM t2;
808
SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
811
REPLACE t2 SET c1='a';
812
SELECT COUNT(c1) FROM t2;
815
SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
819
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
820
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
821
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
822
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
823
INSERT INTO t3 (c1) VALUES('a');
824
SELECT COUNT(c1) FROM t2;
827
SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
830
REPLACE t2 SET c1='a';
831
SELECT COUNT(c1) FROM t2;
834
SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
838
CREATE TABLE t1(c1 CHAR(10) NOT NULL PRIMARY KEY);
839
CREATE TABLE t2(c1 CHAR(10) NOT NULL PRIMARY KEY);
840
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
841
CREATE TABLE t3(c1 CHAR(10) NOT NULL PRIMARY KEY);
842
INSERT INTO t3 (c1) VALUES('a');
843
SELECT COUNT(c1) FROM t3;
846
SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
849
REPLACE t3 SET c1='a';
850
SELECT COUNT(c1) FROM t3;
853
SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
857
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
858
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
859
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
860
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
861
INSERT INTO t3 (c1) VALUES('a');
862
SELECT COUNT(c1) FROM t3;
865
SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
868
REPLACE t3 SET c1='a';
869
SELECT COUNT(c1) FROM t3;
872
SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
876
CREATE TABLE t1(c1 BINARY(10) NOT NULL PRIMARY KEY);
877
CREATE TABLE t2(c1 BINARY(10) NOT NULL PRIMARY KEY);
878
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
879
CREATE TABLE t3(c1 BINARY(10) NOT NULL PRIMARY KEY);
880
INSERT INTO t3 (c1) VALUES('a');
881
SELECT COUNT(c1) FROM t3;
884
SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
887
REPLACE t3 SET c1='a';
888
SELECT COUNT(c1) FROM t3;
891
SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
895
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
896
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
897
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
898
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
899
INSERT INTO t3 (c1) VALUES('a');
900
SELECT COUNT(c1) FROM t3;
903
SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
906
REPLACE t3 SET c1='a';
907
SELECT COUNT(c1) FROM t3;
910
SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';