laptop and a wrench

Bug

In ArcGIS Pro, using the Select By Attribute tool with an empty clause or SQL expression selects all the records in a table

ArcGIS Pro
Bug ID Number BUG-000173175
SubmittedDecember 19, 2024
Last ModifiedDecember 24, 2024
Applies toArcGIS Pro
Version found3.4
Operating SystemWindows OS
Operating System Version10.0 64 Bit
StatusAs Designed

Additional Information

An empty expression or SQL selecting everything is by design. the empty expression behaves consistent with the SQL behavior. The same applies to the tool in ArcMap 10.8.3, as just confirmed with a test. A screenshot is available for confirmation.

Steps to Reproduce

Bug ID: BUG-000173175

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