[postgis-tickets] [PostGIS] #5347: berries are crashing on garden tests ST_Intersection(geography, geography) infinite linestring and point

[PostGIS]

#5347: berries are crashing on garden tests ST_Intersection(geography, geography)
infinite linestring and point
---------------------+---------------------------
 Reporter:  robe     |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  blocker  |  Milestone:  PostGIS 3.0.9
Component:  postgis  |    Version:  master
 Keywords:           |
---------------------+---------------------------
 {{{
 SELECT ST_Intersection(geography(foo1.the_geom), geography(foo2.the_geom))
 As result, ST_AsText(foo1.the_geom) As ref1_geom, ST_AsText(foo2.the_geom)
 As ref2_geom
         FROM ((SELECT
 '0102000020E610000005000000000000000000F07F000000000000F07F000000000000F07F000000000000F07F000000000000F07F000000000000F07F000000000000F07F000000000000F07F000000000000F07F000000000000F07F'::geometry
 AS the_geom
                 )
                 ) As foo1 CROSS JOIN ((SELECT
 '0101000020E6100000000000000000F07F000000000000F07F'::geometry AS the_geom
 ) ) As foo2 LIMIT 10

 NOTICE:  Coordinate values were coerced into range [-180 -90, 180 90] for
 GEOGRAPHY
 NOTICE:  Coordinate values were coerced into range [-180 -90, 180 90] for
 GEOGRAPHY
 server closed the connection unexpectedly
         This probably means the server terminated abnormally
         before or while processing the request.
 connection to server was lost

 }}}


 when I run this on my system I don't get a crash though, I get

 {{{
 NOTICE:  Coordinate values were coerced into range [-180 -90, 180 90] for
 GEOGRAPHY
 NOTICE:  Coordinate values were coerced into range [-180 -90, 180 90] for
 GEOGRAPHY

 ERROR:  Cannot find SRID (-2146484647) in spatial_ref_sys
 CONTEXT:  SQL function "st_intersection" statement 1
 SQL state: XX000
 }}}

 So crash I guess might be ARM specific, though having a crazy srid is not
 that helpful either.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5347>
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.