1 DROP TABLE IF EXISTS t1,t2,t3,t4;
2 CREATE TABLE t1(c1 TINYINT NOT NULL);
3 CREATE TABLE t2(c1 TINYINT NULL);
4 CREATE TABLE t3(c1 TINYINT NOT NULL);
5 CREATE TABLE t4(c1 TINYINT NULL);
6 INSERT INTO t2 (c1) VALUES(NULL);
7 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
8 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
9 SELECT COUNT(c1) AS value FROM t1;
12 SELECT COUNT(c1) AS value FROM t1 WHERE c1 < 0;
15 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NULL;
18 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NOT NULL;
21 DROP TABLE t1,t2,t3,t4;
22 CREATE TABLE t1(c1 SMALLINT NOT NULL);
23 CREATE TABLE t2(c1 SMALLINT NULL);
24 CREATE TABLE t3(c1 SMALLINT NOT NULL);
25 CREATE TABLE t4(c1 SMALLINT NULL);
26 INSERT INTO t2 (c1) VALUES(NULL);
27 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
28 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
29 SELECT COUNT(c1) AS value FROM t1;
32 SELECT COUNT(c1) AS value FROM t1 WHERE c1 < 0;
35 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NULL;
38 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NOT NULL;
41 DROP TABLE t1,t2,t3,t4;
42 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
43 CREATE TABLE t2(c1 MEDIUMINT NULL);
44 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
45 CREATE TABLE t4(c1 MEDIUMINT NULL);
46 INSERT INTO t2 (c1) VALUES(NULL);
47 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
48 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
49 SELECT COUNT(c1) AS value FROM t1;
52 SELECT COUNT(c1) AS value FROM t1 WHERE c1 < 0;
55 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NULL;
58 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NOT NULL;
61 DROP TABLE t1,t2,t3,t4;
62 CREATE TABLE t1(c1 INT NOT NULL);
63 CREATE TABLE t2(c1 INT NULL);
64 CREATE TABLE t3(c1 INT NOT NULL);
65 CREATE TABLE t4(c1 INT NULL);
66 INSERT INTO t2 (c1) VALUES(NULL);
67 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
68 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
69 SELECT COUNT(c1) AS value FROM t1;
72 SELECT COUNT(c1) AS value FROM t1 WHERE c1 < 0;
75 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NULL;
78 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NOT NULL;
81 DROP TABLE t1,t2,t3,t4;
82 CREATE TABLE t1(c1 INTEGER NOT NULL);
83 CREATE TABLE t2(c1 INTEGER NULL);
84 CREATE TABLE t3(c1 INTEGER NOT NULL);
85 CREATE TABLE t4(c1 INTEGER NULL);
86 INSERT INTO t2 (c1) VALUES(NULL);
87 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
88 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
89 SELECT COUNT(c1) AS value FROM t1;
92 SELECT COUNT(c1) AS value FROM t1 WHERE c1 < 0;
95 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NULL;
98 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NOT NULL;
101 DROP TABLE t1,t2,t3,t4;
102 CREATE TABLE t1(c1 BIGINT NOT NULL);
103 CREATE TABLE t2(c1 BIGINT NULL);
104 CREATE TABLE t3(c1 BIGINT NOT NULL);
105 CREATE TABLE t4(c1 BIGINT NULL);
106 INSERT INTO t2 (c1) VALUES(NULL);
107 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
108 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
109 SELECT COUNT(c1) AS value FROM t1;
112 SELECT COUNT(c1) AS value FROM t1 WHERE c1 < 0;
115 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NULL;
118 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NOT NULL;
121 DROP TABLE t1,t2,t3,t4;
122 CREATE TABLE t1(c1 TINYINT NOT NULL);
123 CREATE TABLE t2(c1 TINYINT NULL);
124 CREATE TABLE t3(c1 TINYINT NOT NULL);
125 CREATE TABLE t4(c1 TINYINT NULL);
126 INSERT INTO t2 (c1) VALUES(NULL);
127 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
128 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
129 SELECT COUNT(c1) AS value FROM t2;
132 SELECT COUNT(c1) AS value FROM t2 WHERE c1 < 0;
135 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NULL;
138 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NOT NULL;
141 DROP TABLE t1,t2,t3,t4;
142 CREATE TABLE t1(c1 SMALLINT NOT NULL);
143 CREATE TABLE t2(c1 SMALLINT NULL);
144 CREATE TABLE t3(c1 SMALLINT NOT NULL);
145 CREATE TABLE t4(c1 SMALLINT NULL);
146 INSERT INTO t2 (c1) VALUES(NULL);
147 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
148 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
149 SELECT COUNT(c1) AS value FROM t2;
152 SELECT COUNT(c1) AS value FROM t2 WHERE c1 < 0;
155 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NULL;
158 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NOT NULL;
161 DROP TABLE t1,t2,t3,t4;
162 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
163 CREATE TABLE t2(c1 MEDIUMINT NULL);
164 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
165 CREATE TABLE t4(c1 MEDIUMINT NULL);
166 INSERT INTO t2 (c1) VALUES(NULL);
167 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
168 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
169 SELECT COUNT(c1) AS value FROM t2;
172 SELECT COUNT(c1) AS value FROM t2 WHERE c1 < 0;
175 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NULL;
178 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NOT NULL;
181 DROP TABLE t1,t2,t3,t4;
182 CREATE TABLE t1(c1 INT NOT NULL);
183 CREATE TABLE t2(c1 INT NULL);
184 CREATE TABLE t3(c1 INT NOT NULL);
185 CREATE TABLE t4(c1 INT NULL);
186 INSERT INTO t2 (c1) VALUES(NULL);
187 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
188 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
189 SELECT COUNT(c1) AS value FROM t2;
192 SELECT COUNT(c1) AS value FROM t2 WHERE c1 < 0;
195 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NULL;
198 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NOT NULL;
201 DROP TABLE t1,t2,t3,t4;
202 CREATE TABLE t1(c1 INTEGER NOT NULL);
203 CREATE TABLE t2(c1 INTEGER NULL);
204 CREATE TABLE t3(c1 INTEGER NOT NULL);
205 CREATE TABLE t4(c1 INTEGER NULL);
206 INSERT INTO t2 (c1) VALUES(NULL);
207 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
208 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
209 SELECT COUNT(c1) AS value FROM t2;
212 SELECT COUNT(c1) AS value FROM t2 WHERE c1 < 0;
215 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NULL;
218 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NOT NULL;
221 DROP TABLE t1,t2,t3,t4;
222 CREATE TABLE t1(c1 BIGINT NOT NULL);
223 CREATE TABLE t2(c1 BIGINT NULL);
224 CREATE TABLE t3(c1 BIGINT NOT NULL);
225 CREATE TABLE t4(c1 BIGINT NULL);
226 INSERT INTO t2 (c1) VALUES(NULL);
227 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
228 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
229 SELECT COUNT(c1) AS value FROM t2;
232 SELECT COUNT(c1) AS value FROM t2 WHERE c1 < 0;
235 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NULL;
238 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NOT NULL;
241 DROP TABLE t1,t2,t3,t4;
242 CREATE TABLE t1(c1 TINYINT NOT NULL);
243 CREATE TABLE t2(c1 TINYINT NULL);
244 CREATE TABLE t3(c1 TINYINT NOT NULL);
245 CREATE TABLE t4(c1 TINYINT NULL);
246 INSERT INTO t2 (c1) VALUES(NULL);
247 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
248 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
249 SELECT COUNT(c1) AS value FROM t3;
252 SELECT COUNT(c1) AS value FROM t3 WHERE c1 < 0;
255 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NULL;
258 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NOT NULL;
261 DROP TABLE t1,t2,t3,t4;
262 CREATE TABLE t1(c1 SMALLINT NOT NULL);
263 CREATE TABLE t2(c1 SMALLINT NULL);
264 CREATE TABLE t3(c1 SMALLINT NOT NULL);
265 CREATE TABLE t4(c1 SMALLINT NULL);
266 INSERT INTO t2 (c1) VALUES(NULL);
267 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
268 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
269 SELECT COUNT(c1) AS value FROM t3;
272 SELECT COUNT(c1) AS value FROM t3 WHERE c1 < 0;
275 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NULL;
278 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NOT NULL;
281 DROP TABLE t1,t2,t3,t4;
282 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
283 CREATE TABLE t2(c1 MEDIUMINT NULL);
284 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
285 CREATE TABLE t4(c1 MEDIUMINT NULL);
286 INSERT INTO t2 (c1) VALUES(NULL);
287 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
288 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
289 SELECT COUNT(c1) AS value FROM t3;
292 SELECT COUNT(c1) AS value FROM t3 WHERE c1 < 0;
295 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NULL;
298 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NOT NULL;
301 DROP TABLE t1,t2,t3,t4;
302 CREATE TABLE t1(c1 INT NOT NULL);
303 CREATE TABLE t2(c1 INT NULL);
304 CREATE TABLE t3(c1 INT NOT NULL);
305 CREATE TABLE t4(c1 INT NULL);
306 INSERT INTO t2 (c1) VALUES(NULL);
307 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
308 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
309 SELECT COUNT(c1) AS value FROM t3;
312 SELECT COUNT(c1) AS value FROM t3 WHERE c1 < 0;
315 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NULL;
318 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NOT NULL;
321 DROP TABLE t1,t2,t3,t4;
322 CREATE TABLE t1(c1 INTEGER NOT NULL);
323 CREATE TABLE t2(c1 INTEGER NULL);
324 CREATE TABLE t3(c1 INTEGER NOT NULL);
325 CREATE TABLE t4(c1 INTEGER NULL);
326 INSERT INTO t2 (c1) VALUES(NULL);
327 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
328 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
329 SELECT COUNT(c1) AS value FROM t3;
332 SELECT COUNT(c1) AS value FROM t3 WHERE c1 < 0;
335 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NULL;
338 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NOT NULL;
341 DROP TABLE t1,t2,t3,t4;
342 CREATE TABLE t1(c1 BIGINT NOT NULL);
343 CREATE TABLE t2(c1 BIGINT NULL);
344 CREATE TABLE t3(c1 BIGINT NOT NULL);
345 CREATE TABLE t4(c1 BIGINT NULL);
346 INSERT INTO t2 (c1) VALUES(NULL);
347 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
348 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
349 SELECT COUNT(c1) AS value FROM t3;
352 SELECT COUNT(c1) AS value FROM t3 WHERE c1 < 0;
355 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NULL;
358 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NOT NULL;
361 DROP TABLE t1,t2,t3,t4;
362 CREATE TABLE t1(c1 TINYINT NOT NULL);
363 CREATE TABLE t2(c1 TINYINT NULL);
364 CREATE TABLE t3(c1 TINYINT NOT NULL);
365 CREATE TABLE t4(c1 TINYINT NULL);
366 INSERT INTO t2 (c1) VALUES(NULL);
367 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
368 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
369 SELECT COUNT(c1) AS value FROM t4;
372 SELECT COUNT(c1) AS value FROM t4 WHERE c1 < 0;
375 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NULL;
378 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NOT NULL;
381 DROP TABLE t1,t2,t3,t4;
382 CREATE TABLE t1(c1 SMALLINT NOT NULL);
383 CREATE TABLE t2(c1 SMALLINT NULL);
384 CREATE TABLE t3(c1 SMALLINT NOT NULL);
385 CREATE TABLE t4(c1 SMALLINT NULL);
386 INSERT INTO t2 (c1) VALUES(NULL);
387 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
388 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
389 SELECT COUNT(c1) AS value FROM t4;
392 SELECT COUNT(c1) AS value FROM t4 WHERE c1 < 0;
395 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NULL;
398 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NOT NULL;
401 DROP TABLE t1,t2,t3,t4;
402 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
403 CREATE TABLE t2(c1 MEDIUMINT NULL);
404 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
405 CREATE TABLE t4(c1 MEDIUMINT NULL);
406 INSERT INTO t2 (c1) VALUES(NULL);
407 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
408 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
409 SELECT COUNT(c1) AS value FROM t4;
412 SELECT COUNT(c1) AS value FROM t4 WHERE c1 < 0;
415 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NULL;
418 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NOT NULL;
421 DROP TABLE t1,t2,t3,t4;
422 CREATE TABLE t1(c1 INT NOT NULL);
423 CREATE TABLE t2(c1 INT NULL);
424 CREATE TABLE t3(c1 INT NOT NULL);
425 CREATE TABLE t4(c1 INT NULL);
426 INSERT INTO t2 (c1) VALUES(NULL);
427 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
428 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
429 SELECT COUNT(c1) AS value FROM t4;
432 SELECT COUNT(c1) AS value FROM t4 WHERE c1 < 0;
435 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NULL;
438 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NOT NULL;
441 DROP TABLE t1,t2,t3,t4;
442 CREATE TABLE t1(c1 INTEGER NOT NULL);
443 CREATE TABLE t2(c1 INTEGER NULL);
444 CREATE TABLE t3(c1 INTEGER NOT NULL);
445 CREATE TABLE t4(c1 INTEGER NULL);
446 INSERT INTO t2 (c1) VALUES(NULL);
447 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
448 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
449 SELECT COUNT(c1) AS value FROM t4;
452 SELECT COUNT(c1) AS value FROM t4 WHERE c1 < 0;
455 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NULL;
458 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NOT NULL;
461 DROP TABLE t1,t2,t3,t4;
462 CREATE TABLE t1(c1 BIGINT NOT NULL);
463 CREATE TABLE t2(c1 BIGINT NULL);
464 CREATE TABLE t3(c1 BIGINT NOT NULL);
465 CREATE TABLE t4(c1 BIGINT NULL);
466 INSERT INTO t2 (c1) VALUES(NULL);
467 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
468 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
469 SELECT COUNT(c1) AS value FROM t4;
472 SELECT COUNT(c1) AS value FROM t4 WHERE c1 < 0;
475 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NULL;
478 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NOT NULL;
481 DROP TABLE t1,t2,t3,t4;
482 CREATE TABLE t1(c1 TINYINT NOT NULL);
483 CREATE TABLE t2(c1 TINYINT NULL);
484 CREATE TABLE t3(c1 TINYINT NOT NULL);
485 CREATE TABLE t4(c1 TINYINT NULL);
486 INSERT INTO t2 (c1) VALUES(NULL);
487 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
488 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
489 SELECT COUNT(c1) AS value FROM t1;
492 SELECT COUNT(c1) AS value FROM t1 WHERE c1 <= 0;
495 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NULL;
498 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NOT NULL;
501 DROP TABLE t1,t2,t3,t4;
502 CREATE TABLE t1(c1 SMALLINT NOT NULL);
503 CREATE TABLE t2(c1 SMALLINT NULL);
504 CREATE TABLE t3(c1 SMALLINT NOT NULL);
505 CREATE TABLE t4(c1 SMALLINT NULL);
506 INSERT INTO t2 (c1) VALUES(NULL);
507 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
508 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
509 SELECT COUNT(c1) AS value FROM t1;
512 SELECT COUNT(c1) AS value FROM t1 WHERE c1 <= 0;
515 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NULL;
518 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NOT NULL;
521 DROP TABLE t1,t2,t3,t4;
522 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
523 CREATE TABLE t2(c1 MEDIUMINT NULL);
524 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
525 CREATE TABLE t4(c1 MEDIUMINT NULL);
526 INSERT INTO t2 (c1) VALUES(NULL);
527 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
528 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
529 SELECT COUNT(c1) AS value FROM t1;
532 SELECT COUNT(c1) AS value FROM t1 WHERE c1 <= 0;
535 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NULL;
538 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NOT NULL;
541 DROP TABLE t1,t2,t3,t4;
542 CREATE TABLE t1(c1 INT NOT NULL);
543 CREATE TABLE t2(c1 INT NULL);
544 CREATE TABLE t3(c1 INT NOT NULL);
545 CREATE TABLE t4(c1 INT NULL);
546 INSERT INTO t2 (c1) VALUES(NULL);
547 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
548 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
549 SELECT COUNT(c1) AS value FROM t1;
552 SELECT COUNT(c1) AS value FROM t1 WHERE c1 <= 0;
555 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NULL;
558 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NOT NULL;
561 DROP TABLE t1,t2,t3,t4;
562 CREATE TABLE t1(c1 INTEGER NOT NULL);
563 CREATE TABLE t2(c1 INTEGER NULL);
564 CREATE TABLE t3(c1 INTEGER NOT NULL);
565 CREATE TABLE t4(c1 INTEGER NULL);
566 INSERT INTO t2 (c1) VALUES(NULL);
567 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
568 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
569 SELECT COUNT(c1) AS value FROM t1;
572 SELECT COUNT(c1) AS value FROM t1 WHERE c1 <= 0;
575 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NULL;
578 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NOT NULL;
581 DROP TABLE t1,t2,t3,t4;
582 CREATE TABLE t1(c1 BIGINT NOT NULL);
583 CREATE TABLE t2(c1 BIGINT NULL);
584 CREATE TABLE t3(c1 BIGINT NOT NULL);
585 CREATE TABLE t4(c1 BIGINT NULL);
586 INSERT INTO t2 (c1) VALUES(NULL);
587 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
588 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
589 SELECT COUNT(c1) AS value FROM t1;
592 SELECT COUNT(c1) AS value FROM t1 WHERE c1 <= 0;
595 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NULL;
598 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NOT NULL;
601 DROP TABLE t1,t2,t3,t4;
602 CREATE TABLE t1(c1 TINYINT NOT NULL);
603 CREATE TABLE t2(c1 TINYINT NULL);
604 CREATE TABLE t3(c1 TINYINT NOT NULL);
605 CREATE TABLE t4(c1 TINYINT NULL);
606 INSERT INTO t2 (c1) VALUES(NULL);
607 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
608 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
609 SELECT COUNT(c1) AS value FROM t2;
612 SELECT COUNT(c1) AS value FROM t2 WHERE c1 <= 0;
615 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NULL;
618 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NOT NULL;
621 DROP TABLE t1,t2,t3,t4;
622 CREATE TABLE t1(c1 SMALLINT NOT NULL);
623 CREATE TABLE t2(c1 SMALLINT NULL);
624 CREATE TABLE t3(c1 SMALLINT NOT NULL);
625 CREATE TABLE t4(c1 SMALLINT NULL);
626 INSERT INTO t2 (c1) VALUES(NULL);
627 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
628 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
629 SELECT COUNT(c1) AS value FROM t2;
632 SELECT COUNT(c1) AS value FROM t2 WHERE c1 <= 0;
635 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NULL;
638 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NOT NULL;
641 DROP TABLE t1,t2,t3,t4;
642 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
643 CREATE TABLE t2(c1 MEDIUMINT NULL);
644 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
645 CREATE TABLE t4(c1 MEDIUMINT NULL);
646 INSERT INTO t2 (c1) VALUES(NULL);
647 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
648 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
649 SELECT COUNT(c1) AS value FROM t2;
652 SELECT COUNT(c1) AS value FROM t2 WHERE c1 <= 0;
655 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NULL;
658 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NOT NULL;
661 DROP TABLE t1,t2,t3,t4;
662 CREATE TABLE t1(c1 INT NOT NULL);
663 CREATE TABLE t2(c1 INT NULL);
664 CREATE TABLE t3(c1 INT NOT NULL);
665 CREATE TABLE t4(c1 INT NULL);
666 INSERT INTO t2 (c1) VALUES(NULL);
667 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
668 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
669 SELECT COUNT(c1) AS value FROM t2;
672 SELECT COUNT(c1) AS value FROM t2 WHERE c1 <= 0;
675 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NULL;
678 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NOT NULL;
681 DROP TABLE t1,t2,t3,t4;
682 CREATE TABLE t1(c1 INTEGER NOT NULL);
683 CREATE TABLE t2(c1 INTEGER NULL);
684 CREATE TABLE t3(c1 INTEGER NOT NULL);
685 CREATE TABLE t4(c1 INTEGER NULL);
686 INSERT INTO t2 (c1) VALUES(NULL);
687 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
688 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
689 SELECT COUNT(c1) AS value FROM t2;
692 SELECT COUNT(c1) AS value FROM t2 WHERE c1 <= 0;
695 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NULL;
698 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NOT NULL;
701 DROP TABLE t1,t2,t3,t4;
702 CREATE TABLE t1(c1 BIGINT NOT NULL);
703 CREATE TABLE t2(c1 BIGINT NULL);
704 CREATE TABLE t3(c1 BIGINT NOT NULL);
705 CREATE TABLE t4(c1 BIGINT NULL);
706 INSERT INTO t2 (c1) VALUES(NULL);
707 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
708 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
709 SELECT COUNT(c1) AS value FROM t2;
712 SELECT COUNT(c1) AS value FROM t2 WHERE c1 <= 0;
715 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NULL;
718 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NOT NULL;
721 DROP TABLE t1,t2,t3,t4;
722 CREATE TABLE t1(c1 TINYINT NOT NULL);
723 CREATE TABLE t2(c1 TINYINT NULL);
724 CREATE TABLE t3(c1 TINYINT NOT NULL);
725 CREATE TABLE t4(c1 TINYINT NULL);
726 INSERT INTO t2 (c1) VALUES(NULL);
727 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
728 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
729 SELECT COUNT(c1) AS value FROM t3;
732 SELECT COUNT(c1) AS value FROM t3 WHERE c1 <= 0;
735 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NULL;
738 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NOT NULL;
741 DROP TABLE t1,t2,t3,t4;
742 CREATE TABLE t1(c1 SMALLINT NOT NULL);
743 CREATE TABLE t2(c1 SMALLINT NULL);
744 CREATE TABLE t3(c1 SMALLINT NOT NULL);
745 CREATE TABLE t4(c1 SMALLINT NULL);
746 INSERT INTO t2 (c1) VALUES(NULL);
747 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
748 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
749 SELECT COUNT(c1) AS value FROM t3;
752 SELECT COUNT(c1) AS value FROM t3 WHERE c1 <= 0;
755 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NULL;
758 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NOT NULL;
761 DROP TABLE t1,t2,t3,t4;
762 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
763 CREATE TABLE t2(c1 MEDIUMINT NULL);
764 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
765 CREATE TABLE t4(c1 MEDIUMINT NULL);
766 INSERT INTO t2 (c1) VALUES(NULL);
767 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
768 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
769 SELECT COUNT(c1) AS value FROM t3;
772 SELECT COUNT(c1) AS value FROM t3 WHERE c1 <= 0;
775 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NULL;
778 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NOT NULL;
781 DROP TABLE t1,t2,t3,t4;
782 CREATE TABLE t1(c1 INT NOT NULL);
783 CREATE TABLE t2(c1 INT NULL);
784 CREATE TABLE t3(c1 INT NOT NULL);
785 CREATE TABLE t4(c1 INT NULL);
786 INSERT INTO t2 (c1) VALUES(NULL);
787 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
788 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
789 SELECT COUNT(c1) AS value FROM t3;
792 SELECT COUNT(c1) AS value FROM t3 WHERE c1 <= 0;
795 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NULL;
798 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NOT NULL;
801 DROP TABLE t1,t2,t3,t4;
802 CREATE TABLE t1(c1 INTEGER NOT NULL);
803 CREATE TABLE t2(c1 INTEGER NULL);
804 CREATE TABLE t3(c1 INTEGER NOT NULL);
805 CREATE TABLE t4(c1 INTEGER NULL);
806 INSERT INTO t2 (c1) VALUES(NULL);
807 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
808 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
809 SELECT COUNT(c1) AS value FROM t3;
812 SELECT COUNT(c1) AS value FROM t3 WHERE c1 <= 0;
815 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NULL;
818 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NOT NULL;
821 DROP TABLE t1,t2,t3,t4;
822 CREATE TABLE t1(c1 BIGINT NOT NULL);
823 CREATE TABLE t2(c1 BIGINT NULL);
824 CREATE TABLE t3(c1 BIGINT NOT NULL);
825 CREATE TABLE t4(c1 BIGINT NULL);
826 INSERT INTO t2 (c1) VALUES(NULL);
827 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
828 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
829 SELECT COUNT(c1) AS value FROM t3;
832 SELECT COUNT(c1) AS value FROM t3 WHERE c1 <= 0;
835 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NULL;
838 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NOT NULL;
841 DROP TABLE t1,t2,t3,t4;
842 CREATE TABLE t1(c1 TINYINT NOT NULL);
843 CREATE TABLE t2(c1 TINYINT NULL);
844 CREATE TABLE t3(c1 TINYINT NOT NULL);
845 CREATE TABLE t4(c1 TINYINT NULL);
846 INSERT INTO t2 (c1) VALUES(NULL);
847 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
848 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
849 SELECT COUNT(c1) AS value FROM t4;
852 SELECT COUNT(c1) AS value FROM t4 WHERE c1 <= 0;
855 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NULL;
858 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NOT NULL;
861 DROP TABLE t1,t2,t3,t4;
862 CREATE TABLE t1(c1 SMALLINT NOT NULL);
863 CREATE TABLE t2(c1 SMALLINT NULL);
864 CREATE TABLE t3(c1 SMALLINT NOT NULL);
865 CREATE TABLE t4(c1 SMALLINT NULL);
866 INSERT INTO t2 (c1) VALUES(NULL);
867 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
868 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
869 SELECT COUNT(c1) AS value FROM t4;
872 SELECT COUNT(c1) AS value FROM t4 WHERE c1 <= 0;
875 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NULL;
878 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NOT NULL;
881 DROP TABLE t1,t2,t3,t4;
882 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
883 CREATE TABLE t2(c1 MEDIUMINT NULL);
884 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
885 CREATE TABLE t4(c1 MEDIUMINT NULL);
886 INSERT INTO t2 (c1) VALUES(NULL);
887 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
888 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
889 SELECT COUNT(c1) AS value FROM t4;
892 SELECT COUNT(c1) AS value FROM t4 WHERE c1 <= 0;
895 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NULL;
898 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NOT NULL;
901 DROP TABLE t1,t2,t3,t4;
902 CREATE TABLE t1(c1 INT NOT NULL);
903 CREATE TABLE t2(c1 INT NULL);
904 CREATE TABLE t3(c1 INT NOT NULL);
905 CREATE TABLE t4(c1 INT NULL);
906 INSERT INTO t2 (c1) VALUES(NULL);
907 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
908 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
909 SELECT COUNT(c1) AS value FROM t4;
912 SELECT COUNT(c1) AS value FROM t4 WHERE c1 <= 0;
915 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NULL;
918 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NOT NULL;
921 DROP TABLE t1,t2,t3,t4;
922 CREATE TABLE t1(c1 INTEGER NOT NULL);
923 CREATE TABLE t2(c1 INTEGER NULL);
924 CREATE TABLE t3(c1 INTEGER NOT NULL);
925 CREATE TABLE t4(c1 INTEGER NULL);
926 INSERT INTO t2 (c1) VALUES(NULL);
927 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
928 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
929 SELECT COUNT(c1) AS value FROM t4;
932 SELECT COUNT(c1) AS value FROM t4 WHERE c1 <= 0;
935 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NULL;
938 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NOT NULL;
941 DROP TABLE t1,t2,t3,t4;
942 CREATE TABLE t1(c1 BIGINT NOT NULL);
943 CREATE TABLE t2(c1 BIGINT NULL);
944 CREATE TABLE t3(c1 BIGINT NOT NULL);
945 CREATE TABLE t4(c1 BIGINT NULL);
946 INSERT INTO t2 (c1) VALUES(NULL);
947 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
948 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
949 SELECT COUNT(c1) AS value FROM t4;
952 SELECT COUNT(c1) AS value FROM t4 WHERE c1 <= 0;
955 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NULL;
958 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NOT NULL;
961 DROP TABLE t1,t2,t3,t4;
962 CREATE TABLE t1(c1 TINYINT NOT NULL);
963 CREATE TABLE t2(c1 TINYINT NULL);
964 CREATE TABLE t3(c1 TINYINT NOT NULL);
965 CREATE TABLE t4(c1 TINYINT NULL);
966 INSERT INTO t2 (c1) VALUES(NULL);
967 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
968 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
969 SELECT COUNT(c1) AS value FROM t1;
972 SELECT COUNT(c1) AS value FROM t1 WHERE c1 = 0;
975 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NULL;
978 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NOT NULL;
981 DROP TABLE t1,t2,t3,t4;
982 CREATE TABLE t1(c1 SMALLINT NOT NULL);
983 CREATE TABLE t2(c1 SMALLINT NULL);
984 CREATE TABLE t3(c1 SMALLINT NOT NULL);
985 CREATE TABLE t4(c1 SMALLINT NULL);
986 INSERT INTO t2 (c1) VALUES(NULL);
987 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
988 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
989 SELECT COUNT(c1) AS value FROM t1;
992 SELECT COUNT(c1) AS value FROM t1 WHERE c1 = 0;
995 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NULL;
998 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NOT NULL;
1001 DROP TABLE t1,t2,t3,t4;
1002 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
1003 CREATE TABLE t2(c1 MEDIUMINT NULL);
1004 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
1005 CREATE TABLE t4(c1 MEDIUMINT NULL);
1006 INSERT INTO t2 (c1) VALUES(NULL);
1007 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1008 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1009 SELECT COUNT(c1) AS value FROM t1;
1012 SELECT COUNT(c1) AS value FROM t1 WHERE c1 = 0;
1015 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NULL;
1018 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NOT NULL;
1021 DROP TABLE t1,t2,t3,t4;
1022 CREATE TABLE t1(c1 INT NOT NULL);
1023 CREATE TABLE t2(c1 INT NULL);
1024 CREATE TABLE t3(c1 INT NOT NULL);
1025 CREATE TABLE t4(c1 INT NULL);
1026 INSERT INTO t2 (c1) VALUES(NULL);
1027 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1028 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1029 SELECT COUNT(c1) AS value FROM t1;
1032 SELECT COUNT(c1) AS value FROM t1 WHERE c1 = 0;
1035 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NULL;
1038 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NOT NULL;
1041 DROP TABLE t1,t2,t3,t4;
1042 CREATE TABLE t1(c1 INTEGER NOT NULL);
1043 CREATE TABLE t2(c1 INTEGER NULL);
1044 CREATE TABLE t3(c1 INTEGER NOT NULL);
1045 CREATE TABLE t4(c1 INTEGER NULL);
1046 INSERT INTO t2 (c1) VALUES(NULL);
1047 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1048 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1049 SELECT COUNT(c1) AS value FROM t1;
1052 SELECT COUNT(c1) AS value FROM t1 WHERE c1 = 0;
1055 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NULL;
1058 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NOT NULL;
1061 DROP TABLE t1,t2,t3,t4;
1062 CREATE TABLE t1(c1 BIGINT NOT NULL);
1063 CREATE TABLE t2(c1 BIGINT NULL);
1064 CREATE TABLE t3(c1 BIGINT NOT NULL);
1065 CREATE TABLE t4(c1 BIGINT NULL);
1066 INSERT INTO t2 (c1) VALUES(NULL);
1067 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1068 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1069 SELECT COUNT(c1) AS value FROM t1;
1072 SELECT COUNT(c1) AS value FROM t1 WHERE c1 = 0;
1075 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NULL;
1078 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NOT NULL;
1081 DROP TABLE t1,t2,t3,t4;
1082 CREATE TABLE t1(c1 TINYINT NOT NULL);
1083 CREATE TABLE t2(c1 TINYINT NULL);
1084 CREATE TABLE t3(c1 TINYINT NOT NULL);
1085 CREATE TABLE t4(c1 TINYINT NULL);
1086 INSERT INTO t2 (c1) VALUES(NULL);
1087 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1088 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1089 SELECT COUNT(c1) AS value FROM t2;
1092 SELECT COUNT(c1) AS value FROM t2 WHERE c1 = 0;
1095 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NULL;
1098 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NOT NULL;
1101 DROP TABLE t1,t2,t3,t4;
1102 CREATE TABLE t1(c1 SMALLINT NOT NULL);
1103 CREATE TABLE t2(c1 SMALLINT NULL);
1104 CREATE TABLE t3(c1 SMALLINT NOT NULL);
1105 CREATE TABLE t4(c1 SMALLINT NULL);
1106 INSERT INTO t2 (c1) VALUES(NULL);
1107 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1108 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1109 SELECT COUNT(c1) AS value FROM t2;
1112 SELECT COUNT(c1) AS value FROM t2 WHERE c1 = 0;
1115 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NULL;
1118 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NOT NULL;
1121 DROP TABLE t1,t2,t3,t4;
1122 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
1123 CREATE TABLE t2(c1 MEDIUMINT NULL);
1124 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
1125 CREATE TABLE t4(c1 MEDIUMINT NULL);
1126 INSERT INTO t2 (c1) VALUES(NULL);
1127 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1128 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1129 SELECT COUNT(c1) AS value FROM t2;
1132 SELECT COUNT(c1) AS value FROM t2 WHERE c1 = 0;
1135 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NULL;
1138 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NOT NULL;
1141 DROP TABLE t1,t2,t3,t4;
1142 CREATE TABLE t1(c1 INT NOT NULL);
1143 CREATE TABLE t2(c1 INT NULL);
1144 CREATE TABLE t3(c1 INT NOT NULL);
1145 CREATE TABLE t4(c1 INT NULL);
1146 INSERT INTO t2 (c1) VALUES(NULL);
1147 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1148 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1149 SELECT COUNT(c1) AS value FROM t2;
1152 SELECT COUNT(c1) AS value FROM t2 WHERE c1 = 0;
1155 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NULL;
1158 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NOT NULL;
1161 DROP TABLE t1,t2,t3,t4;
1162 CREATE TABLE t1(c1 INTEGER NOT NULL);
1163 CREATE TABLE t2(c1 INTEGER NULL);
1164 CREATE TABLE t3(c1 INTEGER NOT NULL);
1165 CREATE TABLE t4(c1 INTEGER NULL);
1166 INSERT INTO t2 (c1) VALUES(NULL);
1167 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1168 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1169 SELECT COUNT(c1) AS value FROM t2;
1172 SELECT COUNT(c1) AS value FROM t2 WHERE c1 = 0;
1175 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NULL;
1178 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NOT NULL;
1181 DROP TABLE t1,t2,t3,t4;
1182 CREATE TABLE t1(c1 BIGINT NOT NULL);
1183 CREATE TABLE t2(c1 BIGINT NULL);
1184 CREATE TABLE t3(c1 BIGINT NOT NULL);
1185 CREATE TABLE t4(c1 BIGINT NULL);
1186 INSERT INTO t2 (c1) VALUES(NULL);
1187 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1188 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1189 SELECT COUNT(c1) AS value FROM t2;
1192 SELECT COUNT(c1) AS value FROM t2 WHERE c1 = 0;
1195 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NULL;
1198 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NOT NULL;
1201 DROP TABLE t1,t2,t3,t4;
1202 CREATE TABLE t1(c1 TINYINT NOT NULL);
1203 CREATE TABLE t2(c1 TINYINT NULL);
1204 CREATE TABLE t3(c1 TINYINT NOT NULL);
1205 CREATE TABLE t4(c1 TINYINT NULL);
1206 INSERT INTO t2 (c1) VALUES(NULL);
1207 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1208 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1209 SELECT COUNT(c1) AS value FROM t3;
1212 SELECT COUNT(c1) AS value FROM t3 WHERE c1 = 0;
1215 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NULL;
1218 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NOT NULL;
1221 DROP TABLE t1,t2,t3,t4;
1222 CREATE TABLE t1(c1 SMALLINT NOT NULL);
1223 CREATE TABLE t2(c1 SMALLINT NULL);
1224 CREATE TABLE t3(c1 SMALLINT NOT NULL);
1225 CREATE TABLE t4(c1 SMALLINT NULL);
1226 INSERT INTO t2 (c1) VALUES(NULL);
1227 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1228 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1229 SELECT COUNT(c1) AS value FROM t3;
1232 SELECT COUNT(c1) AS value FROM t3 WHERE c1 = 0;
1235 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NULL;
1238 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NOT NULL;
1241 DROP TABLE t1,t2,t3,t4;
1242 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
1243 CREATE TABLE t2(c1 MEDIUMINT NULL);
1244 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
1245 CREATE TABLE t4(c1 MEDIUMINT NULL);
1246 INSERT INTO t2 (c1) VALUES(NULL);
1247 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1248 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1249 SELECT COUNT(c1) AS value FROM t3;
1252 SELECT COUNT(c1) AS value FROM t3 WHERE c1 = 0;
1255 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NULL;
1258 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NOT NULL;
1261 DROP TABLE t1,t2,t3,t4;
1262 CREATE TABLE t1(c1 INT NOT NULL);
1263 CREATE TABLE t2(c1 INT NULL);
1264 CREATE TABLE t3(c1 INT NOT NULL);
1265 CREATE TABLE t4(c1 INT NULL);
1266 INSERT INTO t2 (c1) VALUES(NULL);
1267 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1268 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1269 SELECT COUNT(c1) AS value FROM t3;
1272 SELECT COUNT(c1) AS value FROM t3 WHERE c1 = 0;
1275 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NULL;
1278 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NOT NULL;
1281 DROP TABLE t1,t2,t3,t4;
1282 CREATE TABLE t1(c1 INTEGER NOT NULL);
1283 CREATE TABLE t2(c1 INTEGER NULL);
1284 CREATE TABLE t3(c1 INTEGER NOT NULL);
1285 CREATE TABLE t4(c1 INTEGER NULL);
1286 INSERT INTO t2 (c1) VALUES(NULL);
1287 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1288 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1289 SELECT COUNT(c1) AS value FROM t3;
1292 SELECT COUNT(c1) AS value FROM t3 WHERE c1 = 0;
1295 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NULL;
1298 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NOT NULL;
1301 DROP TABLE t1,t2,t3,t4;
1302 CREATE TABLE t1(c1 BIGINT NOT NULL);
1303 CREATE TABLE t2(c1 BIGINT NULL);
1304 CREATE TABLE t3(c1 BIGINT NOT NULL);
1305 CREATE TABLE t4(c1 BIGINT NULL);
1306 INSERT INTO t2 (c1) VALUES(NULL);
1307 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1308 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1309 SELECT COUNT(c1) AS value FROM t3;
1312 SELECT COUNT(c1) AS value FROM t3 WHERE c1 = 0;
1315 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NULL;
1318 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NOT NULL;
1321 DROP TABLE t1,t2,t3,t4;
1322 CREATE TABLE t1(c1 TINYINT NOT NULL);
1323 CREATE TABLE t2(c1 TINYINT NULL);
1324 CREATE TABLE t3(c1 TINYINT NOT NULL);
1325 CREATE TABLE t4(c1 TINYINT NULL);
1326 INSERT INTO t2 (c1) VALUES(NULL);
1327 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1328 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1329 SELECT COUNT(c1) AS value FROM t4;
1332 SELECT COUNT(c1) AS value FROM t4 WHERE c1 = 0;
1335 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NULL;
1338 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NOT NULL;
1341 DROP TABLE t1,t2,t3,t4;
1342 CREATE TABLE t1(c1 SMALLINT NOT NULL);
1343 CREATE TABLE t2(c1 SMALLINT NULL);
1344 CREATE TABLE t3(c1 SMALLINT NOT NULL);
1345 CREATE TABLE t4(c1 SMALLINT NULL);
1346 INSERT INTO t2 (c1) VALUES(NULL);
1347 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1348 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1349 SELECT COUNT(c1) AS value FROM t4;
1352 SELECT COUNT(c1) AS value FROM t4 WHERE c1 = 0;
1355 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NULL;
1358 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NOT NULL;
1361 DROP TABLE t1,t2,t3,t4;
1362 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
1363 CREATE TABLE t2(c1 MEDIUMINT NULL);
1364 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
1365 CREATE TABLE t4(c1 MEDIUMINT NULL);
1366 INSERT INTO t2 (c1) VALUES(NULL);
1367 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1368 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1369 SELECT COUNT(c1) AS value FROM t4;
1372 SELECT COUNT(c1) AS value FROM t4 WHERE c1 = 0;
1375 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NULL;
1378 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NOT NULL;
1381 DROP TABLE t1,t2,t3,t4;
1382 CREATE TABLE t1(c1 INT NOT NULL);
1383 CREATE TABLE t2(c1 INT NULL);
1384 CREATE TABLE t3(c1 INT NOT NULL);
1385 CREATE TABLE t4(c1 INT NULL);
1386 INSERT INTO t2 (c1) VALUES(NULL);
1387 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1388 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1389 SELECT COUNT(c1) AS value FROM t4;
1392 SELECT COUNT(c1) AS value FROM t4 WHERE c1 = 0;
1395 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NULL;
1398 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NOT NULL;
1401 DROP TABLE t1,t2,t3,t4;
1402 CREATE TABLE t1(c1 INTEGER NOT NULL);
1403 CREATE TABLE t2(c1 INTEGER NULL);
1404 CREATE TABLE t3(c1 INTEGER NOT NULL);
1405 CREATE TABLE t4(c1 INTEGER NULL);
1406 INSERT INTO t2 (c1) VALUES(NULL);
1407 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1408 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1409 SELECT COUNT(c1) AS value FROM t4;
1412 SELECT COUNT(c1) AS value FROM t4 WHERE c1 = 0;
1415 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NULL;
1418 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NOT NULL;
1421 DROP TABLE t1,t2,t3,t4;
1422 CREATE TABLE t1(c1 BIGINT NOT NULL);
1423 CREATE TABLE t2(c1 BIGINT NULL);
1424 CREATE TABLE t3(c1 BIGINT NOT NULL);
1425 CREATE TABLE t4(c1 BIGINT NULL);
1426 INSERT INTO t2 (c1) VALUES(NULL);
1427 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1428 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1429 SELECT COUNT(c1) AS value FROM t4;
1432 SELECT COUNT(c1) AS value FROM t4 WHERE c1 = 0;
1435 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NULL;
1438 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NOT NULL;
1441 DROP TABLE t1,t2,t3,t4;
1442 CREATE TABLE t1(c1 TINYINT NOT NULL);
1443 CREATE TABLE t2(c1 TINYINT NULL);
1444 CREATE TABLE t3(c1 TINYINT NOT NULL);
1445 CREATE TABLE t4(c1 TINYINT NULL);
1446 INSERT INTO t2 (c1) VALUES(NULL);
1447 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1448 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1449 SELECT COUNT(c1) AS value FROM t1;
1452 SELECT COUNT(c1) AS value FROM t1 WHERE c1 >= 0;
1455 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NULL;
1458 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NOT NULL;
1461 DROP TABLE t1,t2,t3,t4;
1462 CREATE TABLE t1(c1 SMALLINT NOT NULL);
1463 CREATE TABLE t2(c1 SMALLINT NULL);
1464 CREATE TABLE t3(c1 SMALLINT NOT NULL);
1465 CREATE TABLE t4(c1 SMALLINT NULL);
1466 INSERT INTO t2 (c1) VALUES(NULL);
1467 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1468 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1469 SELECT COUNT(c1) AS value FROM t1;
1472 SELECT COUNT(c1) AS value FROM t1 WHERE c1 >= 0;
1475 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NULL;
1478 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NOT NULL;
1481 DROP TABLE t1,t2,t3,t4;
1482 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
1483 CREATE TABLE t2(c1 MEDIUMINT NULL);
1484 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
1485 CREATE TABLE t4(c1 MEDIUMINT NULL);
1486 INSERT INTO t2 (c1) VALUES(NULL);
1487 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1488 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1489 SELECT COUNT(c1) AS value FROM t1;
1492 SELECT COUNT(c1) AS value FROM t1 WHERE c1 >= 0;
1495 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NULL;
1498 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NOT NULL;
1501 DROP TABLE t1,t2,t3,t4;
1502 CREATE TABLE t1(c1 INT NOT NULL);
1503 CREATE TABLE t2(c1 INT NULL);
1504 CREATE TABLE t3(c1 INT NOT NULL);
1505 CREATE TABLE t4(c1 INT NULL);
1506 INSERT INTO t2 (c1) VALUES(NULL);
1507 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1508 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1509 SELECT COUNT(c1) AS value FROM t1;
1512 SELECT COUNT(c1) AS value FROM t1 WHERE c1 >= 0;
1515 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NULL;
1518 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NOT NULL;
1521 DROP TABLE t1,t2,t3,t4;
1522 CREATE TABLE t1(c1 INTEGER NOT NULL);
1523 CREATE TABLE t2(c1 INTEGER NULL);
1524 CREATE TABLE t3(c1 INTEGER NOT NULL);
1525 CREATE TABLE t4(c1 INTEGER NULL);
1526 INSERT INTO t2 (c1) VALUES(NULL);
1527 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1528 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1529 SELECT COUNT(c1) AS value FROM t1;
1532 SELECT COUNT(c1) AS value FROM t1 WHERE c1 >= 0;
1535 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NULL;
1538 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NOT NULL;
1541 DROP TABLE t1,t2,t3,t4;
1542 CREATE TABLE t1(c1 BIGINT NOT NULL);
1543 CREATE TABLE t2(c1 BIGINT NULL);
1544 CREATE TABLE t3(c1 BIGINT NOT NULL);
1545 CREATE TABLE t4(c1 BIGINT NULL);
1546 INSERT INTO t2 (c1) VALUES(NULL);
1547 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1548 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1549 SELECT COUNT(c1) AS value FROM t1;
1552 SELECT COUNT(c1) AS value FROM t1 WHERE c1 >= 0;
1555 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NULL;
1558 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NOT NULL;
1561 DROP TABLE t1,t2,t3,t4;
1562 CREATE TABLE t1(c1 TINYINT NOT NULL);
1563 CREATE TABLE t2(c1 TINYINT NULL);
1564 CREATE TABLE t3(c1 TINYINT NOT NULL);
1565 CREATE TABLE t4(c1 TINYINT NULL);
1566 INSERT INTO t2 (c1) VALUES(NULL);
1567 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1568 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1569 SELECT COUNT(c1) AS value FROM t2;
1572 SELECT COUNT(c1) AS value FROM t2 WHERE c1 >= 0;
1575 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NULL;
1578 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NOT NULL;
1581 DROP TABLE t1,t2,t3,t4;
1582 CREATE TABLE t1(c1 SMALLINT NOT NULL);
1583 CREATE TABLE t2(c1 SMALLINT NULL);
1584 CREATE TABLE t3(c1 SMALLINT NOT NULL);
1585 CREATE TABLE t4(c1 SMALLINT NULL);
1586 INSERT INTO t2 (c1) VALUES(NULL);
1587 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1588 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1589 SELECT COUNT(c1) AS value FROM t2;
1592 SELECT COUNT(c1) AS value FROM t2 WHERE c1 >= 0;
1595 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NULL;
1598 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NOT NULL;
1601 DROP TABLE t1,t2,t3,t4;
1602 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
1603 CREATE TABLE t2(c1 MEDIUMINT NULL);
1604 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
1605 CREATE TABLE t4(c1 MEDIUMINT NULL);
1606 INSERT INTO t2 (c1) VALUES(NULL);
1607 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1608 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1609 SELECT COUNT(c1) AS value FROM t2;
1612 SELECT COUNT(c1) AS value FROM t2 WHERE c1 >= 0;
1615 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NULL;
1618 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NOT NULL;
1621 DROP TABLE t1,t2,t3,t4;
1622 CREATE TABLE t1(c1 INT NOT NULL);
1623 CREATE TABLE t2(c1 INT NULL);
1624 CREATE TABLE t3(c1 INT NOT NULL);
1625 CREATE TABLE t4(c1 INT NULL);
1626 INSERT INTO t2 (c1) VALUES(NULL);
1627 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1628 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1629 SELECT COUNT(c1) AS value FROM t2;
1632 SELECT COUNT(c1) AS value FROM t2 WHERE c1 >= 0;
1635 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NULL;
1638 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NOT NULL;
1641 DROP TABLE t1,t2,t3,t4;
1642 CREATE TABLE t1(c1 INTEGER NOT NULL);
1643 CREATE TABLE t2(c1 INTEGER NULL);
1644 CREATE TABLE t3(c1 INTEGER NOT NULL);
1645 CREATE TABLE t4(c1 INTEGER NULL);
1646 INSERT INTO t2 (c1) VALUES(NULL);
1647 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1648 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1649 SELECT COUNT(c1) AS value FROM t2;
1652 SELECT COUNT(c1) AS value FROM t2 WHERE c1 >= 0;
1655 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NULL;
1658 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NOT NULL;
1661 DROP TABLE t1,t2,t3,t4;
1662 CREATE TABLE t1(c1 BIGINT NOT NULL);
1663 CREATE TABLE t2(c1 BIGINT NULL);
1664 CREATE TABLE t3(c1 BIGINT NOT NULL);
1665 CREATE TABLE t4(c1 BIGINT NULL);
1666 INSERT INTO t2 (c1) VALUES(NULL);
1667 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1668 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1669 SELECT COUNT(c1) AS value FROM t2;
1672 SELECT COUNT(c1) AS value FROM t2 WHERE c1 >= 0;
1675 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NULL;
1678 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NOT NULL;
1681 DROP TABLE t1,t2,t3,t4;
1682 CREATE TABLE t1(c1 TINYINT NOT NULL);
1683 CREATE TABLE t2(c1 TINYINT NULL);
1684 CREATE TABLE t3(c1 TINYINT NOT NULL);
1685 CREATE TABLE t4(c1 TINYINT NULL);
1686 INSERT INTO t2 (c1) VALUES(NULL);
1687 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1688 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1689 SELECT COUNT(c1) AS value FROM t3;
1692 SELECT COUNT(c1) AS value FROM t3 WHERE c1 >= 0;
1695 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NULL;
1698 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NOT NULL;
1701 DROP TABLE t1,t2,t3,t4;
1702 CREATE TABLE t1(c1 SMALLINT NOT NULL);
1703 CREATE TABLE t2(c1 SMALLINT NULL);
1704 CREATE TABLE t3(c1 SMALLINT NOT NULL);
1705 CREATE TABLE t4(c1 SMALLINT NULL);
1706 INSERT INTO t2 (c1) VALUES(NULL);
1707 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1708 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1709 SELECT COUNT(c1) AS value FROM t3;
1712 SELECT COUNT(c1) AS value FROM t3 WHERE c1 >= 0;
1715 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NULL;
1718 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NOT NULL;
1721 DROP TABLE t1,t2,t3,t4;
1722 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
1723 CREATE TABLE t2(c1 MEDIUMINT NULL);
1724 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
1725 CREATE TABLE t4(c1 MEDIUMINT NULL);
1726 INSERT INTO t2 (c1) VALUES(NULL);
1727 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1728 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1729 SELECT COUNT(c1) AS value FROM t3;
1732 SELECT COUNT(c1) AS value FROM t3 WHERE c1 >= 0;
1735 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NULL;
1738 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NOT NULL;
1741 DROP TABLE t1,t2,t3,t4;
1742 CREATE TABLE t1(c1 INT NOT NULL);
1743 CREATE TABLE t2(c1 INT NULL);
1744 CREATE TABLE t3(c1 INT NOT NULL);
1745 CREATE TABLE t4(c1 INT NULL);
1746 INSERT INTO t2 (c1) VALUES(NULL);
1747 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1748 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1749 SELECT COUNT(c1) AS value FROM t3;
1752 SELECT COUNT(c1) AS value FROM t3 WHERE c1 >= 0;
1755 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NULL;
1758 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NOT NULL;
1761 DROP TABLE t1,t2,t3,t4;
1762 CREATE TABLE t1(c1 INTEGER NOT NULL);
1763 CREATE TABLE t2(c1 INTEGER NULL);
1764 CREATE TABLE t3(c1 INTEGER NOT NULL);
1765 CREATE TABLE t4(c1 INTEGER NULL);
1766 INSERT INTO t2 (c1) VALUES(NULL);
1767 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1768 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1769 SELECT COUNT(c1) AS value FROM t3;
1772 SELECT COUNT(c1) AS value FROM t3 WHERE c1 >= 0;
1775 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NULL;
1778 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NOT NULL;
1781 DROP TABLE t1,t2,t3,t4;
1782 CREATE TABLE t1(c1 BIGINT NOT NULL);
1783 CREATE TABLE t2(c1 BIGINT NULL);
1784 CREATE TABLE t3(c1 BIGINT NOT NULL);
1785 CREATE TABLE t4(c1 BIGINT NULL);
1786 INSERT INTO t2 (c1) VALUES(NULL);
1787 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1788 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1789 SELECT COUNT(c1) AS value FROM t3;
1792 SELECT COUNT(c1) AS value FROM t3 WHERE c1 >= 0;
1795 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NULL;
1798 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NOT NULL;
1801 DROP TABLE t1,t2,t3,t4;
1802 CREATE TABLE t1(c1 TINYINT NOT NULL);
1803 CREATE TABLE t2(c1 TINYINT NULL);
1804 CREATE TABLE t3(c1 TINYINT NOT NULL);
1805 CREATE TABLE t4(c1 TINYINT NULL);
1806 INSERT INTO t2 (c1) VALUES(NULL);
1807 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1808 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1809 SELECT COUNT(c1) AS value FROM t4;
1812 SELECT COUNT(c1) AS value FROM t4 WHERE c1 >= 0;
1815 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NULL;
1818 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NOT NULL;
1821 DROP TABLE t1,t2,t3,t4;
1822 CREATE TABLE t1(c1 SMALLINT NOT NULL);
1823 CREATE TABLE t2(c1 SMALLINT NULL);
1824 CREATE TABLE t3(c1 SMALLINT NOT NULL);
1825 CREATE TABLE t4(c1 SMALLINT NULL);
1826 INSERT INTO t2 (c1) VALUES(NULL);
1827 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1828 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1829 SELECT COUNT(c1) AS value FROM t4;
1832 SELECT COUNT(c1) AS value FROM t4 WHERE c1 >= 0;
1835 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NULL;
1838 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NOT NULL;
1841 DROP TABLE t1,t2,t3,t4;
1842 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
1843 CREATE TABLE t2(c1 MEDIUMINT NULL);
1844 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
1845 CREATE TABLE t4(c1 MEDIUMINT NULL);
1846 INSERT INTO t2 (c1) VALUES(NULL);
1847 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1848 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1849 SELECT COUNT(c1) AS value FROM t4;
1852 SELECT COUNT(c1) AS value FROM t4 WHERE c1 >= 0;
1855 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NULL;
1858 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NOT NULL;
1861 DROP TABLE t1,t2,t3,t4;
1862 CREATE TABLE t1(c1 INT NOT NULL);
1863 CREATE TABLE t2(c1 INT NULL);
1864 CREATE TABLE t3(c1 INT NOT NULL);
1865 CREATE TABLE t4(c1 INT NULL);
1866 INSERT INTO t2 (c1) VALUES(NULL);
1867 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1868 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1869 SELECT COUNT(c1) AS value FROM t4;
1872 SELECT COUNT(c1) AS value FROM t4 WHERE c1 >= 0;
1875 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NULL;
1878 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NOT NULL;
1881 DROP TABLE t1,t2,t3,t4;
1882 CREATE TABLE t1(c1 INTEGER NOT NULL);
1883 CREATE TABLE t2(c1 INTEGER NULL);
1884 CREATE TABLE t3(c1 INTEGER NOT NULL);
1885 CREATE TABLE t4(c1 INTEGER NULL);
1886 INSERT INTO t2 (c1) VALUES(NULL);
1887 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1888 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1889 SELECT COUNT(c1) AS value FROM t4;
1892 SELECT COUNT(c1) AS value FROM t4 WHERE c1 >= 0;
1895 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NULL;
1898 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NOT NULL;
1901 DROP TABLE t1,t2,t3,t4;
1902 CREATE TABLE t1(c1 BIGINT NOT NULL);
1903 CREATE TABLE t2(c1 BIGINT NULL);
1904 CREATE TABLE t3(c1 BIGINT NOT NULL);
1905 CREATE TABLE t4(c1 BIGINT NULL);
1906 INSERT INTO t2 (c1) VALUES(NULL);
1907 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1908 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1909 SELECT COUNT(c1) AS value FROM t4;
1912 SELECT COUNT(c1) AS value FROM t4 WHERE c1 >= 0;
1915 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NULL;
1918 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NOT NULL;
1921 DROP TABLE t1,t2,t3,t4;
1922 CREATE TABLE t1(c1 TINYINT NOT NULL);
1923 CREATE TABLE t2(c1 TINYINT NULL);
1924 CREATE TABLE t3(c1 TINYINT NOT NULL);
1925 CREATE TABLE t4(c1 TINYINT NULL);
1926 INSERT INTO t2 (c1) VALUES(NULL);
1927 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1928 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1929 SELECT COUNT(c1) AS value FROM t1;
1932 SELECT COUNT(c1) AS value FROM t1 WHERE c1 != 0;
1935 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NULL;
1938 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NOT NULL;
1941 DROP TABLE t1,t2,t3,t4;
1942 CREATE TABLE t1(c1 SMALLINT NOT NULL);
1943 CREATE TABLE t2(c1 SMALLINT NULL);
1944 CREATE TABLE t3(c1 SMALLINT NOT NULL);
1945 CREATE TABLE t4(c1 SMALLINT NULL);
1946 INSERT INTO t2 (c1) VALUES(NULL);
1947 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1948 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1949 SELECT COUNT(c1) AS value FROM t1;
1952 SELECT COUNT(c1) AS value FROM t1 WHERE c1 != 0;
1955 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NULL;
1958 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NOT NULL;
1961 DROP TABLE t1,t2,t3,t4;
1962 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
1963 CREATE TABLE t2(c1 MEDIUMINT NULL);
1964 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
1965 CREATE TABLE t4(c1 MEDIUMINT NULL);
1966 INSERT INTO t2 (c1) VALUES(NULL);
1967 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1968 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1969 SELECT COUNT(c1) AS value FROM t1;
1972 SELECT COUNT(c1) AS value FROM t1 WHERE c1 != 0;
1975 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NULL;
1978 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NOT NULL;
1981 DROP TABLE t1,t2,t3,t4;
1982 CREATE TABLE t1(c1 INT NOT NULL);
1983 CREATE TABLE t2(c1 INT NULL);
1984 CREATE TABLE t3(c1 INT NOT NULL);
1985 CREATE TABLE t4(c1 INT NULL);
1986 INSERT INTO t2 (c1) VALUES(NULL);
1987 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1988 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1989 SELECT COUNT(c1) AS value FROM t1;
1992 SELECT COUNT(c1) AS value FROM t1 WHERE c1 != 0;
1995 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NULL;
1998 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NOT NULL;
2001 DROP TABLE t1,t2,t3,t4;
2002 CREATE TABLE t1(c1 INTEGER NOT NULL);
2003 CREATE TABLE t2(c1 INTEGER NULL);
2004 CREATE TABLE t3(c1 INTEGER NOT NULL);
2005 CREATE TABLE t4(c1 INTEGER NULL);
2006 INSERT INTO t2 (c1) VALUES(NULL);
2007 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2008 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2009 SELECT COUNT(c1) AS value FROM t1;
2012 SELECT COUNT(c1) AS value FROM t1 WHERE c1 != 0;
2015 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NULL;
2018 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NOT NULL;
2021 DROP TABLE t1,t2,t3,t4;
2022 CREATE TABLE t1(c1 BIGINT NOT NULL);
2023 CREATE TABLE t2(c1 BIGINT NULL);
2024 CREATE TABLE t3(c1 BIGINT NOT NULL);
2025 CREATE TABLE t4(c1 BIGINT NULL);
2026 INSERT INTO t2 (c1) VALUES(NULL);
2027 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2028 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2029 SELECT COUNT(c1) AS value FROM t1;
2032 SELECT COUNT(c1) AS value FROM t1 WHERE c1 != 0;
2035 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NULL;
2038 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NOT NULL;
2041 DROP TABLE t1,t2,t3,t4;
2042 CREATE TABLE t1(c1 TINYINT NOT NULL);
2043 CREATE TABLE t2(c1 TINYINT NULL);
2044 CREATE TABLE t3(c1 TINYINT NOT NULL);
2045 CREATE TABLE t4(c1 TINYINT NULL);
2046 INSERT INTO t2 (c1) VALUES(NULL);
2047 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2048 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2049 SELECT COUNT(c1) AS value FROM t2;
2052 SELECT COUNT(c1) AS value FROM t2 WHERE c1 != 0;
2055 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NULL;
2058 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NOT NULL;
2061 DROP TABLE t1,t2,t3,t4;
2062 CREATE TABLE t1(c1 SMALLINT NOT NULL);
2063 CREATE TABLE t2(c1 SMALLINT NULL);
2064 CREATE TABLE t3(c1 SMALLINT NOT NULL);
2065 CREATE TABLE t4(c1 SMALLINT NULL);
2066 INSERT INTO t2 (c1) VALUES(NULL);
2067 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2068 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2069 SELECT COUNT(c1) AS value FROM t2;
2072 SELECT COUNT(c1) AS value FROM t2 WHERE c1 != 0;
2075 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NULL;
2078 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NOT NULL;
2081 DROP TABLE t1,t2,t3,t4;
2082 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
2083 CREATE TABLE t2(c1 MEDIUMINT NULL);
2084 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
2085 CREATE TABLE t4(c1 MEDIUMINT NULL);
2086 INSERT INTO t2 (c1) VALUES(NULL);
2087 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2088 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2089 SELECT COUNT(c1) AS value FROM t2;
2092 SELECT COUNT(c1) AS value FROM t2 WHERE c1 != 0;
2095 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NULL;
2098 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NOT NULL;
2101 DROP TABLE t1,t2,t3,t4;
2102 CREATE TABLE t1(c1 INT NOT NULL);
2103 CREATE TABLE t2(c1 INT NULL);
2104 CREATE TABLE t3(c1 INT NOT NULL);
2105 CREATE TABLE t4(c1 INT NULL);
2106 INSERT INTO t2 (c1) VALUES(NULL);
2107 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2108 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2109 SELECT COUNT(c1) AS value FROM t2;
2112 SELECT COUNT(c1) AS value FROM t2 WHERE c1 != 0;
2115 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NULL;
2118 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NOT NULL;
2121 DROP TABLE t1,t2,t3,t4;
2122 CREATE TABLE t1(c1 INTEGER NOT NULL);
2123 CREATE TABLE t2(c1 INTEGER NULL);
2124 CREATE TABLE t3(c1 INTEGER NOT NULL);
2125 CREATE TABLE t4(c1 INTEGER NULL);
2126 INSERT INTO t2 (c1) VALUES(NULL);
2127 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2128 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2129 SELECT COUNT(c1) AS value FROM t2;
2132 SELECT COUNT(c1) AS value FROM t2 WHERE c1 != 0;
2135 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NULL;
2138 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NOT NULL;
2141 DROP TABLE t1,t2,t3,t4;
2142 CREATE TABLE t1(c1 BIGINT NOT NULL);
2143 CREATE TABLE t2(c1 BIGINT NULL);
2144 CREATE TABLE t3(c1 BIGINT NOT NULL);
2145 CREATE TABLE t4(c1 BIGINT NULL);
2146 INSERT INTO t2 (c1) VALUES(NULL);
2147 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2148 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2149 SELECT COUNT(c1) AS value FROM t2;
2152 SELECT COUNT(c1) AS value FROM t2 WHERE c1 != 0;
2155 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NULL;
2158 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NOT NULL;
2161 DROP TABLE t1,t2,t3,t4;
2162 CREATE TABLE t1(c1 TINYINT NOT NULL);
2163 CREATE TABLE t2(c1 TINYINT NULL);
2164 CREATE TABLE t3(c1 TINYINT NOT NULL);
2165 CREATE TABLE t4(c1 TINYINT NULL);
2166 INSERT INTO t2 (c1) VALUES(NULL);
2167 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2168 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2169 SELECT COUNT(c1) AS value FROM t3;
2172 SELECT COUNT(c1) AS value FROM t3 WHERE c1 != 0;
2175 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NULL;
2178 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NOT NULL;
2181 DROP TABLE t1,t2,t3,t4;
2182 CREATE TABLE t1(c1 SMALLINT NOT NULL);
2183 CREATE TABLE t2(c1 SMALLINT NULL);
2184 CREATE TABLE t3(c1 SMALLINT NOT NULL);
2185 CREATE TABLE t4(c1 SMALLINT NULL);
2186 INSERT INTO t2 (c1) VALUES(NULL);
2187 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2188 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2189 SELECT COUNT(c1) AS value FROM t3;
2192 SELECT COUNT(c1) AS value FROM t3 WHERE c1 != 0;
2195 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NULL;
2198 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NOT NULL;
2201 DROP TABLE t1,t2,t3,t4;
2202 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
2203 CREATE TABLE t2(c1 MEDIUMINT NULL);
2204 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
2205 CREATE TABLE t4(c1 MEDIUMINT NULL);
2206 INSERT INTO t2 (c1) VALUES(NULL);
2207 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2208 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2209 SELECT COUNT(c1) AS value FROM t3;
2212 SELECT COUNT(c1) AS value FROM t3 WHERE c1 != 0;
2215 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NULL;
2218 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NOT NULL;
2221 DROP TABLE t1,t2,t3,t4;
2222 CREATE TABLE t1(c1 INT NOT NULL);
2223 CREATE TABLE t2(c1 INT NULL);
2224 CREATE TABLE t3(c1 INT NOT NULL);
2225 CREATE TABLE t4(c1 INT NULL);
2226 INSERT INTO t2 (c1) VALUES(NULL);
2227 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2228 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2229 SELECT COUNT(c1) AS value FROM t3;
2232 SELECT COUNT(c1) AS value FROM t3 WHERE c1 != 0;
2235 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NULL;
2238 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NOT NULL;
2241 DROP TABLE t1,t2,t3,t4;
2242 CREATE TABLE t1(c1 INTEGER NOT NULL);
2243 CREATE TABLE t2(c1 INTEGER NULL);
2244 CREATE TABLE t3(c1 INTEGER NOT NULL);
2245 CREATE TABLE t4(c1 INTEGER NULL);
2246 INSERT INTO t2 (c1) VALUES(NULL);
2247 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2248 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2249 SELECT COUNT(c1) AS value FROM t3;
2252 SELECT COUNT(c1) AS value FROM t3 WHERE c1 != 0;
2255 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NULL;
2258 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NOT NULL;
2261 DROP TABLE t1,t2,t3,t4;
2262 CREATE TABLE t1(c1 BIGINT NOT NULL);
2263 CREATE TABLE t2(c1 BIGINT NULL);
2264 CREATE TABLE t3(c1 BIGINT NOT NULL);
2265 CREATE TABLE t4(c1 BIGINT NULL);
2266 INSERT INTO t2 (c1) VALUES(NULL);
2267 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2268 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2269 SELECT COUNT(c1) AS value FROM t3;
2272 SELECT COUNT(c1) AS value FROM t3 WHERE c1 != 0;
2275 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NULL;
2278 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NOT NULL;
2281 DROP TABLE t1,t2,t3,t4;
2282 CREATE TABLE t1(c1 TINYINT NOT NULL);
2283 CREATE TABLE t2(c1 TINYINT NULL);
2284 CREATE TABLE t3(c1 TINYINT NOT NULL);
2285 CREATE TABLE t4(c1 TINYINT NULL);
2286 INSERT INTO t2 (c1) VALUES(NULL);
2287 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2288 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2289 SELECT COUNT(c1) AS value FROM t4;
2292 SELECT COUNT(c1) AS value FROM t4 WHERE c1 != 0;
2295 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NULL;
2298 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NOT NULL;
2301 DROP TABLE t1,t2,t3,t4;
2302 CREATE TABLE t1(c1 SMALLINT NOT NULL);
2303 CREATE TABLE t2(c1 SMALLINT NULL);
2304 CREATE TABLE t3(c1 SMALLINT NOT NULL);
2305 CREATE TABLE t4(c1 SMALLINT NULL);
2306 INSERT INTO t2 (c1) VALUES(NULL);
2307 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2308 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2309 SELECT COUNT(c1) AS value FROM t4;
2312 SELECT COUNT(c1) AS value FROM t4 WHERE c1 != 0;
2315 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NULL;
2318 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NOT NULL;
2321 DROP TABLE t1,t2,t3,t4;
2322 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
2323 CREATE TABLE t2(c1 MEDIUMINT NULL);
2324 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
2325 CREATE TABLE t4(c1 MEDIUMINT NULL);
2326 INSERT INTO t2 (c1) VALUES(NULL);
2327 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2328 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2329 SELECT COUNT(c1) AS value FROM t4;
2332 SELECT COUNT(c1) AS value FROM t4 WHERE c1 != 0;
2335 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NULL;
2338 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NOT NULL;
2341 DROP TABLE t1,t2,t3,t4;
2342 CREATE TABLE t1(c1 INT NOT NULL);
2343 CREATE TABLE t2(c1 INT NULL);
2344 CREATE TABLE t3(c1 INT NOT NULL);
2345 CREATE TABLE t4(c1 INT NULL);
2346 INSERT INTO t2 (c1) VALUES(NULL);
2347 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2348 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2349 SELECT COUNT(c1) AS value FROM t4;
2352 SELECT COUNT(c1) AS value FROM t4 WHERE c1 != 0;
2355 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NULL;
2358 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NOT NULL;
2361 DROP TABLE t1,t2,t3,t4;
2362 CREATE TABLE t1(c1 INTEGER NOT NULL);
2363 CREATE TABLE t2(c1 INTEGER NULL);
2364 CREATE TABLE t3(c1 INTEGER NOT NULL);
2365 CREATE TABLE t4(c1 INTEGER NULL);
2366 INSERT INTO t2 (c1) VALUES(NULL);
2367 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2368 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2369 SELECT COUNT(c1) AS value FROM t4;
2372 SELECT COUNT(c1) AS value FROM t4 WHERE c1 != 0;
2375 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NULL;
2378 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NOT NULL;
2381 DROP TABLE t1,t2,t3,t4;
2382 CREATE TABLE t1(c1 BIGINT NOT NULL);
2383 CREATE TABLE t2(c1 BIGINT NULL);
2384 CREATE TABLE t3(c1 BIGINT NOT NULL);
2385 CREATE TABLE t4(c1 BIGINT NULL);
2386 INSERT INTO t2 (c1) VALUES(NULL);
2387 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2388 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2389 SELECT COUNT(c1) AS value FROM t4;
2392 SELECT COUNT(c1) AS value FROM t4 WHERE c1 != 0;
2395 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NULL;
2398 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NOT NULL;
2401 DROP TABLE t1,t2,t3,t4;
2402 CREATE TABLE t1(c1 TINYINT NOT NULL);
2403 CREATE TABLE t2(c1 TINYINT NULL);
2404 CREATE TABLE t3(c1 TINYINT NOT NULL);
2405 CREATE TABLE t4(c1 TINYINT NULL);
2406 INSERT INTO t2 (c1) VALUES(NULL);
2407 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2408 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2409 SELECT COUNT(c1) AS value FROM t1;
2412 SELECT COUNT(c1) AS value FROM t1 WHERE c1 <> 0;
2415 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NULL;
2418 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NOT NULL;
2421 DROP TABLE t1,t2,t3,t4;
2422 CREATE TABLE t1(c1 SMALLINT NOT NULL);
2423 CREATE TABLE t2(c1 SMALLINT NULL);
2424 CREATE TABLE t3(c1 SMALLINT NOT NULL);
2425 CREATE TABLE t4(c1 SMALLINT NULL);
2426 INSERT INTO t2 (c1) VALUES(NULL);
2427 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2428 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2429 SELECT COUNT(c1) AS value FROM t1;
2432 SELECT COUNT(c1) AS value FROM t1 WHERE c1 <> 0;
2435 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NULL;
2438 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NOT NULL;
2441 DROP TABLE t1,t2,t3,t4;
2442 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
2443 CREATE TABLE t2(c1 MEDIUMINT NULL);
2444 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
2445 CREATE TABLE t4(c1 MEDIUMINT NULL);
2446 INSERT INTO t2 (c1) VALUES(NULL);
2447 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2448 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2449 SELECT COUNT(c1) AS value FROM t1;
2452 SELECT COUNT(c1) AS value FROM t1 WHERE c1 <> 0;
2455 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NULL;
2458 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NOT NULL;
2461 DROP TABLE t1,t2,t3,t4;
2462 CREATE TABLE t1(c1 INT NOT NULL);
2463 CREATE TABLE t2(c1 INT NULL);
2464 CREATE TABLE t3(c1 INT NOT NULL);
2465 CREATE TABLE t4(c1 INT NULL);
2466 INSERT INTO t2 (c1) VALUES(NULL);
2467 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2468 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2469 SELECT COUNT(c1) AS value FROM t1;
2472 SELECT COUNT(c1) AS value FROM t1 WHERE c1 <> 0;
2475 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NULL;
2478 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NOT NULL;
2481 DROP TABLE t1,t2,t3,t4;
2482 CREATE TABLE t1(c1 INTEGER NOT NULL);
2483 CREATE TABLE t2(c1 INTEGER NULL);
2484 CREATE TABLE t3(c1 INTEGER NOT NULL);
2485 CREATE TABLE t4(c1 INTEGER NULL);
2486 INSERT INTO t2 (c1) VALUES(NULL);
2487 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2488 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2489 SELECT COUNT(c1) AS value FROM t1;
2492 SELECT COUNT(c1) AS value FROM t1 WHERE c1 <> 0;
2495 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NULL;
2498 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NOT NULL;
2501 DROP TABLE t1,t2,t3,t4;
2502 CREATE TABLE t1(c1 BIGINT NOT NULL);
2503 CREATE TABLE t2(c1 BIGINT NULL);
2504 CREATE TABLE t3(c1 BIGINT NOT NULL);
2505 CREATE TABLE t4(c1 BIGINT NULL);
2506 INSERT INTO t2 (c1) VALUES(NULL);
2507 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2508 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2509 SELECT COUNT(c1) AS value FROM t1;
2512 SELECT COUNT(c1) AS value FROM t1 WHERE c1 <> 0;
2515 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NULL;
2518 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NOT NULL;
2521 DROP TABLE t1,t2,t3,t4;
2522 CREATE TABLE t1(c1 TINYINT NOT NULL);
2523 CREATE TABLE t2(c1 TINYINT NULL);
2524 CREATE TABLE t3(c1 TINYINT NOT NULL);
2525 CREATE TABLE t4(c1 TINYINT NULL);
2526 INSERT INTO t2 (c1) VALUES(NULL);
2527 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2528 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2529 SELECT COUNT(c1) AS value FROM t2;
2532 SELECT COUNT(c1) AS value FROM t2 WHERE c1 <> 0;
2535 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NULL;
2538 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NOT NULL;
2541 DROP TABLE t1,t2,t3,t4;
2542 CREATE TABLE t1(c1 SMALLINT NOT NULL);
2543 CREATE TABLE t2(c1 SMALLINT NULL);
2544 CREATE TABLE t3(c1 SMALLINT NOT NULL);
2545 CREATE TABLE t4(c1 SMALLINT NULL);
2546 INSERT INTO t2 (c1) VALUES(NULL);
2547 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2548 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2549 SELECT COUNT(c1) AS value FROM t2;
2552 SELECT COUNT(c1) AS value FROM t2 WHERE c1 <> 0;
2555 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NULL;
2558 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NOT NULL;
2561 DROP TABLE t1,t2,t3,t4;
2562 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
2563 CREATE TABLE t2(c1 MEDIUMINT NULL);
2564 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
2565 CREATE TABLE t4(c1 MEDIUMINT NULL);
2566 INSERT INTO t2 (c1) VALUES(NULL);
2567 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2568 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2569 SELECT COUNT(c1) AS value FROM t2;
2572 SELECT COUNT(c1) AS value FROM t2 WHERE c1 <> 0;
2575 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NULL;
2578 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NOT NULL;
2581 DROP TABLE t1,t2,t3,t4;
2582 CREATE TABLE t1(c1 INT NOT NULL);
2583 CREATE TABLE t2(c1 INT NULL);
2584 CREATE TABLE t3(c1 INT NOT NULL);
2585 CREATE TABLE t4(c1 INT NULL);
2586 INSERT INTO t2 (c1) VALUES(NULL);
2587 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2588 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2589 SELECT COUNT(c1) AS value FROM t2;
2592 SELECT COUNT(c1) AS value FROM t2 WHERE c1 <> 0;
2595 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NULL;
2598 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NOT NULL;
2601 DROP TABLE t1,t2,t3,t4;
2602 CREATE TABLE t1(c1 INTEGER NOT NULL);
2603 CREATE TABLE t2(c1 INTEGER NULL);
2604 CREATE TABLE t3(c1 INTEGER NOT NULL);
2605 CREATE TABLE t4(c1 INTEGER NULL);
2606 INSERT INTO t2 (c1) VALUES(NULL);
2607 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2608 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2609 SELECT COUNT(c1) AS value FROM t2;
2612 SELECT COUNT(c1) AS value FROM t2 WHERE c1 <> 0;
2615 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NULL;
2618 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NOT NULL;
2621 DROP TABLE t1,t2,t3,t4;
2622 CREATE TABLE t1(c1 BIGINT NOT NULL);
2623 CREATE TABLE t2(c1 BIGINT NULL);
2624 CREATE TABLE t3(c1 BIGINT NOT NULL);
2625 CREATE TABLE t4(c1 BIGINT NULL);
2626 INSERT INTO t2 (c1) VALUES(NULL);
2627 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2628 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2629 SELECT COUNT(c1) AS value FROM t2;
2632 SELECT COUNT(c1) AS value FROM t2 WHERE c1 <> 0;
2635 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NULL;
2638 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NOT NULL;
2641 DROP TABLE t1,t2,t3,t4;
2642 CREATE TABLE t1(c1 TINYINT NOT NULL);
2643 CREATE TABLE t2(c1 TINYINT NULL);
2644 CREATE TABLE t3(c1 TINYINT NOT NULL);
2645 CREATE TABLE t4(c1 TINYINT NULL);
2646 INSERT INTO t2 (c1) VALUES(NULL);
2647 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2648 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2649 SELECT COUNT(c1) AS value FROM t3;
2652 SELECT COUNT(c1) AS value FROM t3 WHERE c1 <> 0;
2655 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NULL;
2658 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NOT NULL;
2661 DROP TABLE t1,t2,t3,t4;
2662 CREATE TABLE t1(c1 SMALLINT NOT NULL);
2663 CREATE TABLE t2(c1 SMALLINT NULL);
2664 CREATE TABLE t3(c1 SMALLINT NOT NULL);
2665 CREATE TABLE t4(c1 SMALLINT NULL);
2666 INSERT INTO t2 (c1) VALUES(NULL);
2667 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2668 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2669 SELECT COUNT(c1) AS value FROM t3;
2672 SELECT COUNT(c1) AS value FROM t3 WHERE c1 <> 0;
2675 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NULL;
2678 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NOT NULL;
2681 DROP TABLE t1,t2,t3,t4;
2682 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
2683 CREATE TABLE t2(c1 MEDIUMINT NULL);
2684 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
2685 CREATE TABLE t4(c1 MEDIUMINT NULL);
2686 INSERT INTO t2 (c1) VALUES(NULL);
2687 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2688 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2689 SELECT COUNT(c1) AS value FROM t3;
2692 SELECT COUNT(c1) AS value FROM t3 WHERE c1 <> 0;
2695 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NULL;
2698 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NOT NULL;
2701 DROP TABLE t1,t2,t3,t4;
2702 CREATE TABLE t1(c1 INT NOT NULL);
2703 CREATE TABLE t2(c1 INT NULL);
2704 CREATE TABLE t3(c1 INT NOT NULL);
2705 CREATE TABLE t4(c1 INT NULL);
2706 INSERT INTO t2 (c1) VALUES(NULL);
2707 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2708 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2709 SELECT COUNT(c1) AS value FROM t3;
2712 SELECT COUNT(c1) AS value FROM t3 WHERE c1 <> 0;
2715 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NULL;
2718 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NOT NULL;
2721 DROP TABLE t1,t2,t3,t4;
2722 CREATE TABLE t1(c1 INTEGER NOT NULL);
2723 CREATE TABLE t2(c1 INTEGER NULL);
2724 CREATE TABLE t3(c1 INTEGER NOT NULL);
2725 CREATE TABLE t4(c1 INTEGER NULL);
2726 INSERT INTO t2 (c1) VALUES(NULL);
2727 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2728 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2729 SELECT COUNT(c1) AS value FROM t3;
2732 SELECT COUNT(c1) AS value FROM t3 WHERE c1 <> 0;
2735 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NULL;
2738 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NOT NULL;
2741 DROP TABLE t1,t2,t3,t4;
2742 CREATE TABLE t1(c1 BIGINT NOT NULL);
2743 CREATE TABLE t2(c1 BIGINT NULL);
2744 CREATE TABLE t3(c1 BIGINT NOT NULL);
2745 CREATE TABLE t4(c1 BIGINT NULL);
2746 INSERT INTO t2 (c1) VALUES(NULL);
2747 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2748 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2749 SELECT COUNT(c1) AS value FROM t3;
2752 SELECT COUNT(c1) AS value FROM t3 WHERE c1 <> 0;
2755 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NULL;
2758 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NOT NULL;
2761 DROP TABLE t1,t2,t3,t4;
2762 CREATE TABLE t1(c1 TINYINT NOT NULL);
2763 CREATE TABLE t2(c1 TINYINT NULL);
2764 CREATE TABLE t3(c1 TINYINT NOT NULL);
2765 CREATE TABLE t4(c1 TINYINT NULL);
2766 INSERT INTO t2 (c1) VALUES(NULL);
2767 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2768 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2769 SELECT COUNT(c1) AS value FROM t4;
2772 SELECT COUNT(c1) AS value FROM t4 WHERE c1 <> 0;
2775 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NULL;
2778 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NOT NULL;
2781 DROP TABLE t1,t2,t3,t4;
2782 CREATE TABLE t1(c1 SMALLINT NOT NULL);
2783 CREATE TABLE t2(c1 SMALLINT NULL);
2784 CREATE TABLE t3(c1 SMALLINT NOT NULL);
2785 CREATE TABLE t4(c1 SMALLINT NULL);
2786 INSERT INTO t2 (c1) VALUES(NULL);
2787 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2788 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2789 SELECT COUNT(c1) AS value FROM t4;
2792 SELECT COUNT(c1) AS value FROM t4 WHERE c1 <> 0;
2795 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NULL;
2798 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NOT NULL;
2801 DROP TABLE t1,t2,t3,t4;
2802 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
2803 CREATE TABLE t2(c1 MEDIUMINT NULL);
2804 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
2805 CREATE TABLE t4(c1 MEDIUMINT NULL);
2806 INSERT INTO t2 (c1) VALUES(NULL);
2807 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2808 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2809 SELECT COUNT(c1) AS value FROM t4;
2812 SELECT COUNT(c1) AS value FROM t4 WHERE c1 <> 0;
2815 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NULL;
2818 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NOT NULL;
2821 DROP TABLE t1,t2,t3,t4;
2822 CREATE TABLE t1(c1 INT NOT NULL);
2823 CREATE TABLE t2(c1 INT NULL);
2824 CREATE TABLE t3(c1 INT NOT NULL);
2825 CREATE TABLE t4(c1 INT NULL);
2826 INSERT INTO t2 (c1) VALUES(NULL);
2827 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2828 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2829 SELECT COUNT(c1) AS value FROM t4;
2832 SELECT COUNT(c1) AS value FROM t4 WHERE c1 <> 0;
2835 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NULL;
2838 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NOT NULL;
2841 DROP TABLE t1,t2,t3,t4;
2842 CREATE TABLE t1(c1 INTEGER NOT NULL);
2843 CREATE TABLE t2(c1 INTEGER NULL);
2844 CREATE TABLE t3(c1 INTEGER NOT NULL);
2845 CREATE TABLE t4(c1 INTEGER NULL);
2846 INSERT INTO t2 (c1) VALUES(NULL);
2847 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2848 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2849 SELECT COUNT(c1) AS value FROM t4;
2852 SELECT COUNT(c1) AS value FROM t4 WHERE c1 <> 0;
2855 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NULL;
2858 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NOT NULL;
2861 DROP TABLE t1,t2,t3,t4;
2862 CREATE TABLE t1(c1 BIGINT NOT NULL);
2863 CREATE TABLE t2(c1 BIGINT NULL);
2864 CREATE TABLE t3(c1 BIGINT NOT NULL);
2865 CREATE TABLE t4(c1 BIGINT NULL);
2866 INSERT INTO t2 (c1) VALUES(NULL);
2867 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2868 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2869 SELECT COUNT(c1) AS value FROM t4;
2872 SELECT COUNT(c1) AS value FROM t4 WHERE c1 <> 0;
2875 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NULL;
2878 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NOT NULL;
2881 DROP TABLE t1,t2,t3,t4;
2882 CREATE TABLE t1(c1 TINYINT NOT NULL);
2883 CREATE TABLE t2(c1 TINYINT NULL);
2884 CREATE TABLE t3(c1 TINYINT NOT NULL);
2885 CREATE TABLE t4(c1 TINYINT NULL);
2886 INSERT INTO t2 (c1) VALUES(NULL);
2887 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2888 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2889 SELECT COUNT(c1) AS value FROM t1;
2892 SELECT COUNT(c1) AS value FROM t1 WHERE c1 <=> 0;
2895 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NULL;
2898 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NOT NULL;
2901 DROP TABLE t1,t2,t3,t4;
2902 CREATE TABLE t1(c1 SMALLINT NOT NULL);
2903 CREATE TABLE t2(c1 SMALLINT NULL);
2904 CREATE TABLE t3(c1 SMALLINT NOT NULL);
2905 CREATE TABLE t4(c1 SMALLINT NULL);
2906 INSERT INTO t2 (c1) VALUES(NULL);
2907 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2908 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2909 SELECT COUNT(c1) AS value FROM t1;
2912 SELECT COUNT(c1) AS value FROM t1 WHERE c1 <=> 0;
2915 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NULL;
2918 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NOT NULL;
2921 DROP TABLE t1,t2,t3,t4;
2922 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
2923 CREATE TABLE t2(c1 MEDIUMINT NULL);
2924 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
2925 CREATE TABLE t4(c1 MEDIUMINT NULL);
2926 INSERT INTO t2 (c1) VALUES(NULL);
2927 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2928 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2929 SELECT COUNT(c1) AS value FROM t1;
2932 SELECT COUNT(c1) AS value FROM t1 WHERE c1 <=> 0;
2935 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NULL;
2938 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NOT NULL;
2941 DROP TABLE t1,t2,t3,t4;
2942 CREATE TABLE t1(c1 INT NOT NULL);
2943 CREATE TABLE t2(c1 INT NULL);
2944 CREATE TABLE t3(c1 INT NOT NULL);
2945 CREATE TABLE t4(c1 INT NULL);
2946 INSERT INTO t2 (c1) VALUES(NULL);
2947 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2948 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2949 SELECT COUNT(c1) AS value FROM t1;
2952 SELECT COUNT(c1) AS value FROM t1 WHERE c1 <=> 0;
2955 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NULL;
2958 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NOT NULL;
2961 DROP TABLE t1,t2,t3,t4;
2962 CREATE TABLE t1(c1 INTEGER NOT NULL);
2963 CREATE TABLE t2(c1 INTEGER NULL);
2964 CREATE TABLE t3(c1 INTEGER NOT NULL);
2965 CREATE TABLE t4(c1 INTEGER NULL);
2966 INSERT INTO t2 (c1) VALUES(NULL);
2967 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2968 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2969 SELECT COUNT(c1) AS value FROM t1;
2972 SELECT COUNT(c1) AS value FROM t1 WHERE c1 <=> 0;
2975 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NULL;
2978 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NOT NULL;
2981 DROP TABLE t1,t2,t3,t4;
2982 CREATE TABLE t1(c1 BIGINT NOT NULL);
2983 CREATE TABLE t2(c1 BIGINT NULL);
2984 CREATE TABLE t3(c1 BIGINT NOT NULL);
2985 CREATE TABLE t4(c1 BIGINT NULL);
2986 INSERT INTO t2 (c1) VALUES(NULL);
2987 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2988 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
2989 SELECT COUNT(c1) AS value FROM t1;
2992 SELECT COUNT(c1) AS value FROM t1 WHERE c1 <=> 0;
2995 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NULL;
2998 SELECT COUNT(c1) AS value FROM t1 WHERE c1 IS NOT NULL;
3001 DROP TABLE t1,t2,t3,t4;
3002 CREATE TABLE t1(c1 TINYINT NOT NULL);
3003 CREATE TABLE t2(c1 TINYINT NULL);
3004 CREATE TABLE t3(c1 TINYINT NOT NULL);
3005 CREATE TABLE t4(c1 TINYINT NULL);
3006 INSERT INTO t2 (c1) VALUES(NULL);
3007 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3008 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3009 SELECT COUNT(c1) AS value FROM t2;
3012 SELECT COUNT(c1) AS value FROM t2 WHERE c1 <=> 0;
3015 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NULL;
3018 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NOT NULL;
3021 DROP TABLE t1,t2,t3,t4;
3022 CREATE TABLE t1(c1 SMALLINT NOT NULL);
3023 CREATE TABLE t2(c1 SMALLINT NULL);
3024 CREATE TABLE t3(c1 SMALLINT NOT NULL);
3025 CREATE TABLE t4(c1 SMALLINT NULL);
3026 INSERT INTO t2 (c1) VALUES(NULL);
3027 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3028 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3029 SELECT COUNT(c1) AS value FROM t2;
3032 SELECT COUNT(c1) AS value FROM t2 WHERE c1 <=> 0;
3035 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NULL;
3038 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NOT NULL;
3041 DROP TABLE t1,t2,t3,t4;
3042 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
3043 CREATE TABLE t2(c1 MEDIUMINT NULL);
3044 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
3045 CREATE TABLE t4(c1 MEDIUMINT NULL);
3046 INSERT INTO t2 (c1) VALUES(NULL);
3047 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3048 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3049 SELECT COUNT(c1) AS value FROM t2;
3052 SELECT COUNT(c1) AS value FROM t2 WHERE c1 <=> 0;
3055 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NULL;
3058 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NOT NULL;
3061 DROP TABLE t1,t2,t3,t4;
3062 CREATE TABLE t1(c1 INT NOT NULL);
3063 CREATE TABLE t2(c1 INT NULL);
3064 CREATE TABLE t3(c1 INT NOT NULL);
3065 CREATE TABLE t4(c1 INT NULL);
3066 INSERT INTO t2 (c1) VALUES(NULL);
3067 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3068 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3069 SELECT COUNT(c1) AS value FROM t2;
3072 SELECT COUNT(c1) AS value FROM t2 WHERE c1 <=> 0;
3075 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NULL;
3078 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NOT NULL;
3081 DROP TABLE t1,t2,t3,t4;
3082 CREATE TABLE t1(c1 INTEGER NOT NULL);
3083 CREATE TABLE t2(c1 INTEGER NULL);
3084 CREATE TABLE t3(c1 INTEGER NOT NULL);
3085 CREATE TABLE t4(c1 INTEGER NULL);
3086 INSERT INTO t2 (c1) VALUES(NULL);
3087 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3088 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3089 SELECT COUNT(c1) AS value FROM t2;
3092 SELECT COUNT(c1) AS value FROM t2 WHERE c1 <=> 0;
3095 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NULL;
3098 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NOT NULL;
3101 DROP TABLE t1,t2,t3,t4;
3102 CREATE TABLE t1(c1 BIGINT NOT NULL);
3103 CREATE TABLE t2(c1 BIGINT NULL);
3104 CREATE TABLE t3(c1 BIGINT NOT NULL);
3105 CREATE TABLE t4(c1 BIGINT NULL);
3106 INSERT INTO t2 (c1) VALUES(NULL);
3107 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3108 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3109 SELECT COUNT(c1) AS value FROM t2;
3112 SELECT COUNT(c1) AS value FROM t2 WHERE c1 <=> 0;
3115 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NULL;
3118 SELECT COUNT(c1) AS value FROM t2 WHERE c1 IS NOT NULL;
3121 DROP TABLE t1,t2,t3,t4;
3122 CREATE TABLE t1(c1 TINYINT NOT NULL);
3123 CREATE TABLE t2(c1 TINYINT NULL);
3124 CREATE TABLE t3(c1 TINYINT NOT NULL);
3125 CREATE TABLE t4(c1 TINYINT NULL);
3126 INSERT INTO t2 (c1) VALUES(NULL);
3127 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3128 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3129 SELECT COUNT(c1) AS value FROM t3;
3132 SELECT COUNT(c1) AS value FROM t3 WHERE c1 <=> 0;
3135 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NULL;
3138 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NOT NULL;
3141 DROP TABLE t1,t2,t3,t4;
3142 CREATE TABLE t1(c1 SMALLINT NOT NULL);
3143 CREATE TABLE t2(c1 SMALLINT NULL);
3144 CREATE TABLE t3(c1 SMALLINT NOT NULL);
3145 CREATE TABLE t4(c1 SMALLINT NULL);
3146 INSERT INTO t2 (c1) VALUES(NULL);
3147 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3148 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3149 SELECT COUNT(c1) AS value FROM t3;
3152 SELECT COUNT(c1) AS value FROM t3 WHERE c1 <=> 0;
3155 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NULL;
3158 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NOT NULL;
3161 DROP TABLE t1,t2,t3,t4;
3162 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
3163 CREATE TABLE t2(c1 MEDIUMINT NULL);
3164 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
3165 CREATE TABLE t4(c1 MEDIUMINT NULL);
3166 INSERT INTO t2 (c1) VALUES(NULL);
3167 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3168 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3169 SELECT COUNT(c1) AS value FROM t3;
3172 SELECT COUNT(c1) AS value FROM t3 WHERE c1 <=> 0;
3175 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NULL;
3178 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NOT NULL;
3181 DROP TABLE t1,t2,t3,t4;
3182 CREATE TABLE t1(c1 INT NOT NULL);
3183 CREATE TABLE t2(c1 INT NULL);
3184 CREATE TABLE t3(c1 INT NOT NULL);
3185 CREATE TABLE t4(c1 INT NULL);
3186 INSERT INTO t2 (c1) VALUES(NULL);
3187 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3188 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3189 SELECT COUNT(c1) AS value FROM t3;
3192 SELECT COUNT(c1) AS value FROM t3 WHERE c1 <=> 0;
3195 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NULL;
3198 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NOT NULL;
3201 DROP TABLE t1,t2,t3,t4;
3202 CREATE TABLE t1(c1 INTEGER NOT NULL);
3203 CREATE TABLE t2(c1 INTEGER NULL);
3204 CREATE TABLE t3(c1 INTEGER NOT NULL);
3205 CREATE TABLE t4(c1 INTEGER NULL);
3206 INSERT INTO t2 (c1) VALUES(NULL);
3207 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3208 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3209 SELECT COUNT(c1) AS value FROM t3;
3212 SELECT COUNT(c1) AS value FROM t3 WHERE c1 <=> 0;
3215 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NULL;
3218 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NOT NULL;
3221 DROP TABLE t1,t2,t3,t4;
3222 CREATE TABLE t1(c1 BIGINT NOT NULL);
3223 CREATE TABLE t2(c1 BIGINT NULL);
3224 CREATE TABLE t3(c1 BIGINT NOT NULL);
3225 CREATE TABLE t4(c1 BIGINT NULL);
3226 INSERT INTO t2 (c1) VALUES(NULL);
3227 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3228 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3229 SELECT COUNT(c1) AS value FROM t3;
3232 SELECT COUNT(c1) AS value FROM t3 WHERE c1 <=> 0;
3235 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NULL;
3238 SELECT COUNT(c1) AS value FROM t3 WHERE c1 IS NOT NULL;
3241 DROP TABLE t1,t2,t3,t4;
3242 CREATE TABLE t1(c1 TINYINT NOT NULL);
3243 CREATE TABLE t2(c1 TINYINT NULL);
3244 CREATE TABLE t3(c1 TINYINT NOT NULL);
3245 CREATE TABLE t4(c1 TINYINT NULL);
3246 INSERT INTO t2 (c1) VALUES(NULL);
3247 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3248 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3249 SELECT COUNT(c1) AS value FROM t4;
3252 SELECT COUNT(c1) AS value FROM t4 WHERE c1 <=> 0;
3255 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NULL;
3258 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NOT NULL;
3261 DROP TABLE t1,t2,t3,t4;
3262 CREATE TABLE t1(c1 SMALLINT NOT NULL);
3263 CREATE TABLE t2(c1 SMALLINT NULL);
3264 CREATE TABLE t3(c1 SMALLINT NOT NULL);
3265 CREATE TABLE t4(c1 SMALLINT NULL);
3266 INSERT INTO t2 (c1) VALUES(NULL);
3267 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3268 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3269 SELECT COUNT(c1) AS value FROM t4;
3272 SELECT COUNT(c1) AS value FROM t4 WHERE c1 <=> 0;
3275 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NULL;
3278 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NOT NULL;
3281 DROP TABLE t1,t2,t3,t4;
3282 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
3283 CREATE TABLE t2(c1 MEDIUMINT NULL);
3284 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
3285 CREATE TABLE t4(c1 MEDIUMINT NULL);
3286 INSERT INTO t2 (c1) VALUES(NULL);
3287 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3288 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3289 SELECT COUNT(c1) AS value FROM t4;
3292 SELECT COUNT(c1) AS value FROM t4 WHERE c1 <=> 0;
3295 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NULL;
3298 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NOT NULL;
3301 DROP TABLE t1,t2,t3,t4;
3302 CREATE TABLE t1(c1 INT NOT NULL);
3303 CREATE TABLE t2(c1 INT NULL);
3304 CREATE TABLE t3(c1 INT NOT NULL);
3305 CREATE TABLE t4(c1 INT NULL);
3306 INSERT INTO t2 (c1) VALUES(NULL);
3307 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3308 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3309 SELECT COUNT(c1) AS value FROM t4;
3312 SELECT COUNT(c1) AS value FROM t4 WHERE c1 <=> 0;
3315 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NULL;
3318 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NOT NULL;
3321 DROP TABLE t1,t2,t3,t4;
3322 CREATE TABLE t1(c1 INTEGER NOT NULL);
3323 CREATE TABLE t2(c1 INTEGER NULL);
3324 CREATE TABLE t3(c1 INTEGER NOT NULL);
3325 CREATE TABLE t4(c1 INTEGER NULL);
3326 INSERT INTO t2 (c1) VALUES(NULL);
3327 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3328 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3329 SELECT COUNT(c1) AS value FROM t4;
3332 SELECT COUNT(c1) AS value FROM t4 WHERE c1 <=> 0;
3335 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NULL;
3338 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NOT NULL;
3341 DROP TABLE t1,t2,t3,t4;
3342 CREATE TABLE t1(c1 BIGINT NOT NULL);
3343 CREATE TABLE t2(c1 BIGINT NULL);
3344 CREATE TABLE t3(c1 BIGINT NOT NULL);
3345 CREATE TABLE t4(c1 BIGINT NULL);
3346 INSERT INTO t2 (c1) VALUES(NULL);
3347 INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3348 INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
3349 SELECT COUNT(c1) AS value FROM t4;
3352 SELECT COUNT(c1) AS value FROM t4 WHERE c1 <=> 0;
3355 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NULL;
3358 SELECT COUNT(c1) AS value FROM t4 WHERE c1 IS NOT NULL;
3361 DROP TABLE t1,t2,t3,t4;