My Oracle Support Banner

Wrong Result In Spatial Query Using SDO_FILTER (Doc ID 2558987.1)

Last updated on APRIL 12, 2022

Applies to:

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

Symptoms

A query using SDO_FILTER is returning an incorrect result.  After the spatial index on the queried table is rebuilt, the correct result is returned.

The problem occurs when geometries in the table are set to NULL, then set to a geometry in the same transaction. 

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!


In this Document
Symptoms
Cause
Solution
References


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