From 342b83fdca6af04d86e761f4d8d79e5d598688cd Mon Sep 17 00:00:00 2001
From: Tom Lane <tgl@sss.pgh.pa.us>
Date: Sat, 4 Feb 2012 15:52:09 -0500
Subject: [PATCH] Revert "Add some regression test cases for denormalized
 float8 input."

This reverts commit 500cf66d5522b39ddfdc26b309f8b5b0e385f42e.  As was
more or less expected, a small minority of platforms won't accept
denormalized input even with the recent changes.  It doesn't seem
especially helpful to test this if we're going to have to provide an
alternate expected-file to allow failure.
---
 .../float8-exp-three-digits-win32.out         | 19 -------------------
 .../regress/expected/float8-small-is-zero.out | 19 -------------------
 .../expected/float8-small-is-zero_1.out       | 19 -------------------
 src/test/regress/expected/float8.out          | 19 -------------------
 src/test/regress/sql/float8.sql               |  5 -----
 5 files changed, 81 deletions(-)

diff --git a/src/test/regress/expected/float8-exp-three-digits-win32.out b/src/test/regress/expected/float8-exp-three-digits-win32.out
index fe97af0029..2dd648d6b9 100644
--- a/src/test/regress/expected/float8-exp-three-digits-win32.out
+++ b/src/test/regress/expected/float8-exp-three-digits-win32.out
@@ -24,25 +24,6 @@ SELECT '-10e-400'::float8;
 ERROR:  "-10e-400" is out of range for type double precision
 LINE 1: SELECT '-10e-400'::float8;
                ^
--- test whether denormalized values are accepted
-SELECT '4.95e-324'::float8 < '1.49e-323'::float8;
- ?column? 
-----------
- t
-(1 row)
-
-SELECT '4.95e-324'::float8 > '0'::float8;
- ?column? 
-----------
- t
-(1 row)
-
-SELECT substr('-4.95e-324'::float8::text, 1, 4);
- substr 
---------
- -4.9
-(1 row)
-
 -- bad input
 INSERT INTO FLOAT8_TBL(f1) VALUES ('');
 ERROR:  invalid input syntax for type double precision: ""
diff --git a/src/test/regress/expected/float8-small-is-zero.out b/src/test/regress/expected/float8-small-is-zero.out
index 2bf2e6ce60..5da743374c 100644
--- a/src/test/regress/expected/float8-small-is-zero.out
+++ b/src/test/regress/expected/float8-small-is-zero.out
@@ -24,25 +24,6 @@ SELECT '10e-400'::float8;
 
 SELECT '-10e-400'::float8;
  float8 
--- test whether denormalized values are accepted
-SELECT '4.95e-324'::float8 < '1.49e-323'::float8;
- ?column? 
-----------
- t
-(1 row)
-
-SELECT '4.95e-324'::float8 > '0'::float8;
- ?column? 
-----------
- t
-(1 row)
-
-SELECT substr('-4.95e-324'::float8::text, 1, 4);
- substr 
---------
- -4.9
-(1 row)
-
 --------
      -0
 (1 row)
diff --git a/src/test/regress/expected/float8-small-is-zero_1.out b/src/test/regress/expected/float8-small-is-zero_1.out
index b276eeca4f..530842e102 100644
--- a/src/test/regress/expected/float8-small-is-zero_1.out
+++ b/src/test/regress/expected/float8-small-is-zero_1.out
@@ -24,25 +24,6 @@ SELECT '10e-400'::float8;
 
 SELECT '-10e-400'::float8;
  float8 
--- test whether denormalized values are accepted
-SELECT '4.95e-324'::float8 < '1.49e-323'::float8;
- ?column? 
-----------
- t
-(1 row)
-
-SELECT '4.95e-324'::float8 > '0'::float8;
- ?column? 
-----------
- t
-(1 row)
-
-SELECT substr('-4.95e-324'::float8::text, 1, 4);
- substr 
---------
- -4.9
-(1 row)
-
 --------
       0
 (1 row)
diff --git a/src/test/regress/expected/float8.out b/src/test/regress/expected/float8.out
index df6ec9c58c..6221538af5 100644
--- a/src/test/regress/expected/float8.out
+++ b/src/test/regress/expected/float8.out
@@ -24,25 +24,6 @@ SELECT '-10e-400'::float8;
 ERROR:  "-10e-400" is out of range for type double precision
 LINE 1: SELECT '-10e-400'::float8;
                ^
--- test whether denormalized values are accepted
-SELECT '4.95e-324'::float8 < '1.49e-323'::float8;
- ?column? 
-----------
- t
-(1 row)
-
-SELECT '4.95e-324'::float8 > '0'::float8;
- ?column? 
-----------
- t
-(1 row)
-
-SELECT substr('-4.95e-324'::float8::text, 1, 4);
- substr 
---------
- -4.9
-(1 row)
-
 -- bad input
 INSERT INTO FLOAT8_TBL(f1) VALUES ('');
 ERROR:  invalid input syntax for type double precision: ""
diff --git a/src/test/regress/sql/float8.sql b/src/test/regress/sql/float8.sql
index 1f24556fed..92a574ab7b 100644
--- a/src/test/regress/sql/float8.sql
+++ b/src/test/regress/sql/float8.sql
@@ -16,11 +16,6 @@ SELECT '-10e400'::float8;
 SELECT '10e-400'::float8;
 SELECT '-10e-400'::float8;
 
--- test whether denormalized values are accepted
-SELECT '4.95e-324'::float8 < '1.49e-323'::float8;
-SELECT '4.95e-324'::float8 > '0'::float8;
-SELECT substr('-4.95e-324'::float8::text, 1, 4);
-
 -- bad input
 INSERT INTO FLOAT8_TBL(f1) VALUES ('');
 INSERT INTO FLOAT8_TBL(f1) VALUES ('     ');
-- 
2.40.0