[postgis-devel] [PostGIS] #1200: st_estimated_extent returns bogus values

[PostGIS]

#1200: st_estimated_extent returns bogus values
----------------------+-----------------------------------------------------
 Reporter:  dmiranda  |       Owner:  pramsey      
     Type:  defect    |      Status:  new          
 Priority:  high      |   Milestone:  PostGIS 2.0.0
Component:  postgis   |     Version:  trunk        
 Keywords:            |  
----------------------+-----------------------------------------------------
 How to reproduce:
   -load the attached dataset (two rectangles)
   -run vacuum analyze on the table
   -run
    select st_estimated_extent('estimate_extents_fails_on_this','geom');
   -a bogus result should ensue, like this one:
 "BOX(-1703756553.3167 0,0 0)"

 The correct result is:
 select st_extent(geom) from estimate_extents_fails_on_this;
 "BOX(-55.8796586329487 -28.9576596206607,-53.0671265720575
 -27.1734940596501)"

 Tested with postgis 2.0.0, geos 3.2.2 & geos 3.4 SVN
 select postgis_full_version();
 "POSTGIS="2.0.0SVN" GEOS="3.2.2-CAPI-1.6.2" PROJ="Rel. 4.7.1, 23 September
 2009" LIBXML="2.7.8" USE_STATS"
 Exact postgis version is R7856 Last Changed Date: 2011-09-15 14:43:57

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