]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
render col name in on conflict set clause, not given key
authorMike Bayer <mike_mp@zzzcomputing.com>
Fri, 13 May 2022 20:08:34 +0000 (16:08 -0400)
committerMike Bayer <mike_mp@zzzcomputing.com>
Sun, 15 May 2022 21:29:26 +0000 (17:29 -0400)
commitdb861363b7cfa82e5fe8c35fa83c8250d638f280
tree944e8b0d276539b4696ad91bec603217d8af51c3
parent067102a304012ce6afd0097627d5717994930488
render col name in on conflict set clause, not given key

Fixed bug where the PostgreSQL :meth:`_postgresql.Insert.on_conflict`
method and the SQLite :meth:`_sqlite.Insert.on_conflict` method would both
fail to correctly accommodate a column with a separate ".key" when
specifying the column using its key name in the dictionary passed to
``set_``, as well as if the :attr:`_sqlite.Insert.excluded` or
:attr:`_postgresql.Insert.excluded` collection were used as the dictionary
directly.

Fixes: #8014
Change-Id: I67226aeedcb2c683e22405af64720cc1f990f274
(cherry picked from commit 927abc3b33f10464ed04db3d7a454faeb6e729f2)
doc/build/changelog/unreleased_14/8014.rst [new file with mode: 0644]
lib/sqlalchemy/dialects/postgresql/base.py
lib/sqlalchemy/dialects/sqlite/base.py
test/dialect/postgresql/test_compiler.py
test/dialect/test_sqlite.py