laptop and a wrench

Bug

The Select Layer By Attribute tool returns the following error message, "The SQL expression has invalid syntax" when a Where clause has 45,900 characters or more.

Last Published: May 30, 2019 ArcGIS Pro
Bug ID Number BUG-000122374
SubmittedMay 14, 2019
Last ModifiedJune 5, 2024
Applies toArcGIS Pro
Version foundN/A
Operating SystemN/A
StatusKnown Limit

Additional Information

The maximum recursion limit of 2000 is exceeded. Instead of using the SQL 'OR' operator 1996 times, use the SQL 'IN' operator.

Steps to Reproduce

Bug ID: BUG-000122374

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