| Bug #69111 | ST_Contains gives incorrect results on LINESTRINGs | ||
|---|---|---|---|
| Submitted: | 1 May 2013 8:09 | Modified: | 8 May 2015 13:01 |
| Reporter: | Tore Eriksson | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Server: GIS | Severity: | S3 (Non-critical) |
| Version: | Distrib 5.6.10, for Linux on x86_64 | OS: | Linux (RedHat) |
| Assigned to: | CPU Architecture: | Any | |
[2 May 2013 11:26]
Erlend Dahl
Thank you for the bug report. Verified as described on recent 5.6.
[8 May 2015 13:01]
Norvald Ryeng
Posted by developer: This issue has been fixed in MySQL 5.7.
Description: The GIS functions ST_Contains and ST_Within, an probably others as well, give incorrect results when used with LINESTRING and MULTILINESTRING geometries. How to repeat: SET @a = GeomFromText('LINESTRING(1 1,10 1)'); SET @b = GeomFromText('LINESTRING(5 1,6 1)'); SELECT ST_Contains(@a, @b), MBRContains(@a, @b); SELECT ST_Within(@b, @a), MBRWithin(@b, @a);