Bug #93071 | ST_ISVALID reports invalid GEOMETRY's as valid | ||
---|---|---|---|
Submitted: | 4 Nov 2018 3:20 | Modified: | 14 Jan 2019 14:31 |
Reporter: | Mark Drake | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server: GIS | Severity: | S2 (Serious) |
Version: | 8, 8.0.13 | OS: | Any |
Assigned to: | CPU Architecture: | Any | |
Tags: | ST_ISVALID |
[4 Nov 2018 3:20]
Mark Drake
[7 Nov 2018 5:05]
MySQL Verification Team
Hello Mark Drake, Thank you for the report. regards, Umesh
[14 Jan 2019 14:31]
Norvald Ryeng
The points in question are in SRID 0, which is an infinite abstract plane. Hence, any coordinate values are valid. If the points are cast to a latitude-longitude system, e.g., WGS 84, MySQL correctly raises an error: mysql> SELECT COUNT(*) FROM sakila.address WHERE ST_ISVALID(ST_SRID(location, 4326)); ERROR 3731 (22S02): A parameter of function st_srid contains a geometry with longitude 766456911.000000, which is out of range. It must be within (-180.000000, 180.000000]. I'm closing this as not a bug