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

Last updated on JULY 20, 2024

Applies to:

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

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