From 64f92c23e6529e0d7879570c51488d8cf22b8e60 Mon Sep 17 00:00:00 2001
From: Tobias Petersen <tobias.petersen@mikrodust.com>
Date: Fri, 13 Sep 2024 15:56:07 +0200
Subject: [PATCH] Merge url query args to opts in mariadbconnector like mysqldb

Fixes: #11870
---
 lib/sqlalchemy/dialects/mysql/mariadbconnector.py | 1 +
 test/dialect/mysql/test_dialect.py                | 2 ++
 2 files changed, 3 insertions(+)

diff --git a/lib/sqlalchemy/dialects/mysql/mariadbconnector.py b/lib/sqlalchemy/dialects/mysql/mariadbconnector.py
index c33ccd3b93..03af478494 100644
--- a/lib/sqlalchemy/dialects/mysql/mariadbconnector.py
+++ b/lib/sqlalchemy/dialects/mysql/mariadbconnector.py
@@ -166,6 +166,7 @@ class MySQLDialect_mariadbconnector(MySQLDialect):
 
     def create_connect_args(self, url):
         opts = url.translate_connect_args()
+        opts.update(url.query)
 
         int_params = [
             "connect_timeout",
diff --git a/test/dialect/mysql/test_dialect.py b/test/dialect/mysql/test_dialect.py
index c50755df41..7ad9998d0e 100644
--- a/test/dialect/mysql/test_dialect.py
+++ b/test/dialect/mysql/test_dialect.py
@@ -320,8 +320,10 @@ class DialectTest(fixtures.TestBase):
         [
             "mysql+mysqldb",
             "mysql+pymysql",
+            "mysql+mariadbconnector",
             "mariadb+mysqldb",
             "mariadb+pymysql",
+            "mariadb+mariadbconnector",
         ]
     )
     def test_random_arg(self):
-- 
2.47.2