[MDEV-7514] GIS: PointOnSurface returns NULL instead of the point - Jira

XML

Word

Printable

10.1 tree
MariaDB [test]> SELECT ST_AsText(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_AsText(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))'))) \|
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------+
\| NULL \|
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

PostGIS
pgis=# SELECT ST_AsText(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_astext
-----------------------------------
POINT(-70.9510231824279 42.09385)
(1 row)

The shape is rather simple (see the picture).

relates to

MDEV-7509 Testing for GIS extensions

MDEV-35766 ST_PointOnSurface returns NULL with Polygon in some case