This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-14. For the latest, interactive version please visit https://mariadb.com/kb/.

Created: 8 years, 5 months ago
Modified: 7 years, 8 months ago
Type: article
Status: active
License: CC BY-SA / Gnu FDL

Attachments

No attachments exist

MySQL/MariaDB Spatial Support Matrix

This table shows when different spatial features were introduced into MySQL and MariaDB.

My	MySQL
MDB	MariaDB
x	This feature is supported.
MBR	This feature is present, but operates on the Minimum Bounding Rectangle instead of the actual shape.
d	This feature is present, but has been deprecated and will be removed in a future version.
*	This feature is present, but may not work the way you expect.
-	This feature is not supported.

	My 5.4.2	My 5.5	My 5.6.1	My 5.7.4	My 5.7.5	My 5.7.6	MDB 5.1	MDB 5.3.3	MDB 10.1.2	MDB 10.2
InnoDB Spatial Indexes	-	-	-	-	x	x	-	-	-	x
MyISAM Spatial Indexes	x	x	x	x	x	x	x	x	x	x
Aria Spatial Indexes	-	-	-	-	-	-	x	x	x	x
Area	x	x	x	x	x	d	x	x	x	x
AsBinary	x	x	x	x	x	d	x	x	x	x
AsText	x	x	x	x	x	d	x	x	x	x
AsWKB	x	x	x	x	x	d	x	x	x	x
AsWKT	x	x	x	x	x	d	x	x	x	x
Boundary	-	-	-	-	-	-	-	-	x	x
Buffer	-	-	x	x	x	d	x	x	x	x
Centroid	-	x	x	x	x	d	x	x	x	x
Contains	MBR	MBR	MBR	MBR	MBR	d	MBR	MBR	MBR	MBR
ConvexHull	-	-	-	-	x	d	-	-	x	x
Crosses	MBR	x	x	x	x	d	MBR	MBR	MBR	MBR
Dimension	x	x	x	x	x	d	x	x	x	x
Disjoint	MBR	MBR	MBR	MBR	MBR	d	MBR	MBR	MBR	MBR
Distance	MBR	-	-	x	x	d	-	-	-	-
EndPoint	x	x	x	x	x	d	x	x	x	x
Envelope	x	x	x	x	x	d	x	x	x	x
Equals	MBR	MBR	MBR	MBR	MBR	d	MBR	MBR	MBR	MBR
	My 5.4.2	My 5.5	My 5.6.1	My 5.7.4	My 5.7.5	My 5.7.6	MDB 5.1	MDB 5.3.3	MDB 10.1.2	MDB 10.2
ExteriorRing	x	x	x	x	x	d	x	x	x	x
GeomCollFromText	x	x	x	x	x	d	x	x	x	x
GeomCollFromWKB	x	x	x	x	x	d	x	x	x	x
GeometryCollection	x	x	x	x	x	x	x	x	x	x
GeometryCollectionFromText	x	x	x	x	x	d	x	x	x	x
GeometryCollectionFromWKB	x	x	x	x	x	d	x	x	x	x
GeometryFromText	x	x	x	x	x	d	x	x	x	x
GeometryFromWKB	x	x	x	x	x	d	x	x	x	x
GeometryN	x	x	x	x	x	d	x	x	x	x
GeometryType	x	x	x	x	x	d	x	x	x	x
GeomFromText	x	x	x	x	x	d	x	x	x	x
GeomFromWKB	x	x	x	x	x	d	x	x	x	x
GLength	x	x	x	x	x	d	x	x	x	x
InteriorRingN	x	x	x	x	x	d	x	x	x	x
Intersects	MBR	MBR	MBR	MBR	MBR	d	MBR	MBR	MBR	MBR
IsClosed	x	x	x	x	x	d	x	x	x	x
IsEmpty	-	*	*	*	*	d	x	x	x	x
IsRing	-	-	-	-	-	-	-	-	x	x
IsSimple	-	*	*	x	x	d	-	x	x	x
LineFromText	x	x	x	x	x	d	x	x	x	x
	My 5.4.2	My 5.5	My 5.6.1	My 5.7.4	My 5.7.5	My 5.7.6	MDB 5.1	MDB 5.3.3	MDB 10.1.2	MDB 10.2
