diff options
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/float4-exp-three-digits.out | 6 | ||||
| -rw-r--r-- | src/test/regress/expected/float4.out | 6 | ||||
| -rw-r--r-- | src/test/regress/expected/float8-exp-three-digits-win32.out | 6 | ||||
| -rw-r--r-- | src/test/regress/expected/float8-small-is-zero.out | 6 | ||||
| -rw-r--r-- | src/test/regress/expected/float8-small-is-zero_1.out | 6 | ||||
| -rw-r--r-- | src/test/regress/expected/float8.out | 6 | ||||
| -rw-r--r-- | src/test/regress/sql/float4.sql | 2 | ||||
| -rw-r--r-- | src/test/regress/sql/float8.sql | 1 |
8 files changed, 38 insertions, 1 deletions
diff --git a/src/test/regress/expected/float4-exp-three-digits.out b/src/test/regress/expected/float4-exp-three-digits.out index b849910151..ff680f4792 100644 --- a/src/test/regress/expected/float4-exp-three-digits.out +++ b/src/test/regress/expected/float4-exp-three-digits.out @@ -119,6 +119,12 @@ SELECT 'nan'::float4 / 'nan'::float4; NaN (1 row) +SELECT 'nan'::numeric::float4; + float4 +-------- + NaN +(1 row) + SELECT '' AS five, * FROM FLOAT4_TBL; five | f1 ------+-------------- diff --git a/src/test/regress/expected/float4.out b/src/test/regress/expected/float4.out index 2c19e7eb08..dd8066a79c 100644 --- a/src/test/regress/expected/float4.out +++ b/src/test/regress/expected/float4.out @@ -119,6 +119,12 @@ SELECT 'nan'::float4 / 'nan'::float4; NaN (1 row) +SELECT 'nan'::numeric::float4; + float4 +-------- + NaN +(1 row) + SELECT '' AS five, * FROM FLOAT4_TBL; five | f1 ------+------------- 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 4d133b42dc..a4b8b47bad 100644 --- a/src/test/regress/expected/float8-exp-three-digits-win32.out +++ b/src/test/regress/expected/float8-exp-three-digits-win32.out @@ -119,6 +119,12 @@ SELECT 'nan'::float8 / 'nan'::float8; NaN (1 row) +SELECT 'nan'::numeric::float8; + float8 +-------- + NaN +(1 row) + SELECT '' AS five, * FROM FLOAT8_TBL; five | f1 ------+---------------------- diff --git a/src/test/regress/expected/float8-small-is-zero.out b/src/test/regress/expected/float8-small-is-zero.out index 6c756a6f8e..3037892ffe 100644 --- a/src/test/regress/expected/float8-small-is-zero.out +++ b/src/test/regress/expected/float8-small-is-zero.out @@ -123,6 +123,12 @@ SELECT 'nan'::float8 / 'nan'::float8; NaN (1 row) +SELECT 'nan'::numeric::float8; + float8 +-------- + NaN +(1 row) + SELECT '' AS five, * FROM FLOAT8_TBL; five | f1 ------+---------------------- 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 8b25f0955c..c48bb538c4 100644 --- a/src/test/regress/expected/float8-small-is-zero_1.out +++ b/src/test/regress/expected/float8-small-is-zero_1.out @@ -123,6 +123,12 @@ SELECT 'nan'::float8 / 'nan'::float8; NaN (1 row) +SELECT 'nan'::numeric::float8; + float8 +-------- + NaN +(1 row) + SELECT '' AS five, * FROM FLOAT8_TBL; five | f1 ------+---------------------- diff --git a/src/test/regress/expected/float8.out b/src/test/regress/expected/float8.out index e9e71bb7aa..d8350d100e 100644 --- a/src/test/regress/expected/float8.out +++ b/src/test/regress/expected/float8.out @@ -119,6 +119,12 @@ SELECT 'nan'::float8 / 'nan'::float8; NaN (1 row) +SELECT 'nan'::numeric::float8; + float8 +-------- + NaN +(1 row) + SELECT '' AS five, * FROM FLOAT8_TBL; five | f1 ------+---------------------- diff --git a/src/test/regress/sql/float4.sql b/src/test/regress/sql/float4.sql index 5944e2fc14..4cde9d742f 100644 --- a/src/test/regress/sql/float4.sql +++ b/src/test/regress/sql/float4.sql @@ -40,7 +40,7 @@ SELECT ' INFINITY x'::float4; SELECT 'Infinity'::float4 + 100.0; SELECT 'Infinity'::float4 / 'Infinity'::float4; SELECT 'nan'::float4 / 'nan'::float4; - +SELECT 'nan'::numeric::float4; SELECT '' AS five, * FROM FLOAT4_TBL; diff --git a/src/test/regress/sql/float8.sql b/src/test/regress/sql/float8.sql index 92b6b0d7b9..142e6d7d73 100644 --- a/src/test/regress/sql/float8.sql +++ b/src/test/regress/sql/float8.sql @@ -40,6 +40,7 @@ SELECT ' INFINITY x'::float8; SELECT 'Infinity'::float8 + 100.0; SELECT 'Infinity'::float8 / 'Infinity'::float8; SELECT 'nan'::float8 / 'nan'::float8; +SELECT 'nan'::numeric::float8; SELECT '' AS five, * FROM FLOAT8_TBL; |
