[MDEV-642] LP:855323 - ST_AREA returns different results on two equivalent multipolygons Created: 2011-09-21  Updated: 2020-05-28

Status: Open
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.3.9
Fix Version/s: 5.5

Type: Bug Priority: Minor
Reporter: Philip Stoev (Inactive) Assignee: Alexey Botchkov
Resolution: Unresolved Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug855323.xml    

 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.

 Comments   
Comment by Rasmus Johansson (Inactive) [ 2011-11-28 ]

Launchpad bug id: 855323

Generated at Thu Feb 08 06:30:16 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.