My Oracle Support Banner

SDO_RELATE Returns Incorrect Results While SDO_GEOM.RELATE Returns Correct results (Doc ID 2445596.1)

Last updated on APRIL 12, 2022

Applies to:

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

Symptoms

A query using SDO_RELATE returns two polygon areas when SDO_GEOM.RELATE correctly returns only one polygon. 

SELECT
a.name
FROM
area a,
areatype at,
areatype_eventtype ae
WHERE
a.nameareatype = at.name
AND a.zmin <= 0
AND a.zmax >=0
AND at.name = ae.nameareatype (+)
AND at.name IN (
'FF_IM_AB5'
)
AND (
ae.nameeventtype = 'FW-'
OR
ae.nameeventtype IS NULL
)
AND sdo_relate(
a.polygonpoints,
mdsys.sdo_geometry(
2001,
NULL,
mdsys.sdo_point_type(
181896.856867,
5235653.45936,
NULL
),
NULL,
NULL
),
'mask=anyinteract querytype=WINDOW'
) = 'TRUE'
/

The query appears to be providing a wrong result if the search is for a point near the "border" of a polygon area.

Changes

 

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
Changes
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.