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

Commitc015f85

Browse files
committed
Adjust the tests for the hyperbolic functions.
Preliminary results from the buildfarm suggest that no platform getscommitc6f153d's test cases wrong by more than one or two units inthe last place, so setting extra_float_digits = 0 should be plentyto hide the cross-platform variations.Also, add tests for Infinity/NaN inputs. I think it highly likelythat we'll end up removing these again, rather than adding code tomake ancient platforms conform. But it seems useful to find outjust how many platforms have such issues before we make a decision.Discussion:https://postgr.es/m/E1h3nUY-0000sM-Vf@gemulon.postgresql.org
1 parentc6f153d commitc015f85

File tree

2 files changed

+138
-18
lines changed

2 files changed

+138
-18
lines changed

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

Lines changed: 115 additions & 16 deletions
Original file line numberDiff line numberDiff line change
@@ -454,24 +454,25 @@ SELECT '' AS five, * FROM FLOAT8_TBL;
454454
| -1.2345678901234e-200
455455
(5 rows)
456456

457-
RESET extra_float_digits;
458457
-- hyperbolic functions
458+
-- we run these with extra_float_digits = 0 too, since different platforms
459+
-- tend to produce results that vary in the last place.
459460
SELECT sinh(float8 '1');
460-
sinh
461-
--------------------
462-
1.1752011936438014
461+
sinh
462+
-----------------
463+
1.1752011936438
463464
(1 row)
464465

465466
SELECT cosh(float8 '1');
466-
cosh
467-
--------------------
468-
1.5430806348152437
467+
cosh
468+
------------------
469+
1.54308063481524
469470
(1 row)
470471

471472
SELECT tanh(float8 '1');
472-
tanh
473-
--------------------
474-
0.7615941559557649
473+
tanh
474+
-------------------
475+
0.761594155955765
475476
(1 row)
476477

477478
SELECT asinh(float8 '1');
@@ -481,17 +482,115 @@ SELECT asinh(float8 '1');
481482
(1 row)
482483

483484
SELECT acosh(float8 '2');
484-
acosh
485-
--------------------
486-
1.3169578969248166
485+
acosh
486+
------------------
487+
1.31695789692482
487488
(1 row)
488489

489490
SELECT atanh(float8 '0.5');
490-
atanh
491-
--------------------
492-
0.5493061443340548
491+
atanh
492+
-------------------
493+
0.549306144334055
494+
(1 row)
495+
496+
-- test Inf/NaN cases for hyperbolic functions
497+
SELECT sinh(float8 'infinity');
498+
sinh
499+
----------
500+
Infinity
501+
(1 row)
502+
503+
SELECT sinh(float8 '-infinity');
504+
sinh
505+
-----------
506+
-Infinity
507+
(1 row)
508+
509+
SELECT sinh(float8 'nan');
510+
sinh
511+
------
512+
NaN
513+
(1 row)
514+
515+
SELECT cosh(float8 'infinity');
516+
cosh
517+
----------
518+
Infinity
519+
(1 row)
520+
521+
SELECT cosh(float8 '-infinity');
522+
cosh
523+
----------
524+
Infinity
525+
(1 row)
526+
527+
SELECT cosh(float8 'nan');
528+
cosh
529+
------
530+
NaN
531+
(1 row)
532+
533+
SELECT tanh(float8 'infinity');
534+
tanh
535+
------
536+
1
493537
(1 row)
494538

539+
SELECT tanh(float8 '-infinity');
540+
tanh
541+
------
542+
-1
543+
(1 row)
544+
545+
SELECT tanh(float8 'nan');
546+
tanh
547+
------
548+
NaN
549+
(1 row)
550+
551+
SELECT asinh(float8 'infinity');
552+
asinh
553+
----------
554+
Infinity
555+
(1 row)
556+
557+
SELECT asinh(float8 '-infinity');
558+
asinh
559+
-----------
560+
-Infinity
561+
(1 row)
562+
563+
SELECT asinh(float8 'nan');
564+
asinh
565+
-------
566+
NaN
567+
(1 row)
568+
569+
SELECT acosh(float8 'infinity');
570+
acosh
571+
----------
572+
Infinity
573+
(1 row)
574+
575+
SELECT acosh(float8 '-infinity');
576+
ERROR: input is out of range
577+
SELECT acosh(float8 'nan');
578+
acosh
579+
-------
580+
NaN
581+
(1 row)
582+
583+
SELECT atanh(float8 'infinity');
584+
ERROR: input is out of range
585+
SELECT atanh(float8 '-infinity');
586+
ERROR: input is out of range
587+
SELECT atanh(float8 'nan');
588+
atanh
589+
-------
590+
NaN
591+
(1 row)
592+
593+
RESET extra_float_digits;
495594
-- test for over- and underflow
496595
INSERT INTO FLOAT8_TBL(f1) VALUES ('10e400');
497596
ERROR: "10e400" is out of range for type double precision

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

Lines changed: 23 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -154,15 +154,36 @@ SELECT '' AS bad, f.f1 / '0.0' from FLOAT8_TBL f;
154154

155155
SELECT''AS five,*FROM FLOAT8_TBL;
156156

157-
RESET extra_float_digits;
158-
159157
-- hyperbolic functions
158+
-- we run these with extra_float_digits = 0 too, since different platforms
159+
-- tend to produce results that vary in the last place.
160160
SELECT sinh(float8'1');
161161
SELECT cosh(float8'1');
162162
SELECT tanh(float8'1');
163163
SELECT asinh(float8'1');
164164
SELECT acosh(float8'2');
165165
SELECT atanh(float8'0.5');
166+
-- test Inf/NaN cases for hyperbolic functions
167+
SELECT sinh(float8'infinity');
168+
SELECT sinh(float8'-infinity');
169+
SELECT sinh(float8'nan');
170+
SELECT cosh(float8'infinity');
171+
SELECT cosh(float8'-infinity');
172+
SELECT cosh(float8'nan');
173+
SELECT tanh(float8'infinity');
174+
SELECT tanh(float8'-infinity');
175+
SELECT tanh(float8'nan');
176+
SELECT asinh(float8'infinity');
177+
SELECT asinh(float8'-infinity');
178+
SELECT asinh(float8'nan');
179+
SELECT acosh(float8'infinity');
180+
SELECT acosh(float8'-infinity');
181+
SELECT acosh(float8'nan');
182+
SELECT atanh(float8'infinity');
183+
SELECT atanh(float8'-infinity');
184+
SELECT atanh(float8'nan');
185+
186+
RESET extra_float_digits;
166187

167188
-- test for over- and underflow
168189
INSERT INTO FLOAT8_TBL(f1)VALUES ('10e400');

0 commit comments

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