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

Commitb0f1880

Browse files
committed
Add new netbsd file.
1 parente18c912 commitb0f1880

File tree

1 file changed

+232
-0
lines changed

1 file changed

+232
-0
lines changed
Lines changed: 232 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,232 @@
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: 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.*;
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+
QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e-400');
217+
QUERY: DELETE FROM FLOAT8_TBL;
218+
QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('0.0');
219+
QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('-34.84');
220+
QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('-1004.30');
221+
QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('-1.2345678901234e+200');
222+
QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('-1.2345678901234e-200');
223+
QUERY: SELECT '' AS five, FLOAT8_TBL.*;
224+
five|f1
225+
----+---------------------
226+
|0
227+
|-34.84
228+
|-1004.3
229+
|-1.2345678901234e+200
230+
|-1.2345678901234e-200
231+
(5 rows)
232+

0 commit comments

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