laptop and a wrench

Bug

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

Zuletzt veröffentlicht: August 25, 2014 No Product Found
Bug-ID-Nummer NIM084323
EingereichtAugust 31, 2012
Zuletzt geändertApril 2, 2025
Gilt fürNo Product Found
Gefunden in Version10.1
StatusKnown Limit

Zusätzliche Informationen

Doubles in databases are not exactly equal. see workaround

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)

Schritte zur Reproduzierung

Bug-ID: NIM084323

Software:

  • No Product Found

Benachrichtigung erhalten, wenn sich der Status eines Bugs ändert

Esri Support App herunterladen

Weitere Informationen zu diesem Thema erkunden

Unterstützung durch ArcGIS-Experten anfordern

An den technischen Support wenden

Esri Support App herunterladen

Zu Download-Optionen wechseln