SDO_GEOM.RELATE Incorrect Results When Spatial_vector_acceleration=true (Doc ID 2000523.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial and Graph - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

The following query gives incorrect results when spatial_vector_acceleration=true

select
  sdo_geom.relate
  ( (select e.geometrie from rihu_ora_relate_buffer e where e.melding = 'Buffer')
  , 'CONTAINS + COVERS'
  , (select e.geometrie from rihu_ora_relate_buffer e where e.melding = 'GAP 1')
  , 0.00005
  ) relate_result
  , sdo_geom.relate
  ( (select e.geometrie from rihu_ora_relate_buffer e where e.melding = 'Buffer')
  , 'determine'
  , (select e.geometrie from rihu_ora_relate_buffer e where e.melding = 'GAP 1')
  , 0.00005
  ) determine_result
from dual;

RELATE_RESULT
--------------------------------------------------------------------------------
DETERMINE_RESULT
--------------------------------------------------------------------------------
CONTAINS + COVERS
COVERS

Expected output is

RELATE_RESULT
--------------------------------------------------------------------------------
DETERMINE_RESULT
--------------------------------------------------------------------------------
FALSE
OVERLAPBDYINTERSECT

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