Revert "Add some regression test cases for denormalized float8 input."

tglsfdc · tglsfdc · commit 342b83fdca6a · 2012-02-04T15:52:09.000-05:00
This reverts commit 500cf66. 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.
diff --git 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
@@ -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
@@ -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
@@ -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
@@ -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 ('     ');
