[2.0.x] Fixed #28804 -- Fixed "Unknown system variable 'transaction_isolation'" on MariaDB.

Regression in 967450a3bf940c43db891fe1e2ef3bcf73456ff8.

Backport of e3c852cbd609484b272f563f3c21066fb12ef7f8 from master

1 files changed, 3 insertions, 3 deletions

diff --git a/tests/backends/mysql/tests.py b/tests/backends/mysql/tests.py
index 467cd5abc5..02fc312abc 100644
--- a/tests/backends/mysql/tests.py
+++ b/tests/backends/mysql/tests.py
@@ -20,7 +20,7 @@ class IsolationLevelTests(TestCase):
     read_committed = 'read committed'
     repeatable_read = 'repeatable read'
     isolation_values = {
-        level: level.replace(' ', '-').upper()
+        level: level.upper()
         for level in (read_committed, repeatable_read)
     }
 
@@ -38,8 +38,8 @@ class IsolationLevelTests(TestCase):
     @staticmethod
     def get_isolation_level(connection):
         with connection.cursor() as cursor:
-            cursor.execute("SELECT @@session.%s" % connection.transaction_isolation_variable)
-            return cursor.fetchone()[0]
+            cursor.execute("SHOW VARIABLES WHERE variable_name IN ('transaction_isolation', 'tx_isolation')")
+            return cursor.fetchone()[1].replace('-', ' ')
 
     def test_auto_is_null_auto_config(self):
         query = 'set sql_auto_is_null = 0'