Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1,t2,t3;
2 CREATE TABLE t1(c1 TINYINT NOT NULL);
3 CREATE TABLE t2(c1 TINYINT NOT NULL);
4 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
5 CREATE TABLE t3(c1 TINYINT NOT NULL);
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 UPDATE t1 SET c1 = c1 + 1 WHERE c1 < 5;
14 SELECT COUNT(c1),SUM(c1) FROM t1;
15 COUNT(c1) SUM(c1)
16 0 NULL
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);
22 CREATE TABLE t2(c1 SMALLINT NOT NULL);
23 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
24 CREATE TABLE t3(c1 SMALLINT NOT NULL);
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 UPDATE t1 SET c1 = c1 + 1 WHERE c1 < 5;
33 SELECT COUNT(c1),SUM(c1) FROM t1;
34 COUNT(c1) SUM(c1)
35 0 NULL
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);
41 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
42 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
43 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
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 UPDATE t1 SET c1 = c1 + 1 WHERE c1 < 5;
52 SELECT COUNT(c1),SUM(c1) FROM t1;
53 COUNT(c1) SUM(c1)
54 0 NULL
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);
60 CREATE TABLE t2(c1 INT NOT NULL);
61 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
62 CREATE TABLE t3(c1 INT NOT NULL);
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 UPDATE t1 SET c1 = c1 + 1 WHERE c1 < 5;
71 SELECT COUNT(c1),SUM(c1) FROM t1;
72 COUNT(c1) SUM(c1)
73 0 NULL
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);
79 CREATE TABLE t2(c1 INTEGER NOT NULL);
80 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
81 CREATE TABLE t3(c1 INTEGER NOT NULL);
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 UPDATE t1 SET c1 = c1 + 1 WHERE c1 < 5;
90 SELECT COUNT(c1),SUM(c1) FROM t1;
91 COUNT(c1) SUM(c1)
92 0 NULL
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);
98 CREATE TABLE t2(c1 BIGINT NOT NULL);
99 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
100 CREATE TABLE t3(c1 BIGINT NOT NULL);
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 UPDATE t1 SET c1 = c1 + 1 WHERE c1 < 5;
109 SELECT COUNT(c1),SUM(c1) FROM t1;
110 COUNT(c1) SUM(c1)
111 0 NULL
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);
117 CREATE TABLE t2(c1 TINYINT NOT NULL);
118 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
119 CREATE TABLE t3(c1 TINYINT NOT NULL);
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 UPDATE t2 SET c1 = c1 + 1 WHERE c1 < 5;
128 SELECT COUNT(c1),SUM(c1) FROM t2;
129 COUNT(c1) SUM(c1)
130 10 50
131 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5;
132 COUNT(c1) SUM(c1)
133 4 10
134 DROP TABLE t1,t2,t3;
135 CREATE TABLE t1(c1 SMALLINT NOT NULL);
136 CREATE TABLE t2(c1 SMALLINT NOT NULL);
137 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
138 CREATE TABLE t3(c1 SMALLINT NOT NULL);
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 UPDATE t2 SET c1 = c1 + 1 WHERE c1 < 5;
147 SELECT COUNT(c1),SUM(c1) FROM t2;
148 COUNT(c1) SUM(c1)
149 10 50
150 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5;
151 COUNT(c1) SUM(c1)
152 4 10
153 DROP TABLE t1,t2,t3;
154 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
155 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
156 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
157 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
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 UPDATE t2 SET c1 = c1 + 1 WHERE c1 < 5;
166 SELECT COUNT(c1),SUM(c1) FROM t2;
167 COUNT(c1) SUM(c1)
168 10 50
169 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5;
170 COUNT(c1) SUM(c1)
171 4 10
172 DROP TABLE t1,t2,t3;
173 CREATE TABLE t1(c1 INT NOT NULL);
174 CREATE TABLE t2(c1 INT NOT NULL);
175 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
176 CREATE TABLE t3(c1 INT NOT NULL);
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 UPDATE t2 SET c1 = c1 + 1 WHERE c1 < 5;
185 SELECT COUNT(c1),SUM(c1) FROM t2;
186 COUNT(c1) SUM(c1)
187 10 50
188 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5;
189 COUNT(c1) SUM(c1)
190 4 10
191 DROP TABLE t1,t2,t3;
192 CREATE TABLE t1(c1 INTEGER NOT NULL);
193 CREATE TABLE t2(c1 INTEGER NOT NULL);
194 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
195 CREATE TABLE t3(c1 INTEGER NOT NULL);
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 UPDATE t2 SET c1 = c1 + 1 WHERE c1 < 5;
204 SELECT COUNT(c1),SUM(c1) FROM t2;
205 COUNT(c1) SUM(c1)
206 10 50
207 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5;
208 COUNT(c1) SUM(c1)
209 4 10
210 DROP TABLE t1,t2,t3;
211 CREATE TABLE t1(c1 BIGINT NOT NULL);
212 CREATE TABLE t2(c1 BIGINT NOT NULL);
213 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
214 CREATE TABLE t3(c1 BIGINT NOT NULL);
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 UPDATE t2 SET c1 = c1 + 1 WHERE c1 < 5;
223 SELECT COUNT(c1),SUM(c1) FROM t2;
224 COUNT(c1) SUM(c1)
225 10 50
226 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5;
227 COUNT(c1) SUM(c1)
228 4 10
229 DROP TABLE t1,t2,t3;
230 CREATE TABLE t1(c1 TINYINT NOT NULL);
231 CREATE TABLE t2(c1 TINYINT NOT NULL);
232 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
233 CREATE TABLE t3(c1 TINYINT NOT NULL);
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 UPDATE t3 SET c1 = c1 + 1 WHERE c1 < 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);
250 CREATE TABLE t2(c1 SMALLINT NOT NULL);
251 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
252 CREATE TABLE t3(c1 SMALLINT NOT NULL);
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 UPDATE t3 SET c1 = c1 + 1 WHERE c1 < 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);
269 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
270 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
271 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
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 UPDATE t3 SET c1 = c1 + 1 WHERE c1 < 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);
288 CREATE TABLE t2(c1 INT NOT NULL);
289 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
290 CREATE TABLE t3(c1 INT NOT NULL);
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 UPDATE t3 SET c1 = c1 + 1 WHERE c1 < 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);
307 CREATE TABLE t2(c1 INTEGER NOT NULL);
308 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
309 CREATE TABLE t3(c1 INTEGER NOT NULL);
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 UPDATE t3 SET c1 = c1 + 1 WHERE c1 < 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);
326 CREATE TABLE t2(c1 BIGINT NOT NULL);
327 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
328 CREATE TABLE t3(c1 BIGINT NOT NULL);
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 UPDATE t3 SET c1 = c1 + 1 WHERE c1 < 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);
345 CREATE TABLE t2(c1 TINYINT NOT NULL);
346 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
347 CREATE TABLE t3(c1 TINYINT NOT NULL);
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 UPDATE t1 SET c1 = c1 + 1 WHERE c1 <= 5;
356 SELECT COUNT(c1),SUM(c1) FROM t1;
357 COUNT(c1) SUM(c1)
358 0 NULL
359 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5;
360 COUNT(c1) SUM(c1)
361 0 NULL
362 DROP TABLE t1,t2,t3;
363 CREATE TABLE t1(c1 SMALLINT NOT NULL);
364 CREATE TABLE t2(c1 SMALLINT NOT NULL);
365 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
366 CREATE TABLE t3(c1 SMALLINT NOT NULL);
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 UPDATE t1 SET c1 = c1 + 1 WHERE c1 <= 5;
375 SELECT COUNT(c1),SUM(c1) FROM t1;
376 COUNT(c1) SUM(c1)
377 0 NULL
378 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5;
379 COUNT(c1) SUM(c1)
380 0 NULL
381 DROP TABLE t1,t2,t3;
382 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
383 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
384 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
385 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
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 UPDATE t1 SET c1 = c1 + 1 WHERE c1 <= 5;
394 SELECT COUNT(c1),SUM(c1) FROM t1;
395 COUNT(c1) SUM(c1)
396 0 NULL
397 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5;
398 COUNT(c1) SUM(c1)
399 0 NULL
400 DROP TABLE t1,t2,t3;
401 CREATE TABLE t1(c1 INT NOT NULL);
402 CREATE TABLE t2(c1 INT NOT NULL);
403 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
404 CREATE TABLE t3(c1 INT NOT NULL);
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 UPDATE t1 SET c1 = c1 + 1 WHERE c1 <= 5;
413 SELECT COUNT(c1),SUM(c1) FROM t1;
414 COUNT(c1) SUM(c1)
415 0 NULL
416 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5;
417 COUNT(c1) SUM(c1)
418 0 NULL
419 DROP TABLE t1,t2,t3;
420 CREATE TABLE t1(c1 INTEGER NOT NULL);
421 CREATE TABLE t2(c1 INTEGER NOT NULL);
422 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
423 CREATE TABLE t3(c1 INTEGER NOT NULL);
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 UPDATE t1 SET c1 = c1 + 1 WHERE c1 <= 5;
432 SELECT COUNT(c1),SUM(c1) FROM t1;
433 COUNT(c1) SUM(c1)
434 0 NULL
435 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5;
436 COUNT(c1) SUM(c1)
437 0 NULL
438 DROP TABLE t1,t2,t3;
439 CREATE TABLE t1(c1 BIGINT NOT NULL);
440 CREATE TABLE t2(c1 BIGINT NOT NULL);
441 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
442 CREATE TABLE t3(c1 BIGINT NOT NULL);
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 UPDATE t1 SET c1 = c1 + 1 WHERE c1 <= 5;
451 SELECT COUNT(c1),SUM(c1) FROM t1;
452 COUNT(c1) SUM(c1)
453 0 NULL
454 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5;
455 COUNT(c1) SUM(c1)
456 0 NULL
457 DROP TABLE t1,t2,t3;
458 CREATE TABLE t1(c1 TINYINT NOT NULL);
459 CREATE TABLE t2(c1 TINYINT NOT NULL);
460 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
461 CREATE TABLE t3(c1 TINYINT NOT NULL);
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 UPDATE t2 SET c1 = c1 + 1 WHERE c1 <= 5;
470 SELECT COUNT(c1),SUM(c1) FROM t2;
471 COUNT(c1) SUM(c1)
472 10 51
473 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5;
474 COUNT(c1) SUM(c1)
475 5 15
476 DROP TABLE t1,t2,t3;
477 CREATE TABLE t1(c1 SMALLINT NOT NULL);
478 CREATE TABLE t2(c1 SMALLINT NOT NULL);
479 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
480 CREATE TABLE t3(c1 SMALLINT NOT NULL);
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 UPDATE t2 SET c1 = c1 + 1 WHERE c1 <= 5;
489 SELECT COUNT(c1),SUM(c1) FROM t2;
490 COUNT(c1) SUM(c1)
491 10 51
492 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5;
493 COUNT(c1) SUM(c1)
494 5 15
495 DROP TABLE t1,t2,t3;
496 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
497 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
498 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
499 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
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 UPDATE t2 SET c1 = c1 + 1 WHERE c1 <= 5;
508 SELECT COUNT(c1),SUM(c1) FROM t2;
509 COUNT(c1) SUM(c1)
510 10 51
511 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5;
512 COUNT(c1) SUM(c1)
513 5 15
514 DROP TABLE t1,t2,t3;
515 CREATE TABLE t1(c1 INT NOT NULL);
516 CREATE TABLE t2(c1 INT NOT NULL);
517 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
518 CREATE TABLE t3(c1 INT NOT NULL);
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 UPDATE t2 SET c1 = c1 + 1 WHERE c1 <= 5;
527 SELECT COUNT(c1),SUM(c1) FROM t2;
528 COUNT(c1) SUM(c1)
529 10 51
530 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5;
531 COUNT(c1) SUM(c1)
532 5 15
533 DROP TABLE t1,t2,t3;
534 CREATE TABLE t1(c1 INTEGER NOT NULL);
535 CREATE TABLE t2(c1 INTEGER NOT NULL);
536 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
537 CREATE TABLE t3(c1 INTEGER NOT NULL);
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 UPDATE t2 SET c1 = c1 + 1 WHERE c1 <= 5;
546 SELECT COUNT(c1),SUM(c1) FROM t2;
547 COUNT(c1) SUM(c1)
548 10 51
549 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5;
550 COUNT(c1) SUM(c1)
551 5 15
552 DROP TABLE t1,t2,t3;
553 CREATE TABLE t1(c1 BIGINT NOT NULL);
554 CREATE TABLE t2(c1 BIGINT NOT NULL);
555 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
556 CREATE TABLE t3(c1 BIGINT NOT NULL);
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 UPDATE t2 SET c1 = c1 + 1 WHERE c1 <= 5;
565 SELECT COUNT(c1),SUM(c1) FROM t2;
566 COUNT(c1) SUM(c1)
567 10 51
568 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5;
569 COUNT(c1) SUM(c1)
570 5 15
571 DROP TABLE t1,t2,t3;
572 CREATE TABLE t1(c1 TINYINT NOT NULL);
573 CREATE TABLE t2(c1 TINYINT NOT NULL);
574 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
575 CREATE TABLE t3(c1 TINYINT NOT NULL);
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 UPDATE t3 SET c1 = c1 + 1 WHERE c1 <= 5;
584 SELECT COUNT(c1),SUM(c1) FROM t3;
585 COUNT(c1) SUM(c1)
586 1 6
587 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5;
588 COUNT(c1) SUM(c1)
589 0 NULL
590 DROP TABLE t1,t2,t3;
591 CREATE TABLE t1(c1 SMALLINT NOT NULL);
592 CREATE TABLE t2(c1 SMALLINT NOT NULL);
593 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
594 CREATE TABLE t3(c1 SMALLINT NOT NULL);
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 UPDATE t3 SET c1 = c1 + 1 WHERE c1 <= 5;
603 SELECT COUNT(c1),SUM(c1) FROM t3;
604 COUNT(c1) SUM(c1)
605 1 6
606 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5;
607 COUNT(c1) SUM(c1)
608 0 NULL
609 DROP TABLE t1,t2,t3;
610 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
611 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
612 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
613 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
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 UPDATE t3 SET c1 = c1 + 1 WHERE c1 <= 5;
622 SELECT COUNT(c1),SUM(c1) FROM t3;
623 COUNT(c1) SUM(c1)
624 1 6
625 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5;
626 COUNT(c1) SUM(c1)
627 0 NULL
628 DROP TABLE t1,t2,t3;
629 CREATE TABLE t1(c1 INT NOT NULL);
630 CREATE TABLE t2(c1 INT NOT NULL);
631 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
632 CREATE TABLE t3(c1 INT NOT NULL);
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 UPDATE t3 SET c1 = c1 + 1 WHERE c1 <= 5;
641 SELECT COUNT(c1),SUM(c1) FROM t3;
642 COUNT(c1) SUM(c1)
643 1 6
644 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5;
645 COUNT(c1) SUM(c1)
646 0 NULL
647 DROP TABLE t1,t2,t3;
648 CREATE TABLE t1(c1 INTEGER NOT NULL);
649 CREATE TABLE t2(c1 INTEGER NOT NULL);
650 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
651 CREATE TABLE t3(c1 INTEGER NOT NULL);
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 UPDATE t3 SET c1 = c1 + 1 WHERE c1 <= 5;
660 SELECT COUNT(c1),SUM(c1) FROM t3;
661 COUNT(c1) SUM(c1)
662 1 6
663 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5;
664 COUNT(c1) SUM(c1)
665 0 NULL
666 DROP TABLE t1,t2,t3;
667 CREATE TABLE t1(c1 BIGINT NOT NULL);
668 CREATE TABLE t2(c1 BIGINT NOT NULL);
669 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
670 CREATE TABLE t3(c1 BIGINT NOT NULL);
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 UPDATE t3 SET c1 = c1 + 1 WHERE c1 <= 5;
679 SELECT COUNT(c1),SUM(c1) FROM t3;
680 COUNT(c1) SUM(c1)
681 1 6
682 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5;
683 COUNT(c1) SUM(c1)
684 0 NULL
685 DROP TABLE t1,t2,t3;
686 CREATE TABLE t1(c1 TINYINT NOT NULL);
687 CREATE TABLE t2(c1 TINYINT NOT NULL);
688 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
689 CREATE TABLE t3(c1 TINYINT NOT NULL);
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 UPDATE t1 SET c1 = c1 + 1 WHERE c1 = 5;
698 SELECT COUNT(c1),SUM(c1) FROM t1;
699 COUNT(c1) SUM(c1)
700 0 NULL
701 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5;
702 COUNT(c1) SUM(c1)
703 0 NULL
704 DROP TABLE t1,t2,t3;
705 CREATE TABLE t1(c1 SMALLINT NOT NULL);
706 CREATE TABLE t2(c1 SMALLINT NOT NULL);
707 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
708 CREATE TABLE t3(c1 SMALLINT NOT NULL);
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 UPDATE t1 SET c1 = c1 + 1 WHERE c1 = 5;
717 SELECT COUNT(c1),SUM(c1) FROM t1;
718 COUNT(c1) SUM(c1)
719 0 NULL
720 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5;
721 COUNT(c1) SUM(c1)
722 0 NULL
723 DROP TABLE t1,t2,t3;
724 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
725 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
726 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
727 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
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 UPDATE t1 SET c1 = c1 + 1 WHERE c1 = 5;
736 SELECT COUNT(c1),SUM(c1) FROM t1;
737 COUNT(c1) SUM(c1)
738 0 NULL
739 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5;
740 COUNT(c1) SUM(c1)
741 0 NULL
742 DROP TABLE t1,t2,t3;
743 CREATE TABLE t1(c1 INT NOT NULL);
744 CREATE TABLE t2(c1 INT NOT NULL);
745 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
746 CREATE TABLE t3(c1 INT NOT NULL);
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 UPDATE t1 SET c1 = c1 + 1 WHERE c1 = 5;
755 SELECT COUNT(c1),SUM(c1) FROM t1;
756 COUNT(c1) SUM(c1)
757 0 NULL
758 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5;
759 COUNT(c1) SUM(c1)
760 0 NULL
761 DROP TABLE t1,t2,t3;
762 CREATE TABLE t1(c1 INTEGER NOT NULL);
763 CREATE TABLE t2(c1 INTEGER NOT NULL);
764 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
765 CREATE TABLE t3(c1 INTEGER NOT NULL);
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 UPDATE t1 SET c1 = c1 + 1 WHERE c1 = 5;
774 SELECT COUNT(c1),SUM(c1) FROM t1;
775 COUNT(c1) SUM(c1)
776 0 NULL
777 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5;
778 COUNT(c1) SUM(c1)
779 0 NULL
780 DROP TABLE t1,t2,t3;
781 CREATE TABLE t1(c1 BIGINT NOT NULL);
782 CREATE TABLE t2(c1 BIGINT NOT NULL);
783 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
784 CREATE TABLE t3(c1 BIGINT NOT NULL);
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 UPDATE t1 SET c1 = c1 + 1 WHERE c1 = 5;
793 SELECT COUNT(c1),SUM(c1) FROM t1;
794 COUNT(c1) SUM(c1)
795 0 NULL
796 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5;
797 COUNT(c1) SUM(c1)
798 0 NULL
799 DROP TABLE t1,t2,t3;
800 CREATE TABLE t1(c1 TINYINT NOT NULL);
801 CREATE TABLE t2(c1 TINYINT NOT NULL);
802 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
803 CREATE TABLE t3(c1 TINYINT NOT NULL);
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 UPDATE t2 SET c1 = c1 + 1 WHERE c1 = 5;
812 SELECT COUNT(c1),SUM(c1) FROM t2;
813 COUNT(c1) SUM(c1)
814 10 46
815 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5;
816 COUNT(c1) SUM(c1)
817 0 NULL
818 DROP TABLE t1,t2,t3;
819 CREATE TABLE t1(c1 SMALLINT NOT NULL);
820 CREATE TABLE t2(c1 SMALLINT NOT NULL);
821 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
822 CREATE TABLE t3(c1 SMALLINT NOT NULL);
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 UPDATE t2 SET c1 = c1 + 1 WHERE c1 = 5;
831 SELECT COUNT(c1),SUM(c1) FROM t2;
832 COUNT(c1) SUM(c1)
833 10 46
834 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5;
835 COUNT(c1) SUM(c1)
836 0 NULL
837 DROP TABLE t1,t2,t3;
838 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
839 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
840 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
841 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
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 UPDATE t2 SET c1 = c1 + 1 WHERE c1 = 5;
850 SELECT COUNT(c1),SUM(c1) FROM t2;
851 COUNT(c1) SUM(c1)
852 10 46
853 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5;
854 COUNT(c1) SUM(c1)
855 0 NULL
856 DROP TABLE t1,t2,t3;
857 CREATE TABLE t1(c1 INT NOT NULL);
858 CREATE TABLE t2(c1 INT NOT NULL);
859 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
860 CREATE TABLE t3(c1 INT NOT NULL);
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 UPDATE t2 SET c1 = c1 + 1 WHERE c1 = 5;
869 SELECT COUNT(c1),SUM(c1) FROM t2;
870 COUNT(c1) SUM(c1)
871 10 46
872 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5;
873 COUNT(c1) SUM(c1)
874 0 NULL
875 DROP TABLE t1,t2,t3;
876 CREATE TABLE t1(c1 INTEGER NOT NULL);
877 CREATE TABLE t2(c1 INTEGER NOT NULL);
878 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
879 CREATE TABLE t3(c1 INTEGER NOT NULL);
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 UPDATE t2 SET c1 = c1 + 1 WHERE c1 = 5;
888 SELECT COUNT(c1),SUM(c1) FROM t2;
889 COUNT(c1) SUM(c1)
890 10 46
891 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5;
892 COUNT(c1) SUM(c1)
893 0 NULL
894 DROP TABLE t1,t2,t3;
895 CREATE TABLE t1(c1 BIGINT NOT NULL);
896 CREATE TABLE t2(c1 BIGINT NOT NULL);
897 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
898 CREATE TABLE t3(c1 BIGINT NOT NULL);
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 UPDATE t2 SET c1 = c1 + 1 WHERE c1 = 5;
907 SELECT COUNT(c1),SUM(c1) FROM t2;
908 COUNT(c1) SUM(c1)
909 10 46
910 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5;
911 COUNT(c1) SUM(c1)
912 0 NULL
913 DROP TABLE t1,t2,t3;
914 CREATE TABLE t1(c1 TINYINT NOT NULL);
915 CREATE TABLE t2(c1 TINYINT NOT NULL);
916 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
917 CREATE TABLE t3(c1 TINYINT NOT NULL);
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 UPDATE t3 SET c1 = c1 + 1 WHERE c1 = 5;
926 SELECT COUNT(c1),SUM(c1) FROM t3;
927 COUNT(c1) SUM(c1)
928 1 6
929 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5;
930 COUNT(c1) SUM(c1)
931 0 NULL
932 DROP TABLE t1,t2,t3;
933 CREATE TABLE t1(c1 SMALLINT NOT NULL);
934 CREATE TABLE t2(c1 SMALLINT NOT NULL);
935 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
936 CREATE TABLE t3(c1 SMALLINT NOT NULL);
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 UPDATE t3 SET c1 = c1 + 1 WHERE c1 = 5;
945 SELECT COUNT(c1),SUM(c1) FROM t3;
946 COUNT(c1) SUM(c1)
947 1 6
948 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5;
949 COUNT(c1) SUM(c1)
950 0 NULL
951 DROP TABLE t1,t2,t3;
952 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
953 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
954 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
955 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
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 UPDATE t3 SET c1 = c1 + 1 WHERE c1 = 5;
964 SELECT COUNT(c1),SUM(c1) FROM t3;
965 COUNT(c1) SUM(c1)
966 1 6
967 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5;
968 COUNT(c1) SUM(c1)
969 0 NULL
970 DROP TABLE t1,t2,t3;
971 CREATE TABLE t1(c1 INT NOT NULL);
972 CREATE TABLE t2(c1 INT NOT NULL);
973 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
974 CREATE TABLE t3(c1 INT NOT NULL);
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 UPDATE t3 SET c1 = c1 + 1 WHERE c1 = 5;
983 SELECT COUNT(c1),SUM(c1) FROM t3;
984 COUNT(c1) SUM(c1)
985 1 6
986 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5;
987 COUNT(c1) SUM(c1)
988 0 NULL
989 DROP TABLE t1,t2,t3;
990 CREATE TABLE t1(c1 INTEGER NOT NULL);
991 CREATE TABLE t2(c1 INTEGER NOT NULL);
992 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
993 CREATE TABLE t3(c1 INTEGER NOT NULL);
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 UPDATE t3 SET c1 = c1 + 1 WHERE c1 = 5;
1002 SELECT COUNT(c1),SUM(c1) FROM t3;
1003 COUNT(c1) SUM(c1)
1004 1 6
1005 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5;
1006 COUNT(c1) SUM(c1)
1007 0 NULL
1008 DROP TABLE t1,t2,t3;
1009 CREATE TABLE t1(c1 BIGINT NOT NULL);
1010 CREATE TABLE t2(c1 BIGINT NOT NULL);
1011 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1012 CREATE TABLE t3(c1 BIGINT NOT NULL);
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 UPDATE t3 SET c1 = c1 + 1 WHERE c1 = 5;
1021 SELECT COUNT(c1),SUM(c1) FROM t3;
1022 COUNT(c1) SUM(c1)
1023 1 6
1024 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5;
1025 COUNT(c1) SUM(c1)
1026 0 NULL
1027 DROP TABLE t1,t2,t3;
1028 CREATE TABLE t1(c1 TINYINT NOT NULL);
1029 CREATE TABLE t2(c1 TINYINT NOT NULL);
1030 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1031 CREATE TABLE t3(c1 TINYINT NOT NULL);
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 UPDATE t1 SET c1 = c1 + 1 WHERE c1 >= 5;
1040 SELECT COUNT(c1),SUM(c1) FROM t1;
1041 COUNT(c1) SUM(c1)
1042 0 NULL
1043 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5;
1044 COUNT(c1) SUM(c1)
1045 0 NULL
1046 DROP TABLE t1,t2,t3;
1047 CREATE TABLE t1(c1 SMALLINT NOT NULL);
1048 CREATE TABLE t2(c1 SMALLINT NOT NULL);
1049 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1050 CREATE TABLE t3(c1 SMALLINT NOT NULL);
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 UPDATE t1 SET c1 = c1 + 1 WHERE c1 >= 5;
1059 SELECT COUNT(c1),SUM(c1) FROM t1;
1060 COUNT(c1) SUM(c1)
1061 0 NULL
1062 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5;
1063 COUNT(c1) SUM(c1)
1064 0 NULL
1065 DROP TABLE t1,t2,t3;
1066 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
1067 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
1068 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1069 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
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 UPDATE t1 SET c1 = c1 + 1 WHERE c1 >= 5;
1078 SELECT COUNT(c1),SUM(c1) FROM t1;
1079 COUNT(c1) SUM(c1)
1080 0 NULL
1081 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5;
1082 COUNT(c1) SUM(c1)
1083 0 NULL
1084 DROP TABLE t1,t2,t3;
1085 CREATE TABLE t1(c1 INT NOT NULL);
1086 CREATE TABLE t2(c1 INT NOT NULL);
1087 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1088 CREATE TABLE t3(c1 INT NOT NULL);
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 UPDATE t1 SET c1 = c1 + 1 WHERE c1 >= 5;
1097 SELECT COUNT(c1),SUM(c1) FROM t1;
1098 COUNT(c1) SUM(c1)
1099 0 NULL
1100 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5;
1101 COUNT(c1) SUM(c1)
1102 0 NULL
1103 DROP TABLE t1,t2,t3;
1104 CREATE TABLE t1(c1 INTEGER NOT NULL);
1105 CREATE TABLE t2(c1 INTEGER NOT NULL);
1106 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1107 CREATE TABLE t3(c1 INTEGER NOT NULL);
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 UPDATE t1 SET c1 = c1 + 1 WHERE c1 >= 5;
1116 SELECT COUNT(c1),SUM(c1) FROM t1;
1117 COUNT(c1) SUM(c1)
1118 0 NULL
1119 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5;
1120 COUNT(c1) SUM(c1)
1121 0 NULL
1122 DROP TABLE t1,t2,t3;
1123 CREATE TABLE t1(c1 BIGINT NOT NULL);
1124 CREATE TABLE t2(c1 BIGINT NOT NULL);
1125 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1126 CREATE TABLE t3(c1 BIGINT NOT NULL);
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 UPDATE t1 SET c1 = c1 + 1 WHERE c1 >= 5;
1135 SELECT COUNT(c1),SUM(c1) FROM t1;
1136 COUNT(c1) SUM(c1)
1137 0 NULL
1138 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5;
1139 COUNT(c1) SUM(c1)
1140 0 NULL
1141 DROP TABLE t1,t2,t3;
1142 CREATE TABLE t1(c1 TINYINT NOT NULL);
1143 CREATE TABLE t2(c1 TINYINT NOT NULL);
1144 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1145 CREATE TABLE t3(c1 TINYINT NOT NULL);
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 UPDATE t2 SET c1 = c1 + 1 WHERE c1 >= 5;
1154 SELECT COUNT(c1),SUM(c1) FROM t2;
1155 COUNT(c1) SUM(c1)
1156 10 50
1157 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5;
1158 COUNT(c1) SUM(c1)
1159 5 40
1160 DROP TABLE t1,t2,t3;
1161 CREATE TABLE t1(c1 SMALLINT NOT NULL);
1162 CREATE TABLE t2(c1 SMALLINT NOT NULL);
1163 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1164 CREATE TABLE t3(c1 SMALLINT NOT NULL);
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 UPDATE t2 SET c1 = c1 + 1 WHERE c1 >= 5;
1173 SELECT COUNT(c1),SUM(c1) FROM t2;
1174 COUNT(c1) SUM(c1)
1175 10 50
1176 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5;
1177 COUNT(c1) SUM(c1)
1178 5 40
1179 DROP TABLE t1,t2,t3;
1180 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
1181 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
1182 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1183 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
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 UPDATE t2 SET c1 = c1 + 1 WHERE c1 >= 5;
1192 SELECT COUNT(c1),SUM(c1) FROM t2;
1193 COUNT(c1) SUM(c1)
1194 10 50
1195 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5;
1196 COUNT(c1) SUM(c1)
1197 5 40
1198 DROP TABLE t1,t2,t3;
1199 CREATE TABLE t1(c1 INT NOT NULL);
1200 CREATE TABLE t2(c1 INT NOT NULL);
1201 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1202 CREATE TABLE t3(c1 INT NOT NULL);
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 UPDATE t2 SET c1 = c1 + 1 WHERE c1 >= 5;
1211 SELECT COUNT(c1),SUM(c1) FROM t2;
1212 COUNT(c1) SUM(c1)
1213 10 50
1214 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5;
1215 COUNT(c1) SUM(c1)
1216 5 40
1217 DROP TABLE t1,t2,t3;
1218 CREATE TABLE t1(c1 INTEGER NOT NULL);
1219 CREATE TABLE t2(c1 INTEGER NOT NULL);
1220 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1221 CREATE TABLE t3(c1 INTEGER NOT NULL);
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 UPDATE t2 SET c1 = c1 + 1 WHERE c1 >= 5;
1230 SELECT COUNT(c1),SUM(c1) FROM t2;
1231 COUNT(c1) SUM(c1)
1232 10 50
1233 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5;
1234 COUNT(c1) SUM(c1)
1235 5 40
1236 DROP TABLE t1,t2,t3;
1237 CREATE TABLE t1(c1 BIGINT NOT NULL);
1238 CREATE TABLE t2(c1 BIGINT NOT NULL);
1239 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1240 CREATE TABLE t3(c1 BIGINT NOT NULL);
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 UPDATE t2 SET c1 = c1 + 1 WHERE c1 >= 5;
1249 SELECT COUNT(c1),SUM(c1) FROM t2;
1250 COUNT(c1) SUM(c1)
1251 10 50
1252 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5;
1253 COUNT(c1) SUM(c1)
1254 5 40
1255 DROP TABLE t1,t2,t3;
1256 CREATE TABLE t1(c1 TINYINT NOT NULL);
1257 CREATE TABLE t2(c1 TINYINT NOT NULL);
1258 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1259 CREATE TABLE t3(c1 TINYINT NOT NULL);
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 UPDATE t3 SET c1 = c1 + 1 WHERE c1 >= 5;
1268 SELECT COUNT(c1),SUM(c1) FROM t3;
1269 COUNT(c1) SUM(c1)
1270 1 6
1271 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5;
1272 COUNT(c1) SUM(c1)
1273 1 6
1274 DROP TABLE t1,t2,t3;
1275 CREATE TABLE t1(c1 SMALLINT NOT NULL);
1276 CREATE TABLE t2(c1 SMALLINT NOT NULL);
1277 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1278 CREATE TABLE t3(c1 SMALLINT NOT NULL);
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 UPDATE t3 SET c1 = c1 + 1 WHERE c1 >= 5;
1287 SELECT COUNT(c1),SUM(c1) FROM t3;
1288 COUNT(c1) SUM(c1)
1289 1 6
1290 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5;
1291 COUNT(c1) SUM(c1)
1292 1 6
1293 DROP TABLE t1,t2,t3;
1294 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
1295 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
1296 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1297 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
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 UPDATE t3 SET c1 = c1 + 1 WHERE c1 >= 5;
1306 SELECT COUNT(c1),SUM(c1) FROM t3;
1307 COUNT(c1) SUM(c1)
1308 1 6
1309 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5;
1310 COUNT(c1) SUM(c1)
1311 1 6
1312 DROP TABLE t1,t2,t3;
1313 CREATE TABLE t1(c1 INT NOT NULL);
1314 CREATE TABLE t2(c1 INT NOT NULL);
1315 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1316 CREATE TABLE t3(c1 INT NOT NULL);
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 UPDATE t3 SET c1 = c1 + 1 WHERE c1 >= 5;
1325 SELECT COUNT(c1),SUM(c1) FROM t3;
1326 COUNT(c1) SUM(c1)
1327 1 6
1328 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5;
1329 COUNT(c1) SUM(c1)
1330 1 6
1331 DROP TABLE t1,t2,t3;
1332 CREATE TABLE t1(c1 INTEGER NOT NULL);
1333 CREATE TABLE t2(c1 INTEGER NOT NULL);
1334 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1335 CREATE TABLE t3(c1 INTEGER NOT NULL);
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 UPDATE t3 SET c1 = c1 + 1 WHERE c1 >= 5;
1344 SELECT COUNT(c1),SUM(c1) FROM t3;
1345 COUNT(c1) SUM(c1)
1346 1 6
1347 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5;
1348 COUNT(c1) SUM(c1)
1349 1 6
1350 DROP TABLE t1,t2,t3;
1351 CREATE TABLE t1(c1 BIGINT NOT NULL);
1352 CREATE TABLE t2(c1 BIGINT NOT NULL);
1353 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1354 CREATE TABLE t3(c1 BIGINT NOT NULL);
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 UPDATE t3 SET c1 = c1 + 1 WHERE c1 >= 5;
1363 SELECT COUNT(c1),SUM(c1) FROM t3;
1364 COUNT(c1) SUM(c1)
1365 1 6
1366 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5;
1367 COUNT(c1) SUM(c1)
1368 1 6
1369 DROP TABLE t1,t2,t3;
1370 CREATE TABLE t1(c1 TINYINT NOT NULL);
1371 CREATE TABLE t2(c1 TINYINT NOT NULL);
1372 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1373 CREATE TABLE t3(c1 TINYINT NOT NULL);
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 UPDATE t1 SET c1 = c1 + 1 WHERE c1 != 5;
1382 SELECT COUNT(c1),SUM(c1) FROM t1;
1383 COUNT(c1) SUM(c1)
1384 0 NULL
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);
1390 CREATE TABLE t2(c1 SMALLINT NOT NULL);
1391 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1392 CREATE TABLE t3(c1 SMALLINT NOT NULL);
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 UPDATE t1 SET c1 = c1 + 1 WHERE c1 != 5;
1401 SELECT COUNT(c1),SUM(c1) FROM t1;
1402 COUNT(c1) SUM(c1)
1403 0 NULL
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);
1409 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
1410 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1411 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
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 UPDATE t1 SET c1 = c1 + 1 WHERE c1 != 5;
1420 SELECT COUNT(c1),SUM(c1) FROM t1;
1421 COUNT(c1) SUM(c1)
1422 0 NULL
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);
1428 CREATE TABLE t2(c1 INT NOT NULL);
1429 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1430 CREATE TABLE t3(c1 INT NOT NULL);
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 UPDATE t1 SET c1 = c1 + 1 WHERE c1 != 5;
1439 SELECT COUNT(c1),SUM(c1) FROM t1;
1440 COUNT(c1) SUM(c1)
1441 0 NULL
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);
1447 CREATE TABLE t2(c1 INTEGER NOT NULL);
1448 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1449 CREATE TABLE t3(c1 INTEGER NOT NULL);
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 UPDATE t1 SET c1 = c1 + 1 WHERE c1 != 5;
1458 SELECT COUNT(c1),SUM(c1) FROM t1;
1459 COUNT(c1) SUM(c1)
1460 0 NULL
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);
1466 CREATE TABLE t2(c1 BIGINT NOT NULL);
1467 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1468 CREATE TABLE t3(c1 BIGINT NOT NULL);
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 UPDATE t1 SET c1 = c1 + 1 WHERE c1 != 5;
1477 SELECT COUNT(c1),SUM(c1) FROM t1;
1478 COUNT(c1) SUM(c1)
1479 0 NULL
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);
1485 CREATE TABLE t2(c1 TINYINT NOT NULL);
1486 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1487 CREATE TABLE t3(c1 TINYINT NOT NULL);
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 UPDATE t2 SET c1 = c1 + 1 WHERE c1 != 5;
1496 SELECT COUNT(c1),SUM(c1) FROM t2;
1497 COUNT(c1) SUM(c1)
1498 10 54
1499 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5;
1500 COUNT(c1) SUM(c1)
1501 8 44
1502 DROP TABLE t1,t2,t3;
1503 CREATE TABLE t1(c1 SMALLINT NOT NULL);
1504 CREATE TABLE t2(c1 SMALLINT NOT NULL);
1505 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1506 CREATE TABLE t3(c1 SMALLINT NOT NULL);
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 UPDATE t2 SET c1 = c1 + 1 WHERE c1 != 5;
1515 SELECT COUNT(c1),SUM(c1) FROM t2;
1516 COUNT(c1) SUM(c1)
1517 10 54
1518 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5;
1519 COUNT(c1) SUM(c1)
1520 8 44
1521 DROP TABLE t1,t2,t3;
1522 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
1523 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
1524 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1525 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
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 UPDATE t2 SET c1 = c1 + 1 WHERE c1 != 5;
1534 SELECT COUNT(c1),SUM(c1) FROM t2;
1535 COUNT(c1) SUM(c1)
1536 10 54
1537 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5;
1538 COUNT(c1) SUM(c1)
1539 8 44
1540 DROP TABLE t1,t2,t3;
1541 CREATE TABLE t1(c1 INT NOT NULL);
1542 CREATE TABLE t2(c1 INT NOT NULL);
1543 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1544 CREATE TABLE t3(c1 INT NOT NULL);
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 UPDATE t2 SET c1 = c1 + 1 WHERE c1 != 5;
1553 SELECT COUNT(c1),SUM(c1) FROM t2;
1554 COUNT(c1) SUM(c1)
1555 10 54
1556 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5;
1557 COUNT(c1) SUM(c1)
1558 8 44
1559 DROP TABLE t1,t2,t3;
1560 CREATE TABLE t1(c1 INTEGER NOT NULL);
1561 CREATE TABLE t2(c1 INTEGER NOT NULL);
1562 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1563 CREATE TABLE t3(c1 INTEGER NOT NULL);
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 UPDATE t2 SET c1 = c1 + 1 WHERE c1 != 5;
1572 SELECT COUNT(c1),SUM(c1) FROM t2;
1573 COUNT(c1) SUM(c1)
1574 10 54
1575 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5;
1576 COUNT(c1) SUM(c1)
1577 8 44
1578 DROP TABLE t1,t2,t3;
1579 CREATE TABLE t1(c1 BIGINT NOT NULL);
1580 CREATE TABLE t2(c1 BIGINT NOT NULL);
1581 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1582 CREATE TABLE t3(c1 BIGINT NOT NULL);
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 UPDATE t2 SET c1 = c1 + 1 WHERE c1 != 5;
1591 SELECT COUNT(c1),SUM(c1) FROM t2;
1592 COUNT(c1) SUM(c1)
1593 10 54
1594 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5;
1595 COUNT(c1) SUM(c1)
1596 8 44
1597 DROP TABLE t1,t2,t3;
1598 CREATE TABLE t1(c1 TINYINT NOT NULL);
1599 CREATE TABLE t2(c1 TINYINT NOT NULL);
1600 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1601 CREATE TABLE t3(c1 TINYINT NOT NULL);
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 UPDATE t3 SET c1 = c1 + 1 WHERE c1 != 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);
1618 CREATE TABLE t2(c1 SMALLINT NOT NULL);
1619 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1620 CREATE TABLE t3(c1 SMALLINT NOT NULL);
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 UPDATE t3 SET c1 = c1 + 1 WHERE c1 != 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);
1637 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
1638 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1639 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
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 UPDATE t3 SET c1 = c1 + 1 WHERE c1 != 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);
1656 CREATE TABLE t2(c1 INT NOT NULL);
1657 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1658 CREATE TABLE t3(c1 INT NOT NULL);
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 UPDATE t3 SET c1 = c1 + 1 WHERE c1 != 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);
1675 CREATE TABLE t2(c1 INTEGER NOT NULL);
1676 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1677 CREATE TABLE t3(c1 INTEGER NOT NULL);
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 UPDATE t3 SET c1 = c1 + 1 WHERE c1 != 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);
1694 CREATE TABLE t2(c1 BIGINT NOT NULL);
1695 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1696 CREATE TABLE t3(c1 BIGINT NOT NULL);
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 UPDATE t3 SET c1 = c1 + 1 WHERE c1 != 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);
1713 CREATE TABLE t2(c1 TINYINT NOT NULL);
1714 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1715 CREATE TABLE t3(c1 TINYINT NOT NULL);
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 UPDATE t1 SET c1 = c1 + 1 WHERE c1 <> 5;
1724 SELECT COUNT(c1),SUM(c1) FROM t1;
1725 COUNT(c1) SUM(c1)
1726 0 NULL
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);
1732 CREATE TABLE t2(c1 SMALLINT NOT NULL);
1733 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1734 CREATE TABLE t3(c1 SMALLINT NOT NULL);
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 UPDATE t1 SET c1 = c1 + 1 WHERE c1 <> 5;
1743 SELECT COUNT(c1),SUM(c1) FROM t1;
1744 COUNT(c1) SUM(c1)
1745 0 NULL
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);
1751 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
1752 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1753 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
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 UPDATE t1 SET c1 = c1 + 1 WHERE c1 <> 5;
1762 SELECT COUNT(c1),SUM(c1) FROM t1;
1763 COUNT(c1) SUM(c1)
1764 0 NULL
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);
1770 CREATE TABLE t2(c1 INT NOT NULL);
1771 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1772 CREATE TABLE t3(c1 INT NOT NULL);
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 UPDATE t1 SET c1 = c1 + 1 WHERE c1 <> 5;
1781 SELECT COUNT(c1),SUM(c1) FROM t1;
1782 COUNT(c1) SUM(c1)
1783 0 NULL
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);
1789 CREATE TABLE t2(c1 INTEGER NOT NULL);
1790 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1791 CREATE TABLE t3(c1 INTEGER NOT NULL);
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 UPDATE t1 SET c1 = c1 + 1 WHERE c1 <> 5;
1800 SELECT COUNT(c1),SUM(c1) FROM t1;
1801 COUNT(c1) SUM(c1)
1802 0 NULL
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);
1808 CREATE TABLE t2(c1 BIGINT NOT NULL);
1809 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1810 CREATE TABLE t3(c1 BIGINT NOT NULL);
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 UPDATE t1 SET c1 = c1 + 1 WHERE c1 <> 5;
1819 SELECT COUNT(c1),SUM(c1) FROM t1;
1820 COUNT(c1) SUM(c1)
1821 0 NULL
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);
1827 CREATE TABLE t2(c1 TINYINT NOT NULL);
1828 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1829 CREATE TABLE t3(c1 TINYINT NOT NULL);
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 UPDATE t2 SET c1 = c1 + 1 WHERE c1 <> 5;
1838 SELECT COUNT(c1),SUM(c1) FROM t2;
1839 COUNT(c1) SUM(c1)
1840 10 54
1841 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5;
1842 COUNT(c1) SUM(c1)
1843 8 44
1844 DROP TABLE t1,t2,t3;
1845 CREATE TABLE t1(c1 SMALLINT NOT NULL);
1846 CREATE TABLE t2(c1 SMALLINT NOT NULL);
1847 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1848 CREATE TABLE t3(c1 SMALLINT NOT NULL);
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 UPDATE t2 SET c1 = c1 + 1 WHERE c1 <> 5;
1857 SELECT COUNT(c1),SUM(c1) FROM t2;
1858 COUNT(c1) SUM(c1)
1859 10 54
1860 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5;
1861 COUNT(c1) SUM(c1)
1862 8 44
1863 DROP TABLE t1,t2,t3;
1864 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
1865 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
1866 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1867 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
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 UPDATE t2 SET c1 = c1 + 1 WHERE c1 <> 5;
1876 SELECT COUNT(c1),SUM(c1) FROM t2;
1877 COUNT(c1) SUM(c1)
1878 10 54
1879 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5;
1880 COUNT(c1) SUM(c1)
1881 8 44
1882 DROP TABLE t1,t2,t3;
1883 CREATE TABLE t1(c1 INT NOT NULL);
1884 CREATE TABLE t2(c1 INT NOT NULL);
1885 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1886 CREATE TABLE t3(c1 INT NOT NULL);
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 UPDATE t2 SET c1 = c1 + 1 WHERE c1 <> 5;
1895 SELECT COUNT(c1),SUM(c1) FROM t2;
1896 COUNT(c1) SUM(c1)
1897 10 54
1898 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5;
1899 COUNT(c1) SUM(c1)
1900 8 44
1901 DROP TABLE t1,t2,t3;
1902 CREATE TABLE t1(c1 INTEGER NOT NULL);
1903 CREATE TABLE t2(c1 INTEGER NOT NULL);
1904 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1905 CREATE TABLE t3(c1 INTEGER NOT NULL);
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 UPDATE t2 SET c1 = c1 + 1 WHERE c1 <> 5;
1914 SELECT COUNT(c1),SUM(c1) FROM t2;
1915 COUNT(c1) SUM(c1)
1916 10 54
1917 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5;
1918 COUNT(c1) SUM(c1)
1919 8 44
1920 DROP TABLE t1,t2,t3;
1921 CREATE TABLE t1(c1 BIGINT NOT NULL);
1922 CREATE TABLE t2(c1 BIGINT NOT NULL);
1923 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1924 CREATE TABLE t3(c1 BIGINT NOT NULL);
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 UPDATE t2 SET c1 = c1 + 1 WHERE c1 <> 5;
1933 SELECT COUNT(c1),SUM(c1) FROM t2;
1934 COUNT(c1) SUM(c1)
1935 10 54
1936 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5;
1937 COUNT(c1) SUM(c1)
1938 8 44
1939 DROP TABLE t1,t2,t3;
1940 CREATE TABLE t1(c1 TINYINT NOT NULL);
1941 CREATE TABLE t2(c1 TINYINT NOT NULL);
1942 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1943 CREATE TABLE t3(c1 TINYINT NOT NULL);
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 UPDATE t3 SET c1 = c1 + 1 WHERE c1 <> 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);
1960 CREATE TABLE t2(c1 SMALLINT NOT NULL);
1961 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1962 CREATE TABLE t3(c1 SMALLINT NOT NULL);
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 UPDATE t3 SET c1 = c1 + 1 WHERE c1 <> 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);
1979 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
1980 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1981 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
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 UPDATE t3 SET c1 = c1 + 1 WHERE c1 <> 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);
1998 CREATE TABLE t2(c1 INT NOT NULL);
1999 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2000 CREATE TABLE t3(c1 INT NOT NULL);
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 UPDATE t3 SET c1 = c1 + 1 WHERE c1 <> 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);
2017 CREATE TABLE t2(c1 INTEGER NOT NULL);
2018 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2019 CREATE TABLE t3(c1 INTEGER NOT NULL);
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 UPDATE t3 SET c1 = c1 + 1 WHERE c1 <> 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);
2036 CREATE TABLE t2(c1 BIGINT NOT NULL);
2037 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2038 CREATE TABLE t3(c1 BIGINT NOT NULL);
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 UPDATE t3 SET c1 = c1 + 1 WHERE c1 <> 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);
2055 CREATE TABLE t2(c1 TINYINT NOT NULL);
2056 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2057 CREATE TABLE t3(c1 TINYINT NOT NULL);
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 UPDATE t1 SET c1 = c1 + 1 WHERE c1 <=> 5;
2066 SELECT COUNT(c1),SUM(c1) FROM t1;
2067 COUNT(c1) SUM(c1)
2068 0 NULL
2069 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5;
2070 COUNT(c1) SUM(c1)
2071 0 NULL
2072 DROP TABLE t1,t2,t3;
2073 CREATE TABLE t1(c1 SMALLINT NOT NULL);
2074 CREATE TABLE t2(c1 SMALLINT NOT NULL);
2075 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2076 CREATE TABLE t3(c1 SMALLINT NOT NULL);
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 UPDATE t1 SET c1 = c1 + 1 WHERE c1 <=> 5;
2085 SELECT COUNT(c1),SUM(c1) FROM t1;
2086 COUNT(c1) SUM(c1)
2087 0 NULL
2088 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5;
2089 COUNT(c1) SUM(c1)
2090 0 NULL
2091 DROP TABLE t1,t2,t3;
2092 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
2093 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
2094 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2095 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
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 UPDATE t1 SET c1 = c1 + 1 WHERE c1 <=> 5;
2104 SELECT COUNT(c1),SUM(c1) FROM t1;
2105 COUNT(c1) SUM(c1)
2106 0 NULL
2107 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5;
2108 COUNT(c1) SUM(c1)
2109 0 NULL
2110 DROP TABLE t1,t2,t3;
2111 CREATE TABLE t1(c1 INT NOT NULL);
2112 CREATE TABLE t2(c1 INT NOT NULL);
2113 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2114 CREATE TABLE t3(c1 INT NOT NULL);
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 UPDATE t1 SET c1 = c1 + 1 WHERE c1 <=> 5;
2123 SELECT COUNT(c1),SUM(c1) FROM t1;
2124 COUNT(c1) SUM(c1)
2125 0 NULL
2126 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5;
2127 COUNT(c1) SUM(c1)
2128 0 NULL
2129 DROP TABLE t1,t2,t3;
2130 CREATE TABLE t1(c1 INTEGER NOT NULL);
2131 CREATE TABLE t2(c1 INTEGER NOT NULL);
2132 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2133 CREATE TABLE t3(c1 INTEGER NOT NULL);
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 UPDATE t1 SET c1 = c1 + 1 WHERE c1 <=> 5;
2142 SELECT COUNT(c1),SUM(c1) FROM t1;
2143 COUNT(c1) SUM(c1)
2144 0 NULL
2145 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5;
2146 COUNT(c1) SUM(c1)
2147 0 NULL
2148 DROP TABLE t1,t2,t3;
2149 CREATE TABLE t1(c1 BIGINT NOT NULL);
2150 CREATE TABLE t2(c1 BIGINT NOT NULL);
2151 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2152 CREATE TABLE t3(c1 BIGINT NOT NULL);
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 UPDATE t1 SET c1 = c1 + 1 WHERE c1 <=> 5;
2161 SELECT COUNT(c1),SUM(c1) FROM t1;
2162 COUNT(c1) SUM(c1)
2163 0 NULL
2164 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5;
2165 COUNT(c1) SUM(c1)
2166 0 NULL
2167 DROP TABLE t1,t2,t3;
2168 CREATE TABLE t1(c1 TINYINT NOT NULL);
2169 CREATE TABLE t2(c1 TINYINT NOT NULL);
2170 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2171 CREATE TABLE t3(c1 TINYINT NOT NULL);
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 UPDATE t2 SET c1 = c1 + 1 WHERE c1 <=> 5;
2180 SELECT COUNT(c1),SUM(c1) FROM t2;
2181 COUNT(c1) SUM(c1)
2182 10 46
2183 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5;
2184 COUNT(c1) SUM(c1)
2185 0 NULL
2186 DROP TABLE t1,t2,t3;
2187 CREATE TABLE t1(c1 SMALLINT NOT NULL);
2188 CREATE TABLE t2(c1 SMALLINT NOT NULL);
2189 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2190 CREATE TABLE t3(c1 SMALLINT NOT NULL);
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 UPDATE t2 SET c1 = c1 + 1 WHERE c1 <=> 5;
2199 SELECT COUNT(c1),SUM(c1) FROM t2;
2200 COUNT(c1) SUM(c1)
2201 10 46
2202 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5;
2203 COUNT(c1) SUM(c1)
2204 0 NULL
2205 DROP TABLE t1,t2,t3;
2206 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
2207 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
2208 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2209 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
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 UPDATE t2 SET c1 = c1 + 1 WHERE c1 <=> 5;
2218 SELECT COUNT(c1),SUM(c1) FROM t2;
2219 COUNT(c1) SUM(c1)
2220 10 46
2221 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5;
2222 COUNT(c1) SUM(c1)
2223 0 NULL
2224 DROP TABLE t1,t2,t3;
2225 CREATE TABLE t1(c1 INT NOT NULL);
2226 CREATE TABLE t2(c1 INT NOT NULL);
2227 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2228 CREATE TABLE t3(c1 INT NOT NULL);
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 UPDATE t2 SET c1 = c1 + 1 WHERE c1 <=> 5;
2237 SELECT COUNT(c1),SUM(c1) FROM t2;
2238 COUNT(c1) SUM(c1)
2239 10 46
2240 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5;
2241 COUNT(c1) SUM(c1)
2242 0 NULL
2243 DROP TABLE t1,t2,t3;
2244 CREATE TABLE t1(c1 INTEGER NOT NULL);
2245 CREATE TABLE t2(c1 INTEGER NOT NULL);
2246 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2247 CREATE TABLE t3(c1 INTEGER NOT NULL);
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 UPDATE t2 SET c1 = c1 + 1 WHERE c1 <=> 5;
2256 SELECT COUNT(c1),SUM(c1) FROM t2;
2257 COUNT(c1) SUM(c1)
2258 10 46
2259 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5;
2260 COUNT(c1) SUM(c1)
2261 0 NULL
2262 DROP TABLE t1,t2,t3;
2263 CREATE TABLE t1(c1 BIGINT NOT NULL);
2264 CREATE TABLE t2(c1 BIGINT NOT NULL);
2265 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2266 CREATE TABLE t3(c1 BIGINT NOT NULL);
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 UPDATE t2 SET c1 = c1 + 1 WHERE c1 <=> 5;
2275 SELECT COUNT(c1),SUM(c1) FROM t2;
2276 COUNT(c1) SUM(c1)
2277 10 46
2278 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5;
2279 COUNT(c1) SUM(c1)
2280 0 NULL
2281 DROP TABLE t1,t2,t3;
2282 CREATE TABLE t1(c1 TINYINT NOT NULL);
2283 CREATE TABLE t2(c1 TINYINT NOT NULL);
2284 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2285 CREATE TABLE t3(c1 TINYINT NOT NULL);
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 UPDATE t3 SET c1 = c1 + 1 WHERE c1 <=> 5;
2294 SELECT COUNT(c1),SUM(c1) FROM t3;
2295 COUNT(c1) SUM(c1)
2296 1 6
2297 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5;
2298 COUNT(c1) SUM(c1)
2299 0 NULL
2300 DROP TABLE t1,t2,t3;
2301 CREATE TABLE t1(c1 SMALLINT NOT NULL);
2302 CREATE TABLE t2(c1 SMALLINT NOT NULL);
2303 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2304 CREATE TABLE t3(c1 SMALLINT NOT NULL);
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 UPDATE t3 SET c1 = c1 + 1 WHERE c1 <=> 5;
2313 SELECT COUNT(c1),SUM(c1) FROM t3;
2314 COUNT(c1) SUM(c1)
2315 1 6
2316 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5;
2317 COUNT(c1) SUM(c1)
2318 0 NULL
2319 DROP TABLE t1,t2,t3;
2320 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
2321 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
2322 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2323 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
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 UPDATE t3 SET c1 = c1 + 1 WHERE c1 <=> 5;
2332 SELECT COUNT(c1),SUM(c1) FROM t3;
2333 COUNT(c1) SUM(c1)
2334 1 6
2335 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5;
2336 COUNT(c1) SUM(c1)
2337 0 NULL
2338 DROP TABLE t1,t2,t3;
2339 CREATE TABLE t1(c1 INT NOT NULL);
2340 CREATE TABLE t2(c1 INT NOT NULL);
2341 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2342 CREATE TABLE t3(c1 INT NOT NULL);
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 UPDATE t3 SET c1 = c1 + 1 WHERE c1 <=> 5;
2351 SELECT COUNT(c1),SUM(c1) FROM t3;
2352 COUNT(c1) SUM(c1)
2353 1 6
2354 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5;
2355 COUNT(c1) SUM(c1)
2356 0 NULL
2357 DROP TABLE t1,t2,t3;
2358 CREATE TABLE t1(c1 INTEGER NOT NULL);
2359 CREATE TABLE t2(c1 INTEGER NOT NULL);
2360 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2361 CREATE TABLE t3(c1 INTEGER NOT NULL);
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 UPDATE t3 SET c1 = c1 + 1 WHERE c1 <=> 5;
2370 SELECT COUNT(c1),SUM(c1) FROM t3;
2371 COUNT(c1) SUM(c1)
2372 1 6
2373 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5;
2374 COUNT(c1) SUM(c1)
2375 0 NULL
2376 DROP TABLE t1,t2,t3;
2377 CREATE TABLE t1(c1 BIGINT NOT NULL);
2378 CREATE TABLE t2(c1 BIGINT NOT NULL);
2379 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2380 CREATE TABLE t3(c1 BIGINT NOT NULL);
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 UPDATE t3 SET c1 = c1 + 1 WHERE c1 <=> 5;
2389 SELECT COUNT(c1),SUM(c1) FROM t3;
2390 COUNT(c1) SUM(c1)
2391 1 6
2392 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5;
2393 COUNT(c1) SUM(c1)
2394 0 NULL
2395 DROP TABLE t1,t2,t3;