[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