Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t2;
2 CREATE TABLE t2(c1 TINYINT NOT NULL);
3 INSERT INTO t2 (c1) VALUES(0);
4 INSERT INTO t2 (c1) VALUES(1);
5 INSERT INTO t2 (c1) VALUES(16);
6 INSERT INTO t2 (c1) VALUES(-4);
7 INSERT INTO t2 (c1) VALUES(-9);
8 SELECT MAX(c1) AS value FROM t2;
9 value
10 16
11 SELECT MAX(c1) AS postive_value FROM t2 WHERE c1 > 0;
12 postive_value
13 16
14 SELECT MAX(c1) AS negative_value FROM t2 WHERE c1 < 0;
15 negative_value
16 -4
17 SELECT MAX(c1) AS zero_value FROM t2 WHERE c1 = 0;
18 zero_value
19 0
20 SELECT MAX(c1) AS no_results FROM t2 WHERE c1 = 2;
21 no_results
22 NULL
23 DROP TABLE t2;
24 CREATE TABLE t2(c1 SMALLINT NOT NULL);
25 INSERT INTO t2 (c1) VALUES(0);
26 INSERT INTO t2 (c1) VALUES(1);
27 INSERT INTO t2 (c1) VALUES(16);
28 INSERT INTO t2 (c1) VALUES(-4);
29 INSERT INTO t2 (c1) VALUES(-9);
30 SELECT MAX(c1) AS value FROM t2;
31 value
32 16
33 SELECT MAX(c1) AS postive_value FROM t2 WHERE c1 > 0;
34 postive_value
35 16
36 SELECT MAX(c1) AS negative_value FROM t2 WHERE c1 < 0;
37 negative_value
38 -4
39 SELECT MAX(c1) AS zero_value FROM t2 WHERE c1 = 0;
40 zero_value
41 0
42 SELECT MAX(c1) AS no_results FROM t2 WHERE c1 = 2;
43 no_results
44 NULL
45 DROP TABLE t2;
46 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
47 INSERT INTO t2 (c1) VALUES(0);
48 INSERT INTO t2 (c1) VALUES(1);
49 INSERT INTO t2 (c1) VALUES(16);
50 INSERT INTO t2 (c1) VALUES(-4);
51 INSERT INTO t2 (c1) VALUES(-9);
52 SELECT MAX(c1) AS value FROM t2;
53 value
54 16
55 SELECT MAX(c1) AS postive_value FROM t2 WHERE c1 > 0;
56 postive_value
57 16
58 SELECT MAX(c1) AS negative_value FROM t2 WHERE c1 < 0;
59 negative_value
60 -4
61 SELECT MAX(c1) AS zero_value FROM t2 WHERE c1 = 0;
62 zero_value
63 0
64 SELECT MAX(c1) AS no_results FROM t2 WHERE c1 = 2;
65 no_results
66 NULL
67 DROP TABLE t2;
68 CREATE TABLE t2(c1 INT NOT NULL);
69 INSERT INTO t2 (c1) VALUES(0);
70 INSERT INTO t2 (c1) VALUES(1);
71 INSERT INTO t2 (c1) VALUES(16);
72 INSERT INTO t2 (c1) VALUES(-4);
73 INSERT INTO t2 (c1) VALUES(-9);
74 SELECT MAX(c1) AS value FROM t2;
75 value
76 16
77 SELECT MAX(c1) AS postive_value FROM t2 WHERE c1 > 0;
78 postive_value
79 16
80 SELECT MAX(c1) AS negative_value FROM t2 WHERE c1 < 0;
81 negative_value
82 -4
83 SELECT MAX(c1) AS zero_value FROM t2 WHERE c1 = 0;
84 zero_value
85 0
86 SELECT MAX(c1) AS no_results FROM t2 WHERE c1 = 2;
87 no_results
88 NULL
89 DROP TABLE t2;
90 CREATE TABLE t2(c1 INTEGER NOT NULL);
91 INSERT INTO t2 (c1) VALUES(0);
92 INSERT INTO t2 (c1) VALUES(1);
93 INSERT INTO t2 (c1) VALUES(16);
94 INSERT INTO t2 (c1) VALUES(-4);
95 INSERT INTO t2 (c1) VALUES(-9);
96 SELECT MAX(c1) AS value FROM t2;
97 value
98 16
99 SELECT MAX(c1) AS postive_value FROM t2 WHERE c1 > 0;
100 postive_value
101 16
102 SELECT MAX(c1) AS negative_value FROM t2 WHERE c1 < 0;
103 negative_value
104 -4
105 SELECT MAX(c1) AS zero_value FROM t2 WHERE c1 = 0;
106 zero_value
107 0
108 SELECT MAX(c1) AS no_results FROM t2 WHERE c1 = 2;
109 no_results
110 NULL
111 DROP TABLE t2;
112 CREATE TABLE t2(c1 BIGINT NOT NULL);
113 INSERT INTO t2 (c1) VALUES(0);
114 INSERT INTO t2 (c1) VALUES(1);
115 INSERT INTO t2 (c1) VALUES(16);
116 INSERT INTO t2 (c1) VALUES(-4);
117 INSERT INTO t2 (c1) VALUES(-9);
118 SELECT MAX(c1) AS value FROM t2;
119 value
120 16
121 SELECT MAX(c1) AS postive_value FROM t2 WHERE c1 > 0;
122 postive_value
123 16
124 SELECT MAX(c1) AS negative_value FROM t2 WHERE c1 < 0;
125 negative_value
126 -4
127 SELECT MAX(c1) AS zero_value FROM t2 WHERE c1 = 0;
128 zero_value
129 0
130 SELECT MAX(c1) AS no_results FROM t2 WHERE c1 = 2;
131 no_results
132 NULL
133 DROP TABLE t2;
134 CREATE TABLE t2(c1 TINYINT NOT NULL);
135 INSERT INTO t2 (c1) VALUES(0);
136 INSERT INTO t2 (c1) VALUES(1);
137 INSERT INTO t2 (c1) VALUES(16);
138 INSERT INTO t2 (c1) VALUES(-4);
139 INSERT INTO t2 (c1) VALUES(-9);
140 SELECT MIN(c1) AS value FROM t2;
141 value
142 -9
143 SELECT MIN(c1) AS postive_value FROM t2 WHERE c1 > 0;
144 postive_value
145 1
146 SELECT MIN(c1) AS negative_value FROM t2 WHERE c1 < 0;
147 negative_value
148 -9
149 SELECT MIN(c1) AS zero_value FROM t2 WHERE c1 = 0;
150 zero_value
151 0
152 SELECT MIN(c1) AS no_results FROM t2 WHERE c1 = 2;
153 no_results
154 NULL
155 DROP TABLE t2;
156 CREATE TABLE t2(c1 SMALLINT NOT NULL);
157 INSERT INTO t2 (c1) VALUES(0);
158 INSERT INTO t2 (c1) VALUES(1);
159 INSERT INTO t2 (c1) VALUES(16);
160 INSERT INTO t2 (c1) VALUES(-4);
161 INSERT INTO t2 (c1) VALUES(-9);
162 SELECT MIN(c1) AS value FROM t2;
163 value
164 -9
165 SELECT MIN(c1) AS postive_value FROM t2 WHERE c1 > 0;
166 postive_value
167 1
168 SELECT MIN(c1) AS negative_value FROM t2 WHERE c1 < 0;
169 negative_value
170 -9
171 SELECT MIN(c1) AS zero_value FROM t2 WHERE c1 = 0;
172 zero_value
173 0
174 SELECT MIN(c1) AS no_results FROM t2 WHERE c1 = 2;
175 no_results
176 NULL
177 DROP TABLE t2;
178 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
179 INSERT INTO t2 (c1) VALUES(0);
180 INSERT INTO t2 (c1) VALUES(1);
181 INSERT INTO t2 (c1) VALUES(16);
182 INSERT INTO t2 (c1) VALUES(-4);
183 INSERT INTO t2 (c1) VALUES(-9);
184 SELECT MIN(c1) AS value FROM t2;
185 value
186 -9
187 SELECT MIN(c1) AS postive_value FROM t2 WHERE c1 > 0;
188 postive_value
189 1
190 SELECT MIN(c1) AS negative_value FROM t2 WHERE c1 < 0;
191 negative_value
192 -9
193 SELECT MIN(c1) AS zero_value FROM t2 WHERE c1 = 0;
194 zero_value
195 0
196 SELECT MIN(c1) AS no_results FROM t2 WHERE c1 = 2;
197 no_results
198 NULL
199 DROP TABLE t2;
200 CREATE TABLE t2(c1 INT NOT NULL);
201 INSERT INTO t2 (c1) VALUES(0);
202 INSERT INTO t2 (c1) VALUES(1);
203 INSERT INTO t2 (c1) VALUES(16);
204 INSERT INTO t2 (c1) VALUES(-4);
205 INSERT INTO t2 (c1) VALUES(-9);
206 SELECT MIN(c1) AS value FROM t2;
207 value
208 -9
209 SELECT MIN(c1) AS postive_value FROM t2 WHERE c1 > 0;
210 postive_value
211 1
212 SELECT MIN(c1) AS negative_value FROM t2 WHERE c1 < 0;
213 negative_value
214 -9
215 SELECT MIN(c1) AS zero_value FROM t2 WHERE c1 = 0;
216 zero_value
217 0
218 SELECT MIN(c1) AS no_results FROM t2 WHERE c1 = 2;
219 no_results
220 NULL
221 DROP TABLE t2;
222 CREATE TABLE t2(c1 INTEGER NOT NULL);
223 INSERT INTO t2 (c1) VALUES(0);
224 INSERT INTO t2 (c1) VALUES(1);
225 INSERT INTO t2 (c1) VALUES(16);
226 INSERT INTO t2 (c1) VALUES(-4);
227 INSERT INTO t2 (c1) VALUES(-9);
228 SELECT MIN(c1) AS value FROM t2;
229 value
230 -9
231 SELECT MIN(c1) AS postive_value FROM t2 WHERE c1 > 0;
232 postive_value
233 1
234 SELECT MIN(c1) AS negative_value FROM t2 WHERE c1 < 0;
235 negative_value
236 -9
237 SELECT MIN(c1) AS zero_value FROM t2 WHERE c1 = 0;
238 zero_value
239 0
240 SELECT MIN(c1) AS no_results FROM t2 WHERE c1 = 2;
241 no_results
242 NULL
243 DROP TABLE t2;
244 CREATE TABLE t2(c1 BIGINT NOT NULL);
245 INSERT INTO t2 (c1) VALUES(0);
246 INSERT INTO t2 (c1) VALUES(1);
247 INSERT INTO t2 (c1) VALUES(16);
248 INSERT INTO t2 (c1) VALUES(-4);
249 INSERT INTO t2 (c1) VALUES(-9);
250 SELECT MIN(c1) AS value FROM t2;
251 value
252 -9
253 SELECT MIN(c1) AS postive_value FROM t2 WHERE c1 > 0;
254 postive_value
255 1
256 SELECT MIN(c1) AS negative_value FROM t2 WHERE c1 < 0;
257 negative_value
258 -9
259 SELECT MIN(c1) AS zero_value FROM t2 WHERE c1 = 0;
260 zero_value
261 0
262 SELECT MIN(c1) AS no_results FROM t2 WHERE c1 = 2;
263 no_results
264 NULL
265 DROP TABLE t2;
266 CREATE TABLE t2(c1 TINYINT NOT NULL);
267 INSERT INTO t2 (c1) VALUES(0);
268 INSERT INTO t2 (c1) VALUES(1);
269 INSERT INTO t2 (c1) VALUES(16);
270 INSERT INTO t2 (c1) VALUES(-4);
271 INSERT INTO t2 (c1) VALUES(-9);
272 SELECT AVG(c1) AS value FROM t2;
273 value
274 0.8000
275 SELECT AVG(c1) AS postive_value FROM t2 WHERE c1 > 0;
276 postive_value
277 8.5000
278 SELECT AVG(c1) AS negative_value FROM t2 WHERE c1 < 0;
279 negative_value
280 -6.5000
281 SELECT AVG(c1) AS zero_value FROM t2 WHERE c1 = 0;
282 zero_value
283 0.0000
284 SELECT AVG(c1) AS no_results FROM t2 WHERE c1 = 2;
285 no_results
286 NULL
287 DROP TABLE t2;
288 CREATE TABLE t2(c1 SMALLINT NOT NULL);
289 INSERT INTO t2 (c1) VALUES(0);
290 INSERT INTO t2 (c1) VALUES(1);
291 INSERT INTO t2 (c1) VALUES(16);
292 INSERT INTO t2 (c1) VALUES(-4);
293 INSERT INTO t2 (c1) VALUES(-9);
294 SELECT AVG(c1) AS value FROM t2;
295 value
296 0.8000
297 SELECT AVG(c1) AS postive_value FROM t2 WHERE c1 > 0;
298 postive_value
299 8.5000
300 SELECT AVG(c1) AS negative_value FROM t2 WHERE c1 < 0;
301 negative_value
302 -6.5000
303 SELECT AVG(c1) AS zero_value FROM t2 WHERE c1 = 0;
304 zero_value
305 0.0000
306 SELECT AVG(c1) AS no_results FROM t2 WHERE c1 = 2;
307 no_results
308 NULL
309 DROP TABLE t2;
310 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
311 INSERT INTO t2 (c1) VALUES(0);
312 INSERT INTO t2 (c1) VALUES(1);
313 INSERT INTO t2 (c1) VALUES(16);
314 INSERT INTO t2 (c1) VALUES(-4);
315 INSERT INTO t2 (c1) VALUES(-9);
316 SELECT AVG(c1) AS value FROM t2;
317 value
318 0.8000
319 SELECT AVG(c1) AS postive_value FROM t2 WHERE c1 > 0;
320 postive_value
321 8.5000
322 SELECT AVG(c1) AS negative_value FROM t2 WHERE c1 < 0;
323 negative_value
324 -6.5000
325 SELECT AVG(c1) AS zero_value FROM t2 WHERE c1 = 0;
326 zero_value
327 0.0000
328 SELECT AVG(c1) AS no_results FROM t2 WHERE c1 = 2;
329 no_results
330 NULL
331 DROP TABLE t2;
332 CREATE TABLE t2(c1 INT NOT NULL);
333 INSERT INTO t2 (c1) VALUES(0);
334 INSERT INTO t2 (c1) VALUES(1);
335 INSERT INTO t2 (c1) VALUES(16);
336 INSERT INTO t2 (c1) VALUES(-4);
337 INSERT INTO t2 (c1) VALUES(-9);
338 SELECT AVG(c1) AS value FROM t2;
339 value
340 0.8000
341 SELECT AVG(c1) AS postive_value FROM t2 WHERE c1 > 0;
342 postive_value
343 8.5000
344 SELECT AVG(c1) AS negative_value FROM t2 WHERE c1 < 0;
345 negative_value
346 -6.5000
347 SELECT AVG(c1) AS zero_value FROM t2 WHERE c1 = 0;
348 zero_value
349 0.0000
350 SELECT AVG(c1) AS no_results FROM t2 WHERE c1 = 2;
351 no_results
352 NULL
353 DROP TABLE t2;
354 CREATE TABLE t2(c1 INTEGER NOT NULL);
355 INSERT INTO t2 (c1) VALUES(0);
356 INSERT INTO t2 (c1) VALUES(1);
357 INSERT INTO t2 (c1) VALUES(16);
358 INSERT INTO t2 (c1) VALUES(-4);
359 INSERT INTO t2 (c1) VALUES(-9);
360 SELECT AVG(c1) AS value FROM t2;
361 value
362 0.8000
363 SELECT AVG(c1) AS postive_value FROM t2 WHERE c1 > 0;
364 postive_value
365 8.5000
366 SELECT AVG(c1) AS negative_value FROM t2 WHERE c1 < 0;
367 negative_value
368 -6.5000
369 SELECT AVG(c1) AS zero_value FROM t2 WHERE c1 = 0;
370 zero_value
371 0.0000
372 SELECT AVG(c1) AS no_results FROM t2 WHERE c1 = 2;
373 no_results
374 NULL
375 DROP TABLE t2;
376 CREATE TABLE t2(c1 BIGINT NOT NULL);
377 INSERT INTO t2 (c1) VALUES(0);
378 INSERT INTO t2 (c1) VALUES(1);
379 INSERT INTO t2 (c1) VALUES(16);
380 INSERT INTO t2 (c1) VALUES(-4);
381 INSERT INTO t2 (c1) VALUES(-9);
382 SELECT AVG(c1) AS value FROM t2;
383 value
384 0.8000
385 SELECT AVG(c1) AS postive_value FROM t2 WHERE c1 > 0;
386 postive_value
387 8.5000
388 SELECT AVG(c1) AS negative_value FROM t2 WHERE c1 < 0;
389 negative_value
390 -6.5000
391 SELECT AVG(c1) AS zero_value FROM t2 WHERE c1 = 0;
392 zero_value
393 0.0000
394 SELECT AVG(c1) AS no_results FROM t2 WHERE c1 = 2;
395 no_results
396 NULL
397 DROP TABLE t2;
398 CREATE TABLE t2(c1 TINYINT NOT NULL);
399 INSERT INTO t2 (c1) VALUES(0);
400 INSERT INTO t2 (c1) VALUES(1);
401 INSERT INTO t2 (c1) VALUES(16);
402 INSERT INTO t2 (c1) VALUES(-4);
403 INSERT INTO t2 (c1) VALUES(-9);
404 SELECT SUM(c1) AS value FROM t2;
405 value
406 4
407 SELECT SUM(c1) AS postive_value FROM t2 WHERE c1 > 0;
408 postive_value
409 17
410 SELECT SUM(c1) AS negative_value FROM t2 WHERE c1 < 0;
411 negative_value
412 -13
413 SELECT SUM(c1) AS zero_value FROM t2 WHERE c1 = 0;
414 zero_value
415 0
416 SELECT SUM(c1) AS no_results FROM t2 WHERE c1 = 2;
417 no_results
418 NULL
419 DROP TABLE t2;
420 CREATE TABLE t2(c1 SMALLINT NOT NULL);
421 INSERT INTO t2 (c1) VALUES(0);
422 INSERT INTO t2 (c1) VALUES(1);
423 INSERT INTO t2 (c1) VALUES(16);
424 INSERT INTO t2 (c1) VALUES(-4);
425 INSERT INTO t2 (c1) VALUES(-9);
426 SELECT SUM(c1) AS value FROM t2;
427 value
428 4
429 SELECT SUM(c1) AS postive_value FROM t2 WHERE c1 > 0;
430 postive_value
431 17
432 SELECT SUM(c1) AS negative_value FROM t2 WHERE c1 < 0;
433 negative_value
434 -13
435 SELECT SUM(c1) AS zero_value FROM t2 WHERE c1 = 0;
436 zero_value
437 0
438 SELECT SUM(c1) AS no_results FROM t2 WHERE c1 = 2;
439 no_results
440 NULL
441 DROP TABLE t2;
442 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
443 INSERT INTO t2 (c1) VALUES(0);
444 INSERT INTO t2 (c1) VALUES(1);
445 INSERT INTO t2 (c1) VALUES(16);
446 INSERT INTO t2 (c1) VALUES(-4);
447 INSERT INTO t2 (c1) VALUES(-9);
448 SELECT SUM(c1) AS value FROM t2;
449 value
450 4
451 SELECT SUM(c1) AS postive_value FROM t2 WHERE c1 > 0;
452 postive_value
453 17
454 SELECT SUM(c1) AS negative_value FROM t2 WHERE c1 < 0;
455 negative_value
456 -13
457 SELECT SUM(c1) AS zero_value FROM t2 WHERE c1 = 0;
458 zero_value
459 0
460 SELECT SUM(c1) AS no_results FROM t2 WHERE c1 = 2;
461 no_results
462 NULL
463 DROP TABLE t2;
464 CREATE TABLE t2(c1 INT NOT NULL);
465 INSERT INTO t2 (c1) VALUES(0);
466 INSERT INTO t2 (c1) VALUES(1);
467 INSERT INTO t2 (c1) VALUES(16);
468 INSERT INTO t2 (c1) VALUES(-4);
469 INSERT INTO t2 (c1) VALUES(-9);
470 SELECT SUM(c1) AS value FROM t2;
471 value
472 4
473 SELECT SUM(c1) AS postive_value FROM t2 WHERE c1 > 0;
474 postive_value
475 17
476 SELECT SUM(c1) AS negative_value FROM t2 WHERE c1 < 0;
477 negative_value
478 -13
479 SELECT SUM(c1) AS zero_value FROM t2 WHERE c1 = 0;
480 zero_value
481 0
482 SELECT SUM(c1) AS no_results FROM t2 WHERE c1 = 2;
483 no_results
484 NULL
485 DROP TABLE t2;
486 CREATE TABLE t2(c1 INTEGER NOT NULL);
487 INSERT INTO t2 (c1) VALUES(0);
488 INSERT INTO t2 (c1) VALUES(1);
489 INSERT INTO t2 (c1) VALUES(16);
490 INSERT INTO t2 (c1) VALUES(-4);
491 INSERT INTO t2 (c1) VALUES(-9);
492 SELECT SUM(c1) AS value FROM t2;
493 value
494 4
495 SELECT SUM(c1) AS postive_value FROM t2 WHERE c1 > 0;
496 postive_value
497 17
498 SELECT SUM(c1) AS negative_value FROM t2 WHERE c1 < 0;
499 negative_value
500 -13
501 SELECT SUM(c1) AS zero_value FROM t2 WHERE c1 = 0;
502 zero_value
503 0
504 SELECT SUM(c1) AS no_results FROM t2 WHERE c1 = 2;
505 no_results
506 NULL
507 DROP TABLE t2;
508 CREATE TABLE t2(c1 BIGINT NOT NULL);
509 INSERT INTO t2 (c1) VALUES(0);
510 INSERT INTO t2 (c1) VALUES(1);
511 INSERT INTO t2 (c1) VALUES(16);
512 INSERT INTO t2 (c1) VALUES(-4);
513 INSERT INTO t2 (c1) VALUES(-9);
514 SELECT SUM(c1) AS value FROM t2;
515 value
516 4
517 SELECT SUM(c1) AS postive_value FROM t2 WHERE c1 > 0;
518 postive_value
519 17
520 SELECT SUM(c1) AS negative_value FROM t2 WHERE c1 < 0;
521 negative_value
522 -13
523 SELECT SUM(c1) AS zero_value FROM t2 WHERE c1 = 0;
524 zero_value
525 0
526 SELECT SUM(c1) AS no_results FROM t2 WHERE c1 = 2;
527 no_results
528 NULL
529 DROP TABLE t2;
530 CREATE TABLE t2(c1 TINYINT NOT NULL);
531 INSERT INTO t2 (c1) VALUES(0);
532 INSERT INTO t2 (c1) VALUES(1);
533 INSERT INTO t2 (c1) VALUES(16);
534 INSERT INTO t2 (c1) VALUES(-4);
535 INSERT INTO t2 (c1) VALUES(-9);
536 SELECT COUNT(c1) AS value FROM t2;
537 value
538 5
539 SELECT COUNT(c1) AS postive_value FROM t2 WHERE c1 > 0;
540 postive_value
541 2
542 SELECT COUNT(c1) AS negative_value FROM t2 WHERE c1 < 0;
543 negative_value
544 2
545 SELECT COUNT(c1) AS zero_value FROM t2 WHERE c1 = 0;
546 zero_value
547 1
548 SELECT COUNT(c1) AS no_results FROM t2 WHERE c1 = 2;
549 no_results
550 0
551 DROP TABLE t2;
552 CREATE TABLE t2(c1 SMALLINT NOT NULL);
553 INSERT INTO t2 (c1) VALUES(0);
554 INSERT INTO t2 (c1) VALUES(1);
555 INSERT INTO t2 (c1) VALUES(16);
556 INSERT INTO t2 (c1) VALUES(-4);
557 INSERT INTO t2 (c1) VALUES(-9);
558 SELECT COUNT(c1) AS value FROM t2;
559 value
560 5
561 SELECT COUNT(c1) AS postive_value FROM t2 WHERE c1 > 0;
562 postive_value
563 2
564 SELECT COUNT(c1) AS negative_value FROM t2 WHERE c1 < 0;
565 negative_value
566 2
567 SELECT COUNT(c1) AS zero_value FROM t2 WHERE c1 = 0;
568 zero_value
569 1
570 SELECT COUNT(c1) AS no_results FROM t2 WHERE c1 = 2;
571 no_results
572 0
573 DROP TABLE t2;
574 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
575 INSERT INTO t2 (c1) VALUES(0);
576 INSERT INTO t2 (c1) VALUES(1);
577 INSERT INTO t2 (c1) VALUES(16);
578 INSERT INTO t2 (c1) VALUES(-4);
579 INSERT INTO t2 (c1) VALUES(-9);
580 SELECT COUNT(c1) AS value FROM t2;
581 value
582 5
583 SELECT COUNT(c1) AS postive_value FROM t2 WHERE c1 > 0;
584 postive_value
585 2
586 SELECT COUNT(c1) AS negative_value FROM t2 WHERE c1 < 0;
587 negative_value
588 2
589 SELECT COUNT(c1) AS zero_value FROM t2 WHERE c1 = 0;
590 zero_value
591 1
592 SELECT COUNT(c1) AS no_results FROM t2 WHERE c1 = 2;
593 no_results
594 0
595 DROP TABLE t2;
596 CREATE TABLE t2(c1 INT NOT NULL);
597 INSERT INTO t2 (c1) VALUES(0);
598 INSERT INTO t2 (c1) VALUES(1);
599 INSERT INTO t2 (c1) VALUES(16);
600 INSERT INTO t2 (c1) VALUES(-4);
601 INSERT INTO t2 (c1) VALUES(-9);
602 SELECT COUNT(c1) AS value FROM t2;
603 value
604 5
605 SELECT COUNT(c1) AS postive_value FROM t2 WHERE c1 > 0;
606 postive_value
607 2
608 SELECT COUNT(c1) AS negative_value FROM t2 WHERE c1 < 0;
609 negative_value
610 2
611 SELECT COUNT(c1) AS zero_value FROM t2 WHERE c1 = 0;
612 zero_value
613 1
614 SELECT COUNT(c1) AS no_results FROM t2 WHERE c1 = 2;
615 no_results
616 0
617 DROP TABLE t2;
618 CREATE TABLE t2(c1 INTEGER NOT NULL);
619 INSERT INTO t2 (c1) VALUES(0);
620 INSERT INTO t2 (c1) VALUES(1);
621 INSERT INTO t2 (c1) VALUES(16);
622 INSERT INTO t2 (c1) VALUES(-4);
623 INSERT INTO t2 (c1) VALUES(-9);
624 SELECT COUNT(c1) AS value FROM t2;
625 value
626 5
627 SELECT COUNT(c1) AS postive_value FROM t2 WHERE c1 > 0;
628 postive_value
629 2
630 SELECT COUNT(c1) AS negative_value FROM t2 WHERE c1 < 0;
631 negative_value
632 2
633 SELECT COUNT(c1) AS zero_value FROM t2 WHERE c1 = 0;
634 zero_value
635 1
636 SELECT COUNT(c1) AS no_results FROM t2 WHERE c1 = 2;
637 no_results
638 0
639 DROP TABLE t2;
640 CREATE TABLE t2(c1 BIGINT NOT NULL);
641 INSERT INTO t2 (c1) VALUES(0);
642 INSERT INTO t2 (c1) VALUES(1);
643 INSERT INTO t2 (c1) VALUES(16);
644 INSERT INTO t2 (c1) VALUES(-4);
645 INSERT INTO t2 (c1) VALUES(-9);
646 SELECT COUNT(c1) AS value FROM t2;
647 value
648 5
649 SELECT COUNT(c1) AS postive_value FROM t2 WHERE c1 > 0;
650 postive_value
651 2
652 SELECT COUNT(c1) AS negative_value FROM t2 WHERE c1 < 0;
653 negative_value
654 2
655 SELECT COUNT(c1) AS zero_value FROM t2 WHERE c1 = 0;
656 zero_value
657 1
658 SELECT COUNT(c1) AS no_results FROM t2 WHERE c1 = 2;
659 no_results
660 0
661 DROP TABLE t2;