SDO_WITHIN_DISTANCE Operator With Querytype FILTER Returns Wrong Results in

(Doc ID 1524369.1)

Last updated on FEBRUARY 08, 2017

Applies to:

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


In Oracle, 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')


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