diff options
author | Tom Lane <tgl@sss.pgh.pa.us> | 2012-02-04 15:52:09 -0500 |
---|---|---|
committer | Tom Lane <tgl@sss.pgh.pa.us> | 2012-02-04 15:52:09 -0500 |
commit | 342b83fdca6af04d86e761f4d8d79e5d598688cd (patch) | |
tree | 5d3d45a02bee8c896912faaf8311ed4d862d8d57 /src | |
parent | 072ba77bffe005ccd6d1aaf8fff2c52ebed1a8b3 (diff) | |
download | postgresql-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.out | 19 | ||||
-rw-r--r-- | src/test/regress/expected/float8-small-is-zero.out | 19 | ||||
-rw-r--r-- | src/test/regress/expected/float8-small-is-zero_1.out | 19 | ||||
-rw-r--r-- | src/test/regress/expected/float8.out | 19 | ||||
-rw-r--r-- | src/test/regress/sql/float8.sql | 5 |
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 (' '); |