[postgis-tickets] [PostGIS] #4337: ST_Intersects on infinite numbers

[PostGIS]

#4337: ST_Intersects on infinite numbers
---------------------+---------------------------
 Reporter:  komzpa   |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  medium   |  Milestone:  PostGIS 2.5.2
Component:  postgis  |    Version:  2.4.x
 Keywords:           |
---------------------+---------------------------
 I have a table with geometries I have gotten by dumping a world raster in
 EPSG:54009 and projecting to EPSG:3857. QGIS shows table in project good
 enough.

 Identify tool in qgis stops working and barks a warning:

 {{{
 2019-03-05T11:36:36     WARNING    Fetching from cursor qgis_3 failed
              Database error: ERROR: GEOSIntersects:
 IllegalArgumentException: RobustDeterminant encountered non-finite numbers

 2019-03-05T11:36:36     WARNING    Query: CLOSE qgis_3 returned 7 [ERROR:
 current transaction is aborted, commands ignored until end of transaction
 block
              ]
 2019-03-05T11:36:36     WARNING    1 cursor states lost.
              SQL: CLOSE qgis_3
              Result: 7 (ERROR: current transaction is aborted, commands
 ignored until end of transaction block
              )
 }}}

 I believe if we're sure geometry is offscreen we can handle the infininty
 intersects with a point or box in screen by telling "it doesn't
 intersect".

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4337>
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.