Public

Project privacy set to public. By default, its content is available to everyone (authenticated or not). Please note that more restrictive permissions might exist on some items.

stable

Clone or download

Read-only

request #9683: FLOAT(10,4) is not precise enough for big floats

Download Browse

If you enter 14906.09 in a float field, it is saved as 14906.0898 which is wrong. This is due to the type of the column: FLOAT(10,4) As said in the mysql documentation[1]: > For maximum portability, code requiring storage of approximate numeric > data values should use FLOAT or DOUBLE PRECISION with no specification > of precision or number of digits. Please note that we cannot change existing data, this applies only for next changes in artifacts. [1] http://dev.mysql.com/doc/refman/5.5/en/floating-point-types.html Change-Id: Iacf49e7e2f3caa44565cd0f49769c7dd422c3fa2

+60 −5
Nicolas Terray (nterray) 2016-11-29 13:36
Nicolas Terray (nterray) 2016-11-29 13:50
375c50b92cb73b2c5d028edc7d622b831473b54f
d591019a3a04842a823828d5d17065ef93da3212
git #tuleap/stable/375c50b92cb73b2c5d028edc7d622b831473b54f

Modified Files

Side by side diff
Inline diff
Name
M plugins/tracker/db/install.sql +5 −5 Go to diff View file
A plugins/tracker/db/mysql/updates/2016/201611291315_switch_float_to_double.php +55 −0 Go to diff View file