Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.2
-
None
Description
These incorrect values shouldn't be accepted by st_geomfromjson :
select st_astext(st_geomfromgeojson('{"type": "Point","coordinates": [1,-.e]}')); |
select st_astext(st_geomfromgeojson('{"type": "Point","coordinates": [1,-.0]}')); |
select st_astext(st_geomfromgeojson('{"type": "Point","coordinates": [1,5eeeeee10eee]}')); |
select st_astext(st_geomfromgeojson('{"type": "Point","coordinates": [1,5e]}')); |
current output:
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) |