]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
pass asfrom correctly in compilers
authorMike Bayer <mike_mp@zzzcomputing.com>
Sat, 17 Apr 2021 04:30:29 +0000 (00:30 -0400)
committerMike Bayer <mike_mp@zzzcomputing.com>
Sat, 17 Apr 2021 04:37:47 +0000 (00:37 -0400)
commit901f7a2b534e4bbc88d7c6894541223cb0dd968d
tree6a647d3a18a771855d876a6c358fd9241213a219
parentb73fc8f874da94c9c5b2d94feb6b1b45b7f4f02b
pass asfrom correctly in compilers

Fixed an argument error in the default and PostgreSQL compilers that
would interfere with an UPDATE..FROM or DELETE..FROM..USING statement
that was then SELECTed from as a CTE.

The incorrect pattern was also fixed in the mysql and sybase dialects.
MySQL supports CTEs but not "returning".

Fixes: #6303
Change-Id: Ic94805611a5ec443749fb6b1fd8a1326b0d83ef7
doc/build/changelog/unreleased_14/6303.rst [new file with mode: 0644]
lib/sqlalchemy/dialects/mysql/base.py
lib/sqlalchemy/dialects/postgresql/base.py
lib/sqlalchemy/dialects/sybase/base.py
lib/sqlalchemy/sql/compiler.py
test/sql/test_cte.py