1 QUERY: CREATE TABLE FLOAT8_TBL(f1 float8);
2 QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('0.0');
3 QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('1004.30');
4 QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('-34.84');
5 QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('1.2345678901234e+200');
6 QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('1.2345678901234e-200');
7 QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('10e400');
8 WARN: Bad float8 input format
10 QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e400');
11 WARN: Bad float8 input format
13 QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('10e-400');
14 WARN: Bad float8 input format
16 QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e-400');
17 WARN: Bad float8 input format
19 QUERY: SELECT '' AS five, FLOAT8_TBL.*;
21 ----+--------------------
29 QUERY: SELECT '' AS four, f.* FROM FLOAT8_TBL f WHERE f.f1 <> '1004.3';
31 ----+--------------------
38 QUERY: SELECT '' AS one, f.* FROM FLOAT8_TBL f WHERE f.f1 = '1004.3';
44 QUERY: SELECT '' AS three, f.* FROM FLOAT8_TBL f WHERE '1004.3' > f.f1;
46 -----+--------------------
52 QUERY: SELECT '' AS three, f.* FROM FLOAT8_TBL f WHERE f.f1 < '1004.3';
54 -----+--------------------
60 QUERY: SELECT '' AS four, f.* FROM FLOAT8_TBL f WHERE '1004.3' >= f.f1;
62 ----+--------------------
69 QUERY: SELECT '' AS four, f.* FROM FLOAT8_TBL f WHERE f.f1 <= '1004.3';
71 ----+--------------------
78 QUERY: SELECT '' AS three, f.f1, f.f1 * '-10' AS x
82 -----+--------------------+---------------------
84 |1.2345678901234e+200|-1.2345678901234e+201
85 |1.2345678901234e-200|-1.2345678901234e-199
88 QUERY: SELECT '' AS three, f.f1, f.f1 + '-10' AS x
92 -----+--------------------+--------------------
94 |1.2345678901234e+200|1.2345678901234e+200
95 |1.2345678901234e-200|-10
98 QUERY: SELECT '' AS three, f.f1, f.f1 / '-10' AS x
102 -----+--------------------+---------------------
104 |1.2345678901234e+200|-1.2345678901234e+199
105 |1.2345678901234e-200|-1.2345678901234e-201
108 QUERY: SELECT '' AS three, f.f1, f.f1 - '-10' AS x
112 -----+--------------------+--------------------
114 |1.2345678901234e+200|1.2345678901234e+200
115 |1.2345678901234e-200|10
118 QUERY: SELECT '' AS one, f.f1 ^ '2.0' AS square_f1
119 FROM FLOAT8_TBL f where f.f1 = '1004.3';
125 QUERY: SELECT '' AS five, f.f1, @f.f1 AS abs_f1
128 ----+--------------------+--------------------
132 |1.2345678901234e+200|1.2345678901234e+200
133 |1.2345678901234e-200|1.2345678901234e-200
136 QUERY: SELECT '' AS five, f.f1, %f.f1 AS trunc_f1
139 ----+--------------------+--------------------
143 |1.2345678901234e+200|1.2345678901234e+200
144 |1.2345678901234e-200|0
147 QUERY: SELECT '' AS five, f.f1, f.f1 % AS round_f1
150 ----+--------------------+--------------------
154 |1.2345678901234e+200|1.2345678901234e+200
155 |1.2345678901234e-200|0
158 QUERY: SELECT '' AS three, f.f1, |/f.f1 AS sqrt_f1
162 -----+--------------------+---------------------
163 |1004.3 |31.6906926399535
164 |1.2345678901234e+200|1.11111110611109e+100
165 |1.2345678901234e-200|1.11111110611109e-100
168 QUERY: SELECT '' AS three, f.f1, : ( ; f.f1) AS exp_ln_f1
172 -----+--------------------+---------------------
174 |1.2345678901234e+200|1.23456789012338e+200
175 |1.2345678901234e-200|1.23456789012339e-200
178 QUERY: SELECT '' AS five, f.f1, ||/f.f1 AS cbrt_f1 FROM FLOAT8_TBL f;
180 ----+--------------------+--------------------
182 |1004.3 |10.014312837827
183 |-34.84 |-3.26607421344208
184 |1.2345678901234e+200|4.97933859234765e+66
185 |1.2345678901234e-200|2.3112042409018e-67
188 QUERY: SELECT '' AS five, FLOAT8_TBL.*;
190 ----+--------------------
194 |1.2345678901234e+200
195 |1.2345678901234e-200
198 QUERY: UPDATE FLOAT8_TBL
199 SET f1 = FLOAT8_TBL.f1 * '-1'
200 WHERE FLOAT8_TBL.f1 > '0.0';
201 QUERY: SELECT '' AS bad, f.f1 * '1e200' from FLOAT8_TBL f;
202 WARN: Bad float8 input format -- overflow
204 QUERY: SELECT '' AS bad, f.f1 ^ '1e200' from FLOAT8_TBL f;
205 WARN:pow() returned a floating point out of the range
207 QUERY: SELECT '' AS bad, (; (f.f1)) from FLOAT8_TBL f where f.f1 = '0.0' ;
208 WARN:can't take log of 0!
209 QUERY: SELECT '' AS bad, (; (f.f1)) from FLOAT8_TBL f where f.f1 < '0.0' ;
210 WARN:can't take log of a negative number
211 QUERY: SELECT '' AS bad, : (f.f1) from FLOAT8_TBL f;
213 ---+--------------------
215 |7.39912306090513e-16
221 QUERY: SELECT '' AS bad, f.f1 / '0.0' from FLOAT8_TBL f;
222 WARN:float8div: divide by 0.0 error
223 QUERY: SELECT '' AS five, FLOAT8_TBL.*;
225 ----+---------------------
229 |-1.2345678901234e+200
230 |-1.2345678901234e-200