#31331: GROUP BY optimization doesn't work properly when ONLY_FULL_GROUP_BY mode is enabled on MySQL. -------------------------------------+------------------------------------- Reporter: Mariusz Felisiak | Owner: nobody Type: Bug | Status: new Component: Database layer | Version: master (models, ORM) | Severity: Normal | Resolution: Keywords: ONLY_FULL_GROUP_BY | Triage Stage: Accepted MySQL MariaDB | Has patch: 0 | Needs documentation: 0 Needs tests: 0 | Patch needs improvement: 0 Easy pickings: 0 | UI/UX: 0 -------------------------------------+-------------------------------------
Comment (by Simon Charette): For anyone wanting to tackle this, proper support for `ONLY_FULL_GROUP_BY` could likely be added by [https://github.com/django/django/blob/e0a46367df8b17905f1c78f5c86f88d21c0f2b4d/django/db/models/sql/compiler.py#L149-L177 adjusting the MySQL's group by collapsing feature] to take the presence of this flag into account. -- Ticket URL: <https://code.djangoproject.com/ticket/31331#comment:6> 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 view this discussion on the web visit https://groups.google.com/d/msgid/django-updates/065.d4f70e6ba9bf63cdfae6903a8a83418b%40djangoproject.com.