[postgis-tickets] [PostGIS] #2370: ST_EstimatedExtent bug

[PostGIS]

#2370: ST_EstimatedExtent bug
---------------------+------------------------------------------------------
 Reporter:  strk     |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  blocker  |   Milestone:  PostGIS 2.1.0
Component:  postgis  |     Version:  2.1.x        
 Keywords:           |  
---------------------+------------------------------------------------------
 {{{
 CREATE TABLE public.source (g GEOMETRY);
 INSERT INTO public.source VALUES
  ('POINT(0 2047)'),
  ('POINT(0 0)'),
  ('POINT(2047 0)')
  ;
 ANALYZE source;
 SELECT ST_Extent(g) FROM source;
 SELECT ST_Estimated_Extent('public', 'source', 'g');
 }}}

 Real extent:  BOX(0 0,2047 2047)
 Estimated:  BOX(-10.2349996566772 -10.2349996566772,2057.23510742188
 2057.23510742188)

 You can see it's not "just" a precision issue, but the minx and miny are
 off by 10 !

 PostGIS 1.5 and 2.0 are immune.

 The bogus one is POSTGIS="2.1.0beta3dev r11564"

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