]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
Scan for tables without relying upon whereclause
authorMike Bayer <mike_mp@zzzcomputing.com>
Tue, 29 Sep 2020 18:17:42 +0000 (14:17 -0400)
committerMike Bayer <mike_mp@zzzcomputing.com>
Tue, 29 Sep 2020 23:59:55 +0000 (19:59 -0400)
commitf4cc32f66269c98b379920334180514df921397a
tree5d4e9b3efac0541005e6c97326d9f054b8208387
parent2080d87acbb21bbdba67c41a0c1ef869a27163be
Scan for tables without relying upon whereclause

Fixed bug where an UPDATE statement against a JOIN using MySQL multi-table
format would fail to include the table prefix for the target table if the
statement had no WHERE clause, as only the WHERE clause were scanned to
detect a "multi table update" at that particular point.  The target
is now also scanned if it's a JOIN to get the leftmost table as the
primary table and the additional entries as additional FROM entries.

Fixes: #5617
Change-Id: I26d74afebe06e28af28acf960258f170a1627823
(cherry picked from commit 7d8c93d3d0eaf39ec7beb1dcb32ee0e11d3f77fa)
doc/build/changelog/unreleased_13/5617.rst [new file with mode: 0644]
lib/sqlalchemy/sql/dml.py
lib/sqlalchemy/sql/util.py
setup.cfg
test/aaa_profiling/test_compiler.py
test/profiles.txt
test/sql/test_update.py