HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

Does MariaDB support ST_Distance_Sphere?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
supportmariadbst_distance_spheredoes

Problem

Running mariadb, I'm getting


ERROR 1305 (42000): FUNCTION ST_Distance_Sphere does not exist

When I run a basic query like

SELECT ST_Distance_Sphere( POINT(0,0), POINT(0,1) );


However, I'm using a pretty new version.

Server version: 10.1.25-MariaDB-1 Ubuntu 17.10


What's going on here.

Solution

10.2+

This issue has been fixed and backported with MDEV-13467. It's available 10.2.38, 10.3.29, 10.4.19, 10.5.10

Find their support matrix here.

Context

StackExchange Database Administrators Q#191271, answer score: 5

Revisions (0)

No revisions yet.