Update June 12, 2025
The ArcGIS Server 11.5 Calculate Field patch is available: https://support.esri.com/en-us/patches-updates/2025/arcgis-server-11-5-calculate-field-patch
Update June 5, 2025
This issue is fixed in ArcGIS Pro 3.5 Patch 1 (3.5.1). Each patch is cumulative of all previous patch fixes. It is highly recommended to apply the most current patch immediately after installing ArcGIS Pro 3.5.
Description
The ability to set the expression type to SQL in the Calculate Field geoprocessing tool when working with file geodatabase (.gdb) data was introduced in ArcGIS Pro 3.5. A potential data corruption bug has been discovered wherein Calculate Field does not honor the active selection or layer filters (for example, definition query, time filter, range filter, or spatial filter) when using a SQL expression on file geodatabase data, resulting in all rows being calculated.
Cause
Workaround
- Do not use SQL as the expression type until this bug is addressed with a patch. Use Python or Arcade as the expression type.
- Do not publish web tools from ArcGIS Pro 3.5 to ArcGIS Enterprise 11.5 that include Calculate Field using SQL as the expression type.
Article Discussion: