Debian Codegraph @

mysql-test/suite/engines/funcs/t/fu_aggregate_count_number.test

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