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';