Bug #79394 ST_Buffer does not work for non cartesian coordinates in MySQL v5.7
Submitted: 24 Nov 2015 7:55 Modified: 6 Jan 2016 16:32
Reporter: Nikolaos Priggouris Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: GIS Severity:S4 (Feature request)
Version:5.7.9 OS:Any
Assigned to: CPU Architecture:Any

[24 Nov 2015 7:55] Nikolaos Priggouris 
Description:
The MySql Reference manual (v5.7.9) states that ST_Buffer  supports only the cartesian coordinate system. 
This is quite limiting and renders the function almost useless. I know that spatial function were re-implemented in v5.7 but this function was working perfectly well for other SRIDs in MySQL v5.6.
I would like to ask whether there is a provision of making ST_Buffer usable irrespective of the SRID used in a future release? Also is there any workaround to circumvent this limitation?

thanks

How to repeat:
Function limitation. Any use of function with SRID !=0 fails
[3 Dec 2015 13:43] Erlend Dahl 
Thank you for the bug report.
[6 Jan 2016 16:32] Paul DuBois 
Noted in 5.7.11, 5.8.0 changelogs.

ST_Buffer() returned an error for geometries with an SRID different
from 0. Nonzero SRID values now are permitted but ignored
(calculations are still done using Cartesian coordinates).