Debian Codegraph @

mysql-test/suite/engines/funcs/r/re_number_range.result

raw
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;
8 COUNT(c1) SUM(c1)
9 0 NULL
10 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5;
11 COUNT(c1) SUM(c1)
12 0 NULL
13 REPLACE t1 VALUES (5);
14 SELECT COUNT(c1),SUM(c1) FROM t1;
15 COUNT(c1) SUM(c1)
16 1 5
17 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5;
18 COUNT(c1) SUM(c1)
19 0 NULL
20 DROP TABLE t1,t2,t3;
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;
27 COUNT(c1) SUM(c1)
28 0 NULL
29 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5;
30 COUNT(c1) SUM(c1)
31 0 NULL
32 REPLACE t1 VALUES (5);
33 SELECT COUNT(c1),SUM(c1) FROM t1;
34 COUNT(c1) SUM(c1)
35 1 5
36 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5;
37 COUNT(c1) SUM(c1)
38 0 NULL
39 DROP TABLE t1,t2,t3;
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;
46 COUNT(c1) SUM(c1)
47 0 NULL
48 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5;
49 COUNT(c1) SUM(c1)
50 0 NULL
51 REPLACE t1 VALUES (5);
52 SELECT COUNT(c1),SUM(c1) FROM t1;
53 COUNT(c1) SUM(c1)
54 1 5
55 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5;
56 COUNT(c1) SUM(c1)
57 0 NULL
58 DROP TABLE t1,t2,t3;
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;
65 COUNT(c1) SUM(c1)
66 0 NULL
67 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5;
68 COUNT(c1) SUM(c1)
69 0 NULL
70 REPLACE t1 VALUES (5);
71 SELECT COUNT(c1),SUM(c1) FROM t1;
72 COUNT(c1) SUM(c1)
73 1 5
74 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5;
75 COUNT(c1) SUM(c1)
76 0 NULL
77 DROP TABLE t1,t2,t3;
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;
84 COUNT(c1) SUM(c1)
85 0 NULL
86 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5;
87 COUNT(c1) SUM(c1)
88 0 NULL
89 REPLACE t1 VALUES (5);
90 SELECT COUNT(c1),SUM(c1) FROM t1;
91 COUNT(c1) SUM(c1)
92 1 5
93 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5;
94 COUNT(c1) SUM(c1)
95 0 NULL
96 DROP TABLE t1,t2,t3;
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;
103 COUNT(c1) SUM(c1)
104 0 NULL
105 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5;
106 COUNT(c1) SUM(c1)
107 0 NULL
108 REPLACE t1 VALUES (5);
109 SELECT COUNT(c1),SUM(c1) FROM t1;
110 COUNT(c1) SUM(c1)
111 1 5
112 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5;
113 COUNT(c1) SUM(c1)
114 0 NULL
115 DROP TABLE t1,t2,t3;
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;
122 COUNT(c1) SUM(c1)
123 10 45
124 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5;
125 COUNT(c1) SUM(c1)
126 5 10
127 REPLACE t2 VALUES (5);
128 SELECT COUNT(c1),SUM(c1) FROM t2;
129 COUNT(c1) SUM(c1)
130 10 45
131 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5;
132 COUNT(c1) SUM(c1)
133 5 10
134 DROP TABLE t1,t2,t3;
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;
141 COUNT(c1) SUM(c1)
142 10 45
143 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5;
144 COUNT(c1) SUM(c1)
145 5 10
146 REPLACE t2 VALUES (5);
147 SELECT COUNT(c1),SUM(c1) FROM t2;
148 COUNT(c1) SUM(c1)
149 10 45
150 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5;
151 COUNT(c1) SUM(c1)
152 5 10
153 DROP TABLE t1,t2,t3;
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;
160 COUNT(c1) SUM(c1)
161 10 45
162 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5;
163 COUNT(c1) SUM(c1)
164 5 10
165 REPLACE t2 VALUES (5);
166 SELECT COUNT(c1),SUM(c1) FROM t2;
167 COUNT(c1) SUM(c1)
168 10 45
169 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5;
170 COUNT(c1) SUM(c1)
171 5 10
172 DROP TABLE t1,t2,t3;
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;
179 COUNT(c1) SUM(c1)
180 10 45
181 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5;
182 COUNT(c1) SUM(c1)
183 5 10
184 REPLACE t2 VALUES (5);
185 SELECT COUNT(c1),SUM(c1) FROM t2;
186 COUNT(c1) SUM(c1)
187 10 45
188 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5;
189 COUNT(c1) SUM(c1)
190 5 10
191 DROP TABLE t1,t2,t3;
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;
198 COUNT(c1) SUM(c1)
199 10 45
200 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5;
201 COUNT(c1) SUM(c1)
202 5 10
203 REPLACE t2 VALUES (5);
204 SELECT COUNT(c1),SUM(c1) FROM t2;
205 COUNT(c1) SUM(c1)
206 10 45
207 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5;
208 COUNT(c1) SUM(c1)
209 5 10
210 DROP TABLE t1,t2,t3;
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;
217 COUNT(c1) SUM(c1)
218 10 45
219 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5;
220 COUNT(c1) SUM(c1)
221 5 10
222 REPLACE t2 VALUES (5);
223 SELECT COUNT(c1),SUM(c1) FROM t2;
224 COUNT(c1) SUM(c1)
225 10 45
226 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5;
227 COUNT(c1) SUM(c1)
228 5 10
229 DROP TABLE t1,t2,t3;
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;
236 COUNT(c1) SUM(c1)
237 1 5
238 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5;
239 COUNT(c1) SUM(c1)
240 0 NULL
241 REPLACE t3 VALUES (5);
242 SELECT COUNT(c1),SUM(c1) FROM t3;
243 COUNT(c1) SUM(c1)
244 1 5
245 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5;
246 COUNT(c1) SUM(c1)
247 0 NULL
248 DROP TABLE t1,t2,t3;
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;
255 COUNT(c1) SUM(c1)
256 1 5
257 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5;
258 COUNT(c1) SUM(c1)
259 0 NULL
260 REPLACE t3 VALUES (5);
261 SELECT COUNT(c1),SUM(c1) FROM t3;
262 COUNT(c1) SUM(c1)
263 1 5
264 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5;
265 COUNT(c1) SUM(c1)
266 0 NULL
267 DROP TABLE t1,t2,t3;
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;
274 COUNT(c1) SUM(c1)
275 1 5
276 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5;
277 COUNT(c1) SUM(c1)
278 0 NULL
279 REPLACE t3 VALUES (5);
280 SELECT COUNT(c1),SUM(c1) FROM t3;
281 COUNT(c1) SUM(c1)
282 1 5
283 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5;
284 COUNT(c1) SUM(c1)
285 0 NULL
286 DROP TABLE t1,t2,t3;
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;
293 COUNT(c1) SUM(c1)
294 1 5
295 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5;
296 COUNT(c1) SUM(c1)
297 0 NULL
298 REPLACE t3 VALUES (5);
299 SELECT COUNT(c1),SUM(c1) FROM t3;
300 COUNT(c1) SUM(c1)
301 1 5
302 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5;
303 COUNT(c1) SUM(c1)
304 0 NULL
305 DROP TABLE t1,t2,t3;
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;
312 COUNT(c1) SUM(c1)
313 1 5
314 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5;
315 COUNT(c1) SUM(c1)
316 0 NULL
317 REPLACE t3 VALUES (5);
318 SELECT COUNT(c1),SUM(c1) FROM t3;
319 COUNT(c1) SUM(c1)
320 1 5
321 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5;
322 COUNT(c1) SUM(c1)
323 0 NULL
324 DROP TABLE t1,t2,t3;
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;
331 COUNT(c1) SUM(c1)
332 1 5
333 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5;
334 COUNT(c1) SUM(c1)
335 0 NULL
336 REPLACE t3 VALUES (5);
337 SELECT COUNT(c1),SUM(c1) FROM t3;
338 COUNT(c1) SUM(c1)
339 1 5
340 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5;
341 COUNT(c1) SUM(c1)
342 0 NULL
343 DROP TABLE t1,t2,t3;
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;
350 COUNT(c1) SUM(c1)
351 0 NULL
352 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5;
353 COUNT(c1) SUM(c1)
354 0 NULL
355 REPLACE t1 VALUES (5);
356 SELECT COUNT(c1),SUM(c1) FROM t1;
357 COUNT(c1) SUM(c1)
358 1 5
359 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5;
360 COUNT(c1) SUM(c1)
361 1 5
362 DROP TABLE t1,t2,t3;
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;
369 COUNT(c1) SUM(c1)
370 0 NULL
371 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5;
372 COUNT(c1) SUM(c1)
373 0 NULL
374 REPLACE t1 VALUES (5);
375 SELECT COUNT(c1),SUM(c1) FROM t1;
376 COUNT(c1) SUM(c1)
377 1 5
378 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5;
379 COUNT(c1) SUM(c1)
380 1 5
381 DROP TABLE t1,t2,t3;
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;
388 COUNT(c1) SUM(c1)
389 0 NULL
390 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5;
391 COUNT(c1) SUM(c1)
392 0 NULL
393 REPLACE t1 VALUES (5);
394 SELECT COUNT(c1),SUM(c1) FROM t1;
395 COUNT(c1) SUM(c1)
396 1 5
397 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5;
398 COUNT(c1) SUM(c1)
399 1 5
400 DROP TABLE t1,t2,t3;
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;
407 COUNT(c1) SUM(c1)
408 0 NULL
409 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5;
410 COUNT(c1) SUM(c1)
411 0 NULL
412 REPLACE t1 VALUES (5);
413 SELECT COUNT(c1),SUM(c1) FROM t1;
414 COUNT(c1) SUM(c1)
415 1 5
416 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5;
417 COUNT(c1) SUM(c1)
418 1 5
419 DROP TABLE t1,t2,t3;
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;
426 COUNT(c1) SUM(c1)
427 0 NULL
428 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5;
429 COUNT(c1) SUM(c1)
430 0 NULL
431 REPLACE t1 VALUES (5);
432 SELECT COUNT(c1),SUM(c1) FROM t1;
433 COUNT(c1) SUM(c1)
434 1 5
435 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5;
436 COUNT(c1) SUM(c1)
437 1 5
438 DROP TABLE t1,t2,t3;
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;
445 COUNT(c1) SUM(c1)
446 0 NULL
447 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5;
448 COUNT(c1) SUM(c1)
449 0 NULL
450 REPLACE t1 VALUES (5);
451 SELECT COUNT(c1),SUM(c1) FROM t1;
452 COUNT(c1) SUM(c1)
453 1 5
454 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5;
455 COUNT(c1) SUM(c1)
456 1 5
457 DROP TABLE t1,t2,t3;
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;
464 COUNT(c1) SUM(c1)
465 10 45
466 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5;
467 COUNT(c1) SUM(c1)
468 6 15
469 REPLACE t2 VALUES (5);
470 SELECT COUNT(c1),SUM(c1) FROM t2;
471 COUNT(c1) SUM(c1)
472 10 45
473 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5;
474 COUNT(c1) SUM(c1)
475 6 15
476 DROP TABLE t1,t2,t3;
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;
483 COUNT(c1) SUM(c1)
484 10 45
485 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5;
486 COUNT(c1) SUM(c1)
487 6 15
488 REPLACE t2 VALUES (5);
489 SELECT COUNT(c1),SUM(c1) FROM t2;
490 COUNT(c1) SUM(c1)
491 10 45
492 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5;
493 COUNT(c1) SUM(c1)
494 6 15
495 DROP TABLE t1,t2,t3;
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;
502 COUNT(c1) SUM(c1)
503 10 45
504 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5;
505 COUNT(c1) SUM(c1)
506 6 15
507 REPLACE t2 VALUES (5);
508 SELECT COUNT(c1),SUM(c1) FROM t2;
509 COUNT(c1) SUM(c1)
510 10 45
511 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5;
512 COUNT(c1) SUM(c1)
513 6 15
514 DROP TABLE t1,t2,t3;
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;
521 COUNT(c1) SUM(c1)
522 10 45
523 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5;
524 COUNT(c1) SUM(c1)
525 6 15
526 REPLACE t2 VALUES (5);
527 SELECT COUNT(c1),SUM(c1) FROM t2;
528 COUNT(c1) SUM(c1)
529 10 45
530 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5;
531 COUNT(c1) SUM(c1)
532 6 15
533 DROP TABLE t1,t2,t3;
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;
540 COUNT(c1) SUM(c1)
541 10 45
542 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5;
543 COUNT(c1) SUM(c1)
544 6 15
545 REPLACE t2 VALUES (5);
546 SELECT COUNT(c1),SUM(c1) FROM t2;
547 COUNT(c1) SUM(c1)
548 10 45
549 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5;
550 COUNT(c1) SUM(c1)
551 6 15
552 DROP TABLE t1,t2,t3;
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;
559 COUNT(c1) SUM(c1)
560 10 45
561 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5;
562 COUNT(c1) SUM(c1)
563 6 15
564 REPLACE t2 VALUES (5);
565 SELECT COUNT(c1),SUM(c1) FROM t2;
566 COUNT(c1) SUM(c1)
567 10 45
568 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5;
569 COUNT(c1) SUM(c1)
570 6 15
571 DROP TABLE t1,t2,t3;
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;
578 COUNT(c1) SUM(c1)
579 1 5
580 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5;
581 COUNT(c1) SUM(c1)
582 1 5
583 REPLACE t3 VALUES (5);
584 SELECT COUNT(c1),SUM(c1) FROM t3;
585 COUNT(c1) SUM(c1)
586 1 5
587 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5;
588 COUNT(c1) SUM(c1)
589 1 5
590 DROP TABLE t1,t2,t3;
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;
597 COUNT(c1) SUM(c1)
598 1 5
599 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5;
600 COUNT(c1) SUM(c1)
601 1 5
602 REPLACE t3 VALUES (5);
603 SELECT COUNT(c1),SUM(c1) FROM t3;
604 COUNT(c1) SUM(c1)
605 1 5
606 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5;
607 COUNT(c1) SUM(c1)
608 1 5
609 DROP TABLE t1,t2,t3;
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;
616 COUNT(c1) SUM(c1)
617 1 5
618 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5;
619 COUNT(c1) SUM(c1)
620 1 5
621 REPLACE t3 VALUES (5);
622 SELECT COUNT(c1),SUM(c1) FROM t3;
623 COUNT(c1) SUM(c1)
624 1 5
625 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5;
626 COUNT(c1) SUM(c1)
627 1 5
628 DROP TABLE t1,t2,t3;
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;
635 COUNT(c1) SUM(c1)
636 1 5
637 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5;
638 COUNT(c1) SUM(c1)
639 1 5
640 REPLACE t3 VALUES (5);
641 SELECT COUNT(c1),SUM(c1) FROM t3;
642 COUNT(c1) SUM(c1)
643 1 5
644 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5;
645 COUNT(c1) SUM(c1)
646 1 5
647 DROP TABLE t1,t2,t3;
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;
654 COUNT(c1) SUM(c1)
655 1 5
656 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5;
657 COUNT(c1) SUM(c1)
658 1 5
659 REPLACE t3 VALUES (5);
660 SELECT COUNT(c1),SUM(c1) FROM t3;
661 COUNT(c1) SUM(c1)
662 1 5
663 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5;
664 COUNT(c1) SUM(c1)
665 1 5
666 DROP TABLE t1,t2,t3;
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;
673 COUNT(c1) SUM(c1)
674 1 5
675 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5;
676 COUNT(c1) SUM(c1)
677 1 5
678 REPLACE t3 VALUES (5);
679 SELECT COUNT(c1),SUM(c1) FROM t3;
680 COUNT(c1) SUM(c1)
681 1 5
682 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5;
683 COUNT(c1) SUM(c1)
684 1 5
685 DROP TABLE t1,t2,t3;
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;
692 COUNT(c1) SUM(c1)
693 0 NULL
694 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5;
695 COUNT(c1) SUM(c1)
696 0 NULL
697 REPLACE t1 VALUES (5);
698 SELECT COUNT(c1),SUM(c1) FROM t1;
699 COUNT(c1) SUM(c1)
700 1 5
701 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5;
702 COUNT(c1) SUM(c1)
703 1 5
704 DROP TABLE t1,t2,t3;
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;
711 COUNT(c1) SUM(c1)
712 0 NULL
713 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5;
714 COUNT(c1) SUM(c1)
715 0 NULL
716 REPLACE t1 VALUES (5);
717 SELECT COUNT(c1),SUM(c1) FROM t1;
718 COUNT(c1) SUM(c1)
719 1 5
720 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5;
721 COUNT(c1) SUM(c1)
722 1 5
723 DROP TABLE t1,t2,t3;
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;
730 COUNT(c1) SUM(c1)
731 0 NULL
732 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5;
733 COUNT(c1) SUM(c1)
734 0 NULL
735 REPLACE t1 VALUES (5);
736 SELECT COUNT(c1),SUM(c1) FROM t1;
737 COUNT(c1) SUM(c1)
738 1 5
739 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5;
740 COUNT(c1) SUM(c1)
741 1 5
742 DROP TABLE t1,t2,t3;
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;
749 COUNT(c1) SUM(c1)
750 0 NULL
751 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5;
752 COUNT(c1) SUM(c1)
753 0 NULL
754 REPLACE t1 VALUES (5);
755 SELECT COUNT(c1),SUM(c1) FROM t1;
756 COUNT(c1) SUM(c1)
757 1 5
758 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5;
759 COUNT(c1) SUM(c1)
760 1 5
761 DROP TABLE t1,t2,t3;
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;
768 COUNT(c1) SUM(c1)
769 0 NULL
770 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5;
771 COUNT(c1) SUM(c1)
772 0 NULL
773 REPLACE t1 VALUES (5);
774 SELECT COUNT(c1),SUM(c1) FROM t1;
775 COUNT(c1) SUM(c1)
776 1 5
777 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5;
778 COUNT(c1) SUM(c1)
779 1 5
780 DROP TABLE t1,t2,t3;
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;
787 COUNT(c1) SUM(c1)
788 0 NULL
789 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5;
790 COUNT(c1) SUM(c1)
791 0 NULL
792 REPLACE t1 VALUES (5);
793 SELECT COUNT(c1),SUM(c1) FROM t1;
794 COUNT(c1) SUM(c1)
795 1 5
796 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5;
797 COUNT(c1) SUM(c1)
798 1 5
799 DROP TABLE t1,t2,t3;
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;
806 COUNT(c1) SUM(c1)
807 10 45
808 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5;
809 COUNT(c1) SUM(c1)
810 1 5
811 REPLACE t2 VALUES (5);
812 SELECT COUNT(c1),SUM(c1) FROM t2;
813 COUNT(c1) SUM(c1)
814 10 45
815 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5;
816 COUNT(c1) SUM(c1)
817 1 5
818 DROP TABLE t1,t2,t3;
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;
825 COUNT(c1) SUM(c1)
826 10 45
827 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5;
828 COUNT(c1) SUM(c1)
829 1 5
830 REPLACE t2 VALUES (5);
831 SELECT COUNT(c1),SUM(c1) FROM t2;
832 COUNT(c1) SUM(c1)
833 10 45
834 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5;
835 COUNT(c1) SUM(c1)
836 1 5
837 DROP TABLE t1,t2,t3;
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;
844 COUNT(c1) SUM(c1)
845 10 45
846 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5;
847 COUNT(c1) SUM(c1)
848 1 5
849 REPLACE t2 VALUES (5);
850 SELECT COUNT(c1),SUM(c1) FROM t2;
851 COUNT(c1) SUM(c1)
852 10 45
853 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5;
854 COUNT(c1) SUM(c1)
855 1 5
856 DROP TABLE t1,t2,t3;
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;
863 COUNT(c1) SUM(c1)
864 10 45
865 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5;
866 COUNT(c1) SUM(c1)
867 1 5
868 REPLACE t2 VALUES (5);
869 SELECT COUNT(c1),SUM(c1) FROM t2;
870 COUNT(c1) SUM(c1)
871 10 45
872 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5;
873 COUNT(c1) SUM(c1)
874 1 5
875 DROP TABLE t1,t2,t3;
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;
882 COUNT(c1) SUM(c1)
883 10 45
884 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5;
885 COUNT(c1) SUM(c1)
886 1 5
887 REPLACE t2 VALUES (5);
888 SELECT COUNT(c1),SUM(c1) FROM t2;
889 COUNT(c1) SUM(c1)
890 10 45
891 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5;
892 COUNT(c1) SUM(c1)
893 1 5
894 DROP TABLE t1,t2,t3;
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;
901 COUNT(c1) SUM(c1)
902 10 45
903 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5;
904 COUNT(c1) SUM(c1)
905 1 5
906 REPLACE t2 VALUES (5);
907 SELECT COUNT(c1),SUM(c1) FROM t2;
908 COUNT(c1) SUM(c1)
909 10 45
910 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5;
911 COUNT(c1) SUM(c1)
912 1 5
913 DROP TABLE t1,t2,t3;
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;
920 COUNT(c1) SUM(c1)
921 1 5
922 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5;
923 COUNT(c1) SUM(c1)
924 1 5
925 REPLACE t3 VALUES (5);
926 SELECT COUNT(c1),SUM(c1) FROM t3;
927 COUNT(c1) SUM(c1)
928 1 5
929 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5;
930 COUNT(c1) SUM(c1)
931 1 5
932 DROP TABLE t1,t2,t3;
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;
939 COUNT(c1) SUM(c1)
940 1 5
941 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5;
942 COUNT(c1) SUM(c1)
943 1 5
944 REPLACE t3 VALUES (5);
945 SELECT COUNT(c1),SUM(c1) FROM t3;
946 COUNT(c1) SUM(c1)
947 1 5
948 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5;
949 COUNT(c1) SUM(c1)
950 1 5
951 DROP TABLE t1,t2,t3;
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;
958 COUNT(c1) SUM(c1)
959 1 5
960 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5;
961 COUNT(c1) SUM(c1)
962 1 5
963 REPLACE t3 VALUES (5);
964 SELECT COUNT(c1),SUM(c1) FROM t3;
965 COUNT(c1) SUM(c1)
966 1 5
967 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5;
968 COUNT(c1) SUM(c1)
969 1 5
970 DROP TABLE t1,t2,t3;
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;
977 COUNT(c1) SUM(c1)
978 1 5
979 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5;
980 COUNT(c1) SUM(c1)
981 1 5
982 REPLACE t3 VALUES (5);
983 SELECT COUNT(c1),SUM(c1) FROM t3;
984 COUNT(c1) SUM(c1)
985 1 5
986 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5;
987 COUNT(c1) SUM(c1)
988 1 5
989 DROP TABLE t1,t2,t3;
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;
996 COUNT(c1) SUM(c1)
997 1 5
998 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5;
999 COUNT(c1) SUM(c1)
1000 1 5
1001 REPLACE t3 VALUES (5);
1002 SELECT COUNT(c1),SUM(c1) FROM t3;
1003 COUNT(c1) SUM(c1)
1004 1 5
1005 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5;
1006 COUNT(c1) SUM(c1)
1007 1 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;
1015 COUNT(c1) SUM(c1)
1016 1 5
1017 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5;
1018 COUNT(c1) SUM(c1)
1019 1 5
1020 REPLACE t3 VALUES (5);
1021 SELECT COUNT(c1),SUM(c1) FROM t3;
1022 COUNT(c1) SUM(c1)
1023 1 5
1024 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5;
1025 COUNT(c1) SUM(c1)
1026 1 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;
1034 COUNT(c1) SUM(c1)
1035 0 NULL
1036 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5;
1037 COUNT(c1) SUM(c1)
1038 0 NULL
1039 REPLACE t1 VALUES (5);
1040 SELECT COUNT(c1),SUM(c1) FROM t1;
1041 COUNT(c1) SUM(c1)
1042 1 5
1043 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5;
1044 COUNT(c1) SUM(c1)
1045 1 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;
1053 COUNT(c1) SUM(c1)
1054 0 NULL
1055 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5;
1056 COUNT(c1) SUM(c1)
1057 0 NULL
1058 REPLACE t1 VALUES (5);
1059 SELECT COUNT(c1),SUM(c1) FROM t1;
1060 COUNT(c1) SUM(c1)
1061 1 5
1062 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5;
1063 COUNT(c1) SUM(c1)
1064 1 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;
1072 COUNT(c1) SUM(c1)
1073 0 NULL
1074 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5;
1075 COUNT(c1) SUM(c1)
1076 0 NULL
1077 REPLACE t1 VALUES (5);
1078 SELECT COUNT(c1),SUM(c1) FROM t1;
1079 COUNT(c1) SUM(c1)
1080 1 5
1081 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5;
1082 COUNT(c1) SUM(c1)
1083 1 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;
1091 COUNT(c1) SUM(c1)
1092 0 NULL
1093 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5;
1094 COUNT(c1) SUM(c1)
1095 0 NULL
1096 REPLACE t1 VALUES (5);
1097 SELECT COUNT(c1),SUM(c1) FROM t1;
1098 COUNT(c1) SUM(c1)
1099 1 5
1100 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5;
1101 COUNT(c1) SUM(c1)
1102 1 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;
1110 COUNT(c1) SUM(c1)
1111 0 NULL
1112 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5;
1113 COUNT(c1) SUM(c1)
1114 0 NULL
1115 REPLACE t1 VALUES (5);
1116 SELECT COUNT(c1),SUM(c1) FROM t1;
1117 COUNT(c1) SUM(c1)
1118 1 5
1119 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5;
1120 COUNT(c1) SUM(c1)
1121 1 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;
1129 COUNT(c1) SUM(c1)
1130 0 NULL
1131 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5;
1132 COUNT(c1) SUM(c1)
1133 0 NULL
1134 REPLACE t1 VALUES (5);
1135 SELECT COUNT(c1),SUM(c1) FROM t1;
1136 COUNT(c1) SUM(c1)
1137 1 5
1138 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5;
1139 COUNT(c1) SUM(c1)
1140 1 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;
1148 COUNT(c1) SUM(c1)
1149 10 45
1150 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5;
1151 COUNT(c1) SUM(c1)
1152 5 35
1153 REPLACE t2 VALUES (5);
1154 SELECT COUNT(c1),SUM(c1) FROM t2;
1155 COUNT(c1) SUM(c1)
1156 10 45
1157 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5;
1158 COUNT(c1) SUM(c1)
1159 5 35
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;
1167 COUNT(c1) SUM(c1)
1168 10 45
1169 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5;
1170 COUNT(c1) SUM(c1)
1171 5 35
1172 REPLACE t2 VALUES (5);
1173 SELECT COUNT(c1),SUM(c1) FROM t2;
1174 COUNT(c1) SUM(c1)
1175 10 45
1176 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5;
1177 COUNT(c1) SUM(c1)
1178 5 35
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;
1186 COUNT(c1) SUM(c1)
1187 10 45
1188 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5;
1189 COUNT(c1) SUM(c1)
1190 5 35
1191 REPLACE t2 VALUES (5);
1192 SELECT COUNT(c1),SUM(c1) FROM t2;
1193 COUNT(c1) SUM(c1)
1194 10 45
1195 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5;
1196 COUNT(c1) SUM(c1)
1197 5 35
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;
1205 COUNT(c1) SUM(c1)
1206 10 45
1207 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5;
1208 COUNT(c1) SUM(c1)
1209 5 35
1210 REPLACE t2 VALUES (5);
1211 SELECT COUNT(c1),SUM(c1) FROM t2;
1212 COUNT(c1) SUM(c1)
1213 10 45
1214 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5;
1215 COUNT(c1) SUM(c1)
1216 5 35
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;
1224 COUNT(c1) SUM(c1)
1225 10 45
1226 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5;
1227 COUNT(c1) SUM(c1)
1228 5 35
1229 REPLACE t2 VALUES (5);
1230 SELECT COUNT(c1),SUM(c1) FROM t2;
1231 COUNT(c1) SUM(c1)
1232 10 45
1233 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5;
1234 COUNT(c1) SUM(c1)
1235 5 35
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;
1243 COUNT(c1) SUM(c1)
1244 10 45
1245 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5;
1246 COUNT(c1) SUM(c1)
1247 5 35
1248 REPLACE t2 VALUES (5);
1249 SELECT COUNT(c1),SUM(c1) FROM t2;
1250 COUNT(c1) SUM(c1)
1251 10 45
1252 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5;
1253 COUNT(c1) SUM(c1)
1254 5 35
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;
1262 COUNT(c1) SUM(c1)
1263 1 5
1264 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5;
1265 COUNT(c1) SUM(c1)
1266 1 5
1267 REPLACE t3 VALUES (5);
1268 SELECT COUNT(c1),SUM(c1) FROM t3;
1269 COUNT(c1) SUM(c1)
1270 1 5
1271 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5;
1272 COUNT(c1) SUM(c1)
1273 1 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;
1281 COUNT(c1) SUM(c1)
1282 1 5
1283 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5;
1284 COUNT(c1) SUM(c1)
1285 1 5
1286 REPLACE t3 VALUES (5);
1287 SELECT COUNT(c1),SUM(c1) FROM t3;
1288 COUNT(c1) SUM(c1)
1289 1 5
1290 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5;
1291 COUNT(c1) SUM(c1)
1292 1 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;
1300 COUNT(c1) SUM(c1)
1301 1 5
1302 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5;
1303 COUNT(c1) SUM(c1)
1304 1 5
1305 REPLACE t3 VALUES (5);
1306 SELECT COUNT(c1),SUM(c1) FROM t3;
1307 COUNT(c1) SUM(c1)
1308 1 5
1309 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5;
1310 COUNT(c1) SUM(c1)
1311 1 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;
1319 COUNT(c1) SUM(c1)
1320 1 5
1321 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5;
1322 COUNT(c1) SUM(c1)
1323 1 5
1324 REPLACE t3 VALUES (5);
1325 SELECT COUNT(c1),SUM(c1) FROM t3;
1326 COUNT(c1) SUM(c1)
1327 1 5
1328 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5;
1329 COUNT(c1) SUM(c1)
1330 1 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;
1338 COUNT(c1) SUM(c1)
1339 1 5
1340 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5;
1341 COUNT(c1) SUM(c1)
1342 1 5
1343 REPLACE t3 VALUES (5);
1344 SELECT COUNT(c1),SUM(c1) FROM t3;
1345 COUNT(c1) SUM(c1)
1346 1 5
1347 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5;
1348 COUNT(c1) SUM(c1)
1349 1 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;
1357 COUNT(c1) SUM(c1)
1358 1 5
1359 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5;
1360 COUNT(c1) SUM(c1)
1361 1 5
1362 REPLACE t3 VALUES (5);
1363 SELECT COUNT(c1),SUM(c1) FROM t3;
1364 COUNT(c1) SUM(c1)
1365 1 5
1366 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5;
1367 COUNT(c1) SUM(c1)
1368 1 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;
1376 COUNT(c1) SUM(c1)
1377 0 NULL
1378 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5;
1379 COUNT(c1) SUM(c1)
1380 0 NULL
1381 REPLACE t1 VALUES (5);
1382 SELECT COUNT(c1),SUM(c1) FROM t1;
1383 COUNT(c1) SUM(c1)
1384 1 5
1385 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5;
1386 COUNT(c1) SUM(c1)
1387 0 NULL
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;
1395 COUNT(c1) SUM(c1)
1396 0 NULL
1397 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5;
1398 COUNT(c1) SUM(c1)
1399 0 NULL
1400 REPLACE t1 VALUES (5);
1401 SELECT COUNT(c1),SUM(c1) FROM t1;
1402 COUNT(c1) SUM(c1)
1403 1 5
1404 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5;
1405 COUNT(c1) SUM(c1)
1406 0 NULL
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;
1414 COUNT(c1) SUM(c1)
1415 0 NULL
1416 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5;
1417 COUNT(c1) SUM(c1)
1418 0 NULL
1419 REPLACE t1 VALUES (5);
1420 SELECT COUNT(c1),SUM(c1) FROM t1;
1421 COUNT(c1) SUM(c1)
1422 1 5
1423 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5;
1424 COUNT(c1) SUM(c1)
1425 0 NULL
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;
1433 COUNT(c1) SUM(c1)
1434 0 NULL
1435 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5;
1436 COUNT(c1) SUM(c1)
1437 0 NULL
1438 REPLACE t1 VALUES (5);
1439 SELECT COUNT(c1),SUM(c1) FROM t1;
1440 COUNT(c1) SUM(c1)
1441 1 5
1442 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5;
1443 COUNT(c1) SUM(c1)
1444 0 NULL
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;
1452 COUNT(c1) SUM(c1)
1453 0 NULL
1454 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5;
1455 COUNT(c1) SUM(c1)
1456 0 NULL
1457 REPLACE t1 VALUES (5);
1458 SELECT COUNT(c1),SUM(c1) FROM t1;
1459 COUNT(c1) SUM(c1)
1460 1 5
1461 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5;
1462 COUNT(c1) SUM(c1)
1463 0 NULL
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;
1471 COUNT(c1) SUM(c1)
1472 0 NULL
1473 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5;
1474 COUNT(c1) SUM(c1)
1475 0 NULL
1476 REPLACE t1 VALUES (5);
1477 SELECT COUNT(c1),SUM(c1) FROM t1;
1478 COUNT(c1) SUM(c1)
1479 1 5
1480 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5;
1481 COUNT(c1) SUM(c1)
1482 0 NULL
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;
1490 COUNT(c1) SUM(c1)
1491 10 45
1492 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5;
1493 COUNT(c1) SUM(c1)
1494 9 40
1495 REPLACE t2 VALUES (5);
1496 SELECT COUNT(c1),SUM(c1) FROM t2;
1497 COUNT(c1) SUM(c1)
1498 10 45
1499 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5;
1500 COUNT(c1) SUM(c1)
1501 9 40
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;
1509 COUNT(c1) SUM(c1)
1510 10 45
1511 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5;
1512 COUNT(c1) SUM(c1)
1513 9 40
1514 REPLACE t2 VALUES (5);
1515 SELECT COUNT(c1),SUM(c1) FROM t2;
1516 COUNT(c1) SUM(c1)
1517 10 45
1518 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5;
1519 COUNT(c1) SUM(c1)
1520 9 40
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;
1528 COUNT(c1) SUM(c1)
1529 10 45
1530 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5;
1531 COUNT(c1) SUM(c1)
1532 9 40
1533 REPLACE t2 VALUES (5);
1534 SELECT COUNT(c1),SUM(c1) FROM t2;
1535 COUNT(c1) SUM(c1)
1536 10 45
1537 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5;
1538 COUNT(c1) SUM(c1)
1539 9 40
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;
1547 COUNT(c1) SUM(c1)
1548 10 45
1549 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5;
1550 COUNT(c1) SUM(c1)
1551 9 40
1552 REPLACE t2 VALUES (5);
1553 SELECT COUNT(c1),SUM(c1) FROM t2;
1554 COUNT(c1) SUM(c1)
1555 10 45
1556 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5;
1557 COUNT(c1) SUM(c1)
1558 9 40
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;
1566 COUNT(c1) SUM(c1)
1567 10 45
1568 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5;
1569 COUNT(c1) SUM(c1)
1570 9 40
1571 REPLACE t2 VALUES (5);
1572 SELECT COUNT(c1),SUM(c1) FROM t2;
1573 COUNT(c1) SUM(c1)
1574 10 45
1575 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5;
1576 COUNT(c1) SUM(c1)
1577 9 40
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;
1585 COUNT(c1) SUM(c1)
1586 10 45
1587 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5;
1588 COUNT(c1) SUM(c1)
1589 9 40
1590 REPLACE t2 VALUES (5);
1591 SELECT COUNT(c1),SUM(c1) FROM t2;
1592 COUNT(c1) SUM(c1)
1593 10 45
1594 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5;
1595 COUNT(c1) SUM(c1)
1596 9 40
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;
1604 COUNT(c1) SUM(c1)
1605 1 5
1606 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5;
1607 COUNT(c1) SUM(c1)
1608 0 NULL
1609 REPLACE t3 VALUES (5);
1610 SELECT COUNT(c1),SUM(c1) FROM t3;
1611 COUNT(c1) SUM(c1)
1612 1 5
1613 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5;
1614 COUNT(c1) SUM(c1)
1615 0 NULL
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;
1623 COUNT(c1) SUM(c1)
1624 1 5
1625 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5;
1626 COUNT(c1) SUM(c1)
1627 0 NULL
1628 REPLACE t3 VALUES (5);
1629 SELECT COUNT(c1),SUM(c1) FROM t3;
1630 COUNT(c1) SUM(c1)
1631 1 5
1632 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5;
1633 COUNT(c1) SUM(c1)
1634 0 NULL
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;
1642 COUNT(c1) SUM(c1)
1643 1 5
1644 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5;
1645 COUNT(c1) SUM(c1)
1646 0 NULL
1647 REPLACE t3 VALUES (5);
1648 SELECT COUNT(c1),SUM(c1) FROM t3;
1649 COUNT(c1) SUM(c1)
1650 1 5
1651 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5;
1652 COUNT(c1) SUM(c1)
1653 0 NULL
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;
1661 COUNT(c1) SUM(c1)
1662 1 5
1663 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5;
1664 COUNT(c1) SUM(c1)
1665 0 NULL
1666 REPLACE t3 VALUES (5);
1667 SELECT COUNT(c1),SUM(c1) FROM t3;
1668 COUNT(c1) SUM(c1)
1669 1 5
1670 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5;
1671 COUNT(c1) SUM(c1)
1672 0 NULL
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;
1680 COUNT(c1) SUM(c1)
1681 1 5
1682 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5;
1683 COUNT(c1) SUM(c1)
1684 0 NULL
1685 REPLACE t3 VALUES (5);
1686 SELECT COUNT(c1),SUM(c1) FROM t3;
1687 COUNT(c1) SUM(c1)
1688 1 5
1689 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5;
1690 COUNT(c1) SUM(c1)
1691 0 NULL
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;
1699 COUNT(c1) SUM(c1)
1700 1 5
1701 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5;
1702 COUNT(c1) SUM(c1)
1703 0 NULL
1704 REPLACE t3 VALUES (5);
1705 SELECT COUNT(c1),SUM(c1) FROM t3;
1706 COUNT(c1) SUM(c1)
1707 1 5
1708 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5;
1709 COUNT(c1) SUM(c1)
1710 0 NULL
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;
1718 COUNT(c1) SUM(c1)
1719 0 NULL
1720 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5;
1721 COUNT(c1) SUM(c1)
1722 0 NULL
1723 REPLACE t1 VALUES (5);
1724 SELECT COUNT(c1),SUM(c1) FROM t1;
1725 COUNT(c1) SUM(c1)
1726 1 5
1727 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5;
1728 COUNT(c1) SUM(c1)
1729 0 NULL
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;
1737 COUNT(c1) SUM(c1)
1738 0 NULL
1739 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5;
1740 COUNT(c1) SUM(c1)
1741 0 NULL
1742 REPLACE t1 VALUES (5);
1743 SELECT COUNT(c1),SUM(c1) FROM t1;
1744 COUNT(c1) SUM(c1)
1745 1 5
1746 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5;
1747 COUNT(c1) SUM(c1)
1748 0 NULL
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;
1756 COUNT(c1) SUM(c1)
1757 0 NULL
1758 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5;
1759 COUNT(c1) SUM(c1)
1760 0 NULL
1761 REPLACE t1 VALUES (5);
1762 SELECT COUNT(c1),SUM(c1) FROM t1;
1763 COUNT(c1) SUM(c1)
1764 1 5
1765 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5;
1766 COUNT(c1) SUM(c1)
1767 0 NULL
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;
1775 COUNT(c1) SUM(c1)
1776 0 NULL
1777 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5;
1778 COUNT(c1) SUM(c1)
1779 0 NULL
1780 REPLACE t1 VALUES (5);
1781 SELECT COUNT(c1),SUM(c1) FROM t1;
1782 COUNT(c1) SUM(c1)
1783 1 5
1784 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5;
1785 COUNT(c1) SUM(c1)
1786 0 NULL
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;
1794 COUNT(c1) SUM(c1)
1795 0 NULL
1796 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5;
1797 COUNT(c1) SUM(c1)
1798 0 NULL
1799 REPLACE t1 VALUES (5);
1800 SELECT COUNT(c1),SUM(c1) FROM t1;
1801 COUNT(c1) SUM(c1)
1802 1 5
1803 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5;
1804 COUNT(c1) SUM(c1)
1805 0 NULL
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;
1813 COUNT(c1) SUM(c1)
1814 0 NULL
1815 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5;
1816 COUNT(c1) SUM(c1)
1817 0 NULL
1818 REPLACE t1 VALUES (5);
1819 SELECT COUNT(c1),SUM(c1) FROM t1;
1820 COUNT(c1) SUM(c1)
1821 1 5
1822 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5;
1823 COUNT(c1) SUM(c1)
1824 0 NULL
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;
1832 COUNT(c1) SUM(c1)
1833 10 45
1834 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5;
1835 COUNT(c1) SUM(c1)
1836 9 40
1837 REPLACE t2 VALUES (5);
1838 SELECT COUNT(c1),SUM(c1) FROM t2;
1839 COUNT(c1) SUM(c1)
1840 10 45
1841 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5;
1842 COUNT(c1) SUM(c1)
1843 9 40
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;
1851 COUNT(c1) SUM(c1)
1852 10 45
1853 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5;
1854 COUNT(c1) SUM(c1)
1855 9 40
1856 REPLACE t2 VALUES (5);
1857 SELECT COUNT(c1),SUM(c1) FROM t2;
1858 COUNT(c1) SUM(c1)
1859 10 45
1860 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5;
1861 COUNT(c1) SUM(c1)
1862 9 40
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;
1870 COUNT(c1) SUM(c1)
1871 10 45
1872 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5;
1873 COUNT(c1) SUM(c1)
1874 9 40
1875 REPLACE t2 VALUES (5);
1876 SELECT COUNT(c1),SUM(c1) FROM t2;
1877 COUNT(c1) SUM(c1)
1878 10 45
1879 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5;
1880 COUNT(c1) SUM(c1)
1881 9 40
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;
1889 COUNT(c1) SUM(c1)
1890 10 45
1891 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5;
1892 COUNT(c1) SUM(c1)
1893 9 40
1894 REPLACE t2 VALUES (5);
1895 SELECT COUNT(c1),SUM(c1) FROM t2;
1896 COUNT(c1) SUM(c1)
1897 10 45
1898 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5;
1899 COUNT(c1) SUM(c1)
1900 9 40
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;
1908 COUNT(c1) SUM(c1)
1909 10 45
1910 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5;
1911 COUNT(c1) SUM(c1)
1912 9 40
1913 REPLACE t2 VALUES (5);
1914 SELECT COUNT(c1),SUM(c1) FROM t2;
1915 COUNT(c1) SUM(c1)
1916 10 45
1917 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5;
1918 COUNT(c1) SUM(c1)
1919 9 40
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;
1927 COUNT(c1) SUM(c1)
1928 10 45
1929 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5;
1930 COUNT(c1) SUM(c1)
1931 9 40
1932 REPLACE t2 VALUES (5);
1933 SELECT COUNT(c1),SUM(c1) FROM t2;
1934 COUNT(c1) SUM(c1)
1935 10 45
1936 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5;
1937 COUNT(c1) SUM(c1)
1938 9 40
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;
1946 COUNT(c1) SUM(c1)
1947 1 5
1948 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5;
1949 COUNT(c1) SUM(c1)
1950 0 NULL
1951 REPLACE t3 VALUES (5);
1952 SELECT COUNT(c1),SUM(c1) FROM t3;
1953 COUNT(c1) SUM(c1)
1954 1 5
1955 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5;
1956 COUNT(c1) SUM(c1)
1957 0 NULL
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;
1965 COUNT(c1) SUM(c1)
1966 1 5
1967 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5;
1968 COUNT(c1) SUM(c1)
1969 0 NULL
1970 REPLACE t3 VALUES (5);
1971 SELECT COUNT(c1),SUM(c1) FROM t3;
1972 COUNT(c1) SUM(c1)
1973 1 5
1974 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5;
1975 COUNT(c1) SUM(c1)
1976 0 NULL
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;
1984 COUNT(c1) SUM(c1)
1985 1 5
1986 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5;
1987 COUNT(c1) SUM(c1)
1988 0 NULL
1989 REPLACE t3 VALUES (5);
1990 SELECT COUNT(c1),SUM(c1) FROM t3;
1991 COUNT(c1) SUM(c1)
1992 1 5
1993 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5;
1994 COUNT(c1) SUM(c1)
1995 0 NULL
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;
2003 COUNT(c1) SUM(c1)
2004 1 5
2005 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5;
2006 COUNT(c1) SUM(c1)
2007 0 NULL
2008 REPLACE t3 VALUES (5);
2009 SELECT COUNT(c1),SUM(c1) FROM t3;
2010 COUNT(c1) SUM(c1)
2011 1 5
2012 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5;
2013 COUNT(c1) SUM(c1)
2014 0 NULL
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;
2022 COUNT(c1) SUM(c1)
2023 1 5
2024 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5;
2025 COUNT(c1) SUM(c1)
2026 0 NULL
2027 REPLACE t3 VALUES (5);
2028 SELECT COUNT(c1),SUM(c1) FROM t3;
2029 COUNT(c1) SUM(c1)
2030 1 5
2031 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5;
2032 COUNT(c1) SUM(c1)
2033 0 NULL
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;
2041 COUNT(c1) SUM(c1)
2042 1 5
2043 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5;
2044 COUNT(c1) SUM(c1)
2045 0 NULL
2046 REPLACE t3 VALUES (5);
2047 SELECT COUNT(c1),SUM(c1) FROM t3;
2048 COUNT(c1) SUM(c1)
2049 1 5
2050 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5;
2051 COUNT(c1) SUM(c1)
2052 0 NULL
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;
2060 COUNT(c1) SUM(c1)
2061 0 NULL
2062 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5;
2063 COUNT(c1) SUM(c1)
2064 0 NULL
2065 REPLACE t1 VALUES (5);
2066 SELECT COUNT(c1),SUM(c1) FROM t1;
2067 COUNT(c1) SUM(c1)
2068 1 5
2069 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5;
2070 COUNT(c1) SUM(c1)
2071 1 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;
2079 COUNT(c1) SUM(c1)
2080 0 NULL
2081 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5;
2082 COUNT(c1) SUM(c1)
2083 0 NULL
2084 REPLACE t1 VALUES (5);
2085 SELECT COUNT(c1),SUM(c1) FROM t1;
2086 COUNT(c1) SUM(c1)
2087 1 5
2088 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5;
2089 COUNT(c1) SUM(c1)
2090 1 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;
2098 COUNT(c1) SUM(c1)
2099 0 NULL
2100 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5;
2101 COUNT(c1) SUM(c1)
2102 0 NULL
2103 REPLACE t1 VALUES (5);
2104 SELECT COUNT(c1),SUM(c1) FROM t1;
2105 COUNT(c1) SUM(c1)
2106 1 5
2107 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5;
2108 COUNT(c1) SUM(c1)
2109 1 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;
2117 COUNT(c1) SUM(c1)
2118 0 NULL
2119 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5;
2120 COUNT(c1) SUM(c1)
2121 0 NULL
2122 REPLACE t1 VALUES (5);
2123 SELECT COUNT(c1),SUM(c1) FROM t1;
2124 COUNT(c1) SUM(c1)
2125 1 5
2126 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5;
2127 COUNT(c1) SUM(c1)
2128 1 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;
2136 COUNT(c1) SUM(c1)
2137 0 NULL
2138 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5;
2139 COUNT(c1) SUM(c1)
2140 0 NULL
2141 REPLACE t1 VALUES (5);
2142 SELECT COUNT(c1),SUM(c1) FROM t1;
2143 COUNT(c1) SUM(c1)
2144 1 5
2145 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5;
2146 COUNT(c1) SUM(c1)
2147 1 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;
2155 COUNT(c1) SUM(c1)
2156 0 NULL
2157 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5;
2158 COUNT(c1) SUM(c1)
2159 0 NULL
2160 REPLACE t1 VALUES (5);
2161 SELECT COUNT(c1),SUM(c1) FROM t1;
2162 COUNT(c1) SUM(c1)
2163 1 5
2164 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5;
2165 COUNT(c1) SUM(c1)
2166 1 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;
2174 COUNT(c1) SUM(c1)
2175 10 45
2176 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5;
2177 COUNT(c1) SUM(c1)
2178 1 5
2179 REPLACE t2 VALUES (5);
2180 SELECT COUNT(c1),SUM(c1) FROM t2;
2181 COUNT(c1) SUM(c1)
2182 10 45
2183 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5;
2184 COUNT(c1) SUM(c1)
2185 1 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;
2193 COUNT(c1) SUM(c1)
2194 10 45
2195 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5;
2196 COUNT(c1) SUM(c1)
2197 1 5
2198 REPLACE t2 VALUES (5);
2199 SELECT COUNT(c1),SUM(c1) FROM t2;
2200 COUNT(c1) SUM(c1)
2201 10 45
2202 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5;
2203 COUNT(c1) SUM(c1)
2204 1 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;
2212 COUNT(c1) SUM(c1)
2213 10 45
2214 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5;
2215 COUNT(c1) SUM(c1)
2216 1 5
2217 REPLACE t2 VALUES (5);
2218 SELECT COUNT(c1),SUM(c1) FROM t2;
2219 COUNT(c1) SUM(c1)
2220 10 45
2221 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5;
2222 COUNT(c1) SUM(c1)
2223 1 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;
2231 COUNT(c1) SUM(c1)
2232 10 45
2233 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5;
2234 COUNT(c1) SUM(c1)
2235 1 5
2236 REPLACE t2 VALUES (5);
2237 SELECT COUNT(c1),SUM(c1) FROM t2;
2238 COUNT(c1) SUM(c1)
2239 10 45
2240 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5;
2241 COUNT(c1) SUM(c1)
2242 1 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;
2250 COUNT(c1) SUM(c1)
2251 10 45
2252 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5;
2253 COUNT(c1) SUM(c1)
2254 1 5
2255 REPLACE t2 VALUES (5);
2256 SELECT COUNT(c1),SUM(c1) FROM t2;
2257 COUNT(c1) SUM(c1)
2258 10 45
2259 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5;
2260 COUNT(c1) SUM(c1)
2261 1 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;
2269 COUNT(c1) SUM(c1)
2270 10 45
2271 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5;
2272 COUNT(c1) SUM(c1)
2273 1 5
2274 REPLACE t2 VALUES (5);
2275 SELECT COUNT(c1),SUM(c1) FROM t2;
2276 COUNT(c1) SUM(c1)
2277 10 45
2278 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5;
2279 COUNT(c1) SUM(c1)
2280 1 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;
2288 COUNT(c1) SUM(c1)
2289 1 5
2290 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5;
2291 COUNT(c1) SUM(c1)
2292 1 5
2293 REPLACE t3 VALUES (5);
2294 SELECT COUNT(c1),SUM(c1) FROM t3;
2295 COUNT(c1) SUM(c1)
2296 1 5
2297 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5;
2298 COUNT(c1) SUM(c1)
2299 1 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;
2307 COUNT(c1) SUM(c1)
2308 1 5
2309 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5;
2310 COUNT(c1) SUM(c1)
2311 1 5
2312 REPLACE t3 VALUES (5);
2313 SELECT COUNT(c1),SUM(c1) FROM t3;
2314 COUNT(c1) SUM(c1)
2315 1 5
2316 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5;
2317 COUNT(c1) SUM(c1)
2318 1 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;
2326 COUNT(c1) SUM(c1)
2327 1 5
2328 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5;
2329 COUNT(c1) SUM(c1)
2330 1 5
2331 REPLACE t3 VALUES (5);
2332 SELECT COUNT(c1),SUM(c1) FROM t3;
2333 COUNT(c1) SUM(c1)
2334 1 5
2335 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5;
2336 COUNT(c1) SUM(c1)
2337 1 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;
2345 COUNT(c1) SUM(c1)
2346 1 5
2347 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5;
2348 COUNT(c1) SUM(c1)
2349 1 5
2350 REPLACE t3 VALUES (5);
2351 SELECT COUNT(c1),SUM(c1) FROM t3;
2352 COUNT(c1) SUM(c1)
2353 1 5
2354 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5;
2355 COUNT(c1) SUM(c1)
2356 1 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;
2364 COUNT(c1) SUM(c1)
2365 1 5
2366 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5;
2367 COUNT(c1) SUM(c1)
2368 1 5
2369 REPLACE t3 VALUES (5);
2370 SELECT COUNT(c1),SUM(c1) FROM t3;
2371 COUNT(c1) SUM(c1)
2372 1 5
2373 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5;
2374 COUNT(c1) SUM(c1)
2375 1 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;
2383 COUNT(c1) SUM(c1)
2384 1 5
2385 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5;
2386 COUNT(c1) SUM(c1)
2387 1 5
2388 REPLACE t3 VALUES (5);
2389 SELECT COUNT(c1),SUM(c1) FROM t3;
2390 COUNT(c1) SUM(c1)
2391 1 5
2392 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5;
2393 COUNT(c1) SUM(c1)
2394 1 5
2395 DROP TABLE t1,t2,t3;