[postgis-tickets] [PostGIS] #3011: ST_EstimatedExtent return a incorrect extent value

[PostGIS]

#3011: ST_EstimatedExtent return a incorrect extent value
--------------------------------+-------------------------------------------
 Reporter:  rockyc              |       Owner:  pramsey
     Type:  defect              |      Status:  new    
 Priority:  medium              |   Milestone:         
Component:  postgis             |     Version:  2.1.x  
 Keywords:  ST_EstimatedExtent  |  
--------------------------------+-------------------------------------------
 I have a table, and do the following testing.

 1. Execute sql:
  vacuum analyze st_estimatedextent_test

 2. Execute the sql:
  select ST_EstimatedExtent('public','st_estimatedextent_test','geom');
 Get the result:
  BOX(96.6659851074219 -32.3140754699707,129.162185668945
 -10.3033857345581)

 3. reinsert a existing row by executing the sql:
  insert into st_estimatedextent_test select gid,geom from
 st_estimatedextent_test where gid = 1;

 4. Execute sql
  vacuum analyze st_estimatedextent_test;

 5. Execute the sql
  select ST_EstimatedExtent('public','st_estimatedextent_test','geom');
 Get the result:
  BOX(105.510528564453 -32.3140754699707,129.118179321289
 -10.3033857345581)

 I think the correct result should be:
  BOX(96.6659851074219 -32.3140754699707,129.162185668945
 -10.3033857345581), returned in the step 2

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