From 7b18d7266da4e87a9f090d748cea875e155f65e2 Mon Sep 17 00:00:00 2001 From: Caspar Wylie Date: Wed, 1 Feb 2023 22:58:35 +0000 Subject: [PATCH] Fix proper renaming of alias --- lib/sqlalchemy/dialects/mysql/base.py | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/lib/sqlalchemy/dialects/mysql/base.py b/lib/sqlalchemy/dialects/mysql/base.py index 93c1347746..d0126dfd45 100644 --- a/lib/sqlalchemy/dialects/mysql/base.py +++ b/lib/sqlalchemy/dialects/mysql/base.py @@ -1327,7 +1327,7 @@ class MySQLCompiler(compiler.SQLCompiler): else: def replace(obj): - nonlocal alias + nonlocal alias_clause if ( isinstance(obj, elements.BindParameter) and obj.type._isnull @@ -1340,7 +1340,7 @@ class MySQLCompiler(compiler.SQLCompiler): and obj.table is on_duplicate.inserted_alias ): if not alias_clause: - alias = f"AS {ON_DUP_ALIAS_NAME} " + alias_clause = f"AS {ON_DUP_ALIAS_NAME} " return literal_column( f"{ON_DUP_ALIAS_NAME}.{self.preparer.quote(obj.name)}" ) -- 2.47.3