BUG-000153336 for ArcGIS GIS Server

Numéro d’ID de bogue	BUG-000153336
Envoi	October 28, 2022
Dernière modification	June 5, 2024
S’applique à	ArcGIS GIS Server
Version trouvée	10.9.1
Système d’exploitation	Windows Server
Version du système d’exploitation	2019 64 Bit
Statut	As Designed

Informations supplémentaires

The geometry coordinates have a scale of 10: X: 2683453.1229999997 ----> "1229999997" Y: 1247958.1229999997 -----> "1229999997" Double fields X and Y, that is numeric field in the relational data store with precision and scale (38,8). When trying to enter a value of a greater scale (10 in this case) to a field of a smaller scale (8), the database rounds it to nearest complete number. Hence resulting in the values: X: 2683453.123 Y: 1247958.123 It is not a loss of precision but the default behavior. In order to preserve the scale, use the smaller scale (Less then equal to 8 in this case).

Solution de contournement

The geometry coordinates have a scale of 10:

X: 2683453.1229999997 ----> "1229999997"

Y: 1247958.1229999997 -----> "1229999997"

Double fields X and Y, that is numeric field in the relational data store with precision and scale (38,8). When trying to enter a value of a greater scale (10 in this case) to a field of a smaller scale (8), the database rounds it to nearest complete number. Hence resulting in the values:

X: 2683453.123

Y: 1247958.123

It is not a loss of precision but the default behavior. In order to preserve the scale, use the smaller scale (Less then equal to 8 in this case).