Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t6;
2 CREATE TABLE t6(c1 TINYINT UNSIGNED NULL);
3 INSERT INTO t6 (c1) VALUES(NULL);
4 INSERT INTO t6 (c1) VALUES(0);
5 INSERT INTO t6 (c1) VALUES(255);
6 SELECT * FROM t6;
7 c1
8 NULL
9 0
10 255
11 SELECT COUNT(c1) AS total_rows FROM t6;
12 total_rows
13 2
14 SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
15 positive_rows
16 1
17 SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
18 null_rows
19 0
20 SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
21 not_null_rows
22 2
23 DROP TABLE t6;
24 CREATE TABLE t6(c1 SMALLINT UNSIGNED NULL);
25 INSERT INTO t6 (c1) VALUES(NULL);
26 INSERT INTO t6 (c1) VALUES(0);
27 INSERT INTO t6 (c1) VALUES(255);
28 SELECT * FROM t6;
29 c1
30 NULL
31 0
32 255
33 SELECT COUNT(c1) AS total_rows FROM t6;
34 total_rows
35 2
36 SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
37 positive_rows
38 1
39 SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
40 null_rows
41 0
42 SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
43 not_null_rows
44 2
45 DROP TABLE t6;
46 CREATE TABLE t6(c1 MEDIUMINT UNSIGNED NULL);
47 INSERT INTO t6 (c1) VALUES(NULL);
48 INSERT INTO t6 (c1) VALUES(0);
49 INSERT INTO t6 (c1) VALUES(255);
50 SELECT * FROM t6;
51 c1
52 NULL
53 0
54 255
55 SELECT COUNT(c1) AS total_rows FROM t6;
56 total_rows
57 2
58 SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
59 positive_rows
60 1
61 SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
62 null_rows
63 0
64 SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
65 not_null_rows
66 2
67 DROP TABLE t6;
68 CREATE TABLE t6(c1 INT UNSIGNED NULL);
69 INSERT INTO t6 (c1) VALUES(NULL);
70 INSERT INTO t6 (c1) VALUES(0);
71 INSERT INTO t6 (c1) VALUES(255);
72 SELECT * FROM t6;
73 c1
74 NULL
75 0
76 255
77 SELECT COUNT(c1) AS total_rows FROM t6;
78 total_rows
79 2
80 SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
81 positive_rows
82 1
83 SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
84 null_rows
85 0
86 SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
87 not_null_rows
88 2
89 DROP TABLE t6;
90 CREATE TABLE t6(c1 INTEGER UNSIGNED NULL);
91 INSERT INTO t6 (c1) VALUES(NULL);
92 INSERT INTO t6 (c1) VALUES(0);
93 INSERT INTO t6 (c1) VALUES(255);
94 SELECT * FROM t6;
95 c1
96 NULL
97 0
98 255
99 SELECT COUNT(c1) AS total_rows FROM t6;
100 total_rows
101 2
102 SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
103 positive_rows
104 1
105 SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
106 null_rows
107 0
108 SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
109 not_null_rows
110 2
111 DROP TABLE t6;
112 CREATE TABLE t6(c1 BIGINT UNSIGNED NULL);
113 INSERT INTO t6 (c1) VALUES(NULL);
114 INSERT INTO t6 (c1) VALUES(0);
115 INSERT INTO t6 (c1) VALUES(255);
116 SELECT * FROM t6;
117 c1
118 NULL
119 0
120 255
121 SELECT COUNT(c1) AS total_rows FROM t6;
122 total_rows
123 2
124 SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
125 positive_rows
126 1
127 SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
128 null_rows
129 0
130 SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
131 not_null_rows
132 2
133 DROP TABLE t6;