[postgis-tickets] [PostGIS] #5461: 32-bit failure and rounding issues on ST_LineSubstring for geography

[PostGIS]

#5461: 32-bit failure and rounding issues on ST_LineSubstring for geography
---------------------+---------------------------
 Reporter:  robe     |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  medium   |  Milestone:  PostGIS 3.4.0
Component:  postgis  |    Version:  master
 Keywords:           |
---------------------+---------------------------
 See test
 https://trac.osgeo.org/postgis/browser/git/regress/core/geography_interpolate.sql?rev=dfd5ff50b393dd98d44bf6f92f681121efd51697

 The test failing is:


 {{{
 SELECT round(MAX(ST_Length(ST_LineSubstring(g, 0.5, 0.7)))::numeric, 6)
 FROM tbl_geog_linestring3D;
 }}}

 Errors on gitlab and berrie 32-bit cis (though bessie32 is fine)


 {{{
 {{{
 06:20:37  regress/core/geography_interpolate .. failed (diff expected
 obtained: /tmp/pgis_reg/test_115_diff)
 06:20:38
 -----------------------------------------------------------------------------
 06:20:38 --- ./regress/core/geography_interpolate_expected      2023-07-29
 04:11:12.380004361 -0600
 06:20:38 +++ /tmp/pgis_reg/test_115_out 2023-07-29 04:20:38.108382789
 -0600
 06:20:38 @@ -27,6 +27,6 @@
 06:20:38  4180892.366508
 06:20:38  297
 06:20:38  1
 06:20:38 -5520157.913043
 06:20:38 +inf
 06:20:38  4790369.580943
 06:20:38  3215502.296386
 06:20:38
 -----------------------------------------------------------------------------
 }}}

  gitlab 64-bit is also failing, but that looks to be a rounding difference

 {{{
 --- /builds/postgis/postgis/regress/core/geography_interpolate_expected
 2023-07-29 10:09:11.814967894 +0000
 +++ /tmp/pgis_reg/test_115_out  2023-07-29 10:14:05.882460007 +0000
 @@ -27,6 +27,6 @@
  4180892.366508
  297
  1
 -5520157.913043
 +5520157.912684
  4790369.580943
  3215502.296386
 -------------------
 }}}

 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5461>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.