#36571: Deprecated usage of BINARY expr in MySQL lookups
-------------------------------------+-------------------------------------
Reporter: Simon Charette | Owner: Youssef
Type: | Tarek Ali
Cleanup/optimization | Status: assigned
Component: Database layer | Version: dev
(models, ORM) |
Severity: Normal | Resolution:
Keywords: mysql binary like | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 1
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Comment (by Youssef Tarek Ali):
I've opened a PR to handle this deprecation by switching to `CAST(... AS
BINARY)` in the MySQL backend.
I made sure to only cast the RHS parameters to keep index performance
high. I've also run the full `expressions` and `lookup` test suites (337
tests) on both MySQL 9.0 and MariaDB latest to make sure there are no
regressions, especially with the complex escaping cases that were
mentioned in earlier discussions.
PR link: https://github.com/django/django/pull/20865
--
Ticket URL: <https://code.djangoproject.com/ticket/36571#comment:13>
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 visit
https://groups.google.com/d/msgid/django-updates/0107019cca042e51-06e433f9-e49c-44a4-89d3-fc571ca1d74f-000000%40eu-central-1.amazonses.com.
