#24662: Sum() returns True/False when used with BooleanField & MySQL
-------------------------------------+-------------------------------------
Reporter: chriskief | Owner: marco-
| santamaria
Type: Bug | Status: assigned
Component: Database layer | Version: 1.8
(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 akaariai):
`Count(bool_field)` isn't the same as `sum(bool_field)`, what you need is
`sum(case when true then 1 else 0 end)`. I think it is at least worth
considering if we should support min, max and sum for boolean fields.
Sum(bool_field) would be automatically converted to `sum(case when...)`
expression, min would be `min(case when true then 1 else 0 end)` and the
return value would be then converted to either True of False, likewise for
max().
The reason why I think this might be worth supporting is that this is what
you get in Python. For example `sum([True, False, False, True]) == 2` and
min and max work similarly to the above explanation, too.
--
Ticket URL: <https://code.djangoproject.com/ticket/24662#comment:8>
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/067.e78dcba2e0e5a3000e3d8a910ac91a72%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
