[MDEV-2790] LP:801560 - ST_UNION of adjacent polygons includes extra line in maria-5.3-gis Created: 2011-06-24  Updated: 2012-10-04  Resolved: 2012-10-04

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

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

Attachments: XML File LPexportBug801560.xml    

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

 Comments   
Comment by Rasmus Johansson (Inactive) [ 2011-12-13 ]

Launchpad bug id: 801560

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