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

Bug #848939 reported by Philip Stoev on 2011-09-13
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MariaDB
Fix Released
Undecided
Alexey Botchkov

Bug Description

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

Changed in maria:
assignee: nobody → Alexey Botchkov (holyfoot)
Changed in maria:
status: New → Fix Committed
Changed in maria:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers