Bug #52480 GEOSpatial Equals on LineString
Submitted: 30 Mar 2010 15:02 Modified: 15 Oct 2012 14:36
Reporter: nick ooms Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: GIS Severity:S3 (Non-critical)
Version:5.1.35-gis, mysql-5.1.43-snapshot20091222-linux-x86_64 OS:Any
Assigned to: Assigned Account CPU Architecture:Any
Tags: Equals LineString

[30 Mar 2010 15:02] nick ooms 
Description:
Equals on a linestring doesn't return the same linestring.

How to repeat:
CREATE TABLE test.test (
  `multilinestring` multilinestring DEFAULT NULL
) ENGINE=InnoDB;

INSERT INTO test.test (
  `multilinestring`
) VALUES (GEOMFROMTEXT('MULTILINESTRING((-1 -1,0 0,1.01 0,1.01 1.01),(-3 -3,0.00001 0,3.01 0,3.01 3.01,-3 -3))'));

SELECT
  ASTEXT(`multilinestring`)
FROM test.test
WHERE
  EQUALS(`multilinestring`, GEOMFROMTEXT('MULTILINESTRING((-1 -1,0 0,1.01 0,1.01 1.01),(-3 -3,0.00001 0,3.01 0,3.01 3.01,-3 -3))'));

--> No results on 5.1.35-gis, 1 result on 5.1.45

SELECT
  ASTEXT(`multilinestring`)
FROM test.test
WHERE
  EQUALS(`multilinestring`, GEOMFROMTEXT('MULTILINESTRING((-1 -1,0 0,1.01 0,1.01 1.01),(-3 -3,0.001 0,3.01 0,3.01 3.01,-3 -3))'));

--> No results on 5.1.35-gis, 1 result on 5.1.45
[31 Mar 2010 5:23] Sveta Smirnova 
Thank you for the report.

Verified as described using mysql-5.1.43-snapshot20091222-linux-x86_64