]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
establish consistency for RETURNING column labels
authorMike Bayer <mike_mp@zzzcomputing.com>
Mon, 7 Nov 2022 23:40:03 +0000 (18:40 -0500)
committermike bayer <mike_mp@zzzcomputing.com>
Fri, 11 Nov 2022 16:20:00 +0000 (16:20 +0000)
commit8e91cfe529b9b0150c16e52e22e4590bfbbe79fd
treedc8328ae669164a8fe7cf9c8a821ba92a9057921
parente3a8d198917f4246365e09fa975d55c64082cd2e
establish consistency for RETURNING column labels

The RETURNING clause now renders columns using the routine as that of the
:class:`.Select` to generate labels, which will include disambiguating
labels, as well as that a SQL function surrounding a named column will be
labeled using the column name itself. This is a more comprehensive change
than a similar one made for the 1.4 series that adjusted the function label
issue only.

includes 1.4's changelog for the backported version which also
fixes an Oracle issue independently of the 2.0 series.

Fixes: #8770
Change-Id: I2ab078a214a778ffe1720dbd864ae4c105a0691d
doc/build/changelog/unreleased_14/8770.rst [new file with mode: 0644]
doc/build/changelog/unreleased_20/8770.rst [new file with mode: 0644]
lib/sqlalchemy/dialects/mssql/base.py
lib/sqlalchemy/sql/compiler.py
lib/sqlalchemy/sql/dml.py
lib/sqlalchemy/sql/selectable.py
test/dialect/mssql/test_compiler.py
test/dialect/oracle/test_compiler.py
test/dialect/postgresql/test_compiler.py
test/sql/test_labels.py
test/sql/test_returning.py