laptop and a wrench

漏洞

The SQL function GROUP BY used in subqueries is returning wrong values in the file geodatabase.

ArcGIS Pro
漏洞 ID 编号 BUG-000158653
已提交May 30, 2023
上次修改时间July 4, 2025
适用范围ArcGIS Pro
找到的版本3.1
操作系统Windows OS
操作系统版本10.0 64 Bit
状态Known Limit

附加信息

Support for SUB SELECT in the file geodatabase is very limited. Feel free to enter an enhancement request, and we will consider adding GROUP BY support in a SUB SELECT in a future release.

解决办法

Use the DISTINCT function instead of GROUP BY: Field in 1 (Select Distinct Field1 from table where Field2< 2).

Distinct.jpg

重现步骤

漏洞 ID: BUG-000158653

软件:

  • ArcGIS Pro

当漏洞状态发生变化时获得通知

下载 Esri 支持应用程序

发现关于本主题的更多内容

获取来自 ArcGIS 专家的帮助

联系技术支持部门

下载 Esri 支持应用程序

转至下载选项