Running the regression tests on mingw32, I get the following diff in
circle.out:
@@ -111,8 +111,8 @@
WHERE (c1.f1 < c2.f1) AND ((c1.f1 <-> c2.f1) > 0)
ORDER BY distance, area(c1.f1), area(c2.f1);
five | one | two | distance
-------+----------------+----------------+------------------
- | <(3,5),0> | <(1,2),3> | 0.60555127546399
+------+----------------+----------------+-------------------
+ | <(3,5),0> | <(1,2),3> | 0.605551275463989
| <(3,5),0> | <(5,1),3> | 1.47213595499958
| <(100,200),10> | <(100,1),115> | 74
| <(100,200),10> | <(1,2),100> | 111.370729772479
I only get this on master/PG12, but not on PG11, so I suspect that the
new floating-point output routines could be the root of the issue.
This happens only with the 32-bit build (mingw32), but not with a 64-bit
build (mingw64).
Any suggestions on how to analyze this further?
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services