The Ultimate Guide to High Availability with MariaDB

MySQL/MariaDB Spatial Support Matrix

You are viewing an old version of this article. View the current version here.

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

MyMySQL
MDBMariaDB
xThis feature is supported.
MBRThis feature is present, but operates on the Minimum Bounding Rectangle instead of the actual shape.
dThis 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.2My 5.5My 5.6.1My 5.7.4My 5.7.5My 5.7.6MDB 5.1MDB 5.3.3MDB 10.1.2MDB 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.2My 5.5My 5.6.1My 5.7.4My 5.7.5My 5.7.6MDB 5.1MDB 5.3.3MDB 10.1.2MDB 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.2My 5.5My 5.6.1My 5.7.4My 5.7.5My 5.7.6MDB 5.1MDB 5.3.3MDB 10.1.2MDB 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.2My 5.5My 5.6.1My 5.7.4My 5.7.5My 5.7.6MDB 5.1MDB 5.3.3MDB 10.1.2MDB 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.2My 5.5My 5.6.1My 5.7.4My 5.7.5My 5.7.6MDB 5.1MDB 5.3.3MDB 10.1.2MDB 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.2My 5.5My 5.6.1My 5.7.4My 5.7.5My 5.7.6MDB 5.1MDB 5.3.3MDB 10.1.2MDB 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.2My 5.5My 5.6.1My 5.7.4My 5.7.5My 5.7.6MDB 5.1MDB 5.3.3MDB 10.1.2MDB 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.2My 5.5My 5.6.1My 5.7.4My 5.7.5My 5.7.6MDB 5.1MDB 5.3.3MDB 10.1.2MDB 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.2My 5.5My 5.6.1My 5.7.4My 5.7.5My 5.7.6MDB 5.1MDB 5.3.3MDB 10.1.2MDB 10.2

Comments

Comments loading...
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.