[postgis-devel] [PostGIS] #258: ST_HausdorffDistance crashes server

PostGIS trac at osgeo.org
Mon Oct 5 05:56:58 PDT 2009


#258: ST_HausdorffDistance crashes server
---------------------+------------------------------------------------------
 Reporter:  robe     |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  medium   |   Milestone:  postgis 1.5.0
Component:  postgis  |     Version:  trunk        
 Keywords:           |  
---------------------+------------------------------------------------------
 This might be a GEOS problem so not really sure.  I'm running the latest
 trunk GEOS with PostgreSQL 8.4 on windows and latest PostGIS 1.5 trunk.

 This crashes server. If I leave out hausdorff works fine so must be
 something in the ST_HausdorffDistance that is doing it.

         SELECT ST_HausdorffDistance(foo1.the_geom, foo2.the_geom),
 ST_AsEWKT(foo1.the_geom) As ref1_geom, ST_AsEWKT(foo2.the_geom) As
 ref2_geom

                         FROM ((SELECT ST_SetSRID(ST_Point(i,j),4326) As
 the_geom
                 FROM generate_series(-10,50,15) As i
                         CROSS JOIN generate_series(40,70, 15) j
                         ORDER BY i,j
                         )) As foo1 CROSS JOIN ((SELECT
 ST_Buffer(ST_SetSRID(ST_Point(i,j),4326), j*0.05)  As the_geom
                 FROM generate_series(-10,50,10) As i
                         CROSS JOIN generate_series(40,70, 20) As j
                         ORDER BY i, i*j, j)) As foo2
                         LIMIT 2;

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/258>
PostGIS <http://trac.osgeo.org/postgis/>
PostGIS


More information about the postgis-devel mailing list