currently if we have different SRID, there is no error or warning - just some calculations, even if they are wrong then:
MariaDB [test]> SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POINT(0 0)', 4326), ST_GEOMFROMTEXT('POINT(0 1)',3857));
|
+--------------------------------------------------------------------------------------+
|
| ST_DISTANCE(ST_GEOMFROMTEXT('POINT(0 0)', 4326), ST_GEOMFROMTEXT('POINT(0 1)',3857)) |
|
+--------------------------------------------------------------------------------------+
|
| 1 |
|
+--------------------------------------------------------------------------------------+
|
1 row in set (0,001 sec)
|
|
MariaDB [test]> SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('POINT(0 0)', 4326), ST_GEOMFROMTEXT('POINT(0 1)',3857));
|
+---------------------------------------------------------------------------------------------+
|
| ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('POINT(0 0)', 4326), ST_GEOMFROMTEXT('POINT(0 1)',3857)) |
|
+---------------------------------------------------------------------------------------------+
|
| 111194.68229846345 |
|
+---------------------------------------------------------------------------------------------+
|
1 row in set (0,002 sec)
|
mysql (8.0.35) returns error :
mysql> SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POINT(0 0)', 4326), ST_GEOMFROMTEXT('POINT(0 1)',3857));
|
ERROR 3033 (HY000): Binary geometry function st_distance given two geometries of different srids: 4326 and 3857, which should have been identical.
|
|
mysql> SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('POINT(0 0)', 4326), ST_GEOMFROMTEXT('POINT(0 1)',3857));
|
ERROR 3033 (HY000): Binary geometry function st_distance_sphere given two geometries of different srids: 4326 and 3857, which should have been identical.
|
Task
Major
currently if we have different SRID, there is no error or warning - just some calculations, even if they are wrong then:
MariaDB [test]> SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POINT(0 0)', 4326), ST_GEOMFROMTEXT('POINT(0 1)',3857));+--------------------------------------------------------------------------------------+| ST_DISTANCE(ST_GEOMFROMTEXT('POINT(0 0)', 4326), ST_GEOMFROMTEXT('POINT(0 1)',3857)) |+--------------------------------------------------------------------------------------+| 1 |+--------------------------------------------------------------------------------------+1 row in set (0,001 sec)MariaDB [test]> SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('POINT(0 0)', 4326), ST_GEOMFROMTEXT('POINT(0 1)',3857));+---------------------------------------------------------------------------------------------+| ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('POINT(0 0)', 4326), ST_GEOMFROMTEXT('POINT(0 1)',3857)) |+---------------------------------------------------------------------------------------------+| 111194.68229846345 |+---------------------------------------------------------------------------------------------+1 row in set (0,002 sec)mysql (8.0.35) returns error :
mysql> SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POINT(0 0)', 4326), ST_GEOMFROMTEXT('POINT(0 1)',3857));ERROR 3033 (HY000): Binary geometry function st_distance given two geometries of different srids: 4326 and 3857, which should have been identical.mysql> SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('POINT(0 0)', 4326), ST_GEOMFROMTEXT('POINT(0 1)',3857));ERROR 3033 (HY000): Binary geometry function st_distance_sphere given two geometries of different srids: 4326 and 3857, which should have been identical.