1 DROP TABLE IF EXISTS t1,t2,t3;
2 CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY);
3 CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY);
4 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5 CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY);
6 INSERT INTO t3 (c1) VALUES(5);
7 SELECT COUNT(c1),SUM(c1) FROM t1;
10 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5;
13 REPLACE t1 VALUES (5);
14 SELECT COUNT(c1),SUM(c1) FROM t1;
17 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5;
21 CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY);
22 CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY);
23 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
24 CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY);
25 INSERT INTO t3 (c1) VALUES(5);
26 SELECT COUNT(c1),SUM(c1) FROM t1;
29 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5;
32 REPLACE t1 VALUES (5);
33 SELECT COUNT(c1),SUM(c1) FROM t1;
36 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5;
40 CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY);
41 CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY);
42 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
43 CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY);
44 INSERT INTO t3 (c1) VALUES(5);
45 SELECT COUNT(c1),SUM(c1) FROM t1;
48 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5;
51 REPLACE t1 VALUES (5);
52 SELECT COUNT(c1),SUM(c1) FROM t1;
55 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5;
59 CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY);
60 CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY);
61 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
62 CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY);
63 INSERT INTO t3 (c1) VALUES(5);
64 SELECT COUNT(c1),SUM(c1) FROM t1;
67 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5;
70 REPLACE t1 VALUES (5);
71 SELECT COUNT(c1),SUM(c1) FROM t1;
74 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5;
78 CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY);
79 CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY);
80 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
81 CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY);
82 INSERT INTO t3 (c1) VALUES(5);
83 SELECT COUNT(c1),SUM(c1) FROM t1;
86 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5;
89 REPLACE t1 VALUES (5);
90 SELECT COUNT(c1),SUM(c1) FROM t1;
93 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5;
97 CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY);
98 CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY);
99 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
100 CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY);
101 INSERT INTO t3 (c1) VALUES(5);
102 SELECT COUNT(c1),SUM(c1) FROM t1;
105 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5;
108 REPLACE t1 VALUES (5);
109 SELECT COUNT(c1),SUM(c1) FROM t1;
112 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5;
116 CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY);
117 CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY);
118 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
119 CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY);
120 INSERT INTO t3 (c1) VALUES(5);
121 SELECT COUNT(c1),SUM(c1) FROM t2;
124 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5;
127 REPLACE t2 VALUES (5);
128 SELECT COUNT(c1),SUM(c1) FROM t2;
131 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5;
135 CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY);
136 CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY);
137 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
138 CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY);
139 INSERT INTO t3 (c1) VALUES(5);
140 SELECT COUNT(c1),SUM(c1) FROM t2;
143 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5;
146 REPLACE t2 VALUES (5);
147 SELECT COUNT(c1),SUM(c1) FROM t2;
150 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5;
154 CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY);
155 CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY);
156 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
157 CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY);
158 INSERT INTO t3 (c1) VALUES(5);
159 SELECT COUNT(c1),SUM(c1) FROM t2;
162 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5;
165 REPLACE t2 VALUES (5);
166 SELECT COUNT(c1),SUM(c1) FROM t2;
169 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5;
173 CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY);
174 CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY);
175 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
176 CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY);
177 INSERT INTO t3 (c1) VALUES(5);
178 SELECT COUNT(c1),SUM(c1) FROM t2;
181 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5;
184 REPLACE t2 VALUES (5);
185 SELECT COUNT(c1),SUM(c1) FROM t2;
188 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5;
192 CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY);
193 CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY);
194 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
195 CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY);
196 INSERT INTO t3 (c1) VALUES(5);
197 SELECT COUNT(c1),SUM(c1) FROM t2;
200 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5;
203 REPLACE t2 VALUES (5);
204 SELECT COUNT(c1),SUM(c1) FROM t2;
207 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5;
211 CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY);
212 CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY);
213 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
214 CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY);
215 INSERT INTO t3 (c1) VALUES(5);
216 SELECT COUNT(c1),SUM(c1) FROM t2;
219 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5;
222 REPLACE t2 VALUES (5);
223 SELECT COUNT(c1),SUM(c1) FROM t2;
226 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5;
230 CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY);
231 CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY);
232 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
233 CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY);
234 INSERT INTO t3 (c1) VALUES(5);
235 SELECT COUNT(c1),SUM(c1) FROM t3;
238 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5;
241 REPLACE t3 VALUES (5);
242 SELECT COUNT(c1),SUM(c1) FROM t3;
245 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5;
249 CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY);
250 CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY);
251 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
252 CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY);
253 INSERT INTO t3 (c1) VALUES(5);
254 SELECT COUNT(c1),SUM(c1) FROM t3;
257 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5;
260 REPLACE t3 VALUES (5);
261 SELECT COUNT(c1),SUM(c1) FROM t3;
264 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5;
268 CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY);
269 CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY);
270 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
271 CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY);
272 INSERT INTO t3 (c1) VALUES(5);
273 SELECT COUNT(c1),SUM(c1) FROM t3;
276 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5;
279 REPLACE t3 VALUES (5);
280 SELECT COUNT(c1),SUM(c1) FROM t3;
283 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5;
287 CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY);
288 CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY);
289 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
290 CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY);
291 INSERT INTO t3 (c1) VALUES(5);
292 SELECT COUNT(c1),SUM(c1) FROM t3;
295 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5;
298 REPLACE t3 VALUES (5);
299 SELECT COUNT(c1),SUM(c1) FROM t3;
302 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5;
306 CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY);
307 CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY);
308 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
309 CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY);
310 INSERT INTO t3 (c1) VALUES(5);
311 SELECT COUNT(c1),SUM(c1) FROM t3;
314 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5;
317 REPLACE t3 VALUES (5);
318 SELECT COUNT(c1),SUM(c1) FROM t3;
321 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5;
325 CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY);
326 CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY);
327 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
328 CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY);
329 INSERT INTO t3 (c1) VALUES(5);
330 SELECT COUNT(c1),SUM(c1) FROM t3;
333 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5;
336 REPLACE t3 VALUES (5);
337 SELECT COUNT(c1),SUM(c1) FROM t3;
340 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5;
344 CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY);
345 CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY);
346 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
347 CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY);
348 INSERT INTO t3 (c1) VALUES(5);
349 SELECT COUNT(c1),SUM(c1) FROM t1;
352 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5;
355 REPLACE t1 VALUES (5);
356 SELECT COUNT(c1),SUM(c1) FROM t1;
359 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5;
363 CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY);
364 CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY);
365 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
366 CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY);
367 INSERT INTO t3 (c1) VALUES(5);
368 SELECT COUNT(c1),SUM(c1) FROM t1;
371 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5;
374 REPLACE t1 VALUES (5);
375 SELECT COUNT(c1),SUM(c1) FROM t1;
378 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5;
382 CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY);
383 CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY);
384 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
385 CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY);
386 INSERT INTO t3 (c1) VALUES(5);
387 SELECT COUNT(c1),SUM(c1) FROM t1;
390 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5;
393 REPLACE t1 VALUES (5);
394 SELECT COUNT(c1),SUM(c1) FROM t1;
397 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5;
401 CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY);
402 CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY);
403 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
404 CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY);
405 INSERT INTO t3 (c1) VALUES(5);
406 SELECT COUNT(c1),SUM(c1) FROM t1;
409 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5;
412 REPLACE t1 VALUES (5);
413 SELECT COUNT(c1),SUM(c1) FROM t1;
416 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5;
420 CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY);
421 CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY);
422 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
423 CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY);
424 INSERT INTO t3 (c1) VALUES(5);
425 SELECT COUNT(c1),SUM(c1) FROM t1;
428 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5;
431 REPLACE t1 VALUES (5);
432 SELECT COUNT(c1),SUM(c1) FROM t1;
435 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5;
439 CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY);
440 CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY);
441 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
442 CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY);
443 INSERT INTO t3 (c1) VALUES(5);
444 SELECT COUNT(c1),SUM(c1) FROM t1;
447 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5;
450 REPLACE t1 VALUES (5);
451 SELECT COUNT(c1),SUM(c1) FROM t1;
454 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5;
458 CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY);
459 CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY);
460 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
461 CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY);
462 INSERT INTO t3 (c1) VALUES(5);
463 SELECT COUNT(c1),SUM(c1) FROM t2;
466 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5;
469 REPLACE t2 VALUES (5);
470 SELECT COUNT(c1),SUM(c1) FROM t2;
473 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5;
477 CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY);
478 CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY);
479 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
480 CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY);
481 INSERT INTO t3 (c1) VALUES(5);
482 SELECT COUNT(c1),SUM(c1) FROM t2;
485 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5;
488 REPLACE t2 VALUES (5);
489 SELECT COUNT(c1),SUM(c1) FROM t2;
492 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5;
496 CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY);
497 CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY);
498 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
499 CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY);
500 INSERT INTO t3 (c1) VALUES(5);
501 SELECT COUNT(c1),SUM(c1) FROM t2;
504 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5;
507 REPLACE t2 VALUES (5);
508 SELECT COUNT(c1),SUM(c1) FROM t2;
511 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5;
515 CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY);
516 CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY);
517 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
518 CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY);
519 INSERT INTO t3 (c1) VALUES(5);
520 SELECT COUNT(c1),SUM(c1) FROM t2;
523 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5;
526 REPLACE t2 VALUES (5);
527 SELECT COUNT(c1),SUM(c1) FROM t2;
530 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5;
534 CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY);
535 CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY);
536 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
537 CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY);
538 INSERT INTO t3 (c1) VALUES(5);
539 SELECT COUNT(c1),SUM(c1) FROM t2;
542 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5;
545 REPLACE t2 VALUES (5);
546 SELECT COUNT(c1),SUM(c1) FROM t2;
549 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5;
553 CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY);
554 CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY);
555 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
556 CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY);
557 INSERT INTO t3 (c1) VALUES(5);
558 SELECT COUNT(c1),SUM(c1) FROM t2;
561 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5;
564 REPLACE t2 VALUES (5);
565 SELECT COUNT(c1),SUM(c1) FROM t2;
568 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5;
572 CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY);
573 CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY);
574 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
575 CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY);
576 INSERT INTO t3 (c1) VALUES(5);
577 SELECT COUNT(c1),SUM(c1) FROM t3;
580 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5;
583 REPLACE t3 VALUES (5);
584 SELECT COUNT(c1),SUM(c1) FROM t3;
587 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5;
591 CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY);
592 CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY);
593 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
594 CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY);
595 INSERT INTO t3 (c1) VALUES(5);
596 SELECT COUNT(c1),SUM(c1) FROM t3;
599 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5;
602 REPLACE t3 VALUES (5);
603 SELECT COUNT(c1),SUM(c1) FROM t3;
606 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5;
610 CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY);
611 CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY);
612 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
613 CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY);
614 INSERT INTO t3 (c1) VALUES(5);
615 SELECT COUNT(c1),SUM(c1) FROM t3;
618 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5;
621 REPLACE t3 VALUES (5);
622 SELECT COUNT(c1),SUM(c1) FROM t3;
625 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5;
629 CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY);
630 CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY);
631 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
632 CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY);
633 INSERT INTO t3 (c1) VALUES(5);
634 SELECT COUNT(c1),SUM(c1) FROM t3;
637 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5;
640 REPLACE t3 VALUES (5);
641 SELECT COUNT(c1),SUM(c1) FROM t3;
644 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5;
648 CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY);
649 CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY);
650 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
651 CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY);
652 INSERT INTO t3 (c1) VALUES(5);
653 SELECT COUNT(c1),SUM(c1) FROM t3;
656 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5;
659 REPLACE t3 VALUES (5);
660 SELECT COUNT(c1),SUM(c1) FROM t3;
663 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5;
667 CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY);
668 CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY);
669 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
670 CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY);
671 INSERT INTO t3 (c1) VALUES(5);
672 SELECT COUNT(c1),SUM(c1) FROM t3;
675 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5;
678 REPLACE t3 VALUES (5);
679 SELECT COUNT(c1),SUM(c1) FROM t3;
682 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5;
686 CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY);
687 CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY);
688 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
689 CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY);
690 INSERT INTO t3 (c1) VALUES(5);
691 SELECT COUNT(c1),SUM(c1) FROM t1;
694 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5;
697 REPLACE t1 VALUES (5);
698 SELECT COUNT(c1),SUM(c1) FROM t1;
701 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5;
705 CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY);
706 CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY);
707 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
708 CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY);
709 INSERT INTO t3 (c1) VALUES(5);
710 SELECT COUNT(c1),SUM(c1) FROM t1;
713 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5;
716 REPLACE t1 VALUES (5);
717 SELECT COUNT(c1),SUM(c1) FROM t1;
720 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5;
724 CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY);
725 CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY);
726 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
727 CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY);
728 INSERT INTO t3 (c1) VALUES(5);
729 SELECT COUNT(c1),SUM(c1) FROM t1;
732 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5;
735 REPLACE t1 VALUES (5);
736 SELECT COUNT(c1),SUM(c1) FROM t1;
739 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5;
743 CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY);
744 CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY);
745 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
746 CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY);
747 INSERT INTO t3 (c1) VALUES(5);
748 SELECT COUNT(c1),SUM(c1) FROM t1;
751 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5;
754 REPLACE t1 VALUES (5);
755 SELECT COUNT(c1),SUM(c1) FROM t1;
758 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5;
762 CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY);
763 CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY);
764 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
765 CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY);
766 INSERT INTO t3 (c1) VALUES(5);
767 SELECT COUNT(c1),SUM(c1) FROM t1;
770 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5;
773 REPLACE t1 VALUES (5);
774 SELECT COUNT(c1),SUM(c1) FROM t1;
777 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5;
781 CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY);
782 CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY);
783 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
784 CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY);
785 INSERT INTO t3 (c1) VALUES(5);
786 SELECT COUNT(c1),SUM(c1) FROM t1;
789 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5;
792 REPLACE t1 VALUES (5);
793 SELECT COUNT(c1),SUM(c1) FROM t1;
796 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5;
800 CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY);
801 CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY);
802 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
803 CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY);
804 INSERT INTO t3 (c1) VALUES(5);
805 SELECT COUNT(c1),SUM(c1) FROM t2;
808 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5;
811 REPLACE t2 VALUES (5);
812 SELECT COUNT(c1),SUM(c1) FROM t2;
815 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5;
819 CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY);
820 CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY);
821 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
822 CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY);
823 INSERT INTO t3 (c1) VALUES(5);
824 SELECT COUNT(c1),SUM(c1) FROM t2;
827 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5;
830 REPLACE t2 VALUES (5);
831 SELECT COUNT(c1),SUM(c1) FROM t2;
834 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5;
838 CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY);
839 CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY);
840 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
841 CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY);
842 INSERT INTO t3 (c1) VALUES(5);
843 SELECT COUNT(c1),SUM(c1) FROM t2;
846 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5;
849 REPLACE t2 VALUES (5);
850 SELECT COUNT(c1),SUM(c1) FROM t2;
853 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5;
857 CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY);
858 CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY);
859 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
860 CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY);
861 INSERT INTO t3 (c1) VALUES(5);
862 SELECT COUNT(c1),SUM(c1) FROM t2;
865 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5;
868 REPLACE t2 VALUES (5);
869 SELECT COUNT(c1),SUM(c1) FROM t2;
872 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5;
876 CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY);
877 CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY);
878 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
879 CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY);
880 INSERT INTO t3 (c1) VALUES(5);
881 SELECT COUNT(c1),SUM(c1) FROM t2;
884 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5;
887 REPLACE t2 VALUES (5);
888 SELECT COUNT(c1),SUM(c1) FROM t2;
891 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5;
895 CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY);
896 CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY);
897 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
898 CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY);
899 INSERT INTO t3 (c1) VALUES(5);
900 SELECT COUNT(c1),SUM(c1) FROM t2;
903 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5;
906 REPLACE t2 VALUES (5);
907 SELECT COUNT(c1),SUM(c1) FROM t2;
910 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5;
914 CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY);
915 CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY);
916 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
917 CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY);
918 INSERT INTO t3 (c1) VALUES(5);
919 SELECT COUNT(c1),SUM(c1) FROM t3;
922 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5;
925 REPLACE t3 VALUES (5);
926 SELECT COUNT(c1),SUM(c1) FROM t3;
929 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5;
933 CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY);
934 CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY);
935 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
936 CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY);
937 INSERT INTO t3 (c1) VALUES(5);
938 SELECT COUNT(c1),SUM(c1) FROM t3;
941 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5;
944 REPLACE t3 VALUES (5);
945 SELECT COUNT(c1),SUM(c1) FROM t3;
948 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5;
952 CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY);
953 CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY);
954 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
955 CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY);
956 INSERT INTO t3 (c1) VALUES(5);
957 SELECT COUNT(c1),SUM(c1) FROM t3;
960 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5;
963 REPLACE t3 VALUES (5);
964 SELECT COUNT(c1),SUM(c1) FROM t3;
967 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5;
971 CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY);
972 CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY);
973 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
974 CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY);
975 INSERT INTO t3 (c1) VALUES(5);
976 SELECT COUNT(c1),SUM(c1) FROM t3;
979 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5;
982 REPLACE t3 VALUES (5);
983 SELECT COUNT(c1),SUM(c1) FROM t3;
986 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5;
990 CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY);
991 CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY);
992 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
993 CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY);
994 INSERT INTO t3 (c1) VALUES(5);
995 SELECT COUNT(c1),SUM(c1) FROM t3;
998 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5;
1001 REPLACE t3 VALUES (5);
1002 SELECT COUNT(c1),SUM(c1) FROM t3;
1005 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5;
1008 DROP TABLE t1,t2,t3;
1009 CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY);
1010 CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY);
1011 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1012 CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY);
1013 INSERT INTO t3 (c1) VALUES(5);
1014 SELECT COUNT(c1),SUM(c1) FROM t3;
1017 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5;
1020 REPLACE t3 VALUES (5);
1021 SELECT COUNT(c1),SUM(c1) FROM t3;
1024 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5;
1027 DROP TABLE t1,t2,t3;
1028 CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY);
1029 CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY);
1030 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1031 CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY);
1032 INSERT INTO t3 (c1) VALUES(5);
1033 SELECT COUNT(c1),SUM(c1) FROM t1;
1036 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5;
1039 REPLACE t1 VALUES (5);
1040 SELECT COUNT(c1),SUM(c1) FROM t1;
1043 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5;
1046 DROP TABLE t1,t2,t3;
1047 CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY);
1048 CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY);
1049 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1050 CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY);
1051 INSERT INTO t3 (c1) VALUES(5);
1052 SELECT COUNT(c1),SUM(c1) FROM t1;
1055 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5;
1058 REPLACE t1 VALUES (5);
1059 SELECT COUNT(c1),SUM(c1) FROM t1;
1062 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5;
1065 DROP TABLE t1,t2,t3;
1066 CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY);
1067 CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY);
1068 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1069 CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY);
1070 INSERT INTO t3 (c1) VALUES(5);
1071 SELECT COUNT(c1),SUM(c1) FROM t1;
1074 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5;
1077 REPLACE t1 VALUES (5);
1078 SELECT COUNT(c1),SUM(c1) FROM t1;
1081 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5;
1084 DROP TABLE t1,t2,t3;
1085 CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY);
1086 CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY);
1087 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1088 CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY);
1089 INSERT INTO t3 (c1) VALUES(5);
1090 SELECT COUNT(c1),SUM(c1) FROM t1;
1093 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5;
1096 REPLACE t1 VALUES (5);
1097 SELECT COUNT(c1),SUM(c1) FROM t1;
1100 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5;
1103 DROP TABLE t1,t2,t3;
1104 CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY);
1105 CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY);
1106 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1107 CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY);
1108 INSERT INTO t3 (c1) VALUES(5);
1109 SELECT COUNT(c1),SUM(c1) FROM t1;
1112 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5;
1115 REPLACE t1 VALUES (5);
1116 SELECT COUNT(c1),SUM(c1) FROM t1;
1119 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5;
1122 DROP TABLE t1,t2,t3;
1123 CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY);
1124 CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY);
1125 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1126 CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY);
1127 INSERT INTO t3 (c1) VALUES(5);
1128 SELECT COUNT(c1),SUM(c1) FROM t1;
1131 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5;
1134 REPLACE t1 VALUES (5);
1135 SELECT COUNT(c1),SUM(c1) FROM t1;
1138 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5;
1141 DROP TABLE t1,t2,t3;
1142 CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY);
1143 CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY);
1144 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1145 CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY);
1146 INSERT INTO t3 (c1) VALUES(5);
1147 SELECT COUNT(c1),SUM(c1) FROM t2;
1150 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5;
1153 REPLACE t2 VALUES (5);
1154 SELECT COUNT(c1),SUM(c1) FROM t2;
1157 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5;
1160 DROP TABLE t1,t2,t3;
1161 CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY);
1162 CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY);
1163 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1164 CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY);
1165 INSERT INTO t3 (c1) VALUES(5);
1166 SELECT COUNT(c1),SUM(c1) FROM t2;
1169 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5;
1172 REPLACE t2 VALUES (5);
1173 SELECT COUNT(c1),SUM(c1) FROM t2;
1176 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5;
1179 DROP TABLE t1,t2,t3;
1180 CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY);
1181 CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY);
1182 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1183 CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY);
1184 INSERT INTO t3 (c1) VALUES(5);
1185 SELECT COUNT(c1),SUM(c1) FROM t2;
1188 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5;
1191 REPLACE t2 VALUES (5);
1192 SELECT COUNT(c1),SUM(c1) FROM t2;
1195 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5;
1198 DROP TABLE t1,t2,t3;
1199 CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY);
1200 CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY);
1201 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1202 CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY);
1203 INSERT INTO t3 (c1) VALUES(5);
1204 SELECT COUNT(c1),SUM(c1) FROM t2;
1207 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5;
1210 REPLACE t2 VALUES (5);
1211 SELECT COUNT(c1),SUM(c1) FROM t2;
1214 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5;
1217 DROP TABLE t1,t2,t3;
1218 CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY);
1219 CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY);
1220 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1221 CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY);
1222 INSERT INTO t3 (c1) VALUES(5);
1223 SELECT COUNT(c1),SUM(c1) FROM t2;
1226 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5;
1229 REPLACE t2 VALUES (5);
1230 SELECT COUNT(c1),SUM(c1) FROM t2;
1233 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5;
1236 DROP TABLE t1,t2,t3;
1237 CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY);
1238 CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY);
1239 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1240 CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY);
1241 INSERT INTO t3 (c1) VALUES(5);
1242 SELECT COUNT(c1),SUM(c1) FROM t2;
1245 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5;
1248 REPLACE t2 VALUES (5);
1249 SELECT COUNT(c1),SUM(c1) FROM t2;
1252 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5;
1255 DROP TABLE t1,t2,t3;
1256 CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY);
1257 CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY);
1258 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1259 CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY);
1260 INSERT INTO t3 (c1) VALUES(5);
1261 SELECT COUNT(c1),SUM(c1) FROM t3;
1264 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5;
1267 REPLACE t3 VALUES (5);
1268 SELECT COUNT(c1),SUM(c1) FROM t3;
1271 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5;
1274 DROP TABLE t1,t2,t3;
1275 CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY);
1276 CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY);
1277 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1278 CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY);
1279 INSERT INTO t3 (c1) VALUES(5);
1280 SELECT COUNT(c1),SUM(c1) FROM t3;
1283 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5;
1286 REPLACE t3 VALUES (5);
1287 SELECT COUNT(c1),SUM(c1) FROM t3;
1290 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5;
1293 DROP TABLE t1,t2,t3;
1294 CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY);
1295 CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY);
1296 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1297 CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY);
1298 INSERT INTO t3 (c1) VALUES(5);
1299 SELECT COUNT(c1),SUM(c1) FROM t3;
1302 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5;
1305 REPLACE t3 VALUES (5);
1306 SELECT COUNT(c1),SUM(c1) FROM t3;
1309 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5;
1312 DROP TABLE t1,t2,t3;
1313 CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY);
1314 CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY);
1315 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1316 CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY);
1317 INSERT INTO t3 (c1) VALUES(5);
1318 SELECT COUNT(c1),SUM(c1) FROM t3;
1321 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5;
1324 REPLACE t3 VALUES (5);
1325 SELECT COUNT(c1),SUM(c1) FROM t3;
1328 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5;
1331 DROP TABLE t1,t2,t3;
1332 CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY);
1333 CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY);
1334 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1335 CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY);
1336 INSERT INTO t3 (c1) VALUES(5);
1337 SELECT COUNT(c1),SUM(c1) FROM t3;
1340 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5;
1343 REPLACE t3 VALUES (5);
1344 SELECT COUNT(c1),SUM(c1) FROM t3;
1347 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5;
1350 DROP TABLE t1,t2,t3;
1351 CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY);
1352 CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY);
1353 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1354 CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY);
1355 INSERT INTO t3 (c1) VALUES(5);
1356 SELECT COUNT(c1),SUM(c1) FROM t3;
1359 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5;
1362 REPLACE t3 VALUES (5);
1363 SELECT COUNT(c1),SUM(c1) FROM t3;
1366 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5;
1369 DROP TABLE t1,t2,t3;
1370 CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY);
1371 CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY);
1372 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1373 CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY);
1374 INSERT INTO t3 (c1) VALUES(5);
1375 SELECT COUNT(c1),SUM(c1) FROM t1;
1378 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5;
1381 REPLACE t1 VALUES (5);
1382 SELECT COUNT(c1),SUM(c1) FROM t1;
1385 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5;
1388 DROP TABLE t1,t2,t3;
1389 CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY);
1390 CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY);
1391 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1392 CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY);
1393 INSERT INTO t3 (c1) VALUES(5);
1394 SELECT COUNT(c1),SUM(c1) FROM t1;
1397 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5;
1400 REPLACE t1 VALUES (5);
1401 SELECT COUNT(c1),SUM(c1) FROM t1;
1404 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5;
1407 DROP TABLE t1,t2,t3;
1408 CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY);
1409 CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY);
1410 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1411 CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY);
1412 INSERT INTO t3 (c1) VALUES(5);
1413 SELECT COUNT(c1),SUM(c1) FROM t1;
1416 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5;
1419 REPLACE t1 VALUES (5);
1420 SELECT COUNT(c1),SUM(c1) FROM t1;
1423 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5;
1426 DROP TABLE t1,t2,t3;
1427 CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY);
1428 CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY);
1429 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1430 CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY);
1431 INSERT INTO t3 (c1) VALUES(5);
1432 SELECT COUNT(c1),SUM(c1) FROM t1;
1435 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5;
1438 REPLACE t1 VALUES (5);
1439 SELECT COUNT(c1),SUM(c1) FROM t1;
1442 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5;
1445 DROP TABLE t1,t2,t3;
1446 CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY);
1447 CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY);
1448 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1449 CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY);
1450 INSERT INTO t3 (c1) VALUES(5);
1451 SELECT COUNT(c1),SUM(c1) FROM t1;
1454 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5;
1457 REPLACE t1 VALUES (5);
1458 SELECT COUNT(c1),SUM(c1) FROM t1;
1461 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5;
1464 DROP TABLE t1,t2,t3;
1465 CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY);
1466 CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY);
1467 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1468 CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY);
1469 INSERT INTO t3 (c1) VALUES(5);
1470 SELECT COUNT(c1),SUM(c1) FROM t1;
1473 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5;
1476 REPLACE t1 VALUES (5);
1477 SELECT COUNT(c1),SUM(c1) FROM t1;
1480 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5;
1483 DROP TABLE t1,t2,t3;
1484 CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY);
1485 CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY);
1486 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1487 CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY);
1488 INSERT INTO t3 (c1) VALUES(5);
1489 SELECT COUNT(c1),SUM(c1) FROM t2;
1492 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5;
1495 REPLACE t2 VALUES (5);
1496 SELECT COUNT(c1),SUM(c1) FROM t2;
1499 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5;
1502 DROP TABLE t1,t2,t3;
1503 CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY);
1504 CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY);
1505 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1506 CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY);
1507 INSERT INTO t3 (c1) VALUES(5);
1508 SELECT COUNT(c1),SUM(c1) FROM t2;
1511 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5;
1514 REPLACE t2 VALUES (5);
1515 SELECT COUNT(c1),SUM(c1) FROM t2;
1518 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5;
1521 DROP TABLE t1,t2,t3;
1522 CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY);
1523 CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY);
1524 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1525 CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY);
1526 INSERT INTO t3 (c1) VALUES(5);
1527 SELECT COUNT(c1),SUM(c1) FROM t2;
1530 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5;
1533 REPLACE t2 VALUES (5);
1534 SELECT COUNT(c1),SUM(c1) FROM t2;
1537 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5;
1540 DROP TABLE t1,t2,t3;
1541 CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY);
1542 CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY);
1543 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1544 CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY);
1545 INSERT INTO t3 (c1) VALUES(5);
1546 SELECT COUNT(c1),SUM(c1) FROM t2;
1549 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5;
1552 REPLACE t2 VALUES (5);
1553 SELECT COUNT(c1),SUM(c1) FROM t2;
1556 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5;
1559 DROP TABLE t1,t2,t3;
1560 CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY);
1561 CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY);
1562 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1563 CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY);
1564 INSERT INTO t3 (c1) VALUES(5);
1565 SELECT COUNT(c1),SUM(c1) FROM t2;
1568 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5;
1571 REPLACE t2 VALUES (5);
1572 SELECT COUNT(c1),SUM(c1) FROM t2;
1575 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5;
1578 DROP TABLE t1,t2,t3;
1579 CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY);
1580 CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY);
1581 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1582 CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY);
1583 INSERT INTO t3 (c1) VALUES(5);
1584 SELECT COUNT(c1),SUM(c1) FROM t2;
1587 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5;
1590 REPLACE t2 VALUES (5);
1591 SELECT COUNT(c1),SUM(c1) FROM t2;
1594 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5;
1597 DROP TABLE t1,t2,t3;
1598 CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY);
1599 CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY);
1600 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1601 CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY);
1602 INSERT INTO t3 (c1) VALUES(5);
1603 SELECT COUNT(c1),SUM(c1) FROM t3;
1606 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5;
1609 REPLACE t3 VALUES (5);
1610 SELECT COUNT(c1),SUM(c1) FROM t3;
1613 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5;
1616 DROP TABLE t1,t2,t3;
1617 CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY);
1618 CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY);
1619 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1620 CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY);
1621 INSERT INTO t3 (c1) VALUES(5);
1622 SELECT COUNT(c1),SUM(c1) FROM t3;
1625 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5;
1628 REPLACE t3 VALUES (5);
1629 SELECT COUNT(c1),SUM(c1) FROM t3;
1632 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5;
1635 DROP TABLE t1,t2,t3;
1636 CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY);
1637 CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY);
1638 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1639 CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY);
1640 INSERT INTO t3 (c1) VALUES(5);
1641 SELECT COUNT(c1),SUM(c1) FROM t3;
1644 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5;
1647 REPLACE t3 VALUES (5);
1648 SELECT COUNT(c1),SUM(c1) FROM t3;
1651 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5;
1654 DROP TABLE t1,t2,t3;
1655 CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY);
1656 CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY);
1657 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1658 CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY);
1659 INSERT INTO t3 (c1) VALUES(5);
1660 SELECT COUNT(c1),SUM(c1) FROM t3;
1663 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5;
1666 REPLACE t3 VALUES (5);
1667 SELECT COUNT(c1),SUM(c1) FROM t3;
1670 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5;
1673 DROP TABLE t1,t2,t3;
1674 CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY);
1675 CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY);
1676 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1677 CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY);
1678 INSERT INTO t3 (c1) VALUES(5);
1679 SELECT COUNT(c1),SUM(c1) FROM t3;
1682 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5;
1685 REPLACE t3 VALUES (5);
1686 SELECT COUNT(c1),SUM(c1) FROM t3;
1689 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5;
1692 DROP TABLE t1,t2,t3;
1693 CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY);
1694 CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY);
1695 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1696 CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY);
1697 INSERT INTO t3 (c1) VALUES(5);
1698 SELECT COUNT(c1),SUM(c1) FROM t3;
1701 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5;
1704 REPLACE t3 VALUES (5);
1705 SELECT COUNT(c1),SUM(c1) FROM t3;
1708 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5;
1711 DROP TABLE t1,t2,t3;
1712 CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY);
1713 CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY);
1714 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1715 CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY);
1716 INSERT INTO t3 (c1) VALUES(5);
1717 SELECT COUNT(c1),SUM(c1) FROM t1;
1720 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5;
1723 REPLACE t1 VALUES (5);
1724 SELECT COUNT(c1),SUM(c1) FROM t1;
1727 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5;
1730 DROP TABLE t1,t2,t3;
1731 CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY);
1732 CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY);
1733 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1734 CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY);
1735 INSERT INTO t3 (c1) VALUES(5);
1736 SELECT COUNT(c1),SUM(c1) FROM t1;
1739 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5;
1742 REPLACE t1 VALUES (5);
1743 SELECT COUNT(c1),SUM(c1) FROM t1;
1746 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5;
1749 DROP TABLE t1,t2,t3;
1750 CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY);
1751 CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY);
1752 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1753 CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY);
1754 INSERT INTO t3 (c1) VALUES(5);
1755 SELECT COUNT(c1),SUM(c1) FROM t1;
1758 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5;
1761 REPLACE t1 VALUES (5);
1762 SELECT COUNT(c1),SUM(c1) FROM t1;
1765 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5;
1768 DROP TABLE t1,t2,t3;
1769 CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY);
1770 CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY);
1771 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1772 CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY);
1773 INSERT INTO t3 (c1) VALUES(5);
1774 SELECT COUNT(c1),SUM(c1) FROM t1;
1777 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5;
1780 REPLACE t1 VALUES (5);
1781 SELECT COUNT(c1),SUM(c1) FROM t1;
1784 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5;
1787 DROP TABLE t1,t2,t3;
1788 CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY);
1789 CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY);
1790 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1791 CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY);
1792 INSERT INTO t3 (c1) VALUES(5);
1793 SELECT COUNT(c1),SUM(c1) FROM t1;
1796 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5;
1799 REPLACE t1 VALUES (5);
1800 SELECT COUNT(c1),SUM(c1) FROM t1;
1803 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5;
1806 DROP TABLE t1,t2,t3;
1807 CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY);
1808 CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY);
1809 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1810 CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY);
1811 INSERT INTO t3 (c1) VALUES(5);
1812 SELECT COUNT(c1),SUM(c1) FROM t1;
1815 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5;
1818 REPLACE t1 VALUES (5);
1819 SELECT COUNT(c1),SUM(c1) FROM t1;
1822 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5;
1825 DROP TABLE t1,t2,t3;
1826 CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY);
1827 CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY);
1828 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1829 CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY);
1830 INSERT INTO t3 (c1) VALUES(5);
1831 SELECT COUNT(c1),SUM(c1) FROM t2;
1834 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5;
1837 REPLACE t2 VALUES (5);
1838 SELECT COUNT(c1),SUM(c1) FROM t2;
1841 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5;
1844 DROP TABLE t1,t2,t3;
1845 CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY);
1846 CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY);
1847 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1848 CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY);
1849 INSERT INTO t3 (c1) VALUES(5);
1850 SELECT COUNT(c1),SUM(c1) FROM t2;
1853 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5;
1856 REPLACE t2 VALUES (5);
1857 SELECT COUNT(c1),SUM(c1) FROM t2;
1860 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5;
1863 DROP TABLE t1,t2,t3;
1864 CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY);
1865 CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY);
1866 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1867 CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY);
1868 INSERT INTO t3 (c1) VALUES(5);
1869 SELECT COUNT(c1),SUM(c1) FROM t2;
1872 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5;
1875 REPLACE t2 VALUES (5);
1876 SELECT COUNT(c1),SUM(c1) FROM t2;
1879 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5;
1882 DROP TABLE t1,t2,t3;
1883 CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY);
1884 CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY);
1885 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1886 CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY);
1887 INSERT INTO t3 (c1) VALUES(5);
1888 SELECT COUNT(c1),SUM(c1) FROM t2;
1891 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5;
1894 REPLACE t2 VALUES (5);
1895 SELECT COUNT(c1),SUM(c1) FROM t2;
1898 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5;
1901 DROP TABLE t1,t2,t3;
1902 CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY);
1903 CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY);
1904 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1905 CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY);
1906 INSERT INTO t3 (c1) VALUES(5);
1907 SELECT COUNT(c1),SUM(c1) FROM t2;
1910 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5;
1913 REPLACE t2 VALUES (5);
1914 SELECT COUNT(c1),SUM(c1) FROM t2;
1917 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5;
1920 DROP TABLE t1,t2,t3;
1921 CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY);
1922 CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY);
1923 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1924 CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY);
1925 INSERT INTO t3 (c1) VALUES(5);
1926 SELECT COUNT(c1),SUM(c1) FROM t2;
1929 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5;
1932 REPLACE t2 VALUES (5);
1933 SELECT COUNT(c1),SUM(c1) FROM t2;
1936 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5;
1939 DROP TABLE t1,t2,t3;
1940 CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY);
1941 CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY);
1942 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1943 CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY);
1944 INSERT INTO t3 (c1) VALUES(5);
1945 SELECT COUNT(c1),SUM(c1) FROM t3;
1948 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5;
1951 REPLACE t3 VALUES (5);
1952 SELECT COUNT(c1),SUM(c1) FROM t3;
1955 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5;
1958 DROP TABLE t1,t2,t3;
1959 CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY);
1960 CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY);
1961 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1962 CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY);
1963 INSERT INTO t3 (c1) VALUES(5);
1964 SELECT COUNT(c1),SUM(c1) FROM t3;
1967 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5;
1970 REPLACE t3 VALUES (5);
1971 SELECT COUNT(c1),SUM(c1) FROM t3;
1974 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5;
1977 DROP TABLE t1,t2,t3;
1978 CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY);
1979 CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY);
1980 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1981 CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY);
1982 INSERT INTO t3 (c1) VALUES(5);
1983 SELECT COUNT(c1),SUM(c1) FROM t3;
1986 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5;
1989 REPLACE t3 VALUES (5);
1990 SELECT COUNT(c1),SUM(c1) FROM t3;
1993 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5;
1996 DROP TABLE t1,t2,t3;
1997 CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY);
1998 CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY);
1999 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2000 CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY);
2001 INSERT INTO t3 (c1) VALUES(5);
2002 SELECT COUNT(c1),SUM(c1) FROM t3;
2005 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5;
2008 REPLACE t3 VALUES (5);
2009 SELECT COUNT(c1),SUM(c1) FROM t3;
2012 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5;
2015 DROP TABLE t1,t2,t3;
2016 CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY);
2017 CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY);
2018 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2019 CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY);
2020 INSERT INTO t3 (c1) VALUES(5);
2021 SELECT COUNT(c1),SUM(c1) FROM t3;
2024 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5;
2027 REPLACE t3 VALUES (5);
2028 SELECT COUNT(c1),SUM(c1) FROM t3;
2031 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5;
2034 DROP TABLE t1,t2,t3;
2035 CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY);
2036 CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY);
2037 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2038 CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY);
2039 INSERT INTO t3 (c1) VALUES(5);
2040 SELECT COUNT(c1),SUM(c1) FROM t3;
2043 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5;
2046 REPLACE t3 VALUES (5);
2047 SELECT COUNT(c1),SUM(c1) FROM t3;
2050 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5;
2053 DROP TABLE t1,t2,t3;
2054 CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY);
2055 CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY);
2056 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2057 CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY);
2058 INSERT INTO t3 (c1) VALUES(5);
2059 SELECT COUNT(c1),SUM(c1) FROM t1;
2062 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5;
2065 REPLACE t1 VALUES (5);
2066 SELECT COUNT(c1),SUM(c1) FROM t1;
2069 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5;
2072 DROP TABLE t1,t2,t3;
2073 CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY);
2074 CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY);
2075 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2076 CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY);
2077 INSERT INTO t3 (c1) VALUES(5);
2078 SELECT COUNT(c1),SUM(c1) FROM t1;
2081 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5;
2084 REPLACE t1 VALUES (5);
2085 SELECT COUNT(c1),SUM(c1) FROM t1;
2088 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5;
2091 DROP TABLE t1,t2,t3;
2092 CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY);
2093 CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY);
2094 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2095 CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY);
2096 INSERT INTO t3 (c1) VALUES(5);
2097 SELECT COUNT(c1),SUM(c1) FROM t1;
2100 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5;
2103 REPLACE t1 VALUES (5);
2104 SELECT COUNT(c1),SUM(c1) FROM t1;
2107 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5;
2110 DROP TABLE t1,t2,t3;
2111 CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY);
2112 CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY);
2113 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2114 CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY);
2115 INSERT INTO t3 (c1) VALUES(5);
2116 SELECT COUNT(c1),SUM(c1) FROM t1;
2119 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5;
2122 REPLACE t1 VALUES (5);
2123 SELECT COUNT(c1),SUM(c1) FROM t1;
2126 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5;
2129 DROP TABLE t1,t2,t3;
2130 CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY);
2131 CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY);
2132 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2133 CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY);
2134 INSERT INTO t3 (c1) VALUES(5);
2135 SELECT COUNT(c1),SUM(c1) FROM t1;
2138 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5;
2141 REPLACE t1 VALUES (5);
2142 SELECT COUNT(c1),SUM(c1) FROM t1;
2145 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5;
2148 DROP TABLE t1,t2,t3;
2149 CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY);
2150 CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY);
2151 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2152 CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY);
2153 INSERT INTO t3 (c1) VALUES(5);
2154 SELECT COUNT(c1),SUM(c1) FROM t1;
2157 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5;
2160 REPLACE t1 VALUES (5);
2161 SELECT COUNT(c1),SUM(c1) FROM t1;
2164 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5;
2167 DROP TABLE t1,t2,t3;
2168 CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY);
2169 CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY);
2170 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2171 CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY);
2172 INSERT INTO t3 (c1) VALUES(5);
2173 SELECT COUNT(c1),SUM(c1) FROM t2;
2176 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5;
2179 REPLACE t2 VALUES (5);
2180 SELECT COUNT(c1),SUM(c1) FROM t2;
2183 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5;
2186 DROP TABLE t1,t2,t3;
2187 CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY);
2188 CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY);
2189 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2190 CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY);
2191 INSERT INTO t3 (c1) VALUES(5);
2192 SELECT COUNT(c1),SUM(c1) FROM t2;
2195 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5;
2198 REPLACE t2 VALUES (5);
2199 SELECT COUNT(c1),SUM(c1) FROM t2;
2202 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5;
2205 DROP TABLE t1,t2,t3;
2206 CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY);
2207 CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY);
2208 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2209 CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY);
2210 INSERT INTO t3 (c1) VALUES(5);
2211 SELECT COUNT(c1),SUM(c1) FROM t2;
2214 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5;
2217 REPLACE t2 VALUES (5);
2218 SELECT COUNT(c1),SUM(c1) FROM t2;
2221 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5;
2224 DROP TABLE t1,t2,t3;
2225 CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY);
2226 CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY);
2227 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2228 CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY);
2229 INSERT INTO t3 (c1) VALUES(5);
2230 SELECT COUNT(c1),SUM(c1) FROM t2;
2233 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5;
2236 REPLACE t2 VALUES (5);
2237 SELECT COUNT(c1),SUM(c1) FROM t2;
2240 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5;
2243 DROP TABLE t1,t2,t3;
2244 CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY);
2245 CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY);
2246 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2247 CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY);
2248 INSERT INTO t3 (c1) VALUES(5);
2249 SELECT COUNT(c1),SUM(c1) FROM t2;
2252 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5;
2255 REPLACE t2 VALUES (5);
2256 SELECT COUNT(c1),SUM(c1) FROM t2;
2259 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5;
2262 DROP TABLE t1,t2,t3;
2263 CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY);
2264 CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY);
2265 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2266 CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY);
2267 INSERT INTO t3 (c1) VALUES(5);
2268 SELECT COUNT(c1),SUM(c1) FROM t2;
2271 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5;
2274 REPLACE t2 VALUES (5);
2275 SELECT COUNT(c1),SUM(c1) FROM t2;
2278 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5;
2281 DROP TABLE t1,t2,t3;
2282 CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY);
2283 CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY);
2284 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2285 CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY);
2286 INSERT INTO t3 (c1) VALUES(5);
2287 SELECT COUNT(c1),SUM(c1) FROM t3;
2290 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5;
2293 REPLACE t3 VALUES (5);
2294 SELECT COUNT(c1),SUM(c1) FROM t3;
2297 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5;
2300 DROP TABLE t1,t2,t3;
2301 CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY);
2302 CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY);
2303 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2304 CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY);
2305 INSERT INTO t3 (c1) VALUES(5);
2306 SELECT COUNT(c1),SUM(c1) FROM t3;
2309 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5;
2312 REPLACE t3 VALUES (5);
2313 SELECT COUNT(c1),SUM(c1) FROM t3;
2316 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5;
2319 DROP TABLE t1,t2,t3;
2320 CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY);
2321 CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY);
2322 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2323 CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY);
2324 INSERT INTO t3 (c1) VALUES(5);
2325 SELECT COUNT(c1),SUM(c1) FROM t3;
2328 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5;
2331 REPLACE t3 VALUES (5);
2332 SELECT COUNT(c1),SUM(c1) FROM t3;
2335 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5;
2338 DROP TABLE t1,t2,t3;
2339 CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY);
2340 CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY);
2341 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2342 CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY);
2343 INSERT INTO t3 (c1) VALUES(5);
2344 SELECT COUNT(c1),SUM(c1) FROM t3;
2347 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5;
2350 REPLACE t3 VALUES (5);
2351 SELECT COUNT(c1),SUM(c1) FROM t3;
2354 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5;
2357 DROP TABLE t1,t2,t3;
2358 CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY);
2359 CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY);
2360 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2361 CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY);
2362 INSERT INTO t3 (c1) VALUES(5);
2363 SELECT COUNT(c1),SUM(c1) FROM t3;
2366 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5;
2369 REPLACE t3 VALUES (5);
2370 SELECT COUNT(c1),SUM(c1) FROM t3;
2373 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5;
2376 DROP TABLE t1,t2,t3;
2377 CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY);
2378 CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY);
2379 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2380 CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY);
2381 INSERT INTO t3 (c1) VALUES(5);
2382 SELECT COUNT(c1),SUM(c1) FROM t3;
2385 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5;
2388 REPLACE t3 VALUES (5);
2389 SELECT COUNT(c1),SUM(c1) FROM t3;
2392 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5;
2395 DROP TABLE t1,t2,t3;