laptop and a wrench

Bug

When the Oracle-specific SQL functions are used in a SQL expression of a definition query in ArcGIS Pro, if there are no matching records, an incorrect warning message is returned.

Last Published: September 9, 2020 ArcGIS Pro
Bug ID Number BUG-000133382
SubmittedAugust 27, 2020
Last ModifiedFebruary 20, 2025
Applies toArcGIS Pro
Version found2.6
Operating SystemWindows OS
Operating System Version10.0 64 Bit
StatusNon-Reproducible

Additional Information

Unable to reproduce with the current software. The validate does not fail.

Workaround

  1. Repeat steps 1 to 5 above in ArcMap 10.6.
  2. In step 5, notice that "The expression was verified successfully, but no records were returned" is returned (refer to the attached screenshot01).

Steps to Reproduce

Bug ID: BUG-000133382

Software:

  • ArcGIS Pro

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options