]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
fall back to SHOW VARIABLES for MySQL < 5.6
authorMike Bayer <mike_mp@zzzcomputing.com>
Fri, 4 Feb 2022 02:58:14 +0000 (21:58 -0500)
committerMike Bayer <mike_mp@zzzcomputing.com>
Fri, 4 Feb 2022 17:38:53 +0000 (12:38 -0500)
commit9f1ed1c68af05eab5851ffd038011e3e3bd36b63
treeee53a1992a65a2b9c2fb95e0333fb8daf413662d
parentb93cef577d6471aa18a6b1cde8a97598fc837377
fall back to SHOW VARIABLES for MySQL < 5.6

Fixed regression caused by :ticket:`7518` where changing the syntax "SHOW
VARIABLES" to "SELECT @@" broke compatibility with MySQL versions older
than 5.6, including early 5.0 releases. While these are very old MySQL
versions, a change in compatibility was not planned, so version-specific
logic has been restored to fall back to "SHOW VARIABLES" for MySQL server
versions < 5.6.

includes unrelated orm/test_expire ordering issue , only showing
up on 1.4 / py2.7 but seems to be passing by luck otherwise

Fixes: #7518
Change-Id: Ia554080af742f2c3437f88cf3f7a4827b5e55da8
doc/build/changelog/unreleased_14/7518.rst [new file with mode: 0644]
lib/sqlalchemy/dialects/mysql/base.py
lib/sqlalchemy/dialects/mysql/pyodbc.py
test/dialect/mysql/test_dialect.py
test/orm/test_expire.py