diff options
| author | inytar <pietpiet@fastmail.net> | 2017-10-30 12:01:49 -0400 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2017-12-05 14:26:28 -0500 |
| commit | d12b37f90ef538300f8ebb454eec75beccbe929f (patch) | |
| tree | 4a172a7322d2e65172f25439a17ce4d773ff52da /test/sql/test_compiler.py | |
| parent | 76b5981b41618048c4c593bbd9062c34ddc1fa36 (diff) | |
| download | sqlalchemy-d12b37f90ef538300f8ebb454eec75beccbe929f.tar.gz | |
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 <mike_mp@zzzcomputing.com>
Change-Id: I6dfd57b49e44a095d076dc493cd2360bb5d920d3
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/392
Fixes: #959
Diffstat (limited to 'test/sql/test_compiler.py')
| -rw-r--r-- | test/sql/test_compiler.py | 2 |
1 files changed, 1 insertions, 1 deletions
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') |