]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
Handle SHOW VARIABLES returning no row
authorMike Bayer <mike_mp@zzzcomputing.com>
Fri, 16 Jun 2017 17:30:25 +0000 (13:30 -0400)
committerMike Bayer <mike_mp@zzzcomputing.com>
Fri, 16 Jun 2017 19:54:47 +0000 (15:54 -0400)
commit94a0ed697a120629715ab1fd73d708ec75775e3d
tree216f206b15bf0049a7c933e727740548e6ca6a9c
parentd2131156de654de697e14e4f1fb993c22dca2287
Handle SHOW VARIABLES returning no row

MySQL 5.7 has introduced permission limiting for the "SHOW VARIABLES"
command; the MySQL dialect will now handle when SHOW returns no
row, in particular for the initial fetch of SQL_MODE, and will
emit a warning that user permissions should be modified to allow the
row to be present.

Change-Id: I98e7a69230da397b17eae07b7e9d024fa7aeeb26
Fixes: #4007
(cherry picked from commit 5650a0c306391216a9c9ce1961c5b548e534b5eb)
doc/build/changelog/changelog_11.rst
lib/sqlalchemy/dialects/mysql/base.py
test/dialect/mysql/test_dialect.py