[postgis-tickets] [PostGIS] #3481: garden crash on ST_ClusterKMeans

PostGIS trac at osgeo.org
Mon Feb 29 05:39:16 PST 2016


#3481: garden crash on ST_ClusterKMeans
---------------------+---------------------------
 Reporter:  robe     |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  blocker  |  Milestone:  PostGIS 2.3.0
Component:  postgis  |    Version:  trunk
 Keywords:           |
---------------------+---------------------------
 Running on:

 {{{
 POSTGIS="2.3.0dev r14719" GEOS="3.5.0-CAPI-1.9.0 r4090" SFCGAL="1.2.2"
 PROJ="Rel. 4.9.1, 04 March 2015" GDAL="GDAL 2.0.1, released 2015/09/15"
 LIBXML="2.7.8" LIBJSON="0.12" RASTER PostgreSQL 9.5.1, compiled by Visual
 C++ build 1800, 64-bit
 }}}


 This is the actual one in garden test that crashes:


 {{{
 SELECT ST_ClusterKMeans(foo1.the_geom, 3)OVER()  As result
                                                         FROM ((SELECT
 ST_Collect(geom)  As the_geom
                 FROM (VALUES (
 ST_GeomFromText('SRID=4326;MULTIPOLYGON(((-71.0821 42.3036 2,-71.0822
 42.3036 2,-71.082 42.3038 2,-71.0819 42.3037 2,-71.0821 42.3036 2)))') ),
         ( ST_GeomFromText('SRID=4326;POLYGON((-71.1261 42.2703 1,-71.1257
 42.2703 1,-71.1257 42.2701 1,-71.126 42.2701 1,-71.1261 42.2702 1,-71.1261
 42.2703 1))') ) ) As g(geom) CROSS JOIN generate_series(1,3) As i GROUP BY
 i )) As foo1 LIMIT 3;
 }}}

 This is a simplified that also crashes:


 {{{
 SELECT ST_ClusterKMeans(geom,1) OVER()
 FROM (VALUES ( ST_GeomFromEWKT('SRID=4326;MULTIPOLYGON(((-71.0821 42.3036
 2,-71.0822 42.3036 2,-71.082 42.3038 2,-71.0819 42.3037 2,-71.0821 42.3036
 2)))') )
          ) As g(geom);
 }}}

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