diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2012-04-18 19:52:58 -0400 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2012-04-18 19:52:58 -0400 |
| commit | 541e59c3d7c141cfe532b26b5fbf4b8a8d30b841 (patch) | |
| tree | cb390b3341ddd4a0fdbd21646a7ee54f150b9b95 /test/dialect/test_mssql.py | |
| parent | fdda4b0e018f8c1a869411b7ed31387ea90cb082 (diff) | |
| download | sqlalchemy-541e59c3d7c141cfe532b26b5fbf4b8a8d30b841.tar.gz | |
- [bug] UPDATE..FROM syntax with SQL Server
requires that the updated table be present
in the FROM clause when an alias of that
table is also present in the FROM clause.
The updated table is now always present
in the FROM, when FROM is present
in the first place. Courtesy sayap.
[ticket:2468]
Diffstat (limited to 'test/dialect/test_mssql.py')
| -rw-r--r-- | test/dialect/test_mssql.py | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/test/dialect/test_mssql.py b/test/dialect/test_mssql.py index 2b35ff57f..74e96c8ef 100644 --- a/test/dialect/test_mssql.py +++ b/test/dialect/test_mssql.py @@ -136,7 +136,7 @@ class CompileTest(fixtures.TestBase, AssertsCompiledSQL): selectable=t2, dialect_name=darg), "UPDATE sometable SET somecolumn=:somecolumn " - "FROM othertable WITH (PAGLOCK) " + "FROM sometable, othertable WITH (PAGLOCK) " "WHERE sometable.somecolumn = othertable.somecolumn" ) |