Query using a Spatial Index gives incorrect results after row update if multiple columns have sdo_geometry data
(Doc ID 2327688.1)
Last updated on MARCH 09, 2019
Applies to:Oracle Spatial and Graph - Version 220.127.116.11 to 18.104.22.168 [Release 11.2 to 12.2]
Information in this document applies to any platform.
In a table that has at least two columns of spatial data the spatial indexes do not work properly after the data is updated. Incorrect results are returned by queries using a Spatial Index.
Example on a table with two columns of SDO_GEOMETRY datatype and a spatial index created on each.
Following the example, the expected geometries may not be returned when they should which is corrected by either of the following steps:
A. Issue a COMMIT; between steps 3 and 4.
B. ALTER INDEX .... REBUILD on the Spatial Index.
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