MariaDB [test]> select st_astext(st_geomfromgeojson('{"type": "Point","coordinates": [1,-.e]}'));
|
+---------------------------------------------------------------------------+
|
| st_astext(st_geomfromgeojson('{"type": "Point","coordinates": [1,-.e]}')) |
|
+---------------------------------------------------------------------------+
|
| POINT(1 0) |
|
+---------------------------------------------------------------------------+
|
1 row in set (0.00 sec)
|
|
MariaDB [test]> select st_astext(st_geomfromgeojson('{"type": "Point","coordinates": [1,-.0]}'));
|
+---------------------------------------------------------------------------+
|
| st_astext(st_geomfromgeojson('{"type": "Point","coordinates": [1,-.0]}')) |
|
+---------------------------------------------------------------------------+
|
| POINT(1 0) |
|
+---------------------------------------------------------------------------+
|
1 row in set (0.00 sec)
|
|
MariaDB [test]> select st_astext(st_geomfromgeojson('{"type": "Point","coordinates": [1,5eeeeee10eee]}'));
|
+------------------------------------------------------------------------------------+
|
| st_astext(st_geomfromgeojson('{"type": "Point","coordinates": [1,5eeeeee10eee]}')) |
|
+------------------------------------------------------------------------------------+
|
| POINT(1 5) |
|
+------------------------------------------------------------------------------------+
|
1 row in set (0.00 sec)
|
|
MariaDB [test]> select st_astext(st_geomfromgeojson('{"type": "Point","coordinates": [1,5e]}'));
|
+--------------------------------------------------------------------------+
|
| st_astext(st_geomfromgeojson('{"type": "Point","coordinates": [1,5e]}')) |
|
+--------------------------------------------------------------------------+
|
| POINT(1 5) |
|
+--------------------------------------------------------------------------+
|
1 row in set (0.00 sec)
|