aboutsummaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2012-02-04 15:52:09 -0500
committerTom Lane <tgl@sss.pgh.pa.us>2012-02-04 15:52:09 -0500
commit342b83fdca6af04d86e761f4d8d79e5d598688cd (patch)
tree5d3d45a02bee8c896912faaf8311ed4d862d8d57 /src
parent072ba77bffe005ccd6d1aaf8fff2c52ebed1a8b3 (diff)
downloadpostgresql-342b83fdca6af04d86e761f4d8d79e5d598688cd.tar.gz
postgresql-342b83fdca6af04d86e761f4d8d79e5d598688cd.zip
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.
Diffstat (limited to 'src')
-rw-r--r--src/test/regress/expected/float8-exp-three-digits-win32.out19
-rw-r--r--src/test/regress/expected/float8-small-is-zero.out19
-rw-r--r--src/test/regress/expected/float8-small-is-zero_1.out19
-rw-r--r--src/test/regress/expected/float8.out19
-rw-r--r--src/test/regress/sql/float8.sql5
5 files changed, 0 insertions, 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 (' ');