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: SELECT '' AS five, FLOAT8_TBL.*;
9 ----+--------------------
17 QUERY: SELECT '' AS four, f.* FROM FLOAT8_TBL f WHERE f.f1 <> '1004.3';
19 ----+--------------------
26 QUERY: SELECT '' AS one, f.* FROM FLOAT8_TBL f WHERE f.f1 = '1004.3';
32 QUERY: SELECT '' AS three, f.* FROM FLOAT8_TBL f WHERE '1004.3' > f.f1;
34 -----+--------------------
40 QUERY: SELECT '' AS three, f.* FROM FLOAT8_TBL f WHERE f.f1 < '1004.3';
42 -----+--------------------
48 QUERY: SELECT '' AS four, f.* FROM FLOAT8_TBL f WHERE '1004.3' >= f.f1;
50 ----+--------------------
57 QUERY: SELECT '' AS four, f.* FROM FLOAT8_TBL f WHERE f.f1 <= '1004.3';
59 ----+--------------------
66 QUERY: SELECT '' AS three, f.f1, f.f1 * '-10' AS x
70 -----+--------------------+---------------------
72 |1.2345678901234e+200|-1.2345678901234e+201
73 |1.2345678901234e-200|-1.2345678901234e-199
76 QUERY: SELECT '' AS three, f.f1, f.f1 + '-10' AS x
80 -----+--------------------+--------------------
82 |1.2345678901234e+200|1.2345678901234e+200
83 |1.2345678901234e-200|-10
86 QUERY: SELECT '' AS three, f.f1, f.f1 / '-10' AS x
90 -----+--------------------+---------------------
92 |1.2345678901234e+200|-1.2345678901234e+199
93 |1.2345678901234e-200|-1.2345678901234e-201
96 QUERY: SELECT '' AS three, f.f1, f.f1 - '-10' AS x
100 -----+--------------------+--------------------
102 |1.2345678901234e+200|1.2345678901234e+200
103 |1.2345678901234e-200|10
106 QUERY: SELECT '' AS one, f.f1 ^ '2.0' AS square_f1
107 FROM FLOAT8_TBL f where f.f1 = '1004.3';
113 QUERY: SELECT '' AS five, f.f1, @f.f1 AS abs_f1
116 ----+--------------------+--------------------
120 |1.2345678901234e+200|1.2345678901234e+200
121 |1.2345678901234e-200|1.2345678901234e-200
124 QUERY: SELECT '' AS five, f.f1, %f.f1 AS trunc_f1
127 ----+--------------------+--------------------
131 |1.2345678901234e+200|1.2345678901234e+200
132 |1.2345678901234e-200|0
135 QUERY: SELECT '' AS five, f.f1, f.f1 % AS round_f1
138 ----+--------------------+--------------------
142 |1.2345678901234e+200|1.2345678901234e+200
143 |1.2345678901234e-200|0
146 QUERY: SELECT '' AS three, f.f1, |/f.f1 AS sqrt_f1
150 -----+--------------------+---------------------
151 |1004.3 |31.6906926399535
152 |1.2345678901234e+200|1.11111110611109e+100
153 |1.2345678901234e-200|1.11111110611109e-100
156 QUERY: SELECT '' AS three, f.f1, : ( ; f.f1) AS exp_ln_f1
160 -----+--------------------+---------------------
162 |1.2345678901234e+200|1.23456789012338e+200
163 |1.2345678901234e-200|1.23456789012339e-200
166 QUERY: SELECT '' AS five, f.f1, ||/f.f1 AS cbrt_f1 FROM FLOAT8_TBL f;
168 ----+--------------------+--------------------
170 |1004.3 |10.014312837827
171 |-34.84 |-3.26607421344208
172 |1.2345678901234e+200|4.97933859234765e+66
173 |1.2345678901234e-200|2.3112042409018e-67
176 QUERY: SELECT '' AS five, FLOAT8_TBL.*;
178 ----+--------------------
182 |1.2345678901234e+200
183 |1.2345678901234e-200
186 QUERY: UPDATE FLOAT8_TBL
187 SET f1 = FLOAT8_TBL.f1 * '-1'
188 WHERE FLOAT8_TBL.f1 > '0.0';
189 QUERY: SELECT '' AS bad, f.f1 * '1e200' from FLOAT8_TBL f;
190 ERROR: Bad float8 input format -- overflow
191 QUERY: SELECT '' AS bad, f.f1 ^ '1e200' from FLOAT8_TBL f;
192 ERROR: pow() result is out of range
193 QUERY: SELECT '' AS bad, (; (f.f1)) from FLOAT8_TBL f where f.f1 = '0.0' ;
194 ERROR: can't take log of zero
195 QUERY: SELECT '' AS bad, (; (f.f1)) from FLOAT8_TBL f where f.f1 < '0.0' ;
196 ERROR: can't take log of a negative number
197 QUERY: SELECT '' AS bad, : (f.f1) from FLOAT8_TBL f;
198 ERROR: exp() result is out of range
199 QUERY: SELECT '' AS bad, f.f1 / '0.0' from FLOAT8_TBL f;
200 ERROR: float8div: divide by zero error
201 QUERY: SELECT '' AS five, FLOAT8_TBL.*;
203 ----+---------------------
207 |-1.2345678901234e+200
208 |-1.2345678901234e-200
211 QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('10e400');
212 ERROR: Bad float8 input format '10e400'
213 QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e400');
214 ERROR: Bad float8 input format '-10e400'
215 QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('10e-400');
216 ERROR: Bad float8 input format '10e-400'
217 QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e-400');
218 ERROR: Bad float8 input format '-10e-400'
219 QUERY: DELETE FROM FLOAT8_TBL;
220 QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('0.0');
221 QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('-34.84');
222 QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('-1004.30');
223 QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('-1.2345678901234e+200');
224 QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('-1.2345678901234e-200');
225 QUERY: SELECT '' AS five, FLOAT8_TBL.*;
227 ----+---------------------
231 |-1.2345678901234e+200
232 |-1.2345678901234e-200