Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit41543b0

Browse files
committed
Dec ALpha patches
1 parent8223f70 commit41543b0

File tree

3 files changed

+742
-0
lines changed

3 files changed

+742
-0
lines changed
Lines changed: 234 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,234 @@
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.*;
8+
five|f1
9+
----+--------------------
10+
|0
11+
|1004.3
12+
|-34.84
13+
|1.2345678901234e+200
14+
|1.2345678901234e-200
15+
(5 rows)
16+
17+
QUERY: SELECT '' AS four, f.* FROM FLOAT8_TBL f WHERE f.f1 <> '1004.3';
18+
four|f1
19+
----+--------------------
20+
|0
21+
|-34.84
22+
|1.2345678901234e+200
23+
|1.2345678901234e-200
24+
(4 rows)
25+
26+
QUERY: SELECT '' AS one, f.* FROM FLOAT8_TBL f WHERE f.f1 = '1004.3';
27+
one| f1
28+
---+------
29+
|1004.3
30+
(1 row)
31+
32+
QUERY: SELECT '' AS three, f.* FROM FLOAT8_TBL f WHERE '1004.3' > f.f1;
33+
three| f1
34+
-----+--------------------
35+
| 0
36+
| -34.84
37+
|1.2345678901234e-200
38+
(3 rows)
39+
40+
QUERY: SELECT '' AS three, f.* FROM FLOAT8_TBL f WHERE f.f1 < '1004.3';
41+
three| f1
42+
-----+--------------------
43+
| 0
44+
| -34.84
45+
|1.2345678901234e-200
46+
(3 rows)
47+
48+
QUERY: SELECT '' AS four, f.* FROM FLOAT8_TBL f WHERE '1004.3' >= f.f1;
49+
four| f1
50+
----+--------------------
51+
| 0
52+
| 1004.3
53+
| -34.84
54+
|1.2345678901234e-200
55+
(4 rows)
56+
57+
QUERY: SELECT '' AS four, f.* FROM FLOAT8_TBL f WHERE f.f1 <= '1004.3';
58+
four| f1
59+
----+--------------------
60+
| 0
61+
| 1004.3
62+
| -34.84
63+
|1.2345678901234e-200
64+
(4 rows)
65+
66+
QUERY: SELECT '' AS three, f.f1, f.f1 * '-10' AS x
67+
FROM FLOAT8_TBL f
68+
WHERE f.f1 > '0.0';
69+
three|f1 |x
70+
-----+--------------------+---------------------
71+
|1004.3 |-10043
72+
|1.2345678901234e+200|-1.2345678901234e+201
73+
|1.2345678901234e-200|-1.2345678901234e-199
74+
(3 rows)
75+
76+
QUERY: SELECT '' AS three, f.f1, f.f1 + '-10' AS x
77+
FROM FLOAT8_TBL f
78+
WHERE f.f1 > '0.0';
79+
three|f1 |x
80+
-----+--------------------+--------------------
81+
|1004.3 |994.3
82+
|1.2345678901234e+200|1.2345678901234e+200
83+
|1.2345678901234e-200|-10
84+
(3 rows)
85+
86+
QUERY: SELECT '' AS three, f.f1, f.f1 / '-10' AS x
87+
FROM FLOAT8_TBL f
88+
WHERE f.f1 > '0.0';
89+
three|f1 |x
90+
-----+--------------------+---------------------
91+
|1004.3 |-100.43
92+
|1.2345678901234e+200|-1.2345678901234e+199
93+
|1.2345678901234e-200|-1.2345678901234e-201
94+
(3 rows)
95+
96+
QUERY: SELECT '' AS three, f.f1, f.f1 - '-10' AS x
97+
FROM FLOAT8_TBL f
98+
WHERE f.f1 > '0.0';
99+
three|f1 |x
100+
-----+--------------------+--------------------
101+
|1004.3 |1014.3
102+
|1.2345678901234e+200|1.2345678901234e+200
103+
|1.2345678901234e-200|10
104+
(3 rows)
105+
106+
QUERY: SELECT '' AS one, f.f1 ^ '2.0' AS square_f1
107+
FROM FLOAT8_TBL f where f.f1 = '1004.3';
108+
one| square_f1
109+
---+----------
110+
|1008618.49
111+
(1 row)
112+
113+
QUERY: SELECT '' AS five, f.f1, @f.f1 AS abs_f1
114+
FROM FLOAT8_TBL f;
115+
five|f1 |abs_f1
116+
----+--------------------+--------------------
117+
|0 |0
118+
|1004.3 |1004.3
119+
|-34.84 |34.84
120+
|1.2345678901234e+200|1.2345678901234e+200
121+
|1.2345678901234e-200|1.2345678901234e-200
122+
(5 rows)
123+
124+
QUERY: SELECT '' AS five, f.f1, %f.f1 AS trunc_f1
125+
FROM FLOAT8_TBL f;
126+
five|f1 |trunc_f1
127+
----+--------------------+--------------------
128+
|0 |0
129+
|1004.3 |1004
130+
|-34.84 |-34
131+
|1.2345678901234e+200|1.2345678901234e+200
132+
|1.2345678901234e-200|0
133+
(5 rows)
134+
135+
QUERY: SELECT '' AS five, f.f1, f.f1 % AS round_f1
136+
FROM FLOAT8_TBL f;
137+
five|f1 |round_f1
138+
----+--------------------+--------------------
139+
|0 |0
140+
|1004.3 |1004
141+
|-34.84 |-35
142+
|1.2345678901234e+200|1.2345678901234e+200
143+
|1.2345678901234e-200|0
144+
(5 rows)
145+
146+
QUERY: SELECT '' AS three, f.f1, |/f.f1 AS sqrt_f1
147+
FROM FLOAT8_TBL f
148+
WHERE f.f1 > '0.0';
149+
three|f1 |sqrt_f1
150+
-----+--------------------+---------------------
151+
|1004.3 |31.6906926399535
152+
|1.2345678901234e+200|1.11111110611109e+100
153+
|1.2345678901234e-200|1.11111110611109e-100
154+
(3 rows)
155+
156+
QUERY: SELECT '' AS three, f.f1, : ( ; f.f1) AS exp_ln_f1
157+
FROM FLOAT8_TBL f
158+
WHERE f.f1 > '0.0';
159+
three|f1 |exp_ln_f1
160+
-----+--------------------+---------------------
161+
|1004.3 |1004.3
162+
|1.2345678901234e+200|1.23456789012338e+200
163+
|1.2345678901234e-200|1.23456789012339e-200
164+
(3 rows)
165+
166+
QUERY: SELECT '' AS five, f.f1, ||/f.f1 AS cbrt_f1 FROM FLOAT8_TBL f;
167+
five|f1 |cbrt_f1
168+
----+--------------------+--------------------
169+
|0 |0
170+
|1004.3 |10.014312837827
171+
|-34.84 |-3.26607421344208
172+
|1.2345678901234e+200|4.97933859234765e+66
173+
|1.2345678901234e-200|2.3112042409018e-67
174+
(5 rows)
175+
176+
QUERY: SELECT '' AS five, FLOAT8_TBL.*;
177+
five|f1
178+
----+--------------------
179+
|0
180+
|1004.3
181+
|-34.84
182+
|1.2345678901234e+200
183+
|1.2345678901234e-200
184+
(5 rows)
185+
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: floating point exception! The last floating point operation either exceeded legal ranges or was a divide by zero
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.*;
202+
five|f1
203+
----+---------------------
204+
|0
205+
|-34.84
206+
|-1004.3
207+
|-1.2345678901234e+200
208+
|-1.2345678901234e-200
209+
(5 rows)
210+
211+
QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('10e400');
212+
ERROR: Input '10e400' is out of range for float8
213+
QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e400');
214+
ERROR: Input '-10e400' is out of range for float8
215+
QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('10e-400');
216+
ERROR: Input '10e-400' is out of range for float8
217+
QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e-400');
218+
ERROR: Input '-10e-400' is out of range for float8
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.*;
226+
five|f1
227+
----+---------------------
228+
|0
229+
|-34.84
230+
|-1004.3
231+
|-1.2345678901234e+200
232+
|-1.2345678901234e-200
233+
(5 rows)
234+

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp