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);
11
SELECT COUNT(c1) AS total_rows FROM t4;
14
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
17
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
20
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
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);
31
Note 1265 Data truncated for column 'c1' at row 1
39
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
42
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
45
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
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);
58
SELECT COUNT(c1) AS total_rows FROM t4;
61
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
64
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
67
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
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);
78
Note 1265 Data truncated for column 'c1' at row 1
86
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
89
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
92
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
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);
105
SELECT COUNT(c1) AS total_rows FROM t4;
108
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
111
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
114
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
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);
125
Note 1265 Data truncated for column 'c1' at row 1
133
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
136
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
139
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
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);
152
SELECT COUNT(c1) AS total_rows FROM t4;
155
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
158
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
161
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
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);
172
Note 1265 Data truncated for column 'c1' at row 1
180
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
183
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
186
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
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);
199
SELECT COUNT(c1) AS total_rows FROM t4;
202
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
205
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
208
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
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);
225
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
228
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
231
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
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);
244
SELECT COUNT(c1) AS total_rows FROM t4;
247
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
250
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
253
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
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);
270
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
273
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
276
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
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);
289
SELECT COUNT(c1) AS total_rows FROM t4;
292
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
295
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
298
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
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);
315
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
318
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
321
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
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);
334
SELECT COUNT(c1) AS total_rows FROM t4;
337
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
340
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
343
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
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);
360
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
363
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
366
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;