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

Commit72b4086

Browse files
committed
Convert float8 regress test to use exp() and ln() instead of ':' and
';' operators.
1 parent7f116a6 commit72b4086

File tree

4 files changed

+16
-16
lines changed

4 files changed

+16
-16
lines changed

‎src/test/regress/expected/float8-exp-three-digits.out

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -161,7 +161,7 @@ SELECT '' AS three, f.f1, |/f.f1 AS sqrt_f1
161161
(3 rows)
162162

163163
-- take exp of ln(f.f1)
164-
SELECT '' AS three, f.f1,: ( ;f.f1) AS exp_ln_f1
164+
SELECT '' AS three, f.f1,exp(ln(f.f1)) AS exp_ln_f1
165165
FROM FLOAT8_TBL f
166166
WHERE f.f1 > '0.0';
167167
three | f1 | exp_ln_f1
@@ -199,11 +199,11 @@ SELECT '' AS bad, f.f1 * '1e200' from FLOAT8_TBL f;
199199
ERROR: Bad float8 input format -- overflow
200200
SELECT '' AS bad, f.f1 ^ '1e200' from FLOAT8_TBL f;
201201
ERROR: pow() result is out of range
202-
SELECT '' AS bad,(; (f.f1)) from FLOAT8_TBL f where f.f1 = '0.0' ;
202+
SELECT '' AS bad,ln(f.f1) from FLOAT8_TBL f where f.f1 = '0.0' ;
203203
ERROR: can't take log of zero
204-
SELECT '' AS bad,(; (f.f1)) from FLOAT8_TBL f where f.f1 < '0.0' ;
204+
SELECT '' AS bad,ln(f.f1) from FLOAT8_TBL f where f.f1 < '0.0' ;
205205
ERROR: can't take log of a negative number
206-
SELECT '' AS bad,:(f.f1) from FLOAT8_TBL f;
206+
SELECT '' AS bad,exp(f.f1) from FLOAT8_TBL f;
207207
ERROR: exp() result is out of range
208208
SELECT '' AS bad, f.f1 / '0.0' from FLOAT8_TBL f;
209209
ERROR: float8div: divide by zero error

‎src/test/regress/expected/float8-fp-exception.out

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -161,7 +161,7 @@ SELECT '' AS three, f.f1, |/f.f1 AS sqrt_f1
161161
(3 rows)
162162

163163
-- take exp of ln(f.f1)
164-
SELECT '' AS three, f.f1,: ( ;f.f1) AS exp_ln_f1
164+
SELECT '' AS three, f.f1,exp(ln(f.f1)) AS exp_ln_f1
165165
FROM FLOAT8_TBL f
166166
WHERE f.f1 > '0.0';
167167
three | f1 | exp_ln_f1
@@ -199,11 +199,11 @@ SELECT '' AS bad, f.f1 * '1e200' from FLOAT8_TBL f;
199199
ERROR: floating point exception! The last floating point operation either exceeded legal ranges or was a divide by zero
200200
SELECT '' AS bad, f.f1 ^ '1e200' from FLOAT8_TBL f;
201201
ERROR: pow() result is out of range
202-
SELECT '' AS bad,(; (f.f1)) from FLOAT8_TBL f where f.f1 = '0.0' ;
202+
SELECT '' AS bad,ln(f.f1) from FLOAT8_TBL f where f.f1 = '0.0' ;
203203
ERROR: can't take log of zero
204-
SELECT '' AS bad,(; (f.f1)) from FLOAT8_TBL f where f.f1 < '0.0' ;
204+
SELECT '' AS bad,ln(f.f1) from FLOAT8_TBL f where f.f1 < '0.0' ;
205205
ERROR: can't take log of a negative number
206-
SELECT '' AS bad,:(f.f1) from FLOAT8_TBL f;
206+
SELECT '' AS bad,exp(f.f1) from FLOAT8_TBL f;
207207
ERROR: exp() result is out of range
208208
SELECT '' AS bad, f.f1 / '0.0' from FLOAT8_TBL f;
209209
ERROR: float8div: divide by zero error

‎src/test/regress/expected/float8.out

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -173,7 +173,7 @@ SELECT '' AS three, f.f1, |/f.f1 AS sqrt_f1
173173
(3 rows)
174174

175175
-- take exp of ln(f.f1)
176-
SELECT '' AS three, f.f1,: ( ;f.f1) AS exp_ln_f1
176+
SELECT '' AS three, f.f1,exp(ln(f.f1)) AS exp_ln_f1
177177
FROM FLOAT8_TBL f
178178
WHERE f.f1 > '0.0';
179179
three | f1 | exp_ln_f1
@@ -217,11 +217,11 @@ SELECT '' AS bad, f.f1 * '1e200' from FLOAT8_TBL f;
217217
ERROR: Bad float8 input format -- overflow
218218
SELECT '' AS bad, f.f1 ^ '1e200' from FLOAT8_TBL f;
219219
ERROR: pow() result is out of range
220-
SELECT '' AS bad,(; (f.f1)) from FLOAT8_TBL f where f.f1 = '0.0' ;
220+
SELECT '' AS bad,ln(f.f1) from FLOAT8_TBL f where f.f1 = '0.0' ;
221221
ERROR: can't take log of zero
222-
SELECT '' AS bad,(; (f.f1)) from FLOAT8_TBL f where f.f1 < '0.0' ;
222+
SELECT '' AS bad,ln(f.f1) from FLOAT8_TBL f where f.f1 < '0.0' ;
223223
ERROR: can't take log of a negative number
224-
SELECT '' AS bad,:(f.f1) from FLOAT8_TBL f;
224+
SELECT '' AS bad,exp(f.f1) from FLOAT8_TBL f;
225225
ERROR: exp() result is out of range
226226
SELECT '' AS bad, f.f1 / '0.0' from FLOAT8_TBL f;
227227
ERROR: float8div: divide by zero error

‎src/test/regress/sql/float8.sql

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -70,7 +70,7 @@ SELECT '' AS three, f.f1, |/f.f1 AS sqrt_f1
7070
WHEREf.f1>'0.0';
7171

7272
-- take exp of ln(f.f1)
73-
SELECT''AS three,f.f1,: ( ;f.f1)AS exp_ln_f1
73+
SELECT''AS three,f.f1,exp(ln(f.f1))AS exp_ln_f1
7474
FROM FLOAT8_TBL f
7575
WHEREf.f1>'0.0';
7676

@@ -90,11 +90,11 @@ SELECT '' AS bad, f.f1 * '1e200' from FLOAT8_TBL f;
9090

9191
SELECT''AS bad,f.f1 ^'1e200'from FLOAT8_TBL f;
9292

93-
SELECT''AS bad,(; (f.f1))from FLOAT8_TBL fwheref.f1='0.0' ;
93+
SELECT''AS bad,ln(f.f1)from FLOAT8_TBL fwheref.f1='0.0' ;
9494

95-
SELECT''AS bad,(; (f.f1))from FLOAT8_TBL fwheref.f1<'0.0' ;
95+
SELECT''AS bad,ln(f.f1)from FLOAT8_TBL fwheref.f1<'0.0' ;
9696

97-
SELECT''AS bad,:(f.f1)from FLOAT8_TBL f;
97+
SELECT''AS bad,exp(f.f1)from FLOAT8_TBL f;
9898

9999
SELECT''AS bad,f.f1/'0.0'from FLOAT8_TBL f;
100100

0 commit comments

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