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 18.104.22.168 [Release 10.2 to 11.2]
Information in this document applies to any platform.
After applying patch 9398469 Executing query:
select poly.id, state.id
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, 22.214.171.124.0, 126.96.36.199.0 output:
*********** This is the correct output ***********
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