laptop and a wrench

漏洞

Coded value domains created with 'Double' data type show inconsistent values when queried using SQL.

上次发布: August 25, 2014 No Product Found
漏洞 ID 编号 NIM084323
已提交August 31, 2012
上次修改时间April 2, 2025
适用范围No Product Found
找到的版本10.1
状态Known Limit

附加信息

Doubles in databases are not exactly equal. see workaround

解决办法

IEEE 754 describes how doubles are modeled with computers, often seemingly simple doubles cannot be exactly represented, and the next closest representation is used. Search 'directly compare two doubles' to understand why a tolerance based approach must be used. e.g., 10.71 != 10.71 (if its from a database)

重现步骤

漏洞 ID: NIM084323

软件:

  • No Product Found

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

下载 Esri 支持应用程序

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

获取来自 ArcGIS 专家的帮助

联系技术支持部门

下载 Esri 支持应用程序

转至下载选项