Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t4,t5;
2 CREATE TABLE t4(c1 DECIMAL(1,0) NOT NULL);
3 INSERT INTO t4 (c1) VALUES(0);
4 INSERT INTO t4 (c1) VALUES(1.0);
5 INSERT INTO t4 (c1) VALUES(-9.0);
6 SELECT * FROM t4;
7 c1
8 0
9 1
10 -9
11 SELECT COUNT(c1) AS total_rows FROM t4;
12 total_rows
13 3
14 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
15 positive_rows
16 1
17 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
18 negative_rows
19 1
20 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
21 zero_rows
22 1
23 DROP TABLE t4;
24 CREATE TABLE t5(c1 DECIMAL(5,4) NOT NULL);
25 INSERT INTO t5 (c1) VALUES(0);
26 INSERT INTO t5 (c1) VALUES(1.0);
27 INSERT INTO t5 (c1) VALUES(1.2345);
28 INSERT INTO t5 (c1) VALUES(-9.0);
29 INSERT INTO t5 (c1) VALUES(-9.12345);
30 Warnings:
31 Note 1265 Data truncated for column 'c1' at row 1
32 SELECT * FROM t5;
33 c1
34 0.0000
35 1.0000
36 1.2345
37 -9.0000
38 -9.1235
39 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
40 positive_rows
41 2
42 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
43 negative_rows
44 2
45 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
46 zero_rows
47 1
48 DROP TABLE t5;
49 CREATE TABLE t4(c1 DEC(1,0) NOT NULL);
50 INSERT INTO t4 (c1) VALUES(0);
51 INSERT INTO t4 (c1) VALUES(1.0);
52 INSERT INTO t4 (c1) VALUES(-9.0);
53 SELECT * FROM t4;
54 c1
55 0
56 1
57 -9
58 SELECT COUNT(c1) AS total_rows FROM t4;
59 total_rows
60 3
61 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
62 positive_rows
63 1
64 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
65 negative_rows
66 1
67 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
68 zero_rows
69 1
70 DROP TABLE t4;
71 CREATE TABLE t5(c1 DEC(5,4) NOT NULL);
72 INSERT INTO t5 (c1) VALUES(0);
73 INSERT INTO t5 (c1) VALUES(1.0);
74 INSERT INTO t5 (c1) VALUES(1.2345);
75 INSERT INTO t5 (c1) VALUES(-9.0);
76 INSERT INTO t5 (c1) VALUES(-9.12345);
77 Warnings:
78 Note 1265 Data truncated for column 'c1' at row 1
79 SELECT * FROM t5;
80 c1
81 0.0000
82 1.0000
83 1.2345
84 -9.0000
85 -9.1235
86 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
87 positive_rows
88 2
89 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
90 negative_rows
91 2
92 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
93 zero_rows
94 1
95 DROP TABLE t5;
96 CREATE TABLE t4(c1 FIXED(1,0) NOT NULL);
97 INSERT INTO t4 (c1) VALUES(0);
98 INSERT INTO t4 (c1) VALUES(1.0);
99 INSERT INTO t4 (c1) VALUES(-9.0);
100 SELECT * FROM t4;
101 c1
102 0
103 1
104 -9
105 SELECT COUNT(c1) AS total_rows FROM t4;
106 total_rows
107 3
108 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
109 positive_rows
110 1
111 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
112 negative_rows
113 1
114 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
115 zero_rows
116 1
117 DROP TABLE t4;
118 CREATE TABLE t5(c1 FIXED(5,4) NOT NULL);
119 INSERT INTO t5 (c1) VALUES(0);
120 INSERT INTO t5 (c1) VALUES(1.0);
121 INSERT INTO t5 (c1) VALUES(1.2345);
122 INSERT INTO t5 (c1) VALUES(-9.0);
123 INSERT INTO t5 (c1) VALUES(-9.12345);
124 Warnings:
125 Note 1265 Data truncated for column 'c1' at row 1
126 SELECT * FROM t5;
127 c1
128 0.0000
129 1.0000
130 1.2345
131 -9.0000
132 -9.1235
133 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
134 positive_rows
135 2
136 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
137 negative_rows
138 2
139 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
140 zero_rows
141 1
142 DROP TABLE t5;
143 CREATE TABLE t4(c1 NUMERIC(1,0) NOT NULL);
144 INSERT INTO t4 (c1) VALUES(0);
145 INSERT INTO t4 (c1) VALUES(1.0);
146 INSERT INTO t4 (c1) VALUES(-9.0);
147 SELECT * FROM t4;
148 c1
149 0
150 1
151 -9
152 SELECT COUNT(c1) AS total_rows FROM t4;
153 total_rows
154 3
155 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
156 positive_rows
157 1
158 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
159 negative_rows
160 1
161 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
162 zero_rows
163 1
164 DROP TABLE t4;
165 CREATE TABLE t5(c1 NUMERIC(5,4) NOT NULL);
166 INSERT INTO t5 (c1) VALUES(0);
167 INSERT INTO t5 (c1) VALUES(1.0);
168 INSERT INTO t5 (c1) VALUES(1.2345);
169 INSERT INTO t5 (c1) VALUES(-9.0);
170 INSERT INTO t5 (c1) VALUES(-9.12345);
171 Warnings:
172 Note 1265 Data truncated for column 'c1' at row 1
173 SELECT * FROM t5;
174 c1
175 0.0000
176 1.0000
177 1.2345
178 -9.0000
179 -9.1235
180 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
181 positive_rows
182 2
183 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
184 negative_rows
185 2
186 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
187 zero_rows
188 1
189 DROP TABLE t5;
190 CREATE TABLE t4(c1 DOUBLE(1,0) NOT NULL);
191 INSERT INTO t4 (c1) VALUES(0);
192 INSERT INTO t4 (c1) VALUES(1.0);
193 INSERT INTO t4 (c1) VALUES(-9.0);
194 SELECT * FROM t4;
195 c1
196 0
197 1
198 -9
199 SELECT COUNT(c1) AS total_rows FROM t4;
200 total_rows
201 3
202 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
203 positive_rows
204 1
205 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
206 negative_rows
207 1
208 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
209 zero_rows
210 1
211 DROP TABLE t4;
212 CREATE TABLE t5(c1 DOUBLE(5,4) NOT NULL);
213 INSERT INTO t5 (c1) VALUES(0);
214 INSERT INTO t5 (c1) VALUES(1.0);
215 INSERT INTO t5 (c1) VALUES(1.2345);
216 INSERT INTO t5 (c1) VALUES(-9.0);
217 INSERT INTO t5 (c1) VALUES(-9.12345);
218 SELECT * FROM t5;
219 c1
220 0.0000
221 1.0000
222 1.2345
223 -9.0000
224 -9.1234
225 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
226 positive_rows
227 2
228 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
229 negative_rows
230 2
231 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
232 zero_rows
233 1
234 DROP TABLE t5;
235 CREATE TABLE t4(c1 REAL(1,0) NOT NULL);
236 INSERT INTO t4 (c1) VALUES(0);
237 INSERT INTO t4 (c1) VALUES(1.0);
238 INSERT INTO t4 (c1) VALUES(-9.0);
239 SELECT * FROM t4;
240 c1
241 0
242 1
243 -9
244 SELECT COUNT(c1) AS total_rows FROM t4;
245 total_rows
246 3
247 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
248 positive_rows
249 1
250 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
251 negative_rows
252 1
253 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
254 zero_rows
255 1
256 DROP TABLE t4;
257 CREATE TABLE t5(c1 REAL(5,4) NOT NULL);
258 INSERT INTO t5 (c1) VALUES(0);
259 INSERT INTO t5 (c1) VALUES(1.0);
260 INSERT INTO t5 (c1) VALUES(1.2345);
261 INSERT INTO t5 (c1) VALUES(-9.0);
262 INSERT INTO t5 (c1) VALUES(-9.12345);
263 SELECT * FROM t5;
264 c1
265 0.0000
266 1.0000
267 1.2345
268 -9.0000
269 -9.1234
270 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
271 positive_rows
272 2
273 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
274 negative_rows
275 2
276 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
277 zero_rows
278 1
279 DROP TABLE t5;
280 CREATE TABLE t4(c1 DOUBLE PRECISION(1,0) NOT NULL);
281 INSERT INTO t4 (c1) VALUES(0);
282 INSERT INTO t4 (c1) VALUES(1.0);
283 INSERT INTO t4 (c1) VALUES(-9.0);
284 SELECT * FROM t4;
285 c1
286 0
287 1
288 -9
289 SELECT COUNT(c1) AS total_rows FROM t4;
290 total_rows
291 3
292 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
293 positive_rows
294 1
295 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
296 negative_rows
297 1
298 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
299 zero_rows
300 1
301 DROP TABLE t4;
302 CREATE TABLE t5(c1 DOUBLE PRECISION(5,4) NOT NULL);
303 INSERT INTO t5 (c1) VALUES(0);
304 INSERT INTO t5 (c1) VALUES(1.0);
305 INSERT INTO t5 (c1) VALUES(1.2345);
306 INSERT INTO t5 (c1) VALUES(-9.0);
307 INSERT INTO t5 (c1) VALUES(-9.12345);
308 SELECT * FROM t5;
309 c1
310 0.0000
311 1.0000
312 1.2345
313 -9.0000
314 -9.1234
315 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
316 positive_rows
317 2
318 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
319 negative_rows
320 2
321 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
322 zero_rows
323 1
324 DROP TABLE t5;
325 CREATE TABLE t4(c1 FLOAT(1,0) NOT NULL);
326 INSERT INTO t4 (c1) VALUES(0);
327 INSERT INTO t4 (c1) VALUES(1.0);
328 INSERT INTO t4 (c1) VALUES(-9.0);
329 SELECT * FROM t4;
330 c1
331 0
332 1
333 -9
334 SELECT COUNT(c1) AS total_rows FROM t4;
335 total_rows
336 3
337 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
338 positive_rows
339 1
340 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
341 negative_rows
342 1
343 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
344 zero_rows
345 1
346 DROP TABLE t4;
347 CREATE TABLE t5(c1 FLOAT(5,4) NOT NULL);
348 INSERT INTO t5 (c1) VALUES(0);
349 INSERT INTO t5 (c1) VALUES(1.0);
350 INSERT INTO t5 (c1) VALUES(1.2345);
351 INSERT INTO t5 (c1) VALUES(-9.0);
352 INSERT INTO t5 (c1) VALUES(-9.12345);
353 SELECT * FROM t5;
354 c1
355 0.0000
356 1.0000
357 1.2345
358 -9.0000
359 -9.1234
360 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
361 positive_rows
362 2
363 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
364 negative_rows
365 2
366 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
367 zero_rows
368 1
369 DROP TABLE t5;