Replace floats with doubles to increase precision
GENERAL
TESTING
GENERAL
TESTING
Description
Attachments
1
is related to
Activity
Show:
Fixed
Details
Priority
MajorAffects versions
Fix versions
Components
Assignee
SAMIGO TEAMSAMIGO TEAMReporter
Sam OttenhoffSam OttenhoffLabels
Conversion Script Required
Yes
Details
Details
Priority
Affects versions
Fix versions
Components
Assignee

Reporter

Labels
Conversion Script Required
Yes
Created March 9, 2013 at 5:47 PM
Updated March 23, 2022 at 3:02 PM
Resolved March 15, 2013 at 10:04 AM
A float is a single-precision floating point number. The float does not work well when storing large numbers. Here is an example I posted to the samigo mailing list:
> create table floattest (z float);
> insert into floattest VALUES (2075808);
> select * from floattest;
The result: 2075810