1--disable_warnings
2DROP TABLE IF EXISTS t4,t5;
3--enable_warnings
4CREATE TABLE t4(c1 DECIMAL(1,0) NOT NULL);
5INSERT INTO t4 (c1) VALUES(0);
6INSERT INTO t4 (c1) VALUES(1.0);
7INSERT INTO t4 (c1) VALUES(-9.0);
8SELECT * FROM t4;
9SELECT COUNT(c1) AS total_rows FROM t4;
10SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
11SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
12SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
13DROP TABLE t4;
14CREATE TABLE t5(c1 DECIMAL(5,4) NOT NULL);
15INSERT INTO t5 (c1) VALUES(0);
16INSERT INTO t5 (c1) VALUES(1.0);
17INSERT INTO t5 (c1) VALUES(1.2345);
18INSERT INTO t5 (c1) VALUES(-9.0);
19INSERT INTO t5 (c1) VALUES(-9.12345);
20SELECT * FROM t5;
21SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
22SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
23SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
24DROP TABLE t5;
25CREATE TABLE t4(c1 DEC(1,0) NOT NULL);
26INSERT INTO t4 (c1) VALUES(0);
27INSERT INTO t4 (c1) VALUES(1.0);
28INSERT INTO t4 (c1) VALUES(-9.0);
29SELECT * FROM t4;
30SELECT COUNT(c1) AS total_rows FROM t4;
31SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
32SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
33SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
34DROP TABLE t4;
35CREATE TABLE t5(c1 DEC(5,4) NOT NULL);
36INSERT INTO t5 (c1) VALUES(0);
37INSERT INTO t5 (c1) VALUES(1.0);
38INSERT INTO t5 (c1) VALUES(1.2345);
39INSERT INTO t5 (c1) VALUES(-9.0);
40INSERT INTO t5 (c1) VALUES(-9.12345);
41SELECT * FROM t5;
42SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
43SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
44SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
45DROP TABLE t5;
46CREATE TABLE t4(c1 FIXED(1,0) NOT NULL);
47INSERT INTO t4 (c1) VALUES(0);
48INSERT INTO t4 (c1) VALUES(1.0);
49INSERT INTO t4 (c1) VALUES(-9.0);
50SELECT * FROM t4;
51SELECT COUNT(c1) AS total_rows FROM t4;
52SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
53SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
54SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
55DROP TABLE t4;
56CREATE TABLE t5(c1 FIXED(5,4) NOT NULL);
57INSERT INTO t5 (c1) VALUES(0);
58INSERT INTO t5 (c1) VALUES(1.0);
59INSERT INTO t5 (c1) VALUES(1.2345);
60INSERT INTO t5 (c1) VALUES(-9.0);
61INSERT INTO t5 (c1) VALUES(-9.12345);
62SELECT * FROM t5;
63SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
64SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
65SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
66DROP TABLE t5;
67CREATE TABLE t4(c1 NUMERIC(1,0) NOT NULL);
68INSERT INTO t4 (c1) VALUES(0);
69INSERT INTO t4 (c1) VALUES(1.0);
70INSERT INTO t4 (c1) VALUES(-9.0);
71SELECT * FROM t4;
72SELECT COUNT(c1) AS total_rows FROM t4;
73SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
74SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
75SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
76DROP TABLE t4;
77CREATE TABLE t5(c1 NUMERIC(5,4) NOT NULL);
78INSERT INTO t5 (c1) VALUES(0);
79INSERT INTO t5 (c1) VALUES(1.0);
80INSERT INTO t5 (c1) VALUES(1.2345);
81INSERT INTO t5 (c1) VALUES(-9.0);
82INSERT INTO t5 (c1) VALUES(-9.12345);
83SELECT * FROM t5;
84SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
85SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
86SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
87DROP TABLE t5;
88CREATE TABLE t4(c1 DOUBLE(1,0) NOT NULL);
89INSERT INTO t4 (c1) VALUES(0);
90INSERT INTO t4 (c1) VALUES(1.0);
91INSERT INTO t4 (c1) VALUES(-9.0);
92SELECT * FROM t4;
93SELECT COUNT(c1) AS total_rows FROM t4;
94SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
95SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
96SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
97DROP TABLE t4;
98CREATE TABLE t5(c1 DOUBLE(5,4) NOT NULL);
99INSERT INTO t5 (c1) VALUES(0);
100INSERT INTO t5 (c1) VALUES(1.0);
101INSERT INTO t5 (c1) VALUES(1.2345);
102INSERT INTO t5 (c1) VALUES(-9.0);
103INSERT INTO t5 (c1) VALUES(-9.12345);
104SELECT * FROM t5;
105SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
106SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
107SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
108DROP TABLE t5;
109CREATE TABLE t4(c1 REAL(1,0) NOT NULL);
110INSERT INTO t4 (c1) VALUES(0);
111INSERT INTO t4 (c1) VALUES(1.0);
112INSERT INTO t4 (c1) VALUES(-9.0);
113SELECT * FROM t4;
114SELECT COUNT(c1) AS total_rows FROM t4;
115SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
116SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
117SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
118DROP TABLE t4;
119CREATE TABLE t5(c1 REAL(5,4) NOT NULL);
120INSERT INTO t5 (c1) VALUES(0);
121INSERT INTO t5 (c1) VALUES(1.0);
122INSERT INTO t5 (c1) VALUES(1.2345);
123INSERT INTO t5 (c1) VALUES(-9.0);
124INSERT INTO t5 (c1) VALUES(-9.12345);
125SELECT * FROM t5;
126SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
127SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
128SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
129DROP TABLE t5;
130CREATE TABLE t4(c1 DOUBLE PRECISION(1,0) NOT NULL);
131INSERT INTO t4 (c1) VALUES(0);
132INSERT INTO t4 (c1) VALUES(1.0);
133INSERT INTO t4 (c1) VALUES(-9.0);
134SELECT * FROM t4;
135SELECT COUNT(c1) AS total_rows FROM t4;
136SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
137SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
138SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
139DROP TABLE t4;
140CREATE TABLE t5(c1 DOUBLE PRECISION(5,4) NOT NULL);
141INSERT INTO t5 (c1) VALUES(0);
142INSERT INTO t5 (c1) VALUES(1.0);
143INSERT INTO t5 (c1) VALUES(1.2345);
144INSERT INTO t5 (c1) VALUES(-9.0);
145INSERT INTO t5 (c1) VALUES(-9.12345);
146SELECT * FROM t5;
147SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
148SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
149SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
150DROP TABLE t5;
151CREATE TABLE t4(c1 FLOAT(1,0) NOT NULL);
152INSERT INTO t4 (c1) VALUES(0);
153INSERT INTO t4 (c1) VALUES(1.0);
154INSERT INTO t4 (c1) VALUES(-9.0);
155SELECT * FROM t4;
156SELECT COUNT(c1) AS total_rows FROM t4;
157SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
158SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
159SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
160DROP TABLE t4;
161CREATE TABLE t5(c1 FLOAT(5,4) NOT NULL);
162INSERT INTO t5 (c1) VALUES(0);
163INSERT INTO t5 (c1) VALUES(1.0);
164INSERT INTO t5 (c1) VALUES(1.2345);
165INSERT INTO t5 (c1) VALUES(-9.0);
166INSERT INTO t5 (c1) VALUES(-9.12345);
167SELECT * FROM t5;
168SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
169SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
170SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
171DROP TABLE t5;
172
173