Wrong Results From SDO_GEOM.SDO_INTERSECTION After Upgrade To 19.6
(Doc ID 2701467.1)
Last updated on DECEMBER 31, 2020
Applies to:
Oracle Spatial and Graph - Version 19.1.0.0.0 and laterInformation in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |