Project

General

Profile

Actions

Defect #15944

open

Some columns in redmine should be double data type, i.e estimated_hours

Added by Nguyen Thinh Kha about 10 years ago. Updated about 10 years ago.

Status:
New
Priority:
High
Assignee:
-
Category:
Database
Target version:
-
Start date:
Due date:
% Done:

0%

Estimated time:
Resolution:
Affected version:

Description

Dear Team,

We have some problems with fields having float data type (mysql db), sometimes query is wrong.
Example:
We have an issue with estimated_hours = 1.6, when we filter in issue list with parameters:
- estimated_hours >=/is 1.6: the result is right.
- estimated_hours <= 1.6: the list doesn't contain that issue

I viewed source code, the team handled it by adding a range, but I don't think it resolve this problem.
Hope team fix it both in database and source code.

Actions #1

Updated by Daniel Felix about 10 years ago

Yes, I encountered the same problems in small edge cases. Float isn't a good datatype for precission. It's just a bit faster and sometimes a bit smaller in spaceconsumption (compared to some other datatypes).

I don't find the correct issue, but in the tracker is another one open, which aims to the same problem.

Actions

Also available in: Atom PDF