Does MariaDB support ST_Distance_Sphere? 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.