SDO_WITHIN_DISTANCE Operator With Querytype FILTER Returns Wrong Results in 11.2.0.3 (Doc ID 1524369.1)

Last updated on FEBRUARY 08, 2017

Applies to:

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

Symptoms

In Oracle 11.2.0.3, when using SDO_within_distance operator with querytype=filter, it is returning wrong results.
Here is the filter:

(sdo_within_distance(loc_sent_xy, sdo_geometry(2001, 8307, sdo_point_type(-122.40362, 37.77517, null), null, null),'distance=1 unit=mile layer_gtype=POINT querytype=FILTER')='TRUE')

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