My Oracle Support Banner

Spatial Queries using SDO_RELATE May Return Different Result in 12c than in 11g (Doc ID 2228982.1)

Last updated on MARCH 19, 2019

Applies to:

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


A Spatial query using the SDO_RELATE operator on the same data may return a different result in 12c than it did in 11g.
In summary, 

on 12c a small box returning all data of the table works.
but a larger box, does not return the result
and a larger box again, returns the expected result.

In 11g, the expected result is returned in all cases.




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

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