Re: [Django] #36030: Expressions that divide an integer field by a constant decimal.Decimal returns inconsistent decimal places on PostgreSQL

22 views
Skip to first unread message

Django

unread,
Dec 22, 2024, 10:22:47 AM12/22/24
to django-...@googlegroups.com
#36030: Expressions that divide an integer field by a constant decimal.Decimal
returns inconsistent decimal places on PostgreSQL
-------------------------------------+-------------------------------------
Reporter: Bartłomiej Nowak | Owner: (none)
Type: Bug | Status: new
Component: Database layer | Version: 5.1
(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 Gregory Mariani):

I can reproduce too with sqlite3 and postgre17. I'll have a look
--
Ticket URL: <https://code.djangoproject.com/ticket/36030#comment:8>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

Django

unread,
Dec 22, 2024, 11:34:10 AM12/22/24
to django-...@googlegroups.com
#36030: Expressions that divide an integer field by a constant decimal.Decimal
returns inconsistent decimal places on PostgreSQL
-------------------------------------+-------------------------------------
Reporter: Bartłomiej Nowak | Owner: (none)
Type: Bug | Status: new
Component: Database layer | Version: 5.1
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 0
Needs tests: 1 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Gregory Mariani):

* has_patch: 0 => 1
* needs_tests: 0 => 1

Comment:

Need help to create the tests. Have a patch to check
--
Ticket URL: <https://code.djangoproject.com/ticket/36030#comment:9>

Django

unread,
Dec 22, 2024, 12:31:59 PM12/22/24
to django-...@googlegroups.com
#36030: Expressions that divide an integer field by a constant decimal.Decimal
returns inconsistent decimal places on PostgreSQL
-------------------------------------+-------------------------------------
Reporter: Bartłomiej Nowak | Owner: (none)
Type: Bug | Status: new
Component: Database layer | Version: 5.1
(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 Gregory Mariani):

* has_patch: 1 => 0
* needs_tests: 1 => 0

--
Ticket URL: <https://code.djangoproject.com/ticket/36030#comment:10>

Django

unread,
Dec 22, 2024, 2:45:16 PM12/22/24
to django-...@googlegroups.com
#36030: Expressions that divide an integer field by a constant decimal.Decimal
returns inconsistent decimal places on PostgreSQL
-------------------------------------+-------------------------------------
Reporter: Bartłomiej Nowak | Owner: (none)
Type: Bug | Status: new
Component: Database layer | Version: 5.1
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Gregory Mariani):

* has_patch: 0 => 1

--
Ticket URL: <https://code.djangoproject.com/ticket/36030#comment:11>

Django

unread,
Dec 26, 2024, 10:42:40 AM12/26/24
to django-...@googlegroups.com
#36030: Expressions that divide an integer field by a constant decimal.Decimal
returns inconsistent decimal places on PostgreSQL
-------------------------------------+-------------------------------------
Reporter: Bartłomiej Nowak | Owner: Gregory
| Mariani
Type: Bug | Status: assigned
Component: Database layer | Version: 5.1
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 1
Needs tests: 1 | Patch needs improvement: 1
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Natalia Bidart):

* needs_better_patch: 0 => 1
* needs_docs: 0 => 1
* needs_tests: 0 => 1
* owner: (none) => Gregory Mariani
* status: new => assigned

--
Ticket URL: <https://code.djangoproject.com/ticket/36030#comment:12>

Django

unread,
Jan 17, 2025, 6:29:29 AMJan 17
to django-...@googlegroups.com
#36030: Expressions that divide an integer field by a constant decimal.Decimal
returns inconsistent decimal places on PostgreSQL
-------------------------------------+-------------------------------------
Reporter: Bartłomiej Nowak | Owner: Gregory
| Mariani
Type: Bug | Status: assigned
Component: Database layer | Version: 5.1
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Ready for
| checkin
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Gregory Mariani):

* needs_better_patch: 1 => 0
* needs_docs: 1 => 0
* needs_tests: 1 => 0
* stage: Accepted => Ready for checkin

--
Ticket URL: <https://code.djangoproject.com/ticket/36030#comment:13>

Django

unread,
Jan 17, 2025, 7:33:04 AMJan 17
to django-...@googlegroups.com
#36030: Expressions that divide an integer field by a constant decimal.Decimal
returns inconsistent decimal places on PostgreSQL
-------------------------------------+-------------------------------------
Reporter: Bartłomiej Nowak | Owner: Gregory
| Mariani
Type: Bug | Status: assigned
Component: Database layer | Version: 5.1
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Sarah Boyce):

* stage: Ready for checkin => Accepted

Comment:

Hi Gregory, a reviewer must mark the ticket as "Ready for checkin" 🙂
--
Ticket URL: <https://code.djangoproject.com/ticket/36030#comment:14>

Django

unread,
Apr 16, 2025, 12:15:27 PMApr 16
to django-...@googlegroups.com
#36030: Expressions that divide an integer field by a constant decimal.Decimal
returns inconsistent decimal places on PostgreSQL
-------------------------------------+-------------------------------------
Reporter: Bartłomiej Nowak | Owner: Gregory
| Mariani
Type: Bug | Status: assigned
Component: Database layer | Version: dev
(models, ORM) |
Severity: Normal | Resolution:
Keywords: division | Triage Stage: Accepted
decimalfield |
Has patch: 1 | Needs documentation: 1
Needs tests: 0 | Patch needs improvement: 1
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Natalia Bidart):

* keywords: => division decimalfield
* needs_better_patch: 0 => 1
* needs_docs: 0 => 1
* version: 5.1 => dev

--
Ticket URL: <https://code.djangoproject.com/ticket/36030#comment:15>
Reply all
Reply to author
Forward
0 new messages