postgres.git / summary / log / commit / refs
commit 342b83fdca6af04d86e761f4d8d79e5d598688cd
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: Sat Feb 04 20:52:09 2012 +0000
First released in: 9.2.0
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.
.../expected/float8-exp-three-digits-win32.out | 19 -------------------
src/test/regress/expected/float8-small-is-zero.out | 19 -------------------
src/test/regress/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 fe97af0029b..2dd648d6b92 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 2bf2e6ce607..5da743374c9 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 b276eeca4f2..530842e1023 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 df6ec9c58c7..6221538af5c 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 1f24556fed4..92a574ab7bf 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 (' ');
[parent: 072ba77bffe0]