[MDEV-2480] LP:850775 - ST_AREA does not work on GEOMETRYCOLLECTIONs in maria-5.3-gis Created: 2011-09-15  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 LPexportBug850775.xml    

 Description   

ST_AREA returns NULL when passed a GEOMETRYCOLLECTION .

select ST_AREA(ST_GEOMCOLLFROMTEXT(' POLYGON((0 0,4 7,1 1,0 0))'));
returns 1.5

select ST_AREA(ST_GEOMCOLLFROMTEXT(' GEOMETRYCOLLECTION(POLYGON((0 0,4 7,1 1,0 0)))'));
returns NULL

postgis returns 1.5 in both cases.

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

Launchpad bug id: 850775

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