Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-3406

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

        Details

        • Type: Bug
        • Status: Closed
        • Resolution: Fixed
        • Affects Version/s: None
        • Fix Version/s: None
        • Component/s: None
        • Labels:

          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

            Gliffy Diagrams

              Attachments

                Activity

                Hide
                Permalink
                ratzpo Rasmus Johansson added a comment -

                Launchpad bug id: 848939

                Show
                ratzpo Rasmus Johansson added a comment - Launchpad bug id: 848939

                  People

                  • Assignee:
                    holyfoot Alexey Botchkov
                    Reporter:
                    philipstoev Philip Stoev
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    0 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: