MySQL Bugs: #74737: The function Boundary() is documented, but it does not exist.

Bug #74737	The function Boundary() is documented, but it does not exist.
Submitted:	7 Nov 2014 15:03	Modified:	12 Nov 2014 21:56
Reporter:	Erik Frøseth	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:		OS:	Any
Assigned to:	Paul DuBois	CPU Architecture:	Any

Description:
The spatial function Boundary is documented in MySQL manual (see URL below), but it does not exist.

http://dev.mysql.com/doc/refman/5.7/en/spatial-function-reference.html

How to repeat:
mysql> SELECT Boundary(POINT(10, 10));
ERROR 1046 (3D000): No database selected

Suggested fix:
Remove Boundary() from documentation.

In what sense is this a bug? The function description is preceded by:

"The OpenGIS specification also defines the following functions, which MySQL does not implement:"

My apologies, you are correct. I only looked at the list under the URL originally provided, where it seemed to me that it was a MySQL function.

On the other hand, IsEmpty seems to be implemented:

mysql> SELECT IsEmpty(POINT(10, 10));
+------------------------+
| IsEmpty(POINT(10, 10)) |
+------------------------+
|                      0 |
+------------------------+
1 row in set (0.00 sec)

mysql> SELECT VERSION();
+------------+
| VERSION()  |
+------------+
| 5.6.21-log |
+------------+

Is this considered a bug? And if so, should a new one be opened, or could this one be changed?

http://dev.mysql.com/doc/refman/5.7/en/gis-general-property-functions.html#function_isempt... says this about IsEmpty():

This function is a placeholder that returns 0 for any valid geometry value, 1 for any invalid geometry value or NULL.

So while it's true that the function exists, it probably is not very useful.

But since Boundary() actually does *not* exist, I'll remove it from the documentation.

Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly.

Other unimplemented functions mentioned in the docs that have been removed:

http://dev.mysql.com/doc/refman/5.7/en/gis-multipolygon-property-functions.html
PointOnSurface() [5.0 .. 5.7]

http://dev.mysql.com/doc/refman/5.6/en/spatial-operator-functions.html
Buffer() [5.0 .. 5.5]
ConvexHull() [5.0 .. 5.6]
Difference() [5.0 .. 5.6]
Intersection() [5.0 .. 5.6]
SymDifference() [5.0 .. 5.6]
Union() [5.0 .. 5.6]