From ca3041883725393baa6c645050ef926d782eb3a8 Mon Sep 17 00:00:00 2001 From: Alexey Botchkov Date: Sun, 15 Mar 2015 11:17:50 +0400 Subject: MDEV-7514 GIS: PointOnSurface returns NULL instead of the point. Need to take into account cases of a polygon shaped as a very thin line. --- mysql-test/r/gis.result | 6 ++++++ 1 file changed, 6 insertions(+) (limited to 'mysql-test/r/gis.result') diff --git a/mysql-test/r/gis.result b/mysql-test/r/gis.result index f696466f38c..c3d9fa39270 100644 --- a/mysql-test/r/gis.result +++ b/mysql-test/r/gis.result @@ -1774,3 +1774,9 @@ ST_IsRing(ST_LineFromText('LINESTRING(0 0,0 10,10 10,0 0)')) select ST_IsRing(ST_LineFromText('LINESTRING(0 0,0 10,10 10,-10 -10, 0 -10, 0 0)')); ST_IsRing(ST_LineFromText('LINESTRING(0 0,0 10,10 10,-10 -10, 0 -10, 0 0)')) 0 +# +# MDEV-7514 GIS: PointOnSurface returns NULL instead of the point. +# +SELECT ST_GEOMETRYTYPE(ST_PointOnSurface(ST_PolyFromText('POLYGON((-70.916 42.1002,-70.9468 42.0946,-70.9754 42.0875,-70.9749 42.0879,-70.9759 42.0897,-70.916 42.1002))'))); +ST_GEOMETRYTYPE(ST_PointOnSurface(ST_PolyFromText('POLYGON((-70.916 42.1002,-70.9468 42.0946,-70.9754 42.0875,-70.9749 42.0879,-70.9759 42.0897,-70.916 42.1002))'))) +POINT -- cgit v1.2.1