]> 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:52:46 +0000 (15:52 -0400)
commit5650a0c306391216a9c9ce1961c5b548e534b5eb
tree23e15c4971f08e8342bbea6784ce2bbd62168c91
parent3a314fcea8539133947d5ec8e42a6c86e30fdf9a
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
doc/build/changelog/changelog_11.rst
lib/sqlalchemy/dialects/mysql/base.py
test/dialect/mysql/test_dialect.py