[MDEV-13467] Feature request: Support for ST_Distance_Sphere() - Jira

XML

Word

Printable

Details

Type: Task
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Fix Version/s: 10.2.38, 10.3.29, 10.4.19, 10.5.10
Component/s: GIS
Labels:
None

Description

Spatial Convenience Function:

This function does not exist in any version of MariaDB but does on MySQL 5.7+ and is critical for spatial conversions. ST_Distance_Sphere makes use for calculating the distance of coordinates from points.

For more information reference MySQL's documentation directly at:
https://dev.mysql.com/doc/refman/5.7/en/spatial-convenience-functions.html

Source Code Reference (thanks to Daniel Black for the commit number):
https://github.com/mysql/mysql-server/commit/60e7f702ac3929c0e38afa7e6dd75fcd5a54c6a9

Attachments

Issue Links

relates to

MDEV-17398 Implement Geographic functions available in MySQL 8.0

Closed

MDEV-26161 crash in Gis_point::calculate_haversine

Closed

Activity

People

Assignee:: Anel Husakovic

Reporter:: Travis van der Font

Votes:: 29 Vote for this issue

Watchers:: 32 Start watching this issue

Dates

Created:: 2017-08-08 07:58

Updated:: 2024-07-08 00:38

Resolved:: 2021-03-27 10:31

Time Tracking

Estimated:

Remaining:

Logged:

7.5d

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.