#32691: Django 3.2 boolean field SQL output is causing a performance regression in MySQL. -------------------------------------+------------------------------------- Reporter: Todor Velichkov | Owner: nobody Type: | Status: closed Cleanup/optimization | Component: Database layer | Version: 3.2 (models, ORM) | Severity: Normal | Resolution: invalid Keywords: bool, booleanfield, | Triage Stage: orm, sql, mysql | Unreviewed Has patch: 0 | Needs documentation: 0 Needs tests: 0 | Patch needs improvement: 0 Easy pickings: 0 | UI/UX: 0 -------------------------------------+------------------------------------- Changes (by Dan Strokirk):
* cc: Dan Strokirk (added) Comment: We've also seen this change cause a production outage when we've tried upgrading to Django 3, so either a notice in the docs or some other way to to avoid it changing back again in the future would be great. Thanks Todor for your tip about `models.Value(1)`! -- Ticket URL: <https://code.djangoproject.com/ticket/32691#comment:12> 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/072.8e5bf70573945c61e93739f3b2e0de20%40djangoproject.com.