[Django] #28967: Cast with FloatField rounds value to integer on MySQL

[Django]

#28967: Cast with FloatField rounds value to integer on MySQL
-------------------------------------+-------------------------------------
Reporter: Sergey | Owner: nobody
Fedoseev |
Type: Bug | Status: new
Component: Database | Version: 1.10
layer (models, ORM) |
Severity: Normal | Keywords:
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
{{{
In [6]: DurationModel.objects.annotate(f=models.functions.Cast(0.125,
models.FloatField())).first().f
Out[6]: 0.0

In [7]: DurationModel.objects.annotate(f=models.functions.Cast(0.5,
models.FloatField())).first().f
Out[7]: 1.0
}}}

--
Ticket URL: <https://code.djangoproject.com/ticket/28967>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

[Django]

#28967: Cast with FloatField rounds value to integer on MySQL
-------------------------------------+-------------------------------------

Reporter: Sergey Fedoseev | Owner: Sergey
| Fedoseev
Type: Bug | Status: assigned
Component: Database layer | Version: 1.10
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage:
| Unreviewed
Has patch: 0 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Sergey Fedoseev):

* owner: nobody => Sergey Fedoseev
* status: new => assigned

--
Ticket URL: <https://code.djangoproject.com/ticket/28967#comment:1>

[Django]

#28967: Cast with FloatField rounds value to integer on MySQL
-------------------------------------+-------------------------------------

Reporter: Sergey Fedoseev | Owner: Sergey
| Fedoseev
Type: Bug | Status: assigned
Component: Database layer | Version: 1.10
(models, ORM) |
Severity: Normal | Resolution:

Keywords: | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Tim Graham):

* stage: Unreviewed => Accepted

--
Ticket URL: <https://code.djangoproject.com/ticket/28967#comment:2>

[Django]

#28967: Cast with FloatField rounds value to integer on MySQL
-------------------------------------+-------------------------------------

Reporter: Sergey Fedoseev | Owner: Sergey
| Fedoseev
Type: Bug | Status: assigned
Component: Database layer | Version: 1.10
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted

Has patch: 0 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Comment (by Sergey Fedoseev):

[https://github.com/django/django/pull/9497 PR]

--
Ticket URL: <https://code.djangoproject.com/ticket/28967#comment:3>

[Django]

#28967: Cast with FloatField rounds value to integer on MySQL
-------------------------------------+-------------------------------------

Reporter: Sergey Fedoseev | Owner: Sergey
| Fedoseev

Type: Bug | Status: closed

Component: Database layer | Version: 1.10
(models, ORM) |

Severity: Normal | Resolution: fixed
Keywords: | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Tim Graham <timograham@…>):

* status: assigned => closed
* resolution: => fixed

Comment:

In [changeset:"44908d4d9360f72b9511aa0a878458285ba326d4" 44908d4]:
{{{
#!CommitTicketReference repository=""
revision="44908d4d9360f72b9511aa0a878458285ba326d4"
Fixed #28967 -- Prevented Cast to FloatField from rounding to integer on
MySQL.
}}}

--
Ticket URL: <https://code.djangoproject.com/ticket/28967#comment:4>