Bug
Coded value domains created with 'Double' data type show inconsistent values when queried using SQL.
| Bug ID Number | NIM084323 |
|---|---|
| Submitted | August 31, 2012 |
| Last Modified | April 2, 2025 |
| Applies to | No Product Found |
| Version found | 10.1 |
| Status | Known Limit |
Additional Information
Doubles in databases are not exactly equal. see workaroundWorkaround
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)Steps to Reproduce
Bug ID: NIM084323
Software:
- No Product Found
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App