From d8ec57e1ff4d38cd1e4fd14a20575f8d275331a3 Mon Sep 17 00:00:00 2001 From: Joshua Morris Date: Sun, 4 Jun 2023 20:52:32 +1000 Subject: [PATCH] Modify implementation of mysql `string_agg` to avoid discarding arguments --- lib/sqlalchemy/dialects/mysql/base.py | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/lib/sqlalchemy/dialects/mysql/base.py b/lib/sqlalchemy/dialects/mysql/base.py index 4712c9b402..8c77f1c585 100644 --- a/lib/sqlalchemy/dialects/mysql/base.py +++ b/lib/sqlalchemy/dialects/mysql/base.py @@ -1210,8 +1210,11 @@ class MySQLCompiler(compiler.SQLCompiler): def visit_string_agg_func(self, fn, **kw): if len(fn.clauses) > 1: + clause = ", ".join( + elem._compiler_dispatch(self, **kw) for elem in fn.clauses[:-1] + ) return "group_concat(%s SEPARATOR %s)" % ( - fn.clauses[0]._compiler_dispatch(self, **kw), + clause, fn.clauses[-1]._compiler_dispatch(self, **kw), ) else: -- 2.47.3