SQL Error (1210): Incorrect arguments to st_distance_sphere

Problem/Motivation

MySql: 5.7
SQL Error (1210): Incorrect arguments to st_distance_sphere

Proposed resolution

ST_Distance_Sphere uses fixed SRID = 0 longitude/latitude ordering and not SRID = 4326 latitude/longitude ordering
see https://dev.mysql.com/doc/refman/5.7/en/spatial-convenience-functions.ht...

The geometry arguments should consist of points that specify (longitude, latitude) coordinate values:

Longitude and latitude are the first and second coordinates of the point, respectively.

Both coordinates are in degrees.

Longitude values must be in the range (-180, 180]. Positive values are east of the prime meridian.

Latitude values must be in the range [-90, 90]. Positive values are north of the equator.