#31331: GROUP BY optimization doesn't work properly when ONLY_FULL_GROUP_BY
mode is
enabled on MySQL.
-------------------------------------+-------------------------------------
Reporter: Mariusz Felisiak | Owner: Simon
| Charette
Type: Bug | Status: closed
Component: Database layer | Version: dev
(models, ORM) |
Severity: Normal | Resolution: fixed
Keywords: ONLY_FULL_GROUP_BY | Triage Stage: Ready for
MySQL MariaDB | checkin
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Mariusz Felisiak <felisiak.mariusz@…>):
* status: assigned => closed
* resolution: => fixed
Comment:
In [changeset:"041551d716b69ee7c81199eee86a2d10a72e15ab" 041551d7]:
{{{
#!CommitTicketReference repository=""
revision="041551d716b69ee7c81199eee86a2d10a72e15ab"
Fixed #31331 -- Switched MySQL to group by selected primary keys.
MySQL 5.7.15 supports group by functional dependences so there is no
need to special case group by main table primary key anymore and
special case the ONLY_FULL_GROUP_BY sql mode.
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/31331#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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/0107018451fa8fb4-7c2e07c7-fdb5-44ba-a995-76f5b66682a1-000000%40eu-central-1.amazonses.com.
