Debian Codegraph @

mysql-test/suite/engines/funcs/r/de_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 DELETE FROM t1 WHERE c1 < 5;
11 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5;
12 COUNT(c1) SUM(c1)
13 0 NULL
14 SELECT COUNT(c1),SUM(c1) FROM t1;
15 COUNT(c1) SUM(c1)
16 0 NULL
17 DROP TABLE t1,t2,t3;
18 CREATE TABLE t1(c1 SMALLINT NOT NULL);
19 CREATE TABLE t2(c1 SMALLINT NOT NULL);
20 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
21 CREATE TABLE t3(c1 SMALLINT NOT NULL);
22 INSERT INTO t3 (c1) VALUES(5);
23 SELECT COUNT(c1),SUM(c1) FROM t1;
24 COUNT(c1) SUM(c1)
25 0 NULL
26 DELETE FROM t1 WHERE c1 < 5;
27 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5;
28 COUNT(c1) SUM(c1)
29 0 NULL
30 SELECT COUNT(c1),SUM(c1) FROM t1;
31 COUNT(c1) SUM(c1)
32 0 NULL
33 DROP TABLE t1,t2,t3;
34 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
35 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
36 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
37 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
38 INSERT INTO t3 (c1) VALUES(5);
39 SELECT COUNT(c1),SUM(c1) FROM t1;
40 COUNT(c1) SUM(c1)
41 0 NULL
42 DELETE FROM t1 WHERE c1 < 5;
43 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5;
44 COUNT(c1) SUM(c1)
45 0 NULL
46 SELECT COUNT(c1),SUM(c1) FROM t1;
47 COUNT(c1) SUM(c1)
48 0 NULL
49 DROP TABLE t1,t2,t3;
50 CREATE TABLE t1(c1 INT NOT NULL);
51 CREATE TABLE t2(c1 INT NOT NULL);
52 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
53 CREATE TABLE t3(c1 INT NOT NULL);
54 INSERT INTO t3 (c1) VALUES(5);
55 SELECT COUNT(c1),SUM(c1) FROM t1;
56 COUNT(c1) SUM(c1)
57 0 NULL
58 DELETE FROM t1 WHERE c1 < 5;
59 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5;
60 COUNT(c1) SUM(c1)
61 0 NULL
62 SELECT COUNT(c1),SUM(c1) FROM t1;
63 COUNT(c1) SUM(c1)
64 0 NULL
65 DROP TABLE t1,t2,t3;
66 CREATE TABLE t1(c1 INTEGER NOT NULL);
67 CREATE TABLE t2(c1 INTEGER NOT NULL);
68 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
69 CREATE TABLE t3(c1 INTEGER NOT NULL);
70 INSERT INTO t3 (c1) VALUES(5);
71 SELECT COUNT(c1),SUM(c1) FROM t1;
72 COUNT(c1) SUM(c1)
73 0 NULL
74 DELETE FROM t1 WHERE c1 < 5;
75 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5;
76 COUNT(c1) SUM(c1)
77 0 NULL
78 SELECT COUNT(c1),SUM(c1) FROM t1;
79 COUNT(c1) SUM(c1)
80 0 NULL
81 DROP TABLE t1,t2,t3;
82 CREATE TABLE t1(c1 BIGINT NOT NULL);
83 CREATE TABLE t2(c1 BIGINT NOT NULL);
84 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
85 CREATE TABLE t3(c1 BIGINT NOT NULL);
86 INSERT INTO t3 (c1) VALUES(5);
87 SELECT COUNT(c1),SUM(c1) FROM t1;
88 COUNT(c1) SUM(c1)
89 0 NULL
90 DELETE FROM t1 WHERE c1 < 5;
91 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5;
92 COUNT(c1) SUM(c1)
93 0 NULL
94 SELECT COUNT(c1),SUM(c1) FROM t1;
95 COUNT(c1) SUM(c1)
96 0 NULL
97 DROP TABLE t1,t2,t3;
98 CREATE TABLE t1(c1 TINYINT NOT NULL);
99 CREATE TABLE t2(c1 TINYINT NOT NULL);
100 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
101 CREATE TABLE t3(c1 TINYINT NOT NULL);
102 INSERT INTO t3 (c1) VALUES(5);
103 SELECT COUNT(c1),SUM(c1) FROM t2;
104 COUNT(c1) SUM(c1)
105 10 45
106 DELETE FROM t2 WHERE c1 < 5;
107 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5;
108 COUNT(c1) SUM(c1)
109 0 NULL
110 SELECT COUNT(c1),SUM(c1) FROM t2;
111 COUNT(c1) SUM(c1)
112 5 35
113 DROP TABLE t1,t2,t3;
114 CREATE TABLE t1(c1 SMALLINT NOT NULL);
115 CREATE TABLE t2(c1 SMALLINT NOT NULL);
116 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
117 CREATE TABLE t3(c1 SMALLINT NOT NULL);
118 INSERT INTO t3 (c1) VALUES(5);
119 SELECT COUNT(c1),SUM(c1) FROM t2;
120 COUNT(c1) SUM(c1)
121 10 45
122 DELETE FROM t2 WHERE c1 < 5;
123 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5;
124 COUNT(c1) SUM(c1)
125 0 NULL
126 SELECT COUNT(c1),SUM(c1) FROM t2;
127 COUNT(c1) SUM(c1)
128 5 35
129 DROP TABLE t1,t2,t3;
130 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
131 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
132 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
133 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
134 INSERT INTO t3 (c1) VALUES(5);
135 SELECT COUNT(c1),SUM(c1) FROM t2;
136 COUNT(c1) SUM(c1)
137 10 45
138 DELETE FROM t2 WHERE c1 < 5;
139 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5;
140 COUNT(c1) SUM(c1)
141 0 NULL
142 SELECT COUNT(c1),SUM(c1) FROM t2;
143 COUNT(c1) SUM(c1)
144 5 35
145 DROP TABLE t1,t2,t3;
146 CREATE TABLE t1(c1 INT NOT NULL);
147 CREATE TABLE t2(c1 INT NOT NULL);
148 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
149 CREATE TABLE t3(c1 INT NOT NULL);
150 INSERT INTO t3 (c1) VALUES(5);
151 SELECT COUNT(c1),SUM(c1) FROM t2;
152 COUNT(c1) SUM(c1)
153 10 45
154 DELETE FROM t2 WHERE c1 < 5;
155 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5;
156 COUNT(c1) SUM(c1)
157 0 NULL
158 SELECT COUNT(c1),SUM(c1) FROM t2;
159 COUNT(c1) SUM(c1)
160 5 35
161 DROP TABLE t1,t2,t3;
162 CREATE TABLE t1(c1 INTEGER NOT NULL);
163 CREATE TABLE t2(c1 INTEGER NOT NULL);
164 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
165 CREATE TABLE t3(c1 INTEGER NOT NULL);
166 INSERT INTO t3 (c1) VALUES(5);
167 SELECT COUNT(c1),SUM(c1) FROM t2;
168 COUNT(c1) SUM(c1)
169 10 45
170 DELETE FROM t2 WHERE c1 < 5;
171 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5;
172 COUNT(c1) SUM(c1)
173 0 NULL
174 SELECT COUNT(c1),SUM(c1) FROM t2;
175 COUNT(c1) SUM(c1)
176 5 35
177 DROP TABLE t1,t2,t3;
178 CREATE TABLE t1(c1 BIGINT NOT NULL);
179 CREATE TABLE t2(c1 BIGINT NOT NULL);
180 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
181 CREATE TABLE t3(c1 BIGINT NOT NULL);
182 INSERT INTO t3 (c1) VALUES(5);
183 SELECT COUNT(c1),SUM(c1) FROM t2;
184 COUNT(c1) SUM(c1)
185 10 45
186 DELETE FROM t2 WHERE c1 < 5;
187 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5;
188 COUNT(c1) SUM(c1)
189 0 NULL
190 SELECT COUNT(c1),SUM(c1) FROM t2;
191 COUNT(c1) SUM(c1)
192 5 35
193 DROP TABLE t1,t2,t3;
194 CREATE TABLE t1(c1 TINYINT NOT NULL);
195 CREATE TABLE t2(c1 TINYINT NOT NULL);
196 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
197 CREATE TABLE t3(c1 TINYINT NOT NULL);
198 INSERT INTO t3 (c1) VALUES(5);
199 SELECT COUNT(c1),SUM(c1) FROM t3;
200 COUNT(c1) SUM(c1)
201 1 5
202 DELETE FROM t3 WHERE c1 < 5;
203 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5;
204 COUNT(c1) SUM(c1)
205 0 NULL
206 SELECT COUNT(c1),SUM(c1) FROM t3;
207 COUNT(c1) SUM(c1)
208 1 5
209 DROP TABLE t1,t2,t3;
210 CREATE TABLE t1(c1 SMALLINT NOT NULL);
211 CREATE TABLE t2(c1 SMALLINT NOT NULL);
212 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
213 CREATE TABLE t3(c1 SMALLINT NOT NULL);
214 INSERT INTO t3 (c1) VALUES(5);
215 SELECT COUNT(c1),SUM(c1) FROM t3;
216 COUNT(c1) SUM(c1)
217 1 5
218 DELETE FROM t3 WHERE c1 < 5;
219 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5;
220 COUNT(c1) SUM(c1)
221 0 NULL
222 SELECT COUNT(c1),SUM(c1) FROM t3;
223 COUNT(c1) SUM(c1)
224 1 5
225 DROP TABLE t1,t2,t3;
226 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
227 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
228 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
229 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
230 INSERT INTO t3 (c1) VALUES(5);
231 SELECT COUNT(c1),SUM(c1) FROM t3;
232 COUNT(c1) SUM(c1)
233 1 5
234 DELETE FROM t3 WHERE c1 < 5;
235 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5;
236 COUNT(c1) SUM(c1)
237 0 NULL
238 SELECT COUNT(c1),SUM(c1) FROM t3;
239 COUNT(c1) SUM(c1)
240 1 5
241 DROP TABLE t1,t2,t3;
242 CREATE TABLE t1(c1 INT NOT NULL);
243 CREATE TABLE t2(c1 INT NOT NULL);
244 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
245 CREATE TABLE t3(c1 INT NOT NULL);
246 INSERT INTO t3 (c1) VALUES(5);
247 SELECT COUNT(c1),SUM(c1) FROM t3;
248 COUNT(c1) SUM(c1)
249 1 5
250 DELETE FROM t3 WHERE c1 < 5;
251 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5;
252 COUNT(c1) SUM(c1)
253 0 NULL
254 SELECT COUNT(c1),SUM(c1) FROM t3;
255 COUNT(c1) SUM(c1)
256 1 5
257 DROP TABLE t1,t2,t3;
258 CREATE TABLE t1(c1 INTEGER NOT NULL);
259 CREATE TABLE t2(c1 INTEGER NOT NULL);
260 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
261 CREATE TABLE t3(c1 INTEGER NOT NULL);
262 INSERT INTO t3 (c1) VALUES(5);
263 SELECT COUNT(c1),SUM(c1) FROM t3;
264 COUNT(c1) SUM(c1)
265 1 5
266 DELETE FROM t3 WHERE c1 < 5;
267 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5;
268 COUNT(c1) SUM(c1)
269 0 NULL
270 SELECT COUNT(c1),SUM(c1) FROM t3;
271 COUNT(c1) SUM(c1)
272 1 5
273 DROP TABLE t1,t2,t3;
274 CREATE TABLE t1(c1 BIGINT NOT NULL);
275 CREATE TABLE t2(c1 BIGINT NOT NULL);
276 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
277 CREATE TABLE t3(c1 BIGINT NOT NULL);
278 INSERT INTO t3 (c1) VALUES(5);
279 SELECT COUNT(c1),SUM(c1) FROM t3;
280 COUNT(c1) SUM(c1)
281 1 5
282 DELETE FROM t3 WHERE c1 < 5;
283 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5;
284 COUNT(c1) SUM(c1)
285 0 NULL
286 SELECT COUNT(c1),SUM(c1) FROM t3;
287 COUNT(c1) SUM(c1)
288 1 5
289 DROP TABLE t1,t2,t3;
290 CREATE TABLE t1(c1 TINYINT NOT NULL);
291 CREATE TABLE t2(c1 TINYINT NOT NULL);
292 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
293 CREATE TABLE t3(c1 TINYINT NOT NULL);
294 INSERT INTO t3 (c1) VALUES(5);
295 SELECT COUNT(c1),SUM(c1) FROM t1;
296 COUNT(c1) SUM(c1)
297 0 NULL
298 DELETE FROM t1 WHERE c1 <= 5;
299 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5;
300 COUNT(c1) SUM(c1)
301 0 NULL
302 SELECT COUNT(c1),SUM(c1) FROM t1;
303 COUNT(c1) SUM(c1)
304 0 NULL
305 DROP TABLE t1,t2,t3;
306 CREATE TABLE t1(c1 SMALLINT NOT NULL);
307 CREATE TABLE t2(c1 SMALLINT NOT NULL);
308 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
309 CREATE TABLE t3(c1 SMALLINT NOT NULL);
310 INSERT INTO t3 (c1) VALUES(5);
311 SELECT COUNT(c1),SUM(c1) FROM t1;
312 COUNT(c1) SUM(c1)
313 0 NULL
314 DELETE FROM t1 WHERE c1 <= 5;
315 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5;
316 COUNT(c1) SUM(c1)
317 0 NULL
318 SELECT COUNT(c1),SUM(c1) FROM t1;
319 COUNT(c1) SUM(c1)
320 0 NULL
321 DROP TABLE t1,t2,t3;
322 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
323 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
324 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
325 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
326 INSERT INTO t3 (c1) VALUES(5);
327 SELECT COUNT(c1),SUM(c1) FROM t1;
328 COUNT(c1) SUM(c1)
329 0 NULL
330 DELETE FROM t1 WHERE c1 <= 5;
331 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5;
332 COUNT(c1) SUM(c1)
333 0 NULL
334 SELECT COUNT(c1),SUM(c1) FROM t1;
335 COUNT(c1) SUM(c1)
336 0 NULL
337 DROP TABLE t1,t2,t3;
338 CREATE TABLE t1(c1 INT NOT NULL);
339 CREATE TABLE t2(c1 INT NOT NULL);
340 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
341 CREATE TABLE t3(c1 INT NOT NULL);
342 INSERT INTO t3 (c1) VALUES(5);
343 SELECT COUNT(c1),SUM(c1) FROM t1;
344 COUNT(c1) SUM(c1)
345 0 NULL
346 DELETE FROM t1 WHERE c1 <= 5;
347 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5;
348 COUNT(c1) SUM(c1)
349 0 NULL
350 SELECT COUNT(c1),SUM(c1) FROM t1;
351 COUNT(c1) SUM(c1)
352 0 NULL
353 DROP TABLE t1,t2,t3;
354 CREATE TABLE t1(c1 INTEGER NOT NULL);
355 CREATE TABLE t2(c1 INTEGER NOT NULL);
356 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
357 CREATE TABLE t3(c1 INTEGER NOT NULL);
358 INSERT INTO t3 (c1) VALUES(5);
359 SELECT COUNT(c1),SUM(c1) FROM t1;
360 COUNT(c1) SUM(c1)
361 0 NULL
362 DELETE FROM t1 WHERE c1 <= 5;
363 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5;
364 COUNT(c1) SUM(c1)
365 0 NULL
366 SELECT COUNT(c1),SUM(c1) FROM t1;
367 COUNT(c1) SUM(c1)
368 0 NULL
369 DROP TABLE t1,t2,t3;
370 CREATE TABLE t1(c1 BIGINT NOT NULL);
371 CREATE TABLE t2(c1 BIGINT NOT NULL);
372 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
373 CREATE TABLE t3(c1 BIGINT NOT NULL);
374 INSERT INTO t3 (c1) VALUES(5);
375 SELECT COUNT(c1),SUM(c1) FROM t1;
376 COUNT(c1) SUM(c1)
377 0 NULL
378 DELETE FROM t1 WHERE c1 <= 5;
379 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5;
380 COUNT(c1) SUM(c1)
381 0 NULL
382 SELECT COUNT(c1),SUM(c1) FROM t1;
383 COUNT(c1) SUM(c1)
384 0 NULL
385 DROP TABLE t1,t2,t3;
386 CREATE TABLE t1(c1 TINYINT NOT NULL);
387 CREATE TABLE t2(c1 TINYINT NOT NULL);
388 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
389 CREATE TABLE t3(c1 TINYINT NOT NULL);
390 INSERT INTO t3 (c1) VALUES(5);
391 SELECT COUNT(c1),SUM(c1) FROM t2;
392 COUNT(c1) SUM(c1)
393 10 45
394 DELETE FROM t2 WHERE c1 <= 5;
395 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5;
396 COUNT(c1) SUM(c1)
397 0 NULL
398 SELECT COUNT(c1),SUM(c1) FROM t2;
399 COUNT(c1) SUM(c1)
400 4 30
401 DROP TABLE t1,t2,t3;
402 CREATE TABLE t1(c1 SMALLINT NOT NULL);
403 CREATE TABLE t2(c1 SMALLINT NOT NULL);
404 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
405 CREATE TABLE t3(c1 SMALLINT NOT NULL);
406 INSERT INTO t3 (c1) VALUES(5);
407 SELECT COUNT(c1),SUM(c1) FROM t2;
408 COUNT(c1) SUM(c1)
409 10 45
410 DELETE FROM t2 WHERE c1 <= 5;
411 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5;
412 COUNT(c1) SUM(c1)
413 0 NULL
414 SELECT COUNT(c1),SUM(c1) FROM t2;
415 COUNT(c1) SUM(c1)
416 4 30
417 DROP TABLE t1,t2,t3;
418 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
419 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
420 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
421 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
422 INSERT INTO t3 (c1) VALUES(5);
423 SELECT COUNT(c1),SUM(c1) FROM t2;
424 COUNT(c1) SUM(c1)
425 10 45
426 DELETE FROM t2 WHERE c1 <= 5;
427 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5;
428 COUNT(c1) SUM(c1)
429 0 NULL
430 SELECT COUNT(c1),SUM(c1) FROM t2;
431 COUNT(c1) SUM(c1)
432 4 30
433 DROP TABLE t1,t2,t3;
434 CREATE TABLE t1(c1 INT NOT NULL);
435 CREATE TABLE t2(c1 INT NOT NULL);
436 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
437 CREATE TABLE t3(c1 INT NOT NULL);
438 INSERT INTO t3 (c1) VALUES(5);
439 SELECT COUNT(c1),SUM(c1) FROM t2;
440 COUNT(c1) SUM(c1)
441 10 45
442 DELETE FROM t2 WHERE c1 <= 5;
443 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5;
444 COUNT(c1) SUM(c1)
445 0 NULL
446 SELECT COUNT(c1),SUM(c1) FROM t2;
447 COUNT(c1) SUM(c1)
448 4 30
449 DROP TABLE t1,t2,t3;
450 CREATE TABLE t1(c1 INTEGER NOT NULL);
451 CREATE TABLE t2(c1 INTEGER NOT NULL);
452 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
453 CREATE TABLE t3(c1 INTEGER NOT NULL);
454 INSERT INTO t3 (c1) VALUES(5);
455 SELECT COUNT(c1),SUM(c1) FROM t2;
456 COUNT(c1) SUM(c1)
457 10 45
458 DELETE FROM t2 WHERE c1 <= 5;
459 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5;
460 COUNT(c1) SUM(c1)
461 0 NULL
462 SELECT COUNT(c1),SUM(c1) FROM t2;
463 COUNT(c1) SUM(c1)
464 4 30
465 DROP TABLE t1,t2,t3;
466 CREATE TABLE t1(c1 BIGINT NOT NULL);
467 CREATE TABLE t2(c1 BIGINT NOT NULL);
468 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
469 CREATE TABLE t3(c1 BIGINT NOT NULL);
470 INSERT INTO t3 (c1) VALUES(5);
471 SELECT COUNT(c1),SUM(c1) FROM t2;
472 COUNT(c1) SUM(c1)
473 10 45
474 DELETE FROM t2 WHERE c1 <= 5;
475 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5;
476 COUNT(c1) SUM(c1)
477 0 NULL
478 SELECT COUNT(c1),SUM(c1) FROM t2;
479 COUNT(c1) SUM(c1)
480 4 30
481 DROP TABLE t1,t2,t3;
482 CREATE TABLE t1(c1 TINYINT NOT NULL);
483 CREATE TABLE t2(c1 TINYINT NOT NULL);
484 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
485 CREATE TABLE t3(c1 TINYINT NOT NULL);
486 INSERT INTO t3 (c1) VALUES(5);
487 SELECT COUNT(c1),SUM(c1) FROM t3;
488 COUNT(c1) SUM(c1)
489 1 5
490 DELETE FROM t3 WHERE c1 <= 5;
491 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5;
492 COUNT(c1) SUM(c1)
493 0 NULL
494 SELECT COUNT(c1),SUM(c1) FROM t3;
495 COUNT(c1) SUM(c1)
496 0 NULL
497 DROP TABLE t1,t2,t3;
498 CREATE TABLE t1(c1 SMALLINT NOT NULL);
499 CREATE TABLE t2(c1 SMALLINT NOT NULL);
500 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
501 CREATE TABLE t3(c1 SMALLINT NOT NULL);
502 INSERT INTO t3 (c1) VALUES(5);
503 SELECT COUNT(c1),SUM(c1) FROM t3;
504 COUNT(c1) SUM(c1)
505 1 5
506 DELETE FROM t3 WHERE c1 <= 5;
507 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5;
508 COUNT(c1) SUM(c1)
509 0 NULL
510 SELECT COUNT(c1),SUM(c1) FROM t3;
511 COUNT(c1) SUM(c1)
512 0 NULL
513 DROP TABLE t1,t2,t3;
514 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
515 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
516 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
517 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
518 INSERT INTO t3 (c1) VALUES(5);
519 SELECT COUNT(c1),SUM(c1) FROM t3;
520 COUNT(c1) SUM(c1)
521 1 5
522 DELETE FROM t3 WHERE c1 <= 5;
523 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5;
524 COUNT(c1) SUM(c1)
525 0 NULL
526 SELECT COUNT(c1),SUM(c1) FROM t3;
527 COUNT(c1) SUM(c1)
528 0 NULL
529 DROP TABLE t1,t2,t3;
530 CREATE TABLE t1(c1 INT NOT NULL);
531 CREATE TABLE t2(c1 INT NOT NULL);
532 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
533 CREATE TABLE t3(c1 INT NOT NULL);
534 INSERT INTO t3 (c1) VALUES(5);
535 SELECT COUNT(c1),SUM(c1) FROM t3;
536 COUNT(c1) SUM(c1)
537 1 5
538 DELETE FROM t3 WHERE c1 <= 5;
539 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5;
540 COUNT(c1) SUM(c1)
541 0 NULL
542 SELECT COUNT(c1),SUM(c1) FROM t3;
543 COUNT(c1) SUM(c1)
544 0 NULL
545 DROP TABLE t1,t2,t3;
546 CREATE TABLE t1(c1 INTEGER NOT NULL);
547 CREATE TABLE t2(c1 INTEGER NOT NULL);
548 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
549 CREATE TABLE t3(c1 INTEGER NOT NULL);
550 INSERT INTO t3 (c1) VALUES(5);
551 SELECT COUNT(c1),SUM(c1) FROM t3;
552 COUNT(c1) SUM(c1)
553 1 5
554 DELETE FROM t3 WHERE c1 <= 5;
555 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5;
556 COUNT(c1) SUM(c1)
557 0 NULL
558 SELECT COUNT(c1),SUM(c1) FROM t3;
559 COUNT(c1) SUM(c1)
560 0 NULL
561 DROP TABLE t1,t2,t3;
562 CREATE TABLE t1(c1 BIGINT NOT NULL);
563 CREATE TABLE t2(c1 BIGINT NOT NULL);
564 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
565 CREATE TABLE t3(c1 BIGINT NOT NULL);
566 INSERT INTO t3 (c1) VALUES(5);
567 SELECT COUNT(c1),SUM(c1) FROM t3;
568 COUNT(c1) SUM(c1)
569 1 5
570 DELETE FROM t3 WHERE c1 <= 5;
571 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5;
572 COUNT(c1) SUM(c1)
573 0 NULL
574 SELECT COUNT(c1),SUM(c1) FROM t3;
575 COUNT(c1) SUM(c1)
576 0 NULL
577 DROP TABLE t1,t2,t3;
578 CREATE TABLE t1(c1 TINYINT NOT NULL);
579 CREATE TABLE t2(c1 TINYINT NOT NULL);
580 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
581 CREATE TABLE t3(c1 TINYINT NOT NULL);
582 INSERT INTO t3 (c1) VALUES(5);
583 SELECT COUNT(c1),SUM(c1) FROM t1;
584 COUNT(c1) SUM(c1)
585 0 NULL
586 DELETE FROM t1 WHERE c1 = 5;
587 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5;
588 COUNT(c1) SUM(c1)
589 0 NULL
590 SELECT COUNT(c1),SUM(c1) FROM t1;
591 COUNT(c1) SUM(c1)
592 0 NULL
593 DROP TABLE t1,t2,t3;
594 CREATE TABLE t1(c1 SMALLINT NOT NULL);
595 CREATE TABLE t2(c1 SMALLINT NOT NULL);
596 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
597 CREATE TABLE t3(c1 SMALLINT NOT NULL);
598 INSERT INTO t3 (c1) VALUES(5);
599 SELECT COUNT(c1),SUM(c1) FROM t1;
600 COUNT(c1) SUM(c1)
601 0 NULL
602 DELETE FROM t1 WHERE c1 = 5;
603 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5;
604 COUNT(c1) SUM(c1)
605 0 NULL
606 SELECT COUNT(c1),SUM(c1) FROM t1;
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 t1;
616 COUNT(c1) SUM(c1)
617 0 NULL
618 DELETE FROM t1 WHERE c1 = 5;
619 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5;
620 COUNT(c1) SUM(c1)
621 0 NULL
622 SELECT COUNT(c1),SUM(c1) FROM t1;
623 COUNT(c1) SUM(c1)
624 0 NULL
625 DROP TABLE t1,t2,t3;
626 CREATE TABLE t1(c1 INT NOT NULL);
627 CREATE TABLE t2(c1 INT NOT NULL);
628 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
629 CREATE TABLE t3(c1 INT NOT NULL);
630 INSERT INTO t3 (c1) VALUES(5);
631 SELECT COUNT(c1),SUM(c1) FROM t1;
632 COUNT(c1) SUM(c1)
633 0 NULL
634 DELETE FROM t1 WHERE c1 = 5;
635 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5;
636 COUNT(c1) SUM(c1)
637 0 NULL
638 SELECT COUNT(c1),SUM(c1) FROM t1;
639 COUNT(c1) SUM(c1)
640 0 NULL
641 DROP TABLE t1,t2,t3;
642 CREATE TABLE t1(c1 INTEGER NOT NULL);
643 CREATE TABLE t2(c1 INTEGER NOT NULL);
644 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
645 CREATE TABLE t3(c1 INTEGER NOT NULL);
646 INSERT INTO t3 (c1) VALUES(5);
647 SELECT COUNT(c1),SUM(c1) FROM t1;
648 COUNT(c1) SUM(c1)
649 0 NULL
650 DELETE FROM t1 WHERE c1 = 5;
651 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5;
652 COUNT(c1) SUM(c1)
653 0 NULL
654 SELECT COUNT(c1),SUM(c1) FROM t1;
655 COUNT(c1) SUM(c1)
656 0 NULL
657 DROP TABLE t1,t2,t3;
658 CREATE TABLE t1(c1 BIGINT NOT NULL);
659 CREATE TABLE t2(c1 BIGINT NOT NULL);
660 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
661 CREATE TABLE t3(c1 BIGINT NOT NULL);
662 INSERT INTO t3 (c1) VALUES(5);
663 SELECT COUNT(c1),SUM(c1) FROM t1;
664 COUNT(c1) SUM(c1)
665 0 NULL
666 DELETE FROM t1 WHERE c1 = 5;
667 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5;
668 COUNT(c1) SUM(c1)
669 0 NULL
670 SELECT COUNT(c1),SUM(c1) FROM t1;
671 COUNT(c1) SUM(c1)
672 0 NULL
673 DROP TABLE t1,t2,t3;
674 CREATE TABLE t1(c1 TINYINT NOT NULL);
675 CREATE TABLE t2(c1 TINYINT NOT NULL);
676 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
677 CREATE TABLE t3(c1 TINYINT NOT NULL);
678 INSERT INTO t3 (c1) VALUES(5);
679 SELECT COUNT(c1),SUM(c1) FROM t2;
680 COUNT(c1) SUM(c1)
681 10 45
682 DELETE FROM t2 WHERE c1 = 5;
683 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5;
684 COUNT(c1) SUM(c1)
685 0 NULL
686 SELECT COUNT(c1),SUM(c1) FROM t2;
687 COUNT(c1) SUM(c1)
688 9 40
689 DROP TABLE t1,t2,t3;
690 CREATE TABLE t1(c1 SMALLINT NOT NULL);
691 CREATE TABLE t2(c1 SMALLINT NOT NULL);
692 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
693 CREATE TABLE t3(c1 SMALLINT NOT NULL);
694 INSERT INTO t3 (c1) VALUES(5);
695 SELECT COUNT(c1),SUM(c1) FROM t2;
696 COUNT(c1) SUM(c1)
697 10 45
698 DELETE FROM t2 WHERE c1 = 5;
699 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5;
700 COUNT(c1) SUM(c1)
701 0 NULL
702 SELECT COUNT(c1),SUM(c1) FROM t2;
703 COUNT(c1) SUM(c1)
704 9 40
705 DROP TABLE t1,t2,t3;
706 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
707 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
708 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
709 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
710 INSERT INTO t3 (c1) VALUES(5);
711 SELECT COUNT(c1),SUM(c1) FROM t2;
712 COUNT(c1) SUM(c1)
713 10 45
714 DELETE FROM t2 WHERE c1 = 5;
715 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5;
716 COUNT(c1) SUM(c1)
717 0 NULL
718 SELECT COUNT(c1),SUM(c1) FROM t2;
719 COUNT(c1) SUM(c1)
720 9 40
721 DROP TABLE t1,t2,t3;
722 CREATE TABLE t1(c1 INT NOT NULL);
723 CREATE TABLE t2(c1 INT NOT NULL);
724 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
725 CREATE TABLE t3(c1 INT NOT NULL);
726 INSERT INTO t3 (c1) VALUES(5);
727 SELECT COUNT(c1),SUM(c1) FROM t2;
728 COUNT(c1) SUM(c1)
729 10 45
730 DELETE FROM t2 WHERE c1 = 5;
731 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5;
732 COUNT(c1) SUM(c1)
733 0 NULL
734 SELECT COUNT(c1),SUM(c1) FROM t2;
735 COUNT(c1) SUM(c1)
736 9 40
737 DROP TABLE t1,t2,t3;
738 CREATE TABLE t1(c1 INTEGER NOT NULL);
739 CREATE TABLE t2(c1 INTEGER NOT NULL);
740 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
741 CREATE TABLE t3(c1 INTEGER NOT NULL);
742 INSERT INTO t3 (c1) VALUES(5);
743 SELECT COUNT(c1),SUM(c1) FROM t2;
744 COUNT(c1) SUM(c1)
745 10 45
746 DELETE FROM t2 WHERE c1 = 5;
747 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5;
748 COUNT(c1) SUM(c1)
749 0 NULL
750 SELECT COUNT(c1),SUM(c1) FROM t2;
751 COUNT(c1) SUM(c1)
752 9 40
753 DROP TABLE t1,t2,t3;
754 CREATE TABLE t1(c1 BIGINT NOT NULL);
755 CREATE TABLE t2(c1 BIGINT NOT NULL);
756 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
757 CREATE TABLE t3(c1 BIGINT NOT NULL);
758 INSERT INTO t3 (c1) VALUES(5);
759 SELECT COUNT(c1),SUM(c1) FROM t2;
760 COUNT(c1) SUM(c1)
761 10 45
762 DELETE FROM t2 WHERE c1 = 5;
763 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5;
764 COUNT(c1) SUM(c1)
765 0 NULL
766 SELECT COUNT(c1),SUM(c1) FROM t2;
767 COUNT(c1) SUM(c1)
768 9 40
769 DROP TABLE t1,t2,t3;
770 CREATE TABLE t1(c1 TINYINT NOT NULL);
771 CREATE TABLE t2(c1 TINYINT NOT NULL);
772 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
773 CREATE TABLE t3(c1 TINYINT NOT NULL);
774 INSERT INTO t3 (c1) VALUES(5);
775 SELECT COUNT(c1),SUM(c1) FROM t3;
776 COUNT(c1) SUM(c1)
777 1 5
778 DELETE FROM t3 WHERE c1 = 5;
779 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5;
780 COUNT(c1) SUM(c1)
781 0 NULL
782 SELECT COUNT(c1),SUM(c1) FROM t3;
783 COUNT(c1) SUM(c1)
784 0 NULL
785 DROP TABLE t1,t2,t3;
786 CREATE TABLE t1(c1 SMALLINT NOT NULL);
787 CREATE TABLE t2(c1 SMALLINT NOT NULL);
788 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
789 CREATE TABLE t3(c1 SMALLINT NOT NULL);
790 INSERT INTO t3 (c1) VALUES(5);
791 SELECT COUNT(c1),SUM(c1) FROM t3;
792 COUNT(c1) SUM(c1)
793 1 5
794 DELETE FROM t3 WHERE c1 = 5;
795 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5;
796 COUNT(c1) SUM(c1)
797 0 NULL
798 SELECT COUNT(c1),SUM(c1) FROM t3;
799 COUNT(c1) SUM(c1)
800 0 NULL
801 DROP TABLE t1,t2,t3;
802 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
803 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
804 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
805 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
806 INSERT INTO t3 (c1) VALUES(5);
807 SELECT COUNT(c1),SUM(c1) FROM t3;
808 COUNT(c1) SUM(c1)
809 1 5
810 DELETE FROM t3 WHERE c1 = 5;
811 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5;
812 COUNT(c1) SUM(c1)
813 0 NULL
814 SELECT COUNT(c1),SUM(c1) FROM t3;
815 COUNT(c1) SUM(c1)
816 0 NULL
817 DROP TABLE t1,t2,t3;
818 CREATE TABLE t1(c1 INT NOT NULL);
819 CREATE TABLE t2(c1 INT NOT NULL);
820 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
821 CREATE TABLE t3(c1 INT NOT NULL);
822 INSERT INTO t3 (c1) VALUES(5);
823 SELECT COUNT(c1),SUM(c1) FROM t3;
824 COUNT(c1) SUM(c1)
825 1 5
826 DELETE FROM t3 WHERE c1 = 5;
827 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5;
828 COUNT(c1) SUM(c1)
829 0 NULL
830 SELECT COUNT(c1),SUM(c1) FROM t3;
831 COUNT(c1) SUM(c1)
832 0 NULL
833 DROP TABLE t1,t2,t3;
834 CREATE TABLE t1(c1 INTEGER NOT NULL);
835 CREATE TABLE t2(c1 INTEGER NOT NULL);
836 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
837 CREATE TABLE t3(c1 INTEGER NOT NULL);
838 INSERT INTO t3 (c1) VALUES(5);
839 SELECT COUNT(c1),SUM(c1) FROM t3;
840 COUNT(c1) SUM(c1)
841 1 5
842 DELETE FROM t3 WHERE c1 = 5;
843 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5;
844 COUNT(c1) SUM(c1)
845 0 NULL
846 SELECT COUNT(c1),SUM(c1) FROM t3;
847 COUNT(c1) SUM(c1)
848 0 NULL
849 DROP TABLE t1,t2,t3;
850 CREATE TABLE t1(c1 BIGINT NOT NULL);
851 CREATE TABLE t2(c1 BIGINT NOT NULL);
852 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
853 CREATE TABLE t3(c1 BIGINT NOT NULL);
854 INSERT INTO t3 (c1) VALUES(5);
855 SELECT COUNT(c1),SUM(c1) FROM t3;
856 COUNT(c1) SUM(c1)
857 1 5
858 DELETE FROM t3 WHERE c1 = 5;
859 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5;
860 COUNT(c1) SUM(c1)
861 0 NULL
862 SELECT COUNT(c1),SUM(c1) FROM t3;
863 COUNT(c1) SUM(c1)
864 0 NULL
865 DROP TABLE t1,t2,t3;
866 CREATE TABLE t1(c1 TINYINT NOT NULL);
867 CREATE TABLE t2(c1 TINYINT NOT NULL);
868 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
869 CREATE TABLE t3(c1 TINYINT NOT NULL);
870 INSERT INTO t3 (c1) VALUES(5);
871 SELECT COUNT(c1),SUM(c1) FROM t1;
872 COUNT(c1) SUM(c1)
873 0 NULL
874 DELETE FROM t1 WHERE c1 >= 5;
875 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5;
876 COUNT(c1) SUM(c1)
877 0 NULL
878 SELECT COUNT(c1),SUM(c1) FROM t1;
879 COUNT(c1) SUM(c1)
880 0 NULL
881 DROP TABLE t1,t2,t3;
882 CREATE TABLE t1(c1 SMALLINT NOT NULL);
883 CREATE TABLE t2(c1 SMALLINT NOT NULL);
884 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
885 CREATE TABLE t3(c1 SMALLINT NOT NULL);
886 INSERT INTO t3 (c1) VALUES(5);
887 SELECT COUNT(c1),SUM(c1) FROM t1;
888 COUNT(c1) SUM(c1)
889 0 NULL
890 DELETE FROM t1 WHERE c1 >= 5;
891 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5;
892 COUNT(c1) SUM(c1)
893 0 NULL
894 SELECT COUNT(c1),SUM(c1) FROM t1;
895 COUNT(c1) SUM(c1)
896 0 NULL
897 DROP TABLE t1,t2,t3;
898 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
899 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
900 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
901 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
902 INSERT INTO t3 (c1) VALUES(5);
903 SELECT COUNT(c1),SUM(c1) FROM t1;
904 COUNT(c1) SUM(c1)
905 0 NULL
906 DELETE FROM t1 WHERE c1 >= 5;
907 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5;
908 COUNT(c1) SUM(c1)
909 0 NULL
910 SELECT COUNT(c1),SUM(c1) FROM t1;
911 COUNT(c1) SUM(c1)
912 0 NULL
913 DROP TABLE t1,t2,t3;
914 CREATE TABLE t1(c1 INT NOT NULL);
915 CREATE TABLE t2(c1 INT NOT NULL);
916 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
917 CREATE TABLE t3(c1 INT NOT NULL);
918 INSERT INTO t3 (c1) VALUES(5);
919 SELECT COUNT(c1),SUM(c1) FROM t1;
920 COUNT(c1) SUM(c1)
921 0 NULL
922 DELETE FROM t1 WHERE c1 >= 5;
923 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5;
924 COUNT(c1) SUM(c1)
925 0 NULL
926 SELECT COUNT(c1),SUM(c1) FROM t1;
927 COUNT(c1) SUM(c1)
928 0 NULL
929 DROP TABLE t1,t2,t3;
930 CREATE TABLE t1(c1 INTEGER NOT NULL);
931 CREATE TABLE t2(c1 INTEGER NOT NULL);
932 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
933 CREATE TABLE t3(c1 INTEGER NOT NULL);
934 INSERT INTO t3 (c1) VALUES(5);
935 SELECT COUNT(c1),SUM(c1) FROM t1;
936 COUNT(c1) SUM(c1)
937 0 NULL
938 DELETE FROM t1 WHERE c1 >= 5;
939 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5;
940 COUNT(c1) SUM(c1)
941 0 NULL
942 SELECT COUNT(c1),SUM(c1) FROM t1;
943 COUNT(c1) SUM(c1)
944 0 NULL
945 DROP TABLE t1,t2,t3;
946 CREATE TABLE t1(c1 BIGINT NOT NULL);
947 CREATE TABLE t2(c1 BIGINT NOT NULL);
948 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
949 CREATE TABLE t3(c1 BIGINT NOT NULL);
950 INSERT INTO t3 (c1) VALUES(5);
951 SELECT COUNT(c1),SUM(c1) FROM t1;
952 COUNT(c1) SUM(c1)
953 0 NULL
954 DELETE FROM t1 WHERE c1 >= 5;
955 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5;
956 COUNT(c1) SUM(c1)
957 0 NULL
958 SELECT COUNT(c1),SUM(c1) FROM t1;
959 COUNT(c1) SUM(c1)
960 0 NULL
961 DROP TABLE t1,t2,t3;
962 CREATE TABLE t1(c1 TINYINT NOT NULL);
963 CREATE TABLE t2(c1 TINYINT NOT NULL);
964 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
965 CREATE TABLE t3(c1 TINYINT NOT NULL);
966 INSERT INTO t3 (c1) VALUES(5);
967 SELECT COUNT(c1),SUM(c1) FROM t2;
968 COUNT(c1) SUM(c1)
969 10 45
970 DELETE FROM t2 WHERE c1 >= 5;
971 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5;
972 COUNT(c1) SUM(c1)
973 0 NULL
974 SELECT COUNT(c1),SUM(c1) FROM t2;
975 COUNT(c1) SUM(c1)
976 5 10
977 DROP TABLE t1,t2,t3;
978 CREATE TABLE t1(c1 SMALLINT NOT NULL);
979 CREATE TABLE t2(c1 SMALLINT NOT NULL);
980 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
981 CREATE TABLE t3(c1 SMALLINT NOT NULL);
982 INSERT INTO t3 (c1) VALUES(5);
983 SELECT COUNT(c1),SUM(c1) FROM t2;
984 COUNT(c1) SUM(c1)
985 10 45
986 DELETE FROM t2 WHERE c1 >= 5;
987 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5;
988 COUNT(c1) SUM(c1)
989 0 NULL
990 SELECT COUNT(c1),SUM(c1) FROM t2;
991 COUNT(c1) SUM(c1)
992 5 10
993 DROP TABLE t1,t2,t3;
994 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
995 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
996 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
997 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
998 INSERT INTO t3 (c1) VALUES(5);
999 SELECT COUNT(c1),SUM(c1) FROM t2;
1000 COUNT(c1) SUM(c1)
1001 10 45
1002 DELETE FROM t2 WHERE c1 >= 5;
1003 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5;
1004 COUNT(c1) SUM(c1)
1005 0 NULL
1006 SELECT COUNT(c1),SUM(c1) FROM t2;
1007 COUNT(c1) SUM(c1)
1008 5 10
1009 DROP TABLE t1,t2,t3;
1010 CREATE TABLE t1(c1 INT NOT NULL);
1011 CREATE TABLE t2(c1 INT NOT NULL);
1012 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1013 CREATE TABLE t3(c1 INT NOT NULL);
1014 INSERT INTO t3 (c1) VALUES(5);
1015 SELECT COUNT(c1),SUM(c1) FROM t2;
1016 COUNT(c1) SUM(c1)
1017 10 45
1018 DELETE FROM t2 WHERE c1 >= 5;
1019 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5;
1020 COUNT(c1) SUM(c1)
1021 0 NULL
1022 SELECT COUNT(c1),SUM(c1) FROM t2;
1023 COUNT(c1) SUM(c1)
1024 5 10
1025 DROP TABLE t1,t2,t3;
1026 CREATE TABLE t1(c1 INTEGER NOT NULL);
1027 CREATE TABLE t2(c1 INTEGER NOT NULL);
1028 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1029 CREATE TABLE t3(c1 INTEGER NOT NULL);
1030 INSERT INTO t3 (c1) VALUES(5);
1031 SELECT COUNT(c1),SUM(c1) FROM t2;
1032 COUNT(c1) SUM(c1)
1033 10 45
1034 DELETE FROM t2 WHERE c1 >= 5;
1035 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5;
1036 COUNT(c1) SUM(c1)
1037 0 NULL
1038 SELECT COUNT(c1),SUM(c1) FROM t2;
1039 COUNT(c1) SUM(c1)
1040 5 10
1041 DROP TABLE t1,t2,t3;
1042 CREATE TABLE t1(c1 BIGINT NOT NULL);
1043 CREATE TABLE t2(c1 BIGINT NOT NULL);
1044 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1045 CREATE TABLE t3(c1 BIGINT NOT NULL);
1046 INSERT INTO t3 (c1) VALUES(5);
1047 SELECT COUNT(c1),SUM(c1) FROM t2;
1048 COUNT(c1) SUM(c1)
1049 10 45
1050 DELETE FROM t2 WHERE c1 >= 5;
1051 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5;
1052 COUNT(c1) SUM(c1)
1053 0 NULL
1054 SELECT COUNT(c1),SUM(c1) FROM t2;
1055 COUNT(c1) SUM(c1)
1056 5 10
1057 DROP TABLE t1,t2,t3;
1058 CREATE TABLE t1(c1 TINYINT NOT NULL);
1059 CREATE TABLE t2(c1 TINYINT NOT NULL);
1060 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1061 CREATE TABLE t3(c1 TINYINT NOT NULL);
1062 INSERT INTO t3 (c1) VALUES(5);
1063 SELECT COUNT(c1),SUM(c1) FROM t3;
1064 COUNT(c1) SUM(c1)
1065 1 5
1066 DELETE FROM t3 WHERE c1 >= 5;
1067 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5;
1068 COUNT(c1) SUM(c1)
1069 0 NULL
1070 SELECT COUNT(c1),SUM(c1) FROM t3;
1071 COUNT(c1) SUM(c1)
1072 0 NULL
1073 DROP TABLE t1,t2,t3;
1074 CREATE TABLE t1(c1 SMALLINT NOT NULL);
1075 CREATE TABLE t2(c1 SMALLINT NOT NULL);
1076 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1077 CREATE TABLE t3(c1 SMALLINT NOT NULL);
1078 INSERT INTO t3 (c1) VALUES(5);
1079 SELECT COUNT(c1),SUM(c1) FROM t3;
1080 COUNT(c1) SUM(c1)
1081 1 5
1082 DELETE FROM t3 WHERE c1 >= 5;
1083 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5;
1084 COUNT(c1) SUM(c1)
1085 0 NULL
1086 SELECT COUNT(c1),SUM(c1) FROM t3;
1087 COUNT(c1) SUM(c1)
1088 0 NULL
1089 DROP TABLE t1,t2,t3;
1090 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
1091 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
1092 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1093 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
1094 INSERT INTO t3 (c1) VALUES(5);
1095 SELECT COUNT(c1),SUM(c1) FROM t3;
1096 COUNT(c1) SUM(c1)
1097 1 5
1098 DELETE FROM t3 WHERE c1 >= 5;
1099 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5;
1100 COUNT(c1) SUM(c1)
1101 0 NULL
1102 SELECT COUNT(c1),SUM(c1) FROM t3;
1103 COUNT(c1) SUM(c1)
1104 0 NULL
1105 DROP TABLE t1,t2,t3;
1106 CREATE TABLE t1(c1 INT NOT NULL);
1107 CREATE TABLE t2(c1 INT NOT NULL);
1108 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1109 CREATE TABLE t3(c1 INT NOT NULL);
1110 INSERT INTO t3 (c1) VALUES(5);
1111 SELECT COUNT(c1),SUM(c1) FROM t3;
1112 COUNT(c1) SUM(c1)
1113 1 5
1114 DELETE FROM t3 WHERE c1 >= 5;
1115 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5;
1116 COUNT(c1) SUM(c1)
1117 0 NULL
1118 SELECT COUNT(c1),SUM(c1) FROM t3;
1119 COUNT(c1) SUM(c1)
1120 0 NULL
1121 DROP TABLE t1,t2,t3;
1122 CREATE TABLE t1(c1 INTEGER NOT NULL);
1123 CREATE TABLE t2(c1 INTEGER NOT NULL);
1124 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1125 CREATE TABLE t3(c1 INTEGER NOT NULL);
1126 INSERT INTO t3 (c1) VALUES(5);
1127 SELECT COUNT(c1),SUM(c1) FROM t3;
1128 COUNT(c1) SUM(c1)
1129 1 5
1130 DELETE FROM t3 WHERE c1 >= 5;
1131 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5;
1132 COUNT(c1) SUM(c1)
1133 0 NULL
1134 SELECT COUNT(c1),SUM(c1) FROM t3;
1135 COUNT(c1) SUM(c1)
1136 0 NULL
1137 DROP TABLE t1,t2,t3;
1138 CREATE TABLE t1(c1 BIGINT NOT NULL);
1139 CREATE TABLE t2(c1 BIGINT NOT NULL);
1140 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1141 CREATE TABLE t3(c1 BIGINT NOT NULL);
1142 INSERT INTO t3 (c1) VALUES(5);
1143 SELECT COUNT(c1),SUM(c1) FROM t3;
1144 COUNT(c1) SUM(c1)
1145 1 5
1146 DELETE FROM t3 WHERE c1 >= 5;
1147 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5;
1148 COUNT(c1) SUM(c1)
1149 0 NULL
1150 SELECT COUNT(c1),SUM(c1) FROM t3;
1151 COUNT(c1) SUM(c1)
1152 0 NULL
1153 DROP TABLE t1,t2,t3;
1154 CREATE TABLE t1(c1 TINYINT NOT NULL);
1155 CREATE TABLE t2(c1 TINYINT NOT NULL);
1156 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1157 CREATE TABLE t3(c1 TINYINT NOT NULL);
1158 INSERT INTO t3 (c1) VALUES(5);
1159 SELECT COUNT(c1),SUM(c1) FROM t1;
1160 COUNT(c1) SUM(c1)
1161 0 NULL
1162 DELETE FROM t1 WHERE c1 != 5;
1163 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5;
1164 COUNT(c1) SUM(c1)
1165 0 NULL
1166 SELECT COUNT(c1),SUM(c1) FROM t1;
1167 COUNT(c1) SUM(c1)
1168 0 NULL
1169 DROP TABLE t1,t2,t3;
1170 CREATE TABLE t1(c1 SMALLINT NOT NULL);
1171 CREATE TABLE t2(c1 SMALLINT NOT NULL);
1172 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1173 CREATE TABLE t3(c1 SMALLINT NOT NULL);
1174 INSERT INTO t3 (c1) VALUES(5);
1175 SELECT COUNT(c1),SUM(c1) FROM t1;
1176 COUNT(c1) SUM(c1)
1177 0 NULL
1178 DELETE FROM t1 WHERE c1 != 5;
1179 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5;
1180 COUNT(c1) SUM(c1)
1181 0 NULL
1182 SELECT COUNT(c1),SUM(c1) FROM t1;
1183 COUNT(c1) SUM(c1)
1184 0 NULL
1185 DROP TABLE t1,t2,t3;
1186 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
1187 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
1188 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1189 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
1190 INSERT INTO t3 (c1) VALUES(5);
1191 SELECT COUNT(c1),SUM(c1) FROM t1;
1192 COUNT(c1) SUM(c1)
1193 0 NULL
1194 DELETE FROM t1 WHERE c1 != 5;
1195 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5;
1196 COUNT(c1) SUM(c1)
1197 0 NULL
1198 SELECT COUNT(c1),SUM(c1) FROM t1;
1199 COUNT(c1) SUM(c1)
1200 0 NULL
1201 DROP TABLE t1,t2,t3;
1202 CREATE TABLE t1(c1 INT NOT NULL);
1203 CREATE TABLE t2(c1 INT NOT NULL);
1204 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1205 CREATE TABLE t3(c1 INT NOT NULL);
1206 INSERT INTO t3 (c1) VALUES(5);
1207 SELECT COUNT(c1),SUM(c1) FROM t1;
1208 COUNT(c1) SUM(c1)
1209 0 NULL
1210 DELETE FROM t1 WHERE c1 != 5;
1211 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5;
1212 COUNT(c1) SUM(c1)
1213 0 NULL
1214 SELECT COUNT(c1),SUM(c1) FROM t1;
1215 COUNT(c1) SUM(c1)
1216 0 NULL
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 t1;
1224 COUNT(c1) SUM(c1)
1225 0 NULL
1226 DELETE FROM t1 WHERE c1 != 5;
1227 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5;
1228 COUNT(c1) SUM(c1)
1229 0 NULL
1230 SELECT COUNT(c1),SUM(c1) FROM t1;
1231 COUNT(c1) SUM(c1)
1232 0 NULL
1233 DROP TABLE t1,t2,t3;
1234 CREATE TABLE t1(c1 BIGINT NOT NULL);
1235 CREATE TABLE t2(c1 BIGINT NOT NULL);
1236 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1237 CREATE TABLE t3(c1 BIGINT NOT NULL);
1238 INSERT INTO t3 (c1) VALUES(5);
1239 SELECT COUNT(c1),SUM(c1) FROM t1;
1240 COUNT(c1) SUM(c1)
1241 0 NULL
1242 DELETE FROM t1 WHERE c1 != 5;
1243 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5;
1244 COUNT(c1) SUM(c1)
1245 0 NULL
1246 SELECT COUNT(c1),SUM(c1) FROM t1;
1247 COUNT(c1) SUM(c1)
1248 0 NULL
1249 DROP TABLE t1,t2,t3;
1250 CREATE TABLE t1(c1 TINYINT NOT NULL);
1251 CREATE TABLE t2(c1 TINYINT NOT NULL);
1252 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1253 CREATE TABLE t3(c1 TINYINT NOT NULL);
1254 INSERT INTO t3 (c1) VALUES(5);
1255 SELECT COUNT(c1),SUM(c1) FROM t2;
1256 COUNT(c1) SUM(c1)
1257 10 45
1258 DELETE FROM t2 WHERE c1 != 5;
1259 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5;
1260 COUNT(c1) SUM(c1)
1261 0 NULL
1262 SELECT COUNT(c1),SUM(c1) FROM t2;
1263 COUNT(c1) SUM(c1)
1264 1 5
1265 DROP TABLE t1,t2,t3;
1266 CREATE TABLE t1(c1 SMALLINT NOT NULL);
1267 CREATE TABLE t2(c1 SMALLINT NOT NULL);
1268 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1269 CREATE TABLE t3(c1 SMALLINT NOT NULL);
1270 INSERT INTO t3 (c1) VALUES(5);
1271 SELECT COUNT(c1),SUM(c1) FROM t2;
1272 COUNT(c1) SUM(c1)
1273 10 45
1274 DELETE FROM t2 WHERE c1 != 5;
1275 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5;
1276 COUNT(c1) SUM(c1)
1277 0 NULL
1278 SELECT COUNT(c1),SUM(c1) FROM t2;
1279 COUNT(c1) SUM(c1)
1280 1 5
1281 DROP TABLE t1,t2,t3;
1282 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
1283 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
1284 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1285 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
1286 INSERT INTO t3 (c1) VALUES(5);
1287 SELECT COUNT(c1),SUM(c1) FROM t2;
1288 COUNT(c1) SUM(c1)
1289 10 45
1290 DELETE FROM t2 WHERE c1 != 5;
1291 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5;
1292 COUNT(c1) SUM(c1)
1293 0 NULL
1294 SELECT COUNT(c1),SUM(c1) FROM t2;
1295 COUNT(c1) SUM(c1)
1296 1 5
1297 DROP TABLE t1,t2,t3;
1298 CREATE TABLE t1(c1 INT NOT NULL);
1299 CREATE TABLE t2(c1 INT NOT NULL);
1300 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1301 CREATE TABLE t3(c1 INT NOT NULL);
1302 INSERT INTO t3 (c1) VALUES(5);
1303 SELECT COUNT(c1),SUM(c1) FROM t2;
1304 COUNT(c1) SUM(c1)
1305 10 45
1306 DELETE FROM t2 WHERE c1 != 5;
1307 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5;
1308 COUNT(c1) SUM(c1)
1309 0 NULL
1310 SELECT COUNT(c1),SUM(c1) FROM t2;
1311 COUNT(c1) SUM(c1)
1312 1 5
1313 DROP TABLE t1,t2,t3;
1314 CREATE TABLE t1(c1 INTEGER NOT NULL);
1315 CREATE TABLE t2(c1 INTEGER NOT NULL);
1316 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1317 CREATE TABLE t3(c1 INTEGER NOT NULL);
1318 INSERT INTO t3 (c1) VALUES(5);
1319 SELECT COUNT(c1),SUM(c1) FROM t2;
1320 COUNT(c1) SUM(c1)
1321 10 45
1322 DELETE FROM t2 WHERE c1 != 5;
1323 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5;
1324 COUNT(c1) SUM(c1)
1325 0 NULL
1326 SELECT COUNT(c1),SUM(c1) FROM t2;
1327 COUNT(c1) SUM(c1)
1328 1 5
1329 DROP TABLE t1,t2,t3;
1330 CREATE TABLE t1(c1 BIGINT NOT NULL);
1331 CREATE TABLE t2(c1 BIGINT NOT NULL);
1332 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1333 CREATE TABLE t3(c1 BIGINT NOT NULL);
1334 INSERT INTO t3 (c1) VALUES(5);
1335 SELECT COUNT(c1),SUM(c1) FROM t2;
1336 COUNT(c1) SUM(c1)
1337 10 45
1338 DELETE FROM t2 WHERE c1 != 5;
1339 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5;
1340 COUNT(c1) SUM(c1)
1341 0 NULL
1342 SELECT COUNT(c1),SUM(c1) FROM t2;
1343 COUNT(c1) SUM(c1)
1344 1 5
1345 DROP TABLE t1,t2,t3;
1346 CREATE TABLE t1(c1 TINYINT NOT NULL);
1347 CREATE TABLE t2(c1 TINYINT NOT NULL);
1348 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1349 CREATE TABLE t3(c1 TINYINT NOT NULL);
1350 INSERT INTO t3 (c1) VALUES(5);
1351 SELECT COUNT(c1),SUM(c1) FROM t3;
1352 COUNT(c1) SUM(c1)
1353 1 5
1354 DELETE FROM t3 WHERE c1 != 5;
1355 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5;
1356 COUNT(c1) SUM(c1)
1357 0 NULL
1358 SELECT COUNT(c1),SUM(c1) FROM t3;
1359 COUNT(c1) SUM(c1)
1360 1 5
1361 DROP TABLE t1,t2,t3;
1362 CREATE TABLE t1(c1 SMALLINT NOT NULL);
1363 CREATE TABLE t2(c1 SMALLINT NOT NULL);
1364 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1365 CREATE TABLE t3(c1 SMALLINT NOT NULL);
1366 INSERT INTO t3 (c1) VALUES(5);
1367 SELECT COUNT(c1),SUM(c1) FROM t3;
1368 COUNT(c1) SUM(c1)
1369 1 5
1370 DELETE FROM t3 WHERE c1 != 5;
1371 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5;
1372 COUNT(c1) SUM(c1)
1373 0 NULL
1374 SELECT COUNT(c1),SUM(c1) FROM t3;
1375 COUNT(c1) SUM(c1)
1376 1 5
1377 DROP TABLE t1,t2,t3;
1378 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
1379 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
1380 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1381 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
1382 INSERT INTO t3 (c1) VALUES(5);
1383 SELECT COUNT(c1),SUM(c1) FROM t3;
1384 COUNT(c1) SUM(c1)
1385 1 5
1386 DELETE FROM t3 WHERE c1 != 5;
1387 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5;
1388 COUNT(c1) SUM(c1)
1389 0 NULL
1390 SELECT COUNT(c1),SUM(c1) FROM t3;
1391 COUNT(c1) SUM(c1)
1392 1 5
1393 DROP TABLE t1,t2,t3;
1394 CREATE TABLE t1(c1 INT NOT NULL);
1395 CREATE TABLE t2(c1 INT NOT NULL);
1396 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1397 CREATE TABLE t3(c1 INT NOT NULL);
1398 INSERT INTO t3 (c1) VALUES(5);
1399 SELECT COUNT(c1),SUM(c1) FROM t3;
1400 COUNT(c1) SUM(c1)
1401 1 5
1402 DELETE FROM t3 WHERE c1 != 5;
1403 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5;
1404 COUNT(c1) SUM(c1)
1405 0 NULL
1406 SELECT COUNT(c1),SUM(c1) FROM t3;
1407 COUNT(c1) SUM(c1)
1408 1 5
1409 DROP TABLE t1,t2,t3;
1410 CREATE TABLE t1(c1 INTEGER NOT NULL);
1411 CREATE TABLE t2(c1 INTEGER NOT NULL);
1412 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1413 CREATE TABLE t3(c1 INTEGER NOT NULL);
1414 INSERT INTO t3 (c1) VALUES(5);
1415 SELECT COUNT(c1),SUM(c1) FROM t3;
1416 COUNT(c1) SUM(c1)
1417 1 5
1418 DELETE FROM t3 WHERE c1 != 5;
1419 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5;
1420 COUNT(c1) SUM(c1)
1421 0 NULL
1422 SELECT COUNT(c1),SUM(c1) FROM t3;
1423 COUNT(c1) SUM(c1)
1424 1 5
1425 DROP TABLE t1,t2,t3;
1426 CREATE TABLE t1(c1 BIGINT NOT NULL);
1427 CREATE TABLE t2(c1 BIGINT NOT NULL);
1428 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1429 CREATE TABLE t3(c1 BIGINT NOT NULL);
1430 INSERT INTO t3 (c1) VALUES(5);
1431 SELECT COUNT(c1),SUM(c1) FROM t3;
1432 COUNT(c1) SUM(c1)
1433 1 5
1434 DELETE FROM t3 WHERE c1 != 5;
1435 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5;
1436 COUNT(c1) SUM(c1)
1437 0 NULL
1438 SELECT COUNT(c1),SUM(c1) FROM t3;
1439 COUNT(c1) SUM(c1)
1440 1 5
1441 DROP TABLE t1,t2,t3;
1442 CREATE TABLE t1(c1 TINYINT NOT NULL);
1443 CREATE TABLE t2(c1 TINYINT NOT NULL);
1444 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1445 CREATE TABLE t3(c1 TINYINT NOT NULL);
1446 INSERT INTO t3 (c1) VALUES(5);
1447 SELECT COUNT(c1),SUM(c1) FROM t1;
1448 COUNT(c1) SUM(c1)
1449 0 NULL
1450 DELETE FROM t1 WHERE c1 <> 5;
1451 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5;
1452 COUNT(c1) SUM(c1)
1453 0 NULL
1454 SELECT COUNT(c1),SUM(c1) FROM t1;
1455 COUNT(c1) SUM(c1)
1456 0 NULL
1457 DROP TABLE t1,t2,t3;
1458 CREATE TABLE t1(c1 SMALLINT NOT NULL);
1459 CREATE TABLE t2(c1 SMALLINT NOT NULL);
1460 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1461 CREATE TABLE t3(c1 SMALLINT NOT NULL);
1462 INSERT INTO t3 (c1) VALUES(5);
1463 SELECT COUNT(c1),SUM(c1) FROM t1;
1464 COUNT(c1) SUM(c1)
1465 0 NULL
1466 DELETE FROM t1 WHERE c1 <> 5;
1467 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5;
1468 COUNT(c1) SUM(c1)
1469 0 NULL
1470 SELECT COUNT(c1),SUM(c1) FROM t1;
1471 COUNT(c1) SUM(c1)
1472 0 NULL
1473 DROP TABLE t1,t2,t3;
1474 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
1475 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
1476 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1477 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
1478 INSERT INTO t3 (c1) VALUES(5);
1479 SELECT COUNT(c1),SUM(c1) FROM t1;
1480 COUNT(c1) SUM(c1)
1481 0 NULL
1482 DELETE FROM t1 WHERE c1 <> 5;
1483 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5;
1484 COUNT(c1) SUM(c1)
1485 0 NULL
1486 SELECT COUNT(c1),SUM(c1) FROM t1;
1487 COUNT(c1) SUM(c1)
1488 0 NULL
1489 DROP TABLE t1,t2,t3;
1490 CREATE TABLE t1(c1 INT NOT NULL);
1491 CREATE TABLE t2(c1 INT NOT NULL);
1492 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1493 CREATE TABLE t3(c1 INT NOT NULL);
1494 INSERT INTO t3 (c1) VALUES(5);
1495 SELECT COUNT(c1),SUM(c1) FROM t1;
1496 COUNT(c1) SUM(c1)
1497 0 NULL
1498 DELETE FROM t1 WHERE c1 <> 5;
1499 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5;
1500 COUNT(c1) SUM(c1)
1501 0 NULL
1502 SELECT COUNT(c1),SUM(c1) FROM t1;
1503 COUNT(c1) SUM(c1)
1504 0 NULL
1505 DROP TABLE t1,t2,t3;
1506 CREATE TABLE t1(c1 INTEGER NOT NULL);
1507 CREATE TABLE t2(c1 INTEGER NOT NULL);
1508 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1509 CREATE TABLE t3(c1 INTEGER NOT NULL);
1510 INSERT INTO t3 (c1) VALUES(5);
1511 SELECT COUNT(c1),SUM(c1) FROM t1;
1512 COUNT(c1) SUM(c1)
1513 0 NULL
1514 DELETE FROM t1 WHERE c1 <> 5;
1515 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5;
1516 COUNT(c1) SUM(c1)
1517 0 NULL
1518 SELECT COUNT(c1),SUM(c1) FROM t1;
1519 COUNT(c1) SUM(c1)
1520 0 NULL
1521 DROP TABLE t1,t2,t3;
1522 CREATE TABLE t1(c1 BIGINT NOT NULL);
1523 CREATE TABLE t2(c1 BIGINT NOT NULL);
1524 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1525 CREATE TABLE t3(c1 BIGINT NOT NULL);
1526 INSERT INTO t3 (c1) VALUES(5);
1527 SELECT COUNT(c1),SUM(c1) FROM t1;
1528 COUNT(c1) SUM(c1)
1529 0 NULL
1530 DELETE FROM t1 WHERE c1 <> 5;
1531 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5;
1532 COUNT(c1) SUM(c1)
1533 0 NULL
1534 SELECT COUNT(c1),SUM(c1) FROM t1;
1535 COUNT(c1) SUM(c1)
1536 0 NULL
1537 DROP TABLE t1,t2,t3;
1538 CREATE TABLE t1(c1 TINYINT NOT NULL);
1539 CREATE TABLE t2(c1 TINYINT NOT NULL);
1540 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1541 CREATE TABLE t3(c1 TINYINT NOT NULL);
1542 INSERT INTO t3 (c1) VALUES(5);
1543 SELECT COUNT(c1),SUM(c1) FROM t2;
1544 COUNT(c1) SUM(c1)
1545 10 45
1546 DELETE FROM t2 WHERE c1 <> 5;
1547 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5;
1548 COUNT(c1) SUM(c1)
1549 0 NULL
1550 SELECT COUNT(c1),SUM(c1) FROM t2;
1551 COUNT(c1) SUM(c1)
1552 1 5
1553 DROP TABLE t1,t2,t3;
1554 CREATE TABLE t1(c1 SMALLINT NOT NULL);
1555 CREATE TABLE t2(c1 SMALLINT NOT NULL);
1556 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1557 CREATE TABLE t3(c1 SMALLINT NOT NULL);
1558 INSERT INTO t3 (c1) VALUES(5);
1559 SELECT COUNT(c1),SUM(c1) FROM t2;
1560 COUNT(c1) SUM(c1)
1561 10 45
1562 DELETE FROM t2 WHERE c1 <> 5;
1563 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5;
1564 COUNT(c1) SUM(c1)
1565 0 NULL
1566 SELECT COUNT(c1),SUM(c1) FROM t2;
1567 COUNT(c1) SUM(c1)
1568 1 5
1569 DROP TABLE t1,t2,t3;
1570 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
1571 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
1572 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1573 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
1574 INSERT INTO t3 (c1) VALUES(5);
1575 SELECT COUNT(c1),SUM(c1) FROM t2;
1576 COUNT(c1) SUM(c1)
1577 10 45
1578 DELETE FROM t2 WHERE c1 <> 5;
1579 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5;
1580 COUNT(c1) SUM(c1)
1581 0 NULL
1582 SELECT COUNT(c1),SUM(c1) FROM t2;
1583 COUNT(c1) SUM(c1)
1584 1 5
1585 DROP TABLE t1,t2,t3;
1586 CREATE TABLE t1(c1 INT NOT NULL);
1587 CREATE TABLE t2(c1 INT NOT NULL);
1588 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1589 CREATE TABLE t3(c1 INT NOT NULL);
1590 INSERT INTO t3 (c1) VALUES(5);
1591 SELECT COUNT(c1),SUM(c1) FROM t2;
1592 COUNT(c1) SUM(c1)
1593 10 45
1594 DELETE FROM t2 WHERE c1 <> 5;
1595 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5;
1596 COUNT(c1) SUM(c1)
1597 0 NULL
1598 SELECT COUNT(c1),SUM(c1) FROM t2;
1599 COUNT(c1) SUM(c1)
1600 1 5
1601 DROP TABLE t1,t2,t3;
1602 CREATE TABLE t1(c1 INTEGER NOT NULL);
1603 CREATE TABLE t2(c1 INTEGER NOT NULL);
1604 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1605 CREATE TABLE t3(c1 INTEGER NOT NULL);
1606 INSERT INTO t3 (c1) VALUES(5);
1607 SELECT COUNT(c1),SUM(c1) FROM t2;
1608 COUNT(c1) SUM(c1)
1609 10 45
1610 DELETE FROM t2 WHERE c1 <> 5;
1611 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5;
1612 COUNT(c1) SUM(c1)
1613 0 NULL
1614 SELECT COUNT(c1),SUM(c1) FROM t2;
1615 COUNT(c1) SUM(c1)
1616 1 5
1617 DROP TABLE t1,t2,t3;
1618 CREATE TABLE t1(c1 BIGINT NOT NULL);
1619 CREATE TABLE t2(c1 BIGINT NOT NULL);
1620 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1621 CREATE TABLE t3(c1 BIGINT NOT NULL);
1622 INSERT INTO t3 (c1) VALUES(5);
1623 SELECT COUNT(c1),SUM(c1) FROM t2;
1624 COUNT(c1) SUM(c1)
1625 10 45
1626 DELETE FROM t2 WHERE c1 <> 5;
1627 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5;
1628 COUNT(c1) SUM(c1)
1629 0 NULL
1630 SELECT COUNT(c1),SUM(c1) FROM t2;
1631 COUNT(c1) SUM(c1)
1632 1 5
1633 DROP TABLE t1,t2,t3;
1634 CREATE TABLE t1(c1 TINYINT NOT NULL);
1635 CREATE TABLE t2(c1 TINYINT NOT NULL);
1636 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1637 CREATE TABLE t3(c1 TINYINT NOT NULL);
1638 INSERT INTO t3 (c1) VALUES(5);
1639 SELECT COUNT(c1),SUM(c1) FROM t3;
1640 COUNT(c1) SUM(c1)
1641 1 5
1642 DELETE FROM t3 WHERE c1 <> 5;
1643 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5;
1644 COUNT(c1) SUM(c1)
1645 0 NULL
1646 SELECT COUNT(c1),SUM(c1) FROM t3;
1647 COUNT(c1) SUM(c1)
1648 1 5
1649 DROP TABLE t1,t2,t3;
1650 CREATE TABLE t1(c1 SMALLINT NOT NULL);
1651 CREATE TABLE t2(c1 SMALLINT NOT NULL);
1652 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1653 CREATE TABLE t3(c1 SMALLINT NOT NULL);
1654 INSERT INTO t3 (c1) VALUES(5);
1655 SELECT COUNT(c1),SUM(c1) FROM t3;
1656 COUNT(c1) SUM(c1)
1657 1 5
1658 DELETE FROM t3 WHERE c1 <> 5;
1659 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5;
1660 COUNT(c1) SUM(c1)
1661 0 NULL
1662 SELECT COUNT(c1),SUM(c1) FROM t3;
1663 COUNT(c1) SUM(c1)
1664 1 5
1665 DROP TABLE t1,t2,t3;
1666 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
1667 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
1668 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1669 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
1670 INSERT INTO t3 (c1) VALUES(5);
1671 SELECT COUNT(c1),SUM(c1) FROM t3;
1672 COUNT(c1) SUM(c1)
1673 1 5
1674 DELETE FROM t3 WHERE c1 <> 5;
1675 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5;
1676 COUNT(c1) SUM(c1)
1677 0 NULL
1678 SELECT COUNT(c1),SUM(c1) FROM t3;
1679 COUNT(c1) SUM(c1)
1680 1 5
1681 DROP TABLE t1,t2,t3;
1682 CREATE TABLE t1(c1 INT NOT NULL);
1683 CREATE TABLE t2(c1 INT NOT NULL);
1684 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1685 CREATE TABLE t3(c1 INT NOT NULL);
1686 INSERT INTO t3 (c1) VALUES(5);
1687 SELECT COUNT(c1),SUM(c1) FROM t3;
1688 COUNT(c1) SUM(c1)
1689 1 5
1690 DELETE FROM t3 WHERE c1 <> 5;
1691 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5;
1692 COUNT(c1) SUM(c1)
1693 0 NULL
1694 SELECT COUNT(c1),SUM(c1) FROM t3;
1695 COUNT(c1) SUM(c1)
1696 1 5
1697 DROP TABLE t1,t2,t3;
1698 CREATE TABLE t1(c1 INTEGER NOT NULL);
1699 CREATE TABLE t2(c1 INTEGER NOT NULL);
1700 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1701 CREATE TABLE t3(c1 INTEGER NOT NULL);
1702 INSERT INTO t3 (c1) VALUES(5);
1703 SELECT COUNT(c1),SUM(c1) FROM t3;
1704 COUNT(c1) SUM(c1)
1705 1 5
1706 DELETE FROM t3 WHERE c1 <> 5;
1707 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5;
1708 COUNT(c1) SUM(c1)
1709 0 NULL
1710 SELECT COUNT(c1),SUM(c1) FROM t3;
1711 COUNT(c1) SUM(c1)
1712 1 5
1713 DROP TABLE t1,t2,t3;
1714 CREATE TABLE t1(c1 BIGINT NOT NULL);
1715 CREATE TABLE t2(c1 BIGINT NOT NULL);
1716 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1717 CREATE TABLE t3(c1 BIGINT NOT NULL);
1718 INSERT INTO t3 (c1) VALUES(5);
1719 SELECT COUNT(c1),SUM(c1) FROM t3;
1720 COUNT(c1) SUM(c1)
1721 1 5
1722 DELETE FROM t3 WHERE c1 <> 5;
1723 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5;
1724 COUNT(c1) SUM(c1)
1725 0 NULL
1726 SELECT COUNT(c1),SUM(c1) FROM t3;
1727 COUNT(c1) SUM(c1)
1728 1 5
1729 DROP TABLE t1,t2,t3;
1730 CREATE TABLE t1(c1 TINYINT NOT NULL);
1731 CREATE TABLE t2(c1 TINYINT NOT NULL);
1732 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1733 CREATE TABLE t3(c1 TINYINT NOT NULL);
1734 INSERT INTO t3 (c1) VALUES(5);
1735 SELECT COUNT(c1),SUM(c1) FROM t1;
1736 COUNT(c1) SUM(c1)
1737 0 NULL
1738 DELETE FROM t1 WHERE c1 <=> 5;
1739 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5;
1740 COUNT(c1) SUM(c1)
1741 0 NULL
1742 SELECT COUNT(c1),SUM(c1) FROM t1;
1743 COUNT(c1) SUM(c1)
1744 0 NULL
1745 DROP TABLE t1,t2,t3;
1746 CREATE TABLE t1(c1 SMALLINT NOT NULL);
1747 CREATE TABLE t2(c1 SMALLINT NOT NULL);
1748 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1749 CREATE TABLE t3(c1 SMALLINT NOT NULL);
1750 INSERT INTO t3 (c1) VALUES(5);
1751 SELECT COUNT(c1),SUM(c1) FROM t1;
1752 COUNT(c1) SUM(c1)
1753 0 NULL
1754 DELETE FROM t1 WHERE c1 <=> 5;
1755 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5;
1756 COUNT(c1) SUM(c1)
1757 0 NULL
1758 SELECT COUNT(c1),SUM(c1) FROM t1;
1759 COUNT(c1) SUM(c1)
1760 0 NULL
1761 DROP TABLE t1,t2,t3;
1762 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
1763 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
1764 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1765 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
1766 INSERT INTO t3 (c1) VALUES(5);
1767 SELECT COUNT(c1),SUM(c1) FROM t1;
1768 COUNT(c1) SUM(c1)
1769 0 NULL
1770 DELETE FROM t1 WHERE c1 <=> 5;
1771 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5;
1772 COUNT(c1) SUM(c1)
1773 0 NULL
1774 SELECT COUNT(c1),SUM(c1) FROM t1;
1775 COUNT(c1) SUM(c1)
1776 0 NULL
1777 DROP TABLE t1,t2,t3;
1778 CREATE TABLE t1(c1 INT NOT NULL);
1779 CREATE TABLE t2(c1 INT NOT NULL);
1780 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1781 CREATE TABLE t3(c1 INT NOT NULL);
1782 INSERT INTO t3 (c1) VALUES(5);
1783 SELECT COUNT(c1),SUM(c1) FROM t1;
1784 COUNT(c1) SUM(c1)
1785 0 NULL
1786 DELETE FROM t1 WHERE c1 <=> 5;
1787 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5;
1788 COUNT(c1) SUM(c1)
1789 0 NULL
1790 SELECT COUNT(c1),SUM(c1) FROM t1;
1791 COUNT(c1) SUM(c1)
1792 0 NULL
1793 DROP TABLE t1,t2,t3;
1794 CREATE TABLE t1(c1 INTEGER NOT NULL);
1795 CREATE TABLE t2(c1 INTEGER NOT NULL);
1796 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1797 CREATE TABLE t3(c1 INTEGER NOT NULL);
1798 INSERT INTO t3 (c1) VALUES(5);
1799 SELECT COUNT(c1),SUM(c1) FROM t1;
1800 COUNT(c1) SUM(c1)
1801 0 NULL
1802 DELETE FROM t1 WHERE c1 <=> 5;
1803 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5;
1804 COUNT(c1) SUM(c1)
1805 0 NULL
1806 SELECT COUNT(c1),SUM(c1) FROM t1;
1807 COUNT(c1) SUM(c1)
1808 0 NULL
1809 DROP TABLE t1,t2,t3;
1810 CREATE TABLE t1(c1 BIGINT NOT NULL);
1811 CREATE TABLE t2(c1 BIGINT NOT NULL);
1812 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1813 CREATE TABLE t3(c1 BIGINT NOT NULL);
1814 INSERT INTO t3 (c1) VALUES(5);
1815 SELECT COUNT(c1),SUM(c1) FROM t1;
1816 COUNT(c1) SUM(c1)
1817 0 NULL
1818 DELETE FROM t1 WHERE c1 <=> 5;
1819 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5;
1820 COUNT(c1) SUM(c1)
1821 0 NULL
1822 SELECT COUNT(c1),SUM(c1) FROM t1;
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 DELETE FROM t2 WHERE c1 <=> 5;
1835 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5;
1836 COUNT(c1) SUM(c1)
1837 0 NULL
1838 SELECT COUNT(c1),SUM(c1) FROM t2;
1839 COUNT(c1) SUM(c1)
1840 9 40
1841 DROP TABLE t1,t2,t3;
1842 CREATE TABLE t1(c1 SMALLINT NOT NULL);
1843 CREATE TABLE t2(c1 SMALLINT NOT NULL);
1844 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1845 CREATE TABLE t3(c1 SMALLINT NOT NULL);
1846 INSERT INTO t3 (c1) VALUES(5);
1847 SELECT COUNT(c1),SUM(c1) FROM t2;
1848 COUNT(c1) SUM(c1)
1849 10 45
1850 DELETE FROM t2 WHERE c1 <=> 5;
1851 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5;
1852 COUNT(c1) SUM(c1)
1853 0 NULL
1854 SELECT COUNT(c1),SUM(c1) FROM t2;
1855 COUNT(c1) SUM(c1)
1856 9 40
1857 DROP TABLE t1,t2,t3;
1858 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
1859 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
1860 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1861 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
1862 INSERT INTO t3 (c1) VALUES(5);
1863 SELECT COUNT(c1),SUM(c1) FROM t2;
1864 COUNT(c1) SUM(c1)
1865 10 45
1866 DELETE FROM t2 WHERE c1 <=> 5;
1867 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5;
1868 COUNT(c1) SUM(c1)
1869 0 NULL
1870 SELECT COUNT(c1),SUM(c1) FROM t2;
1871 COUNT(c1) SUM(c1)
1872 9 40
1873 DROP TABLE t1,t2,t3;
1874 CREATE TABLE t1(c1 INT NOT NULL);
1875 CREATE TABLE t2(c1 INT NOT NULL);
1876 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1877 CREATE TABLE t3(c1 INT NOT NULL);
1878 INSERT INTO t3 (c1) VALUES(5);
1879 SELECT COUNT(c1),SUM(c1) FROM t2;
1880 COUNT(c1) SUM(c1)
1881 10 45
1882 DELETE FROM t2 WHERE c1 <=> 5;
1883 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5;
1884 COUNT(c1) SUM(c1)
1885 0 NULL
1886 SELECT COUNT(c1),SUM(c1) FROM t2;
1887 COUNT(c1) SUM(c1)
1888 9 40
1889 DROP TABLE t1,t2,t3;
1890 CREATE TABLE t1(c1 INTEGER NOT NULL);
1891 CREATE TABLE t2(c1 INTEGER NOT NULL);
1892 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1893 CREATE TABLE t3(c1 INTEGER NOT NULL);
1894 INSERT INTO t3 (c1) VALUES(5);
1895 SELECT COUNT(c1),SUM(c1) FROM t2;
1896 COUNT(c1) SUM(c1)
1897 10 45
1898 DELETE FROM t2 WHERE c1 <=> 5;
1899 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5;
1900 COUNT(c1) SUM(c1)
1901 0 NULL
1902 SELECT COUNT(c1),SUM(c1) FROM t2;
1903 COUNT(c1) SUM(c1)
1904 9 40
1905 DROP TABLE t1,t2,t3;
1906 CREATE TABLE t1(c1 BIGINT NOT NULL);
1907 CREATE TABLE t2(c1 BIGINT NOT NULL);
1908 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1909 CREATE TABLE t3(c1 BIGINT NOT NULL);
1910 INSERT INTO t3 (c1) VALUES(5);
1911 SELECT COUNT(c1),SUM(c1) FROM t2;
1912 COUNT(c1) SUM(c1)
1913 10 45
1914 DELETE FROM t2 WHERE c1 <=> 5;
1915 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5;
1916 COUNT(c1) SUM(c1)
1917 0 NULL
1918 SELECT COUNT(c1),SUM(c1) FROM t2;
1919 COUNT(c1) SUM(c1)
1920 9 40
1921 DROP TABLE t1,t2,t3;
1922 CREATE TABLE t1(c1 TINYINT NOT NULL);
1923 CREATE TABLE t2(c1 TINYINT NOT NULL);
1924 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1925 CREATE TABLE t3(c1 TINYINT NOT NULL);
1926 INSERT INTO t3 (c1) VALUES(5);
1927 SELECT COUNT(c1),SUM(c1) FROM t3;
1928 COUNT(c1) SUM(c1)
1929 1 5
1930 DELETE FROM t3 WHERE c1 <=> 5;
1931 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5;
1932 COUNT(c1) SUM(c1)
1933 0 NULL
1934 SELECT COUNT(c1),SUM(c1) FROM t3;
1935 COUNT(c1) SUM(c1)
1936 0 NULL
1937 DROP TABLE t1,t2,t3;
1938 CREATE TABLE t1(c1 SMALLINT NOT NULL);
1939 CREATE TABLE t2(c1 SMALLINT NOT NULL);
1940 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1941 CREATE TABLE t3(c1 SMALLINT NOT NULL);
1942 INSERT INTO t3 (c1) VALUES(5);
1943 SELECT COUNT(c1),SUM(c1) FROM t3;
1944 COUNT(c1) SUM(c1)
1945 1 5
1946 DELETE FROM t3 WHERE c1 <=> 5;
1947 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5;
1948 COUNT(c1) SUM(c1)
1949 0 NULL
1950 SELECT COUNT(c1),SUM(c1) FROM t3;
1951 COUNT(c1) SUM(c1)
1952 0 NULL
1953 DROP TABLE t1,t2,t3;
1954 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
1955 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
1956 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1957 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
1958 INSERT INTO t3 (c1) VALUES(5);
1959 SELECT COUNT(c1),SUM(c1) FROM t3;
1960 COUNT(c1) SUM(c1)
1961 1 5
1962 DELETE FROM t3 WHERE c1 <=> 5;
1963 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5;
1964 COUNT(c1) SUM(c1)
1965 0 NULL
1966 SELECT COUNT(c1),SUM(c1) FROM t3;
1967 COUNT(c1) SUM(c1)
1968 0 NULL
1969 DROP TABLE t1,t2,t3;
1970 CREATE TABLE t1(c1 INT NOT NULL);
1971 CREATE TABLE t2(c1 INT NOT NULL);
1972 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1973 CREATE TABLE t3(c1 INT NOT NULL);
1974 INSERT INTO t3 (c1) VALUES(5);
1975 SELECT COUNT(c1),SUM(c1) FROM t3;
1976 COUNT(c1) SUM(c1)
1977 1 5
1978 DELETE FROM t3 WHERE c1 <=> 5;
1979 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5;
1980 COUNT(c1) SUM(c1)
1981 0 NULL
1982 SELECT COUNT(c1),SUM(c1) FROM t3;
1983 COUNT(c1) SUM(c1)
1984 0 NULL
1985 DROP TABLE t1,t2,t3;
1986 CREATE TABLE t1(c1 INTEGER NOT NULL);
1987 CREATE TABLE t2(c1 INTEGER NOT NULL);
1988 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1989 CREATE TABLE t3(c1 INTEGER NOT NULL);
1990 INSERT INTO t3 (c1) VALUES(5);
1991 SELECT COUNT(c1),SUM(c1) FROM t3;
1992 COUNT(c1) SUM(c1)
1993 1 5
1994 DELETE FROM t3 WHERE c1 <=> 5;
1995 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5;
1996 COUNT(c1) SUM(c1)
1997 0 NULL
1998 SELECT COUNT(c1),SUM(c1) FROM t3;
1999 COUNT(c1) SUM(c1)
2000 0 NULL
2001 DROP TABLE t1,t2,t3;
2002 CREATE TABLE t1(c1 BIGINT NOT NULL);
2003 CREATE TABLE t2(c1 BIGINT NOT NULL);
2004 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2005 CREATE TABLE t3(c1 BIGINT NOT NULL);
2006 INSERT INTO t3 (c1) VALUES(5);
2007 SELECT COUNT(c1),SUM(c1) FROM t3;
2008 COUNT(c1) SUM(c1)
2009 1 5
2010 DELETE FROM t3 WHERE c1 <=> 5;
2011 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5;
2012 COUNT(c1) SUM(c1)
2013 0 NULL
2014 SELECT COUNT(c1),SUM(c1) FROM t3;
2015 COUNT(c1) SUM(c1)
2016 0 NULL
2017 DROP TABLE t1,t2,t3;