postgres.git / summary / log / commit / refs

commit    08b96a2b5243957acd3f7c3105af8b5b2d0da3ef
Author:   Tom Lane <tgl@sss.pgh.pa.us>
Date:     Fri Sep 03 14:01:02 2021 +0000
First released in: 15.0, 11.14, 12.9, 13.5, 14.0

    Fix portability issue in tests from commit ce773f230.
    
    Modern POSIX seems to require strtod() to accept "-NaN", but there's
    nothing about NaN in SUSv2, and some of our oldest buildfarm members
    don't like it.  Let's try writing it as -'NaN' instead; that seems
    to produce the same result, at least on Intel hardware.
    
    Per buildfarm.


 src/test/regress/expected/hash_func.out | 4 ++--
 src/test/regress/sql/hash_func.sql      | 4 ++--
 2 files changed, 4 insertions(+), 4 deletions(-)

diff --git a/src/test/regress/expected/hash_func.out b/src/test/regress/expected/hash_func.out
index 61c6cbbf109..8e23dc39783 100644
--- a/src/test/regress/expected/hash_func.out
+++ b/src/test/regress/expected/hash_func.out
@@ -348,7 +348,7 @@ SELECT hashfloat4('0'::float4) = hashfloat4('-0'::float4) AS t;
  t
 (1 row)
 
-SELECT hashfloat4('NaN'::float4) = hashfloat4('-NaN'::float4) AS t;
+SELECT hashfloat4('NaN'::float4) = hashfloat4(-'NaN'::float4) AS t;
  t 
 ---
  t
@@ -360,7 +360,7 @@ SELECT hashfloat8('0'::float8) = hashfloat8('-0'::float8) AS t;
  t
 (1 row)
 
-SELECT hashfloat8('NaN'::float8) = hashfloat8('-NaN'::float8) AS t;
+SELECT hashfloat8('NaN'::float8) = hashfloat8(-'NaN'::float8) AS t;
  t 
 ---
  t
diff --git a/src/test/regress/sql/hash_func.sql b/src/test/regress/sql/hash_func.sql
index 5c994f5de5e..5ad33c1f9d4 100644
--- a/src/test/regress/sql/hash_func.sql
+++ b/src/test/regress/sql/hash_func.sql
@@ -258,7 +258,7 @@ DROP TYPE hash_test_t2;
 -- Check special cases for specific data types
 --
 SELECT hashfloat4('0'::float4) = hashfloat4('-0'::float4) AS t;
-SELECT hashfloat4('NaN'::float4) = hashfloat4('-NaN'::float4) AS t;
+SELECT hashfloat4('NaN'::float4) = hashfloat4(-'NaN'::float4) AS t;
 SELECT hashfloat8('0'::float8) = hashfloat8('-0'::float8) AS t;
-SELECT hashfloat8('NaN'::float8) = hashfloat8('-NaN'::float8) AS t;
+SELECT hashfloat8('NaN'::float8) = hashfloat8(-'NaN'::float8) AS t;
 SELECT hashfloat4('NaN'::float4) = hashfloat8('NaN'::float8) AS t;


[parent: 6b54f12332a1]