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 almost 11 years ago. Updated almost 11 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

Also available in: Atom PDF