Bug #77598 Add ST_NumInteriorRing alias for ST_NumInteriorRings
Submitted: 2 Jul 2015 10:48 Modified: 8 Jul 2015 22:12
Reporter: Norvald Ryeng Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: GIS Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any

[2 Jul 2015 10:48] Norvald Ryeng
Description:
SQL/MM and SFA-CA specify the name of the function as "ST_NumInteriorRing" (in singular), while MySQL has implemented the name "ST_NumInteriorRings" (in plural).

How to repeat:
SELECT ST_NUMINTERIORRING(ST_GEOMFROMTEXT('POLYGON((0 0, 1 0, 1 1, 0 1, 0 0))'));

Suggested fix:
Add an alias, but don't remove the plural form.
[8 Jul 2015 22:12] Paul DuBois
Noted in 5.7.8, 5.8.0 changelogs.

ST_NumInteriorRing() was added as more a standard-compliant alias of
ST_NumInteriorRings().