BUG-000118916 for ArcSDE/Enterprise Geodatabase

Bug ID Number	BUG-000118916
Submitted	December 18, 2018
Last Modified	June 5, 2024
Applies to	ArcSDE/Enterprise Geodatabase
Version found	10.5.1
Operating System	Windows OS
Operating System Version	7.0 64 Bit
Status	Will Not Be Addressed

Additional Information

We apologize that we were unable to address this issue within the current product support cycle. If the issue continues to affect your work in a supported release, please contact Technical Support. Note that ArcGIS 10.8.2 is the current release of ArcGIS Desktop and will enter Mature Support in March 2024 https://support.esri.com/en-us/products/arcmap/life-cycle. There are no plans to release an ArcGIS Desktop 10.9, and we recommend that you migrate to ArcGIS Pro. See Migrate from ArcMap to ArcGIS Pro https://www.esri.com/en-us/arcgis/products/arcgis-pro/resources/migrate for more information.

Workaround

Create a custom versioned view which incorporates st_geometry functions inside the view. The st_intersects query is added to the end WHERE clause in both sides of the UNION in the versioned view. So this means the ST_INTERSECTS filter is added to the Adds and Base portion of the view DDL. Adding the function to the view DDL allows the spatial index to be used.