Details
-
Task
-
Status: In Testing (View Workflow)
-
Major
-
Resolution: Unresolved
Description
As documented in https://mariadb.com/kb/en/library/function-differences-between-mariadb-106-and-mysql-80 MySQL 8.0 has quite a few Geographic functions not available in MariaDB:
DISTANCE (removed in 8.0)
MBRCOVEREDBY
ST_Collect (from MySQL 8.0.24)
ST_DISTANCE_SPHERE (MDEV-13467)
ST_GeoHash (from MySQL-5.7.4)
ST_IsValid
ST_LatFromGeoHash (from MySQL-5.7.4)
ST_LongFromGeoHash (from MySQL-5.7.4)
ST_PointFromGeoHash (from MySQL-5.7.4)
ST_SIMPLIFY
ST_VALIDATE
ST_BUFFER_STRATEGY
ST_FrechetDistance
ST_HausdorffDistance
ST_LineInterpolatePoint() (from MySQL 8.0.24)
ST_LineInterpolatePoints() (from MySQL 8.0.24)
The lack of these can cause problems for some MySQL users wanting to use MariaDB.
Attachments
Issue Links
- causes
-
MDEV-34120 GSoC 2024, Spatial (GIS) functions in MariaDB
-
- In Testing
-
- includes
-
MDEV-34137 Implement the GIS function ST_Validate
-
- In Testing
-
-
MDEV-34138 Implement the GIS function MBRCoveredBy
-
- In Testing
-
-
MDEV-34141 Implement the GIS function ST_Simplify
-
- In Testing
-
-
MDEV-34158 Implement the GIS function ST_GeoHash
-
- In Testing
-
-
MDEV-34159 Implement the GIS function ST_LatFromGeoHash
-
- In Testing
-
-
MDEV-34160 Implement the GIS function ST_LongFromGeoHash
-
- In Testing
-
-
MDEV-34276 Implement the GIS function ST_IsValid
-
- In Testing
-
-
MDEV-34277 Implement the GIS function ST_PointFromGeoHash
-
- In Testing
-
-
MDEV-34278 Implement the GIS function ST_Collect
-
- In Testing
-
- is part of
-
MDEV-28906 MySQL 8.0 desired compatibility
-
- Open
-
- relates to
-
MDEV-13467 Feature request: Support for ST_Distance_Sphere()
-
- Closed
-