| Bug ID Number |
BUG-000150037 |
| Submitted | June 15, 2022 |
| Last Modified | March 20, 2025 |
| Applies to | ArcGIS Pro |
| Version found | 2.9.3 |
| Operating System | Windows Server |
| Operating System Version | 2019 64 Bit |
| Status | As Designed
After review by the development team, it has been determined that this behavior is as designed. See the Additional Information section for details.
|
Additional Information
Calculate Field's documentation states in the last section of Usage:
Using the SQL option for the Expression Type parameter has the following limitations:
• The option is only supported for Db2, Oracle, PostgreSQL, SAP HANA, and SQL Server enterprise geodatabases.
• Calculating field values on joined tables is not supported.
• Versioned and archived data is not supported.
• The ability to undo geoprocessing operations is not supported.
Take note of this important information. As a result, the issue is not reproducible in ArcGIS Pro 2.9.3, 3.0 final, and 3.1_40108.
Workaround
Use Python 3 or Arcade expression types.
Steps to Reproduce