#18247: Filtering on aggregate annotations with a Decimal value doesn't work
-------------------------------------+-------------------------------------
Reporter: elmopl@… | Owner: NEOatNHNG
Type: Bug | Status: closed
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution: fixed
Keywords: decimal filter | Triage Stage: Ready for
annotate having | checkin
Has patch: 1 | 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:"3bbaf84d6533fb61ac0038f2bbe52ee0d7b4fd10" 3bbaf84d]:
{{{
#!CommitTicketReference repository=""
revision="3bbaf84d6533fb61ac0038f2bbe52ee0d7b4fd10"
Fixed #18247 -- Added cast to NUMERIC for Decimals on sqlite
On sqlite the SUM() of a decimal column doesn't have a NUMERIC type so
when comparing it to a string literal (which a Decimal gets converted to
in Django) it is not compared as expected.
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/18247#comment:14>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/074.18d8fa87e5103dad30846d3440cb338b%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