LineFromWKB	x	x	x	x	x	d	x	x	x	x
LineString	x	x	x	x	x	x	x	x	x	x
LineStringFromText	x	x	x	x	x	d	x	x	x	x
LineStringFromWKB	x	x	x	x	x	d	x	x	x	x
MBRContains	MBR	MBR	MBR	MBR	MBR	MBR	MBR	MBR	MBR	MBR
MBRCoveredBy	-	-	-	MBR	MBR	MBR	-	-	-	-
MBRDisjoint	MBR	MBR	MBR	MBR	MBR	MBR	MBR	MBR	MBR	MBR
MBREqual	MBR	MBR	MBR	MBR	MBR	MBR	MBR	MBR	MBR	MBR
MBREquals	-	-	-	MBR	MBR	MBR	-	-	-	MBR
MBRIntersects	MBR	MBR	MBR	MBR	MBR	MBR	MBR	MBR	MBR	MBR
MBROverlaps	MBR	MBR	MBR	MBR	MBR	MBR	MBR	MBR	MBR	MBR
MBRTouches	MBR	MBR	MBR	MBR	MBR	MBR	MBR	MBR	MBR	MBR
MBRWithin	MBR	MBR	MBR	MBR	MBR	MBR	MBR	MBR	MBR	MBR
MLineFromText	x	x	x	x	x	d	x	x	x	x
MLineFromWKB	x	x	x	x	x	d	x	x	x	x
MPointFromText	x	x	x	x	x	d	x	x	x	x
MPointFromWKB	x	x	x	x	x	d	x	x	x	x
MPolyFromText	x	x	x	x	x	d	x	x	x	x
MPolyFromWKB	x	x	x	x	x	d	x	x	x	x
MultiLineString	x	x	x	x	x	x	x	x	x	x
	My 5.4.2	My 5.5	My 5.6.1	My 5.7.4	My 5.7.5	My 5.7.6	MDB 5.1	MDB 5.3.3	MDB 10.1.2	MDB 10.2
MultiLineStringFromText	x	x	x	x	x	d	x	x	x	x
MultiLineStringFromWKB	x	x	x	x	x	d	x	x	x	x
MultiPoint	x	x	x	x	x	x	x	x	x	x
MultiPointFromText	x	x	x	x	x	d	x	x	x	x
MultiPointFromWKB	x	x	x	x	x	d	x	x	x	x
MultiPolygon	x	x	x	x	x	x	x	x	x	x
MultiPolygonFromText	x	x	x	x	x	d	x	x	x	x
MultiPolygonFromWKB	x	x	x	x	x	d	x	x	x	x
NumGeometries	x	x	x	x	x	d	x	x	x	x
NumInteriorRings	x	x	x	x	x	d	x	x	x	x
NumPoints	x	x	x	x	x	d	x	x	x	x
Overlaps	MBR	MBR	MBR	MBR	MBR	d	MBR	MBR	MBR	MBR
Point	x	x	x	x	x	x	x	x	x	x
PointFromText	x	x	x	x	x	d	x	x	x	x
PointFromWKB	x	x	x	x	x	d	x	x	x	x
PointOnSurface	-	-	-	-	-	-	-	-	x	x
PointN	x	x	x	x	x	d	x	x	x	x
PolyFromText	x	x	x	x	x	d	x	x	x	x
PolyFromWKB	x	x	x	x	x	d	x	x	x	x
Polygon	x	x	x	x	x	x	x	x	x	x
	My 5.4.2	My 5.5	My 5.6.1	My 5.7.4	My 5.7.5	My 5.7.6	MDB 5.1	MDB 5.3.3	MDB 10.1.2	MDB 10.2
PolygonFromText	x	x	x	x	x	d	x	x	x	x
PolygonFromWKB	x	x	x	x	x	d	x	x	x	x
SRID	x	x	x	x	x	d	x	x	x	x
ST_Area	-	-	x	x	x	x	-	x	x	x
ST_AsBinary	-	-	x	x	x	x	-	x	x	x
ST_AsGeoJSON	-	-	-	x	x	x	-	-	-	x
ST_AsText	-	-	x	x	x	x	-	x	x	x
ST_AsWKB	-	-	x	x	x	x	-	x	x	x
ST_AsWKT	-	-	x	x	x	x	-	x	x	x
ST_Boundary	-	-	-	-	-	-	-	-	x	x
ST_Buffer	-	-	x	x	x	x	-	x	x	x
ST_Buffer_Strategy	-	-	-	x	x	x	-	-	-	-
ST_Centroid	-	-	x	x	x	x	-	x	x	x
ST_Contains	-	-	x	x	x	x	-	x	x	x
ST_ConvexHull	-	-	-	-	x	x	-	-	x	x
ST_Crosses	-	-	x	x	x	x	-	x	x	x
ST_Difference	-	-	x	x	x	x	-	x	x	x
ST_Dimension	-	-	x	x	x	x	-	x	x	x
ST_Disjoint	-	-	x	x	x	x	-	x	x	x
ST_Distance	-	-	x	x	x	x	-	x	x	x
	My 5.4.2	My 5.5	My 5.6.1	My 5.7.4	My 5.7.5	My 5.7.6	MDB 5.1	MDB 5.3.3	MDB 10.1.2	MDB 10.2
