Result Of SDO_INTERSECTION Between Two Multi-Polygon Geometries Is Incorrect (Doc ID 1909507.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial and Graph - Version 11.2.0.2 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms

In Oracle Server 11.2.0.2 and 11.2.0.3, a SDO_INTERSECTION between two multi-polygon geometries is returning a completely different result compared to 10.2.0.5
The issue does not reproduce in Oracle Database 11.2.0.4.

Query:
SELECT SDO_GEOM.SDO_INTERSECTION(GEOLOC, (SELECT GEOLOC FROM SR_REGION WHERE ID=1), 0.05)
FROM SR_AREA A
WHERE A.ID=1;

Geometries:
1. SDO_GEOMETRY(2007, 8307, SDO_POINT_TYPE(34.817571, 38.075717, NULL), SDO_ELEM_INFO_ARRAY(1, 1003, 1, 607, 2003, 1) ...
2. SDO_GEOMETRY(2007, 8307, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 1, 9, 1003, 1) ...

Result in 10.2.0.5:
SDO_GEOMETRY(2004, 8307, NULL, SDO_ELEM_INFO_ARRAY(1, 1, 1, 3, 2, 1, 9, 1003, 1, 499, 2003, 1)...

Result in 11.2.0.3:
SDO_GEOMETRY(2005, 8307, NULL, SDO_ELEM_INFO_ARRAY(1, 1, 1, 3, 1, 23), ...

The result in 11.2.0.4 is closer to the result in 10.2.0.5
SDO_GEOMETRY(2004, 8307, NULL, SDO_ELEM_INFO_ARRAY(1, 2, 1, 7, 1003, 1, 15, 1003, 1, 533, 2003, 1) ....



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms