diff options
Diffstat (limited to 'src')
-rw-r--r-- | src/test/regress/expected/float4-misrounded-input.out | 8 | ||||
-rw-r--r-- | src/test/regress/expected/float4.out | 8 | ||||
-rw-r--r-- | src/test/regress/expected/float8.out | 8 | ||||
-rw-r--r-- | src/test/regress/sql/float4.sql | 2 | ||||
-rw-r--r-- | src/test/regress/sql/float8.sql | 2 |
5 files changed, 14 insertions, 14 deletions
diff --git a/src/test/regress/expected/float4-misrounded-input.out b/src/test/regress/expected/float4-misrounded-input.out index 20fd7139136..61c68a6c9ff 100644 --- a/src/test/regress/expected/float4-misrounded-input.out +++ b/src/test/regress/expected/float4-misrounded-input.out @@ -308,14 +308,14 @@ SELECT f.f1, @f.f1 AS abs_f1 FROM FLOAT4_TBL f; UPDATE FLOAT4_TBL SET f1 = FLOAT4_TBL.f1 * '-1' WHERE FLOAT4_TBL.f1 > '0.0'; -SELECT * FROM FLOAT4_TBL; +SELECT * FROM FLOAT4_TBL ORDER BY 1; f1 ---------------- - 0 - -34.84 - -1004.3 -1.2345679e+20 + -1004.3 + -34.84 -1.2345679e-20 + 0 (5 rows) -- test edge-case coercions to integer diff --git a/src/test/regress/expected/float4.out b/src/test/regress/expected/float4.out index 1d21c4390ad..eaed1f2bfe7 100644 --- a/src/test/regress/expected/float4.out +++ b/src/test/regress/expected/float4.out @@ -308,14 +308,14 @@ SELECT f.f1, @f.f1 AS abs_f1 FROM FLOAT4_TBL f; UPDATE FLOAT4_TBL SET f1 = FLOAT4_TBL.f1 * '-1' WHERE FLOAT4_TBL.f1 > '0.0'; -SELECT * FROM FLOAT4_TBL; +SELECT * FROM FLOAT4_TBL ORDER BY 1; f1 ---------------- - 0 - -34.84 - -1004.3 -1.2345679e+20 + -1004.3 + -34.84 -1.2345679e-20 + 0 (5 rows) -- test edge-case coercions to integer diff --git a/src/test/regress/expected/float8.out b/src/test/regress/expected/float8.out index 10a5a6e1b65..9c519f1a1a1 100644 --- a/src/test/regress/expected/float8.out +++ b/src/test/regress/expected/float8.out @@ -648,14 +648,14 @@ SELECT exp(f.f1) from FLOAT8_TBL f; ERROR: value out of range: underflow SELECT f.f1 / '0.0' from FLOAT8_TBL f; ERROR: division by zero -SELECT * FROM FLOAT8_TBL; +SELECT * FROM FLOAT8_TBL ORDER BY 1; f1 ----------------------- - 0 - -34.84 - -1004.3 -1.2345678901234e+200 + -1004.3 + -34.84 -1.2345678901234e-200 + 0 (5 rows) -- hyperbolic functions diff --git a/src/test/regress/sql/float4.sql b/src/test/regress/sql/float4.sql index 8fb12368c39..44418a64002 100644 --- a/src/test/regress/sql/float4.sql +++ b/src/test/regress/sql/float4.sql @@ -98,7 +98,7 @@ UPDATE FLOAT4_TBL SET f1 = FLOAT4_TBL.f1 * '-1' WHERE FLOAT4_TBL.f1 > '0.0'; -SELECT * FROM FLOAT4_TBL; +SELECT * FROM FLOAT4_TBL ORDER BY 1; -- test edge-case coercions to integer SELECT '32767.4'::float4::int2; diff --git a/src/test/regress/sql/float8.sql b/src/test/regress/sql/float8.sql index db8d5724c25..0ef271f2702 100644 --- a/src/test/regress/sql/float8.sql +++ b/src/test/regress/sql/float8.sql @@ -197,7 +197,7 @@ SELECT exp(f.f1) from FLOAT8_TBL f; SELECT f.f1 / '0.0' from FLOAT8_TBL f; -SELECT * FROM FLOAT8_TBL; +SELECT * FROM FLOAT8_TBL ORDER BY 1; -- hyperbolic functions -- we run these with extra_float_digits = 0 too, since different platforms |