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

LP:855323 - ST_AREA returns different results on two equivalent multipolygons

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 5.3.9
    • 5.5
    • None

    Description

      The following 2 polygons appear equivalent when graphed with a GUI application:

      MULTIPOLYGON (
      		 
        ((4 6, 4 7.14285714285714, 8 6, 4 6), (8 6, 9 9, 9 6, 8 6)), 
        ((4 7.14285714285714, 1 8, 4 8.375, 4 7.14285714285714)), 
        ((4 8.375, 4 9, 9 9, 4 8.375))
      		 
      )
      		 
       
      		 
       
      		 
      MULTIPOLYGON (
      		 
        ((9 9, 4 8.375, 4 9, 9 9)), 
        ((4 7.14285714285714, 1 8, 4 8.375, 4 7.14285714285714)), 
        ((4 7.14285714285714, 8 6, 4 6, 4 7.14285714285714)), 
        ((8 6, 9 9, 9 6, 8 6))
      		 
        )

      And yet ST_AREA() returns different results for them. Same is observed in PostGIS, and it seems incorrect.

      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:

              Git Integration

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