laptop and a wrench

Bug

ArcGIS Pro does not validate complex SQL queries while the underlying database management system (DBMS) does.

Last Published: October 26, 2020 ArcGIS Pro
Bug ID Number BUG-000133709
SubmittedSeptember 9, 2020
Last ModifiedJuly 11, 2025
Applies toArcGIS Pro
Version found2.6.1
Operating SystemWindows OS
Operating System Version10.0 64 Bit
Version Fixed2.7
StatusFixed

Workaround

Simplify the SQL expression by deleting CaseReported IN ('Citizen Complaint').

Steps to Reproduce

Bug ID: BUG-000133709

Software:

  • ArcGIS Pro

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