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.


Almost unbelievably, MariaDB lacks this ST_Distance_Sphere (MDEV-13467).

Find their support matrix here.

And it's not just that either, it also lacks ST_GeoHash that MySQL has.


ST_Distance_Sphere was added only recently to MySQL -- 5.7.6. 10.1 is not the newest; there is 10.2 and 10.3. Sure, 10.1.25 came out recently (2017-07-04), but the development effort has shifted to 10.2.x and 10.3.x .

Feel free to file a feature request with MariaDB.

  • 1
    Feature request is already filled MDEV-13467 – Kepi Jan 29 '18 at 16:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.