My Oracle Support Banner

Sdo_Join Wrong Result After 9398469 Relationship Touch Instead Of Overlapbdyintersect (Doc ID 1118974.1)

Last updated on FEBRUARY 12, 2019

Applies to:

Oracle Spatial and Graph - Version 10.2.0.4 to 11.2.0.4 [Release 10.2 to 11.2]
Information in this document applies to any platform.

Symptoms

After applying patch 9398469 Executing query:

select poly.id, state.id
from table(sdo_join
('STATE','GEOMETRY','POLY','GEOMETRY',
'mask=OVERLAPBDYDISJOINT+OVERLAPBDYINTERSECT+INSIDE+COVEREDBY+CONTAINS+COVERS
+EQUAL')) jn
,POLY
,STATE
WHERE STATE.rowid = jn.rowid1
AND POLY.rowid = jn.rowid2;

not getting any rows when one row was expected

The cause of the problem is that the relationship between the two geometries
is now TOUCH instead of OVERLAPBDYINTERSECT


The output before the patch was correct:

/* 10.2.0.4.0 no patches, 11.1.0.7.0, 11.2.0.1.0 output:

*********** This is the correct output ***********

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


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