]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
Optimize MySQL foreign key reflection
authorFederico Caselli <cfederico87@gmail.com>
Sat, 12 Oct 2024 12:58:26 +0000 (14:58 +0200)
committerFederico Caselli <cfederico87@gmail.com>
Sat, 12 Oct 2024 12:58:26 +0000 (14:58 +0200)
commita98d31621d58d45e2a4d74351282cedddcfe85fa
tree8b3d77631969cbdfae65020e7d0ee6a5d0cc1938
parent3b7ffd2f9745e6038bbb7209635d3407fe8ff5ec
Optimize MySQL foreign key reflection

Improved foreign keys reflection logic in MySQL 8+ to use a better
optimized query. The previous query could be quite slow in databases
with a large number of columns.

Fixes: #11975
Change-Id: Ie8bcd810d4b37abf7fd5e497596e0ade52c3f82e
doc/build/changelog/unreleased_20/11975.rst [new file with mode: 0644]
lib/sqlalchemy/dialects/mysql/base.py
test/dialect/mysql/test_reflection.py