v1-0001-Fortify-float4-and-float8-tests-by-ordering-test-.patch
application/octet-stream
Filename: v1-0001-Fortify-float4-and-float8-tests-by-ordering-test-.patch
Type: application/octet-stream
Part: 0
Patch
Same data as JSON:
GET /api/v1/attachments/:id/patch
the parsed metadata as JSON — format, series position, per-file stats; never the diff bytes.
API reference →
Format: format-patch
Series: patch v1-0001
Subject: Fortify float4 and float8 tests by ordering test results
| File | + | − |
|---|---|---|
| src/test/regress/expected/float4.out | 35 | 35 |
| src/test/regress/expected/float8.out | 54 | 54 |
| src/test/regress/sql/float4.sql | 14 | 14 |
| src/test/regress/sql/float8.sql | 22 | 22 |
From bec122b31257ecf9f0fd84f6c957d436b9c96225 Mon Sep 17 00:00:00 2001
From: Pavel Borisov <pashkin.elfe@gmail.com>
Date: Tue, 22 Apr 2025 17:17:38 +0400
Subject: [PATCH v1] Fortify float4 and float8 tests by ordering test results
---
src/test/regress/expected/float4.out | 70 ++++++++---------
src/test/regress/expected/float8.out | 108 +++++++++++++--------------
src/test/regress/sql/float4.sql | 28 +++----
src/test/regress/sql/float8.sql | 44 +++++------
4 files changed, 125 insertions(+), 125 deletions(-)
diff --git a/src/test/regress/expected/float4.out b/src/test/regress/expected/float4.out
index 1d21c4390ad..90b319e4737 100644
--- a/src/test/regress/expected/float4.out
+++ b/src/test/regress/expected/float4.out
@@ -186,136 +186,136 @@ SELECT 'nan'::numeric::float4;
NaN
(1 row)
-SELECT * FROM FLOAT4_TBL;
+SELECT * FROM FLOAT4_TBL ORDER BY 1;
f1
---------------
+ -34.84
0
+ 1.2345679e-20
1004.3
- -34.84
1.2345679e+20
- 1.2345679e-20
(5 rows)
-SELECT f.* FROM FLOAT4_TBL f WHERE f.f1 <> '1004.3';
+SELECT f.* FROM FLOAT4_TBL f WHERE f.f1 <> '1004.3' ORDER BY 1;
f1
---------------
- 0
-34.84
- 1.2345679e+20
+ 0
1.2345679e-20
+ 1.2345679e+20
(4 rows)
-SELECT f.* FROM FLOAT4_TBL f WHERE f.f1 = '1004.3';
+SELECT f.* FROM FLOAT4_TBL f WHERE f.f1 = '1004.3' ORDER BY 1;
f1
--------
1004.3
(1 row)
-SELECT f.* FROM FLOAT4_TBL f WHERE '1004.3' > f.f1;
+SELECT f.* FROM FLOAT4_TBL f WHERE '1004.3' > f.f1 ORDER BY 1;
f1
---------------
- 0
-34.84
+ 0
1.2345679e-20
(3 rows)
-SELECT f.* FROM FLOAT4_TBL f WHERE f.f1 < '1004.3';
+SELECT f.* FROM FLOAT4_TBL f WHERE f.f1 < '1004.3' ORDER BY 1;
f1
---------------
- 0
-34.84
+ 0
1.2345679e-20
(3 rows)
-SELECT f.* FROM FLOAT4_TBL f WHERE '1004.3' >= f.f1;
+SELECT f.* FROM FLOAT4_TBL f WHERE '1004.3' >= f.f1 ORDER BY 1;
f1
---------------
- 0
- 1004.3
-34.84
+ 0
1.2345679e-20
+ 1004.3
(4 rows)
-SELECT f.* FROM FLOAT4_TBL f WHERE f.f1 <= '1004.3';
+SELECT f.* FROM FLOAT4_TBL f WHERE f.f1 <= '1004.3' ORDER BY 1;
f1
---------------
- 0
- 1004.3
-34.84
+ 0
1.2345679e-20
+ 1004.3
(4 rows)
SELECT f.f1, f.f1 * '-10' AS x FROM FLOAT4_TBL f
- WHERE f.f1 > '0.0';
+ WHERE f.f1 > '0.0' ORDER BY 1;
f1 | x
---------------+----------------
+ 1.2345679e-20 | -1.2345678e-19
1004.3 | -10043
1.2345679e+20 | -1.2345678e+21
- 1.2345679e-20 | -1.2345678e-19
(3 rows)
SELECT f.f1, f.f1 + '-10' AS x FROM FLOAT4_TBL f
- WHERE f.f1 > '0.0';
+ WHERE f.f1 > '0.0' ORDER BY 1;
f1 | x
---------------+---------------
+ 1.2345679e-20 | -10
1004.3 | 994.3
1.2345679e+20 | 1.2345679e+20
- 1.2345679e-20 | -10
(3 rows)
SELECT f.f1, f.f1 / '-10' AS x FROM FLOAT4_TBL f
- WHERE f.f1 > '0.0';
+ WHERE f.f1 > '0.0' ORDER BY 1;
f1 | x
---------------+----------------
+ 1.2345679e-20 | -1.2345679e-21
1004.3 | -100.43
1.2345679e+20 | -1.2345679e+19
- 1.2345679e-20 | -1.2345679e-21
(3 rows)
SELECT f.f1, f.f1 - '-10' AS x FROM FLOAT4_TBL f
- WHERE f.f1 > '0.0';
+ WHERE f.f1 > '0.0' ORDER BY 1;
f1 | x
---------------+---------------
+ 1.2345679e-20 | 10
1004.3 | 1014.3
1.2345679e+20 | 1.2345679e+20
- 1.2345679e-20 | 10
(3 rows)
-- test divide by zero
SELECT f.f1 / '0.0' from FLOAT4_TBL f;
ERROR: division by zero
-SELECT * FROM FLOAT4_TBL;
+SELECT * FROM FLOAT4_TBL ORDER BY 1;
f1
---------------
+ -34.84
0
+ 1.2345679e-20
1004.3
- -34.84
1.2345679e+20
- 1.2345679e-20
(5 rows)
-- test the unary float4abs operator
-SELECT f.f1, @f.f1 AS abs_f1 FROM FLOAT4_TBL f;
+SELECT f.f1, @f.f1 AS abs_f1 FROM FLOAT4_TBL f ORDER BY 1;
f1 | abs_f1
---------------+---------------
+ -34.84 | 34.84
0 | 0
+ 1.2345679e-20 | 1.2345679e-20
1004.3 | 1004.3
- -34.84 | 34.84
1.2345679e+20 | 1.2345679e+20
- 1.2345679e-20 | 1.2345679e-20
(5 rows)
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..19984a925ee 100644
--- a/src/test/regress/expected/float8.out
+++ b/src/test/regress/expected/float8.out
@@ -173,103 +173,103 @@ SELECT 'nan'::numeric::float8;
NaN
(1 row)
-SELECT * FROM FLOAT8_TBL;
+SELECT * FROM FLOAT8_TBL ORDER BY 1;
f1
----------------------
+ -34.84
0
+ 1.2345678901234e-200
1004.3
- -34.84
1.2345678901234e+200
- 1.2345678901234e-200
(5 rows)
-SELECT f.* FROM FLOAT8_TBL f WHERE f.f1 <> '1004.3';
+SELECT f.* FROM FLOAT8_TBL f WHERE f.f1 <> '1004.3' ORDER BY 1;
f1
----------------------
- 0
-34.84
- 1.2345678901234e+200
+ 0
1.2345678901234e-200
+ 1.2345678901234e+200
(4 rows)
-SELECT f.* FROM FLOAT8_TBL f WHERE f.f1 = '1004.3';
+SELECT f.* FROM FLOAT8_TBL f WHERE f.f1 = '1004.3' ORDER BY 1;
f1
--------
1004.3
(1 row)
-SELECT f.* FROM FLOAT8_TBL f WHERE '1004.3' > f.f1;
+SELECT f.* FROM FLOAT8_TBL f WHERE '1004.3' > f.f1 ORDER BY 1;
f1
----------------------
- 0
-34.84
+ 0
1.2345678901234e-200
(3 rows)
-SELECT f.* FROM FLOAT8_TBL f WHERE f.f1 < '1004.3';
+SELECT f.* FROM FLOAT8_TBL f WHERE f.f1 < '1004.3' ORDER BY 1;
f1
----------------------
- 0
-34.84
+ 0
1.2345678901234e-200
(3 rows)
-SELECT f.* FROM FLOAT8_TBL f WHERE '1004.3' >= f.f1;
+SELECT f.* FROM FLOAT8_TBL f WHERE '1004.3' >= f.f1 ORDER BY 1;
f1
----------------------
- 0
- 1004.3
-34.84
+ 0
1.2345678901234e-200
+ 1004.3
(4 rows)
-SELECT f.* FROM FLOAT8_TBL f WHERE f.f1 <= '1004.3';
+SELECT f.* FROM FLOAT8_TBL f WHERE f.f1 <= '1004.3' ORDER BY 1;
f1
----------------------
- 0
- 1004.3
-34.84
+ 0
1.2345678901234e-200
+ 1004.3
(4 rows)
SELECT f.f1, f.f1 * '-10' AS x
FROM FLOAT8_TBL f
- WHERE f.f1 > '0.0';
+ WHERE f.f1 > '0.0' ORDER BY 1;
f1 | x
----------------------+-----------------------
+ 1.2345678901234e-200 | -1.2345678901234e-199
1004.3 | -10043
1.2345678901234e+200 | -1.2345678901234e+201
- 1.2345678901234e-200 | -1.2345678901234e-199
(3 rows)
SELECT f.f1, f.f1 + '-10' AS x
FROM FLOAT8_TBL f
- WHERE f.f1 > '0.0';
+ WHERE f.f1 > '0.0' ORDER BY 1;
f1 | x
----------------------+----------------------
+ 1.2345678901234e-200 | -10
1004.3 | 994.3
1.2345678901234e+200 | 1.2345678901234e+200
- 1.2345678901234e-200 | -10
(3 rows)
SELECT f.f1, f.f1 / '-10' AS x
FROM FLOAT8_TBL f
- WHERE f.f1 > '0.0';
+ WHERE f.f1 > '0.0' ORDER BY 1;
f1 | x
----------------------+-----------------------
+ 1.2345678901234e-200 | -1.2345678901234e-201
1004.3 | -100.42999999999999
1.2345678901234e+200 | -1.2345678901234e+199
- 1.2345678901234e-200 | -1.2345678901234e-201
(3 rows)
SELECT f.f1, f.f1 - '-10' AS x
FROM FLOAT8_TBL f
- WHERE f.f1 > '0.0';
+ WHERE f.f1 > '0.0' ORDER BY 1;
f1 | x
----------------------+----------------------
+ 1.2345678901234e-200 | 10
1004.3 | 1014.3
1.2345678901234e+200 | 1.2345678901234e+200
- 1.2345678901234e-200 | 10
(3 rows)
SELECT f.f1 ^ '2.0' AS square_f1
@@ -281,38 +281,38 @@ SELECT f.f1 ^ '2.0' AS square_f1
-- absolute value
SELECT f.f1, @f.f1 AS abs_f1
- FROM FLOAT8_TBL f;
+ FROM FLOAT8_TBL f ORDER BY 1;
f1 | abs_f1
----------------------+----------------------
+ -34.84 | 34.84
0 | 0
+ 1.2345678901234e-200 | 1.2345678901234e-200
1004.3 | 1004.3
- -34.84 | 34.84
1.2345678901234e+200 | 1.2345678901234e+200
- 1.2345678901234e-200 | 1.2345678901234e-200
(5 rows)
-- truncate
SELECT f.f1, trunc(f.f1) AS trunc_f1
- FROM FLOAT8_TBL f;
+ FROM FLOAT8_TBL f ORDER BY 1;
f1 | trunc_f1
----------------------+----------------------
+ -34.84 | -34
0 | 0
+ 1.2345678901234e-200 | 0
1004.3 | 1004
- -34.84 | -34
1.2345678901234e+200 | 1.2345678901234e+200
- 1.2345678901234e-200 | 0
(5 rows)
-- round
SELECT f.f1, round(f.f1) AS round_f1
- FROM FLOAT8_TBL f;
+ FROM FLOAT8_TBL f ORDER BY 1;
f1 | round_f1
----------------------+----------------------
+ -34.84 | -35
0 | 0
+ 1.2345678901234e-200 | 0
1004.3 | 1004
- -34.84 | -35
1.2345678901234e+200 | 1.2345678901234e+200
- 1.2345678901234e-200 | 0
(5 rows)
-- ceil / ceiling
@@ -375,12 +375,12 @@ SELECT |/ float8 '64' AS eight;
SELECT f.f1, |/f.f1 AS sqrt_f1
FROM FLOAT8_TBL f
- WHERE f.f1 > '0.0';
+ WHERE f.f1 > '0.0' ORDER BY 1;
f1 | sqrt_f1
----------------------+-----------------------
+ 1.2345678901234e-200 | 1.11111110611109e-100
1004.3 | 31.6906926399535
1.2345678901234e+200 | 1.11111110611109e+100
- 1.2345678901234e-200 | 1.11111110611109e-100
(3 rows)
-- power
@@ -585,12 +585,12 @@ SELECT power(float8 '-inf', float8 '-inf');
-- take exp of ln(f.f1)
SELECT f.f1, exp(ln(f.f1)) AS exp_ln_f1
FROM FLOAT8_TBL f
- WHERE f.f1 > '0.0';
+ WHERE f.f1 > '0.0' ORDER BY 1;
f1 | exp_ln_f1
----------------------+-----------------------
+ 1.2345678901234e-200 | 1.23456789012339e-200
1004.3 | 1004.3
1.2345678901234e+200 | 1.23456789012338e+200
- 1.2345678901234e-200 | 1.23456789012339e-200
(3 rows)
-- check edge cases for exp
@@ -607,24 +607,24 @@ SELECT ||/ float8 '27' AS three;
3
(1 row)
-SELECT f.f1, ||/f.f1 AS cbrt_f1 FROM FLOAT8_TBL f;
+SELECT f.f1, ||/f.f1 AS cbrt_f1 FROM FLOAT8_TBL f ORDER BY 1;
f1 | cbrt_f1
----------------------+----------------------
+ -34.84 | -3.26607421344208
0 | 0
+ 1.2345678901234e-200 | 2.3112042409018e-67
1004.3 | 10.014312837827
- -34.84 | -3.26607421344208
1.2345678901234e+200 | 4.97933859234765e+66
- 1.2345678901234e-200 | 2.3112042409018e-67
(5 rows)
-SELECT * FROM FLOAT8_TBL;
+SELECT * FROM FLOAT8_TBL ORDER BY 1;
f1
----------------------
+ -34.84
0
+ 1.2345678901234e-200
1004.3
- -34.84
1.2345678901234e+200
- 1.2345678901234e-200
(5 rows)
UPDATE FLOAT8_TBL
@@ -640,22 +640,22 @@ SELECT 0 ^ 0 + 0 ^ 1 + 0 ^ 0.0 + 0 ^ 0.5;
2
(1 row)
-SELECT ln(f.f1) from FLOAT8_TBL f where f.f1 = '0.0' ;
+SELECT ln(f.f1) from FLOAT8_TBL f where f.f1 = '0.0';
ERROR: cannot take logarithm of zero
-SELECT ln(f.f1) from FLOAT8_TBL f where f.f1 < '0.0' ;
+SELECT ln(f.f1) from FLOAT8_TBL f where f.f1 < '0.0';
ERROR: cannot take logarithm of a negative number
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
@@ -906,14 +906,14 @@ LINE 1: INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e-400');
^
DROP TABLE FLOAT8_TBL;
-- Check the float8 values exported for use by other tests
-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)
-- test edge-case coercions to integer
diff --git a/src/test/regress/sql/float4.sql b/src/test/regress/sql/float4.sql
index 8fb12368c39..f13cb7c50f8 100644
--- a/src/test/regress/sql/float4.sql
+++ b/src/test/regress/sql/float4.sql
@@ -60,45 +60,45 @@ SELECT 'nan'::float4 / 'nan'::float4;
SELECT 'nan'::float4 / '0'::float4;
SELECT 'nan'::numeric::float4;
-SELECT * FROM FLOAT4_TBL;
+SELECT * FROM FLOAT4_TBL ORDER BY 1;
-SELECT f.* FROM FLOAT4_TBL f WHERE f.f1 <> '1004.3';
+SELECT f.* FROM FLOAT4_TBL f WHERE f.f1 <> '1004.3' ORDER BY 1;
-SELECT f.* FROM FLOAT4_TBL f WHERE f.f1 = '1004.3';
+SELECT f.* FROM FLOAT4_TBL f WHERE f.f1 = '1004.3' ORDER BY 1;
-SELECT f.* FROM FLOAT4_TBL f WHERE '1004.3' > f.f1;
+SELECT f.* FROM FLOAT4_TBL f WHERE '1004.3' > f.f1 ORDER BY 1;
-SELECT f.* FROM FLOAT4_TBL f WHERE f.f1 < '1004.3';
+SELECT f.* FROM FLOAT4_TBL f WHERE f.f1 < '1004.3' ORDER BY 1;
-SELECT f.* FROM FLOAT4_TBL f WHERE '1004.3' >= f.f1;
+SELECT f.* FROM FLOAT4_TBL f WHERE '1004.3' >= f.f1 ORDER BY 1;
-SELECT f.* FROM FLOAT4_TBL f WHERE f.f1 <= '1004.3';
+SELECT f.* FROM FLOAT4_TBL f WHERE f.f1 <= '1004.3' ORDER BY 1;
SELECT f.f1, f.f1 * '-10' AS x FROM FLOAT4_TBL f
- WHERE f.f1 > '0.0';
+ WHERE f.f1 > '0.0' ORDER BY 1;
SELECT f.f1, f.f1 + '-10' AS x FROM FLOAT4_TBL f
- WHERE f.f1 > '0.0';
+ WHERE f.f1 > '0.0' ORDER BY 1;
SELECT f.f1, f.f1 / '-10' AS x FROM FLOAT4_TBL f
- WHERE f.f1 > '0.0';
+ WHERE f.f1 > '0.0' ORDER BY 1;
SELECT f.f1, f.f1 - '-10' AS x FROM FLOAT4_TBL f
- WHERE f.f1 > '0.0';
+ WHERE f.f1 > '0.0' ORDER BY 1;
-- test divide by zero
SELECT f.f1 / '0.0' from FLOAT4_TBL f;
-SELECT * FROM FLOAT4_TBL;
+SELECT * FROM FLOAT4_TBL ORDER BY 1;
-- test the unary float4abs operator
-SELECT f.f1, @f.f1 AS abs_f1 FROM FLOAT4_TBL f;
+SELECT f.f1, @f.f1 AS abs_f1 FROM FLOAT4_TBL f ORDER BY 1;
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..e7b8ac8fbb1 100644
--- a/src/test/regress/sql/float8.sql
+++ b/src/test/regress/sql/float8.sql
@@ -58,50 +58,50 @@ SELECT 'nan'::float8 / 'nan'::float8;
SELECT 'nan'::float8 / '0'::float8;
SELECT 'nan'::numeric::float8;
-SELECT * FROM FLOAT8_TBL;
+SELECT * FROM FLOAT8_TBL ORDER BY 1;
-SELECT f.* FROM FLOAT8_TBL f WHERE f.f1 <> '1004.3';
+SELECT f.* FROM FLOAT8_TBL f WHERE f.f1 <> '1004.3' ORDER BY 1;
-SELECT f.* FROM FLOAT8_TBL f WHERE f.f1 = '1004.3';
+SELECT f.* FROM FLOAT8_TBL f WHERE f.f1 = '1004.3' ORDER BY 1;
-SELECT f.* FROM FLOAT8_TBL f WHERE '1004.3' > f.f1;
+SELECT f.* FROM FLOAT8_TBL f WHERE '1004.3' > f.f1 ORDER BY 1;
-SELECT f.* FROM FLOAT8_TBL f WHERE f.f1 < '1004.3';
+SELECT f.* FROM FLOAT8_TBL f WHERE f.f1 < '1004.3' ORDER BY 1;
-SELECT f.* FROM FLOAT8_TBL f WHERE '1004.3' >= f.f1;
+SELECT f.* FROM FLOAT8_TBL f WHERE '1004.3' >= f.f1 ORDER BY 1;
-SELECT f.* FROM FLOAT8_TBL f WHERE f.f1 <= '1004.3';
+SELECT f.* FROM FLOAT8_TBL f WHERE f.f1 <= '1004.3' ORDER BY 1;
SELECT f.f1, f.f1 * '-10' AS x
FROM FLOAT8_TBL f
- WHERE f.f1 > '0.0';
+ WHERE f.f1 > '0.0' ORDER BY 1;
SELECT f.f1, f.f1 + '-10' AS x
FROM FLOAT8_TBL f
- WHERE f.f1 > '0.0';
+ WHERE f.f1 > '0.0' ORDER BY 1;
SELECT f.f1, f.f1 / '-10' AS x
FROM FLOAT8_TBL f
- WHERE f.f1 > '0.0';
+ WHERE f.f1 > '0.0' ORDER BY 1;
SELECT f.f1, f.f1 - '-10' AS x
FROM FLOAT8_TBL f
- WHERE f.f1 > '0.0';
+ WHERE f.f1 > '0.0' ORDER BY 1;
SELECT f.f1 ^ '2.0' AS square_f1
FROM FLOAT8_TBL f where f.f1 = '1004.3';
-- absolute value
SELECT f.f1, @f.f1 AS abs_f1
- FROM FLOAT8_TBL f;
+ FROM FLOAT8_TBL f ORDER BY 1;
-- truncate
SELECT f.f1, trunc(f.f1) AS trunc_f1
- FROM FLOAT8_TBL f;
+ FROM FLOAT8_TBL f ORDER BY 1;
-- round
SELECT f.f1, round(f.f1) AS round_f1
- FROM FLOAT8_TBL f;
+ FROM FLOAT8_TBL f ORDER BY 1;
-- ceil / ceiling
select ceil(f1) as ceil_f1 from float8_tbl f;
@@ -123,7 +123,7 @@ SELECT |/ float8 '64' AS eight;
SELECT f.f1, |/f.f1 AS sqrt_f1
FROM FLOAT8_TBL f
- WHERE f.f1 > '0.0';
+ WHERE f.f1 > '0.0' ORDER BY 1;
-- power
SELECT power(float8 '144', float8 '0.5');
@@ -166,7 +166,7 @@ SELECT power(float8 '-inf', float8 '-inf');
-- take exp of ln(f.f1)
SELECT f.f1, exp(ln(f.f1)) AS exp_ln_f1
FROM FLOAT8_TBL f
- WHERE f.f1 > '0.0';
+ WHERE f.f1 > '0.0' ORDER BY 1;
-- check edge cases for exp
SELECT exp('inf'::float8), exp('-inf'::float8), exp('nan'::float8);
@@ -174,10 +174,10 @@ SELECT exp('inf'::float8), exp('-inf'::float8), exp('nan'::float8);
-- cube root
SELECT ||/ float8 '27' AS three;
-SELECT f.f1, ||/f.f1 AS cbrt_f1 FROM FLOAT8_TBL f;
+SELECT f.f1, ||/f.f1 AS cbrt_f1 FROM FLOAT8_TBL f ORDER BY 1;
-SELECT * FROM FLOAT8_TBL;
+SELECT * FROM FLOAT8_TBL ORDER BY 1;
UPDATE FLOAT8_TBL
SET f1 = FLOAT8_TBL.f1 * '-1'
@@ -189,15 +189,15 @@ SELECT f.f1 ^ '1e200' from FLOAT8_TBL f;
SELECT 0 ^ 0 + 0 ^ 1 + 0 ^ 0.0 + 0 ^ 0.5;
-SELECT ln(f.f1) from FLOAT8_TBL f where f.f1 = '0.0' ;
+SELECT ln(f.f1) from FLOAT8_TBL f where f.f1 = '0.0';
-SELECT ln(f.f1) from FLOAT8_TBL f where f.f1 < '0.0' ;
+SELECT ln(f.f1) from FLOAT8_TBL f where f.f1 < '0.0';
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
@@ -281,7 +281,7 @@ DROP TABLE FLOAT8_TBL;
-- Check the float8 values exported for use by other tests
-SELECT * FROM FLOAT8_TBL;
+SELECT * FROM FLOAT8_TBL ORDER BY 1;
-- test edge-case coercions to integer
SELECT '32767.4'::float8::int2;
--
2.39.2 (Apple Git-143)