Debian Codegraph @

mysql-test/suite/engines/funcs/r/general_no_data.result

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 TINYINT NOT NULL);
3 SELECT MAX(c1) AS value FROM t1;
4 value
5 NULL
6 SELECT MAX(c1) AS postive_value FROM t1 WHERE c1 > 0;
7 postive_value
8 NULL
9 SELECT MAX(c1) AS negative_value FROM t1 WHERE c1 < 0;
10 negative_value
11 NULL
12 SELECT MAX(c1) AS zero_value FROM t1 WHERE c1 = 0;
13 zero_value
14 NULL
15 SELECT MAX(c1) AS no_results FROM t1 WHERE c1 = 2;
16 no_results
17 NULL
18 DROP TABLE t1;
19 CREATE TABLE t1(c1 SMALLINT NOT NULL);
20 SELECT MAX(c1) AS value FROM t1;
21 value
22 NULL
23 SELECT MAX(c1) AS postive_value FROM t1 WHERE c1 > 0;
24 postive_value
25 NULL
26 SELECT MAX(c1) AS negative_value FROM t1 WHERE c1 < 0;
27 negative_value
28 NULL
29 SELECT MAX(c1) AS zero_value FROM t1 WHERE c1 = 0;
30 zero_value
31 NULL
32 SELECT MAX(c1) AS no_results FROM t1 WHERE c1 = 2;
33 no_results
34 NULL
35 DROP TABLE t1;
36 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
37 SELECT MAX(c1) AS value FROM t1;
38 value
39 NULL
40 SELECT MAX(c1) AS postive_value FROM t1 WHERE c1 > 0;
41 postive_value
42 NULL
43 SELECT MAX(c1) AS negative_value FROM t1 WHERE c1 < 0;
44 negative_value
45 NULL
46 SELECT MAX(c1) AS zero_value FROM t1 WHERE c1 = 0;
47 zero_value
48 NULL
49 SELECT MAX(c1) AS no_results FROM t1 WHERE c1 = 2;
50 no_results
51 NULL
52 DROP TABLE t1;
53 CREATE TABLE t1(c1 INT NOT NULL);
54 SELECT MAX(c1) AS value FROM t1;
55 value
56 NULL
57 SELECT MAX(c1) AS postive_value FROM t1 WHERE c1 > 0;
58 postive_value
59 NULL
60 SELECT MAX(c1) AS negative_value FROM t1 WHERE c1 < 0;
61 negative_value
62 NULL
63 SELECT MAX(c1) AS zero_value FROM t1 WHERE c1 = 0;
64 zero_value
65 NULL
66 SELECT MAX(c1) AS no_results FROM t1 WHERE c1 = 2;
67 no_results
68 NULL
69 DROP TABLE t1;
70 CREATE TABLE t1(c1 INTEGER NOT NULL);
71 SELECT MAX(c1) AS value FROM t1;
72 value
73 NULL
74 SELECT MAX(c1) AS postive_value FROM t1 WHERE c1 > 0;
75 postive_value
76 NULL
77 SELECT MAX(c1) AS negative_value FROM t1 WHERE c1 < 0;
78 negative_value
79 NULL
80 SELECT MAX(c1) AS zero_value FROM t1 WHERE c1 = 0;
81 zero_value
82 NULL
83 SELECT MAX(c1) AS no_results FROM t1 WHERE c1 = 2;
84 no_results
85 NULL
86 DROP TABLE t1;
87 CREATE TABLE t1(c1 BIGINT NOT NULL);
88 SELECT MAX(c1) AS value FROM t1;
89 value
90 NULL
91 SELECT MAX(c1) AS postive_value FROM t1 WHERE c1 > 0;
92 postive_value
93 NULL
94 SELECT MAX(c1) AS negative_value FROM t1 WHERE c1 < 0;
95 negative_value
96 NULL
97 SELECT MAX(c1) AS zero_value FROM t1 WHERE c1 = 0;
98 zero_value
99 NULL
100 SELECT MAX(c1) AS no_results FROM t1 WHERE c1 = 2;
101 no_results
102 NULL
103 DROP TABLE t1;
104 CREATE TABLE t1(c1 TINYINT NOT NULL);
105 SELECT MIN(c1) AS value FROM t1;
106 value
107 NULL
108 SELECT MIN(c1) AS postive_value FROM t1 WHERE c1 > 0;
109 postive_value
110 NULL
111 SELECT MIN(c1) AS negative_value FROM t1 WHERE c1 < 0;
112 negative_value
113 NULL
114 SELECT MIN(c1) AS zero_value FROM t1 WHERE c1 = 0;
115 zero_value
116 NULL
117 SELECT MIN(c1) AS no_results FROM t1 WHERE c1 = 2;
118 no_results
119 NULL
120 DROP TABLE t1;
121 CREATE TABLE t1(c1 SMALLINT NOT NULL);
122 SELECT MIN(c1) AS value FROM t1;
123 value
124 NULL
125 SELECT MIN(c1) AS postive_value FROM t1 WHERE c1 > 0;
126 postive_value
127 NULL
128 SELECT MIN(c1) AS negative_value FROM t1 WHERE c1 < 0;
129 negative_value
130 NULL
131 SELECT MIN(c1) AS zero_value FROM t1 WHERE c1 = 0;
132 zero_value
133 NULL
134 SELECT MIN(c1) AS no_results FROM t1 WHERE c1 = 2;
135 no_results
136 NULL
137 DROP TABLE t1;
138 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
139 SELECT MIN(c1) AS value FROM t1;
140 value
141 NULL
142 SELECT MIN(c1) AS postive_value FROM t1 WHERE c1 > 0;
143 postive_value
144 NULL
145 SELECT MIN(c1) AS negative_value FROM t1 WHERE c1 < 0;
146 negative_value
147 NULL
148 SELECT MIN(c1) AS zero_value FROM t1 WHERE c1 = 0;
149 zero_value
150 NULL
151 SELECT MIN(c1) AS no_results FROM t1 WHERE c1 = 2;
152 no_results
153 NULL
154 DROP TABLE t1;
155 CREATE TABLE t1(c1 INT NOT NULL);
156 SELECT MIN(c1) AS value FROM t1;
157 value
158 NULL
159 SELECT MIN(c1) AS postive_value FROM t1 WHERE c1 > 0;
160 postive_value
161 NULL
162 SELECT MIN(c1) AS negative_value FROM t1 WHERE c1 < 0;
163 negative_value
164 NULL
165 SELECT MIN(c1) AS zero_value FROM t1 WHERE c1 = 0;
166 zero_value
167 NULL
168 SELECT MIN(c1) AS no_results FROM t1 WHERE c1 = 2;
169 no_results
170 NULL
171 DROP TABLE t1;
172 CREATE TABLE t1(c1 INTEGER NOT NULL);
173 SELECT MIN(c1) AS value FROM t1;
174 value
175 NULL
176 SELECT MIN(c1) AS postive_value FROM t1 WHERE c1 > 0;
177 postive_value
178 NULL
179 SELECT MIN(c1) AS negative_value FROM t1 WHERE c1 < 0;
180 negative_value
181 NULL
182 SELECT MIN(c1) AS zero_value FROM t1 WHERE c1 = 0;
183 zero_value
184 NULL
185 SELECT MIN(c1) AS no_results FROM t1 WHERE c1 = 2;
186 no_results
187 NULL
188 DROP TABLE t1;
189 CREATE TABLE t1(c1 BIGINT NOT NULL);
190 SELECT MIN(c1) AS value FROM t1;
191 value
192 NULL
193 SELECT MIN(c1) AS postive_value FROM t1 WHERE c1 > 0;
194 postive_value
195 NULL
196 SELECT MIN(c1) AS negative_value FROM t1 WHERE c1 < 0;
197 negative_value
198 NULL
199 SELECT MIN(c1) AS zero_value FROM t1 WHERE c1 = 0;
200 zero_value
201 NULL
202 SELECT MIN(c1) AS no_results FROM t1 WHERE c1 = 2;
203 no_results
204 NULL
205 DROP TABLE t1;
206 CREATE TABLE t1(c1 TINYINT NOT NULL);
207 SELECT AVG(c1) AS value FROM t1;
208 value
209 NULL
210 SELECT AVG(c1) AS postive_value FROM t1 WHERE c1 > 0;
211 postive_value
212 NULL
213 SELECT AVG(c1) AS negative_value FROM t1 WHERE c1 < 0;
214 negative_value
215 NULL
216 SELECT AVG(c1) AS zero_value FROM t1 WHERE c1 = 0;
217 zero_value
218 NULL
219 SELECT AVG(c1) AS no_results FROM t1 WHERE c1 = 2;
220 no_results
221 NULL
222 DROP TABLE t1;
223 CREATE TABLE t1(c1 SMALLINT NOT NULL);
224 SELECT AVG(c1) AS value FROM t1;
225 value
226 NULL
227 SELECT AVG(c1) AS postive_value FROM t1 WHERE c1 > 0;
228 postive_value
229 NULL
230 SELECT AVG(c1) AS negative_value FROM t1 WHERE c1 < 0;
231 negative_value
232 NULL
233 SELECT AVG(c1) AS zero_value FROM t1 WHERE c1 = 0;
234 zero_value
235 NULL
236 SELECT AVG(c1) AS no_results FROM t1 WHERE c1 = 2;
237 no_results
238 NULL
239 DROP TABLE t1;
240 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
241 SELECT AVG(c1) AS value FROM t1;
242 value
243 NULL
244 SELECT AVG(c1) AS postive_value FROM t1 WHERE c1 > 0;
245 postive_value
246 NULL
247 SELECT AVG(c1) AS negative_value FROM t1 WHERE c1 < 0;
248 negative_value
249 NULL
250 SELECT AVG(c1) AS zero_value FROM t1 WHERE c1 = 0;
251 zero_value
252 NULL
253 SELECT AVG(c1) AS no_results FROM t1 WHERE c1 = 2;
254 no_results
255 NULL
256 DROP TABLE t1;
257 CREATE TABLE t1(c1 INT NOT NULL);
258 SELECT AVG(c1) AS value FROM t1;
259 value
260 NULL
261 SELECT AVG(c1) AS postive_value FROM t1 WHERE c1 > 0;
262 postive_value
263 NULL
264 SELECT AVG(c1) AS negative_value FROM t1 WHERE c1 < 0;
265 negative_value
266 NULL
267 SELECT AVG(c1) AS zero_value FROM t1 WHERE c1 = 0;
268 zero_value
269 NULL
270 SELECT AVG(c1) AS no_results FROM t1 WHERE c1 = 2;
271 no_results
272 NULL
273 DROP TABLE t1;
274 CREATE TABLE t1(c1 INTEGER NOT NULL);
275 SELECT AVG(c1) AS value FROM t1;
276 value
277 NULL
278 SELECT AVG(c1) AS postive_value FROM t1 WHERE c1 > 0;
279 postive_value
280 NULL
281 SELECT AVG(c1) AS negative_value FROM t1 WHERE c1 < 0;
282 negative_value
283 NULL
284 SELECT AVG(c1) AS zero_value FROM t1 WHERE c1 = 0;
285 zero_value
286 NULL
287 SELECT AVG(c1) AS no_results FROM t1 WHERE c1 = 2;
288 no_results
289 NULL
290 DROP TABLE t1;
291 CREATE TABLE t1(c1 BIGINT NOT NULL);
292 SELECT AVG(c1) AS value FROM t1;
293 value
294 NULL
295 SELECT AVG(c1) AS postive_value FROM t1 WHERE c1 > 0;
296 postive_value
297 NULL
298 SELECT AVG(c1) AS negative_value FROM t1 WHERE c1 < 0;
299 negative_value
300 NULL
301 SELECT AVG(c1) AS zero_value FROM t1 WHERE c1 = 0;
302 zero_value
303 NULL
304 SELECT AVG(c1) AS no_results FROM t1 WHERE c1 = 2;
305 no_results
306 NULL
307 DROP TABLE t1;
308 CREATE TABLE t1(c1 TINYINT NOT NULL);
309 SELECT SUM(c1) AS value FROM t1;
310 value
311 NULL
312 SELECT SUM(c1) AS postive_value FROM t1 WHERE c1 > 0;
313 postive_value
314 NULL
315 SELECT SUM(c1) AS negative_value FROM t1 WHERE c1 < 0;
316 negative_value
317 NULL
318 SELECT SUM(c1) AS zero_value FROM t1 WHERE c1 = 0;
319 zero_value
320 NULL
321 SELECT SUM(c1) AS no_results FROM t1 WHERE c1 = 2;
322 no_results
323 NULL
324 DROP TABLE t1;
325 CREATE TABLE t1(c1 SMALLINT NOT NULL);
326 SELECT SUM(c1) AS value FROM t1;
327 value
328 NULL
329 SELECT SUM(c1) AS postive_value FROM t1 WHERE c1 > 0;
330 postive_value
331 NULL
332 SELECT SUM(c1) AS negative_value FROM t1 WHERE c1 < 0;
333 negative_value
334 NULL
335 SELECT SUM(c1) AS zero_value FROM t1 WHERE c1 = 0;
336 zero_value
337 NULL
338 SELECT SUM(c1) AS no_results FROM t1 WHERE c1 = 2;
339 no_results
340 NULL
341 DROP TABLE t1;
342 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
343 SELECT SUM(c1) AS value FROM t1;
344 value
345 NULL
346 SELECT SUM(c1) AS postive_value FROM t1 WHERE c1 > 0;
347 postive_value
348 NULL
349 SELECT SUM(c1) AS negative_value FROM t1 WHERE c1 < 0;
350 negative_value
351 NULL
352 SELECT SUM(c1) AS zero_value FROM t1 WHERE c1 = 0;
353 zero_value
354 NULL
355 SELECT SUM(c1) AS no_results FROM t1 WHERE c1 = 2;
356 no_results
357 NULL
358 DROP TABLE t1;
359 CREATE TABLE t1(c1 INT NOT NULL);
360 SELECT SUM(c1) AS value FROM t1;
361 value
362 NULL
363 SELECT SUM(c1) AS postive_value FROM t1 WHERE c1 > 0;
364 postive_value
365 NULL
366 SELECT SUM(c1) AS negative_value FROM t1 WHERE c1 < 0;
367 negative_value
368 NULL
369 SELECT SUM(c1) AS zero_value FROM t1 WHERE c1 = 0;
370 zero_value
371 NULL
372 SELECT SUM(c1) AS no_results FROM t1 WHERE c1 = 2;
373 no_results
374 NULL
375 DROP TABLE t1;
376 CREATE TABLE t1(c1 INTEGER NOT NULL);
377 SELECT SUM(c1) AS value FROM t1;
378 value
379 NULL
380 SELECT SUM(c1) AS postive_value FROM t1 WHERE c1 > 0;
381 postive_value
382 NULL
383 SELECT SUM(c1) AS negative_value FROM t1 WHERE c1 < 0;
384 negative_value
385 NULL
386 SELECT SUM(c1) AS zero_value FROM t1 WHERE c1 = 0;
387 zero_value
388 NULL
389 SELECT SUM(c1) AS no_results FROM t1 WHERE c1 = 2;
390 no_results
391 NULL
392 DROP TABLE t1;
393 CREATE TABLE t1(c1 BIGINT NOT NULL);
394 SELECT SUM(c1) AS value FROM t1;
395 value
396 NULL
397 SELECT SUM(c1) AS postive_value FROM t1 WHERE c1 > 0;
398 postive_value
399 NULL
400 SELECT SUM(c1) AS negative_value FROM t1 WHERE c1 < 0;
401 negative_value
402 NULL
403 SELECT SUM(c1) AS zero_value FROM t1 WHERE c1 = 0;
404 zero_value
405 NULL
406 SELECT SUM(c1) AS no_results FROM t1 WHERE c1 = 2;
407 no_results
408 NULL
409 DROP TABLE t1;
410 CREATE TABLE t1(c1 TINYINT NOT NULL);
411 SELECT COUNT(c1) AS value FROM t1;
412 value
413 0
414 SELECT COUNT(c1) AS postive_value FROM t1 WHERE c1 > 0;
415 postive_value
416 0
417 SELECT COUNT(c1) AS negative_value FROM t1 WHERE c1 < 0;
418 negative_value
419 0
420 SELECT COUNT(c1) AS zero_value FROM t1 WHERE c1 = 0;
421 zero_value
422 0
423 SELECT COUNT(c1) AS no_results FROM t1 WHERE c1 = 2;
424 no_results
425 0
426 DROP TABLE t1;
427 CREATE TABLE t1(c1 SMALLINT NOT NULL);
428 SELECT COUNT(c1) AS value FROM t1;
429 value
430 0
431 SELECT COUNT(c1) AS postive_value FROM t1 WHERE c1 > 0;
432 postive_value
433 0
434 SELECT COUNT(c1) AS negative_value FROM t1 WHERE c1 < 0;
435 negative_value
436 0
437 SELECT COUNT(c1) AS zero_value FROM t1 WHERE c1 = 0;
438 zero_value
439 0
440 SELECT COUNT(c1) AS no_results FROM t1 WHERE c1 = 2;
441 no_results
442 0
443 DROP TABLE t1;
444 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
445 SELECT COUNT(c1) AS value FROM t1;
446 value
447 0
448 SELECT COUNT(c1) AS postive_value FROM t1 WHERE c1 > 0;
449 postive_value
450 0
451 SELECT COUNT(c1) AS negative_value FROM t1 WHERE c1 < 0;
452 negative_value
453 0
454 SELECT COUNT(c1) AS zero_value FROM t1 WHERE c1 = 0;
455 zero_value
456 0
457 SELECT COUNT(c1) AS no_results FROM t1 WHERE c1 = 2;
458 no_results
459 0
460 DROP TABLE t1;
461 CREATE TABLE t1(c1 INT NOT NULL);
462 SELECT COUNT(c1) AS value FROM t1;
463 value
464 0
465 SELECT COUNT(c1) AS postive_value FROM t1 WHERE c1 > 0;
466 postive_value
467 0
468 SELECT COUNT(c1) AS negative_value FROM t1 WHERE c1 < 0;
469 negative_value
470 0
471 SELECT COUNT(c1) AS zero_value FROM t1 WHERE c1 = 0;
472 zero_value
473 0
474 SELECT COUNT(c1) AS no_results FROM t1 WHERE c1 = 2;
475 no_results
476 0
477 DROP TABLE t1;
478 CREATE TABLE t1(c1 INTEGER NOT NULL);
479 SELECT COUNT(c1) AS value FROM t1;
480 value
481 0
482 SELECT COUNT(c1) AS postive_value FROM t1 WHERE c1 > 0;
483 postive_value
484 0
485 SELECT COUNT(c1) AS negative_value FROM t1 WHERE c1 < 0;
486 negative_value
487 0
488 SELECT COUNT(c1) AS zero_value FROM t1 WHERE c1 = 0;
489 zero_value
490 0
491 SELECT COUNT(c1) AS no_results FROM t1 WHERE c1 = 2;
492 no_results
493 0
494 DROP TABLE t1;
495 CREATE TABLE t1(c1 BIGINT NOT NULL);
496 SELECT COUNT(c1) AS value FROM t1;
497 value
498 0
499 SELECT COUNT(c1) AS postive_value FROM t1 WHERE c1 > 0;
500 postive_value
501 0
502 SELECT COUNT(c1) AS negative_value FROM t1 WHERE c1 < 0;
503 negative_value
504 0
505 SELECT COUNT(c1) AS zero_value FROM t1 WHERE c1 = 0;
506 zero_value
507 0
508 SELECT COUNT(c1) AS no_results FROM t1 WHERE c1 = 2;
509 no_results
510 0
511 DROP TABLE t1;