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

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Resolution: Fixed
    • None
    • None
    • None

    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))

      Attachments

        Activity

          People

            holyfoot Alexey Botchkov
            philipstoev Philip Stoev (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.