Debian Codegraph @

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

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