No support for ST_Distance_Sphere

[surinderrawat1987]

I am trying to find out users which exists in 5km radius. But for more accuracy I need ST_Distance_Sphere function. I checked the code and get to know that ST_Distance_Sphere implementation is not done yet.
Can anyone help me on this

[khooz]

I have submitted an issue already #91 and made a working fork, I am trying to submit a pull request but it fails since the default radius for the earth in MySQL is way off the real median implemented in the fork.

[grimzy]

Thank you for reporting this; we're working on it! We should have a new major release soon just for MySQL 8 and SRID support.

Meanwhile you might want to take a look at the srid branch. It would be great to know if it fits your needs.