diff options
| author | Tom <tom@tomforb.es> | 2018-06-19 23:24:43 +0100 |
|---|---|---|
| committer | Tim Graham <timograham@gmail.com> | 2018-06-20 10:58:01 -0400 |
| commit | 17017ba12a183d491c983ca1ff9c3889619676fe (patch) | |
| tree | 11054cb2c811460b5785985003120363b4ca1479 | |
| parent | dae75481fabbe775160893a2e7cb2b2d73705a8f (diff) | |
[2.1.x] Refs #29451 -- Fixed regex/iregex lookups on MySQL 8.
Backport of 42490768441701bc02255b22df8e6894cbe487c7 from master
| -rw-r--r-- | django/db/backends/mysql/base.py | 2 | ||||
| -rw-r--r-- | django/db/backends/mysql/operations.py | 11 | ||||
| -rw-r--r-- | docs/releases/2.0.7.txt | 2 |
3 files changed, 13 insertions, 2 deletions
diff --git a/django/db/backends/mysql/base.py b/django/db/backends/mysql/base.py index ea6f50ef1c..91e0e83242 100644 --- a/django/db/backends/mysql/base.py +++ b/django/db/backends/mysql/base.py @@ -141,8 +141,6 @@ class DatabaseWrapper(BaseDatabaseWrapper): 'iexact': 'LIKE %s', 'contains': 'LIKE BINARY %s', 'icontains': 'LIKE %s', - 'regex': 'REGEXP BINARY %s', - 'iregex': 'REGEXP %s', 'gt': '> %s', 'gte': '>= %s', 'lt': '< %s', diff --git a/django/db/backends/mysql/operations.py b/django/db/backends/mysql/operations.py index e5c0c5c71b..47e179db41 100644 --- a/django/db/backends/mysql/operations.py +++ b/django/db/backends/mysql/operations.py @@ -282,3 +282,14 @@ class DatabaseOperations(BaseDatabaseOperations): # EXTENDED and FORMAT are mutually exclusive options. prefix += ' EXTENDED' return prefix + + def regex_lookup(self, lookup_type): + # REGEXP BINARY doesn't work correctly in MySQL 8+ and REGEXP_LIKE + # doesn't exist in MySQL 5.6. + if self.connection.mysql_version < (8, 0, 0): + if lookup_type == 'regex': + return '%s REGEXP BINARY %s' + return '%s REGEXP %s' + + match_option = 'c' if lookup_type == 'regex' else 'i' + return "REGEXP_LIKE(%%s, %%s, '%s')" % match_option diff --git a/docs/releases/2.0.7.txt b/docs/releases/2.0.7.txt index 4890ee2dba..8d06deb226 100644 --- a/docs/releases/2.0.7.txt +++ b/docs/releases/2.0.7.txt @@ -14,3 +14,5 @@ Bugfixes * Fixed admin check crash when using a query expression in ``ModelAdmin.ordering`` (:ticket:`29428`). + +* Fixed ``__regex`` and ``__iregex`` lookups with MySQL 8 (:ticket:`29451`). |