Coded value domains created with 'Double' data type show inconsistent values when queried using SQL.
上次发布: August 25, 2014No Product Found
漏洞 ID 编号
NIM084323
已提交
August 31, 2012
上次修改时间
April 2, 2025
适用范围
No Product Found
找到的版本
10.1
状态
Known Limit
经开发团队审核,已确定此问题与不受 Esri 控制的软件的已知限制有关。 问题的“其他信息”部分可能包含进一步说明。
附加信息
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)