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

[1 May 2013 8:09] Tore Eriksson
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);
[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.