SQL query builder shows strange double values
450
1
04-16-2020 03:32 PM
by
I'm trying to perform a select by attribute in ArcGIS Pro on a field of type double. The problem I have is that there are strange values in the list of possible values. Ex: rather than showing 60.3, the list of possible values contains 60.300000000000004. Of course, if a try the select with this strange value, I get no results.
I looked into the attribute table and the value is really 60.3. I even looked into my Oracle tables directly and found that the stored value is also 60.3. So everything seems fine, on the data side.
The only way to make the select work is to switch to the SQL view and manually type in 60.3.
Any idea what could be wrong with the SQL query builder?
