Wrong result with ST_INTERSECTION between linestrings and a polygon in 5.3-gis

[Philip Stoev]

The following expresion:

SELECT ASTEXT(ST_INTERSECTION( GEOMETRYFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(7 7,5.33333333333333 7),LINESTRING(5.33333333333333 7,0 7,5 8,5.33333333333333 7),LINESTRING(5.33333333333333 7,7 2,7 7),POLYGON((0 5,3 5,3 2,1 2,1 1,3 1,3 0,0 0,0 3,2 3,2 4,0 4,0 5)))'), geomETRYFROMTEXT(' MULTILINESTRING( ( 5 1 , 3 7 , 6 1 , 7 0 ) , ( 1 6 , 8 5 , 7 5 , 5 6 ) )') ));

returns MULTIPOINT(7 5,5.14285714285714 7,5.3 5.9,5.6 5.8,3 7) in mysql

and MULTIPOINT(3 7,5.8 5.6,5.9 5.3,7 5,7 5.14285714285714) in postgis

Visual examination of the geometries in an editor reveals that the postgis result is correct. In the mysql result, the X and Y coordinates appear to be reversed for some points.

revision-id: <email address hidden>
date: 2011-09-13 15:19:55 +0500
build-date: 2011-09-13 15:45:15 +0300
revno: 3000
branch-nick: maria-5.3-gis