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

Commit9b381a6

Browse files
committed
Add NetBSD specific expected files
1 parent5191d52 commit9b381a6

File tree

4 files changed

+1012
-0
lines changed

4 files changed

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

0 commit comments

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