Wrong Results From SDO_GEOM.SDO_INTERSECTION After Upgrade To 19.6 (Doc ID 2701467.1)

Last updated on DECEMBER 31, 2020

Applies to:

Symptoms

Wrong results from SDO_GEOM.SDO_INTERSECTION after upgrade.

After upgrading database from 12.1.0.2 to 19.6 shows empty geometries when using SDO_GEOM.SDO_INTERSECTION.
Setting spatial_vector_acceleration=true does not resolve the issue.

SELECT SDO_GEOM.RELATE(c.<COLUMN_NAME>,'DETERMINE',d.<COLUMN_NAME>,0.00005) sdo_relate,
SDO_GEOM.SDO_INTERSECTION(C.<COLUMN_NAME>,C1.DIMINFO,D.<COLUMN_NAME>,D1.DIMINFO)
FROM T1 C JOIN USER_SDO_GEOM_METADATA C1 ON C1.TABLE_NAME='T1' AND C1.COLUMN_NAME='<COLUMN_NAME>',
T2 D JOIN USER_SDO_GEOM_METADATA D1 ON D1.TABLE_NAME='T2' AND D1.COLUMN_NAME='<COLUMN_NAME>',
TABLE(SDO_JOIN('T1', 'G3E_GEOMETRY',
'T2', '<COLUMN_NAME>',
'MASK=ANYINTERACT')) JN
where c.ROWID=JN.ROWID1 and d.ROWID=JN.ROWID2
and SDO_GEOM.SDO_INTERSECTION(C.<COLUMN_NAME>,C1.DIMINFO,D.<COLUMN_NAME>,D1.DIMINFO) is null;

SDO_RELATE

------------------------------------------------------------------------------
--
SDO_GEOM.SDO_INTERSECTION(C.G3E_GEOMETRY,C1.DIMINFO,D.G3E_GEOMETRY,D1.DIMINFO)
(S
------------------------------------------------------------------------------
--
OVERLAPBDYDISJOINT

OVERLAPBDYDISJOINT

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.