ST_Distance_Sphere	-	-	-	-	-	x	-	-	-	-
ST_EndPoint	-	-	x	x	x	x	-	x	x	x
ST_Envelope	-	-	x	x	x	x	-	x	x	x
ST_Equals	-	-	x	x	x	x	-	x	x	x
ST_ExteriorRing	-	-	x	x	x	x	-	x	x	x
ST_GeoHash	-	-	-	-	x	x	-	-	-	-
ST_GeomCollFromText	-	-	x	x	x	x	-	x	x	x
ST_GeomCollFromWKB	-	-	x	x	x	x	-	x	x	x
ST_GeometryCollectionFromText	-	-	x	x	x	x	-	x	x	x
ST_GeometryCollectionFromWKB	-	-	x	x	x	x	-	x	x	x
ST_GeometryFromText	-	-	x	x	x	x	-	x	x	x
ST_GeometryFromWKB	-	-	x	x	x	x	-	x	x	x
ST_GeometryN	-	-	x	x	x	x	-	x	x	x
ST_GeometryType	-	-	x	x	x	x	-	x	x	x
ST_GeomFromGeoJSON	-	-	-	-	x	x	-	-	-	x
ST_GeomFromText	-	-	x	x	x	x	-	x	x	x
ST_GeomFromWKB	-	-	x	x	x	x	-	x	x	x
ST_InteriorRingN	-	-	x	x	x	x	-	x	x	x
ST_Intersection	-	-	x	x	x	x	-	x	x	x
ST_Intersects	-	-	x	x	x	x	-	x	x	x
	My 5.4.2	My 5.5	My 5.6.1	My 5.7.4	My 5.7.5	My 5.7.6	MDB 5.1	MDB 5.3.3	MDB 10.1.2	MDB 10.2
ST_IsClosed	-	-	x	x	x	x	-	x	x	x
ST_IsEmpty	-	-	x	x	x	x	-	x	x	x
ST_IsRing	-	-	-	-	-	-	-	-	x	x
ST_IsSimple	-	-	x	x	x	x	-	x	x	x
ST_IsValid	-	-	-	-	-	x	-	-	-	-
ST_LatFromGeoHash	-	-	-	-	x	x	-	-	-	-
ST_Length	-	-	-	-	-	x	-	x	x	x
ST_LineFromText	-	-	x	x	x	x	-	x	x	x
ST_LineFromWKB	-	-	x	x	x	x	-	x	x	x
ST_LineStringFromText	-	-	x	x	x	x	-	x	x	x
ST_LineStringFromWKB	-	-	x	x	x	x	-	x	x	x
ST_LongFromGeoHash	-	-	-	-	x	x	-	-	-	-
ST_NumGeometries	-	-	x	x	x	x	-	x	x	x
ST_NumInteriorRings	-	-	x	x	x	x	-	x	x	x
ST_NumPoints	-	-	x	x	x	x	-	x	x	x
ST_Overlaps	-	-	x	x	x	x	-	x	x	x
ST_PointFromGeoHash	-	-	-	-	x	x	-	-	-	-
ST_PointFromText	-	-	x	x	x	x	-	x	x	x
ST_PointFromWKB	-	-	x	x	x	x	-	x	x	x
ST_PointOnSurface	-	-	-	-	-	-	-	-	x	x
	My 5.4.2	My 5.5	My 5.6.1	My 5.7.4	My 5.7.5	My 5.7.6	MDB 5.1	MDB 5.3.3	MDB 10.1.2	MDB 10.2
ST_PointN	-	-	x	x	x	x	-	x	x	x
ST_PolyFromText	-	-	x	x	x	x	-	x	x	x
ST_PolyFromWKB	-	-	x	x	x	x	-	x	x	x
ST_PolygonFromText	-	-	x	x	x	x	-	x	x	x
ST_PolygonFromWKB	-	-	x	x	x	x	-	x	x	x
ST_Relate	-	-	-	-	-	-	-	-	x	x
ST_Simplify	-	-	-	-	-	x	-	-	-	-
ST_SRID	-	-	x	x	x	x	-	x	x	x
ST_StartPoint	-	-	x	x	x	x	-	x	x	x
ST_SymDifference	-	-	x	x	x	x	-	x	x	x
ST_Touches	-	-	x	x	x	x	-	x	x	x
ST_Union	-	-	x	x	x	x	-	x	x	x
ST_Validate	-	-	-	-	-	x	-	-	-	-
ST_Within	-	-	x	x	x	x	-	x	x	x
ST_X	-	-	x	x	x	x	-	x	x	x
ST_Y	-	-	x	x	x	x	-	x	x	x
StartPoint	x	x	x	x	x	d	x	x	x	x
Touches	MBR	x	x	x	x	d	MBR	MBR	MBR	MBR
Within	MBR	MBR	MBR	MBR	MBR	d	MBR	MBR	MBR	MBR
X	x	x	x	x	x	d	x	x	x	x
Y	x	x	x	x	x	d	x	x	x	x
	My 5.4.2	My 5.5	My 5.6.1	My 5.7.4	My 5.7.5	My 5.7.6	MDB 5.1	MDB 5.3.3	MDB 10.1.2	MDB 10.2

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

MySQL/MariaDB Spatial Support Matrix

Products

Services

Pricing

Resources

About Us

Download MariaDB