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