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;