| Ticket Hash: | 198c7314db29bf2469fb05dc5feb14b65ef91fba | |||
| Title: | GeomFromGeoJSON() fails with scientific notation numbers | |||
| Status: | Closed | Type: | Code_Defect | |
| Severity: | Important | Priority: | Immediate | |
| Subsystem: | Resolution: | Overcome_By_Events | ||
| Last Modified: | 2020-08-02 11:26:58 | |||
| Version Found In: | 4.3.0a | |||
| User Comments: | ||||
anonymous added on 2019-02-18 13:23:18:
Numbers in JSON can be specified in the scientific notation e.g. 1e-5 (see "number section" on http://www.json.org/) but having this style in the GeoJSON passed to GeomFromGeoJSON() causes it to return null.
// pass
SELECT AsText( GeomFromGeoJSON('{"type":"Point","coordinates":[0.00001, 1]}') )
// fail
SELECT AsText( GeomFromGeoJSON('{"type":"Point","coordinates":[1e-5, 1]}') )
sandro added on 2020-08-02 11:26:58: fixed in following versions | ||||
View Ticket
Not logged in