Error occurred in Multipolygon st_intersection() function

[Former Member]

Hi,

We are using HANA 08, and using Spatial Reference, trying to calculate intersection of 3 polygons(BLACK part in diagram). For this, we use multipolygon, as shown below query and it's graphical diagram is also shown,

SELECT NEW ST_MultiPolygon( 'MultiPolygon(((0 0, 5 0, 2.5 4, 0 0)),(( 0 0, 3 2, 0 4, 0 0 )))' ).ST_Intersection
(NEW ST_MultiPolygon( 'MultiPolygon((( 6 0, 5 4, 2 2, 6 0 )))' )).ST_AsEWKT() as Ar
FROM dummy

but it gives following error :

Could not execute 'SELECT NEW ST_MultiPolygon( 'MultiPolygon(((0 0, 5 0, 2.5 4, 0 0)),(( 0 0, 3 2, 0 4, 0 0 )))' ...' in 243 ms 288 µs .

[129]: transaction rolled back by an internal error: exception 1000013: exception  1: no.0  (geometry/error/GeometryError.h:17)

    Intersection

NO exception throw location recorded. Stack generation suppressed.

at function st_intersection()

I am searching on internet and also read Spatial Reference guide, but not find any solution. Is any one have solution please share.

Thanks,

Somnath A. Kadam

Message was edited by: Tom Flanagan

[Former Member · Accepted solution]

Finally i got solution,

SELECT NEW ST_MultiPolygon( 'MultiPolygon(((0 0, 5 0, 2.5 4, 0 0)))' )

.ST_Intersection(NEW ST_MultiPolygon( 'MultiPolygon((( 6 0, 5 4, 2 2, 6 0 )))' ))

.ST_Intersection(NEW ST_MultiPolygon( 'MultiPolygon((( 0 0, 3 2, 0 4, 0 0 )))' )).ST_AsEWKT() as Ar

FROM dummy