Spec-Zone.ru › MariaDB

Матрица поддержки пространственных функций MySQL/MariaDB

Эта таблица показывает, когда различные пространственные функции были введены в MySQL и MariaDB.

My MySQL
MDB MariaDB
x Эта функция поддерживается.
MBR Эта функция присутствует, но работает с минимальной ограничивающей прямоугольником, а не с фактической формой.
d Эта функция присутствует, но устарела и будет удалена в будущей версии.
* Эта функция присутствует, но может работать не так, как вы ожидаете.
- Эта функция не поддерживается.
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 - - - - x x - - - x
MyISAM Spatial Indexes x x x x x x x x x x
Aria Spatial Indexes - - - - - - x x x x
Площадь 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
Граница - - - - - - - - x x
Буфер - - x x x d x x x x
Центроид - x x x x d x x x x
Содержит MBR MBR MBR MBR MBR d MBR MBR MBR MBR
Огибающая выпуклой оболочки - - - - x d - - x x
Пересекается MBR x x x x d MBR MBR MBR MBR
Размерность x x x x x d x x x x
Непересекается MBR MBR MBR MBR MBR d MBR MBR MBR MBR
Дистанция MBR - - x x d - - - -
Конечная точка 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
Многоугольник x x x x x x x x x x
Многоугольник из текста x x x x x d x x x x
Многоугольник из WKB x x x x x d x x x x
Число геометрий x x x x x d x x x x
Число внутренних колец x x x x x d x x x x
Число точек x x x x x d x x x x
Пересечения MBR MBR MBR MBR MBR d MBR MBR MBR MBR
Точка 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
Многоугольник 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
МногоугольникИзWKB x x x x x d x x x x
SRID x x x x x d x x x x
ST_Площадь - - x x x x - x x x
ST_КакБинарный - - x x x x - x x x
ST_ВGeoJSON - - - x x x - - - x
ST_ВТекст - - x x x x - x x x
ST_КакWKB - - x x x x - x x x
ST_ВWKT - - x x x x - x x x
ST_Граница - - - - - - - - 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.

© 2023 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/mysqlmariadb-spatial-support-matrix/

Spec-Zone.ru

Настройки Оффлайн Что нового Помощь О нас
Spec-Zone .ru
спецификации, руководства, описания, API