From b920869ef54d05e73e2a980b73647d6050ffeb9d Mon Sep 17 00:00:00 2001 From: Gord Thompson Date: Thu, 24 Jun 2021 12:16:32 -0600 Subject: Modernize tests Eliminate engine.execute() and engine.scalar() Change-Id: I99f76d0e615ddebab2da4fd07a40a0a2796995c7 --- lib/sqlalchemy/dialects/mysql/base.py | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) (limited to 'lib/sqlalchemy/dialects/mysql/base.py') diff --git a/lib/sqlalchemy/dialects/mysql/base.py b/lib/sqlalchemy/dialects/mysql/base.py index cfb6c2924..e39010762 100644 --- a/lib/sqlalchemy/dialects/mysql/base.py +++ b/lib/sqlalchemy/dialects/mysql/base.py @@ -3358,10 +3358,11 @@ class MySQLDialect(default.DefaultDialect): # https://dev.mysql.com/doc/refman/en/identifier-case-sensitivity.html charset = self._connection_charset + show_var = connection.execute( + sql.text("SHOW VARIABLES LIKE 'lower_case_table_names'") + ) row = self._compat_first( - connection.execute( - sql.text("SHOW VARIABLES LIKE 'lower_case_table_names'") - ), + show_var, charset=charset, ) if not row: -- cgit v1.2.1