#34978: Annotating through an aggregate with RawSQL() raises 1056 "Can't group
on"
on MySQL/MariaDB.
-------------------------------------+-------------------------------------
Reporter: Matthew Somerville | Owner: Simon
| Charette
Type: Bug | Status: assigned
Component: Database layer | Version: 4.2
(models, ORM) |
Severity: Release blocker | 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 Simon Charette):
> it looks like the code will not work at all with MariaDB with
ONLY_FULL_GROUP_BY turned on.
That's good to know thanks for investigating further that's appreciated! I
think it's worth having a separate ticket for it yes. The solution will
likely be to turn off the `allows_group_by_selected_pks` feature on
MariaDB when `ONLY_FULL_GROUP_BY` mode is turned on. Note that the
`allows_group_by_selected_pks` feature is different from the
`allows_group_by_pk` feature removed in
041551d716b69ee7c81199eee86a2d10a72e15ab.
--
Ticket URL: <https://code.djangoproject.com/ticket/34978#comment:11>
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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/0107018bf8aec398-c01ee2ab-27b9-4b27-9609-df07115019ca-000000%40eu-central-1.amazonses.com.
