laptop and a wrench

Bug

The Select by Attributes tool displays incorrect selection of records on a database table without a Unique ID field.

Last Published: January 16, 2020 ArcGIS Pro
Bug ID Number BUG-000125909
SubmittedOctober 10, 2019
Last ModifiedJune 19, 2025
Applies toArcGIS Pro
Version found2.4.1
Operating SystemN/A
Operating System VersionN/A
Version Fixed2.8
StatusFixed

Workaround

Add a unique ID field from the database end in the table.

For example: alter table [dbo].[TableName]

      ADD id int IDENTITY (1,1)

 

Steps to Reproduce

Bug ID: BUG-000125909

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