[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