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

LP:801560 - ST_UNION of adjacent polygons includes extra line in maria-5.3-gis

        Details

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

          Description

          The ST_UNION of two polygons that share a common edge is a polygon that contains that edge as a redundant line.

          Example:

          SELECT AsText( ST_UNION(
          PolygonFromText(' POLYGON( ( 2 2 , 3 2 , 7 5 , 2 0 , 2 2 ) ) ') ,
          PolygonFromText(' POLYGON( ( 2 2 , 3 2 , 3 3 , 2 5 , 2 2 ) ) ') ) );

          Returns POLYGON((2 0,2 2,3 2,2 2,2 5,3 3,3 2,7 5,2 0))

          Note that the list includes "2 2,3 2,2 2"

          whereas postgis returns the correct POLYGON((3 2,7 5,2 0,2 2,2 5,3 3,3 2))

            Gliffy Diagrams

              Attachments

                Activity

                Hide
                Permalink
                ratzpo Rasmus Johansson added a comment -

                Launchpad bug id: 801560

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

                  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: