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 JANUARY 31, 2017

Applies to:

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

Symptoms

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.

Cause

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.