From d12b37f90ef538300f8ebb454eec75beccbe929f Mon Sep 17 00:00:00 2001 From: inytar Date: Mon, 30 Oct 2017 12:01:49 -0400 Subject: Allow delete where clause to refer multiple tables. Implemented "DELETE..FROM" syntax for Postgresql, MySQL, MS SQL Server (as well as within the unsupported Sybase dialect) in a manner similar to how "UPDATE..FROM" works. A DELETE statement that refers to more than one table will switch into "multi-table" mode and render the appropriate "USING" or multi-table "FROM" clause as understood by the database. Pull request courtesy Pieter Mulder. For SQL syntaxes see: Postgresql: https://www.postgresql.org/docs/current/static/sql-delete.html MySQL: https://dev.mysql.com/doc/refman/5.7/en/delete.html#multiple-table_syntax MSSQL: https://docs.microsoft.com/en-us/sql/t-sql/statements/delete-transact-sql Sybase: http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc00801.1510/html/iqrefso/X315721.htm Co-authored by: Mike Bayer Change-Id: I6dfd57b49e44a095d076dc493cd2360bb5d920d3 Pull-request: https://github.com/zzzeek/sqlalchemy/pull/392 Fixes: #959 --- test/sql/test_compiler.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'test/sql/test_compiler.py') diff --git a/test/sql/test_compiler.py b/test/sql/test_compiler.py index 053619f46..988230ac5 100644 --- a/test/sql/test_compiler.py +++ b/test/sql/test_compiler.py @@ -2926,7 +2926,7 @@ class ExecutionOptionsTest(fixtures.TestBase): class CRUDTest(fixtures.TestBase, AssertsCompiledSQL): - __dialect__ = 'default' + __dialect__ = 'default_enhanced' def test_insert_literal_binds(self): stmt = table1.insert().values(myid=3, name='jack') -- cgit v1.2.1