]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
Perform additional retrieval of correct column names
authorMike Bayer <mike_mp@zzzcomputing.com>
Tue, 2 Oct 2018 21:49:44 +0000 (17:49 -0400)
committerMike Bayer <mike_mp@zzzcomputing.com>
Wed, 3 Oct 2018 13:53:22 +0000 (09:53 -0400)
commit4c15580fa4e36a585d4eb599d96579c526ee353d
tree7c3e9d7125b2a76f072428944f0ca1dca8adda4b
parentdb160e73d04fc9856e8e4f306cb5d7c059928eec
Perform additional retrieval of correct column names

Added a workaround for a MySQL bug #88718 introduced in the 8.0 series,
where the reflection of a foreign key constraint is not reporting the
correct case sensitivity for the referred column, leading to errors during
use of the reflected constraint such as when using the automap extension.
The workaround emits an additional query to the information_schema tables in
order to retrieve the correct case sensitive name.

Fixes: #4344
Change-Id: I08020d6eec43cbe8a56316660380d3739a0b45f7
(cherry picked from commit 56fb68ca8620a211ca29b3d47d649dfa332d354a)
doc/build/changelog/unreleased_12/4344.rst [new file with mode: 0644]
lib/sqlalchemy/dialects/mysql/base.py
test/dialect/mysql/test_reflection.py