[PostGIS] #5734: Wrong ST_EstimatedExtent result for geography column

PostGIS trac at osgeo.org
Wed May 22 03:26:33 PDT 2024


#5734: Wrong ST_EstimatedExtent result for geography column
---------------------+---------------------------
 Reporter:  strk     |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  medium   |  Milestone:  PostGIS 3.4.3
Component:  postgis  |    Version:  3.4.x
 Keywords:           |
---------------------+---------------------------
 See this session:
 {{{
 strk=# select id, st_astext(g) from qgis_issue_30294;
  id |   st_astext
 ----+----------------
   1 | POINT(-10 -10)
   2 | POINT(20 30)
 (2 rows)

 strk=# analyze qgis_issue_30294;
 ANALYZE
 strk=# select st_estimatedextent('qgis_issue_30294', 'g');
                               st_estimatedextent
 -------------------------------------------------------------------------------
  BOX(0.813017427921295 -0.173346117138863,0.970626592636108
 0.298534214496613)
 (1 row)
 }}}

 The `g` column is of geography type.
 The estimated extent is plain wrong
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5734>
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.


More information about the postgis-tickets mailing list