laptop and a wrench

Bug

ArcMap crashes when running a query that has an Oracle function call is present on the right-hand-side of a predicate that is located inside a nested select statement.

Last Published: October 25, 2019 ArcGIS GIS Server
Bug ID Number BUG-000124364
SubmittedAugust 8, 2019
Last ModifiedJanuary 28, 2021
Applies toArcGIS GIS Server
Version found10.6.1
StatusIn Review

Workaround

When the function is on the left side, it validates without crash:

select tbl.* from (select * from <table_name> where to_number('1') = 1) tbl

Steps to Reproduce

Bug ID: BUG-000124364

Software:

  • ArcGIS GIS Server

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options