[MDEV-17398] Implement Geographic functions available in MySQL 8.0 Created: 2018-10-08 Updated: 2023-09-29 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | GIS |
| Fix Version/s: | None |
| Type: | Task | Priority: | Major |
| Reporter: | Ian Gilfillan | Assignee: | Alexey Botchkov |
| Resolution: | Unresolved | Votes: | 10 |
| Labels: | Compatibility, compat57, compat80 | ||
| Issue Links: |
|
||||||||||||||||
| 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: The lack of these can cause problems for some MySQL users wanting to use MariaDB. |
| Comments |
| Comment by Francisco Dueñas [ 2018-11-23 ] |
|
I Vote for this, for now, we have to use Two servers, MariaDB for Tabular data and MySQL 5.7/ Mysql 8.0 for GIS data because the lack of these functions. |
| Comment by Francisco Dueñas [ 2019-02-12 ] |
|
Will this changes cna be taken into Mariadb DB 10.4? |
| Comment by Francisco Dueñas [ 2020-09-23 ] |
|
¿Any chance any one you can look on this? |
| Comment by Ian Gilfillan [ 2021-03-29 ] |
|
MySQL 8.0.23 added ST_FrechetDistance and ST_HausdorffDistance |
| Comment by Anel Husakovic [ 2021-03-29 ] |
|
greenman seems there is no DISTANCE in MySQL or I couldn't find it. |
| Comment by Ian Gilfillan [ 2021-03-29 ] |
|
Thanks anel - this existed in 5.7 as a synonym for ST_DISTANCE, but was removed in 8.0 - I'll update the docs. |
| Comment by Chris Hewett [ 2022-06-24 ] |
|
I note this is tagged with the “compat80” label but I also think it deserves the “compat57” as the following functions were added in 5.7.5 ST_GeoHash |