My Oracle Support Banner

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')


To view full details, 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 a vibrant support community of peers and Oracle experts.