Debian Codegraph @

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

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