diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2011-09-23 21:56:10 -0400 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2011-09-23 21:56:10 -0400 |
| commit | c52e31b1e019fb447e0a2edb7e2c75ebe9307a95 (patch) | |
| tree | d0986a19a3bef4112f79db44953d55fdafc1e40e /test/dialect/test_mssql.py | |
| parent | e4c04590a6438f73278675e96dd84b57121eeb5f (diff) | |
| download | sqlalchemy-c52e31b1e019fb447e0a2edb7e2c75ebe9307a95.tar.gz | |
- The behavior of =/!= when comparing a scalar select
to a value will no longer produce IN/NOT IN as of 0.8;
this behavior is a little too heavy handed (use in_() if
you want to emit IN) and now emits a deprecation warning.
To get the 0.8 behavior immediately and remove the warning,
a compiler recipe is given at
http://www.sqlalchemy.org/docs/07/dialects/mssql.html#scalar-select-comparisons
to override the behavior of visit_binary().
[ticket:2277]
Diffstat (limited to 'test/dialect/test_mssql.py')
| -rw-r--r-- | test/dialect/test_mssql.py | 9 |
1 files changed, 5 insertions, 4 deletions
diff --git a/test/dialect/test_mssql.py b/test/dialect/test_mssql.py index 4cce395b8..f336f5f3b 100644 --- a/test/dialect/test_mssql.py +++ b/test/dialect/test_mssql.py @@ -63,6 +63,7 @@ class CompileTest(fixtures.TestBase, AssertsCompiledSQL): ]: self.assert_compile(expr, compile, dialect=mxodbc_dialect) + @testing.uses_deprecated def test_in_with_subqueries(self): """Test that when using subqueries in a binary expression the == and != are changed to IN and NOT IN respectively. @@ -117,7 +118,7 @@ class CompileTest(fixtures.TestBase, AssertsCompiledSQL): 'DELETE FROM paj.test WHERE paj.test.id = ' ':id_1') s = select([tbl.c.id]).where(tbl.c.id == 1) - self.assert_compile(tbl.delete().where(tbl.c.id == s), + self.assert_compile(tbl.delete().where(tbl.c.id.in_(s)), 'DELETE FROM paj.test WHERE paj.test.id IN ' '(SELECT test_1.id FROM paj.test AS test_1 ' 'WHERE test_1.id = :id_1)') @@ -130,7 +131,7 @@ class CompileTest(fixtures.TestBase, AssertsCompiledSQL): 'DELETE FROM banana.paj.test WHERE ' 'banana.paj.test.id = :id_1') s = select([tbl.c.id]).where(tbl.c.id == 1) - self.assert_compile(tbl.delete().where(tbl.c.id == s), + self.assert_compile(tbl.delete().where(tbl.c.id.in_(s)), 'DELETE FROM banana.paj.test WHERE ' 'banana.paj.test.id IN (SELECT test_1.id ' 'FROM banana.paj.test AS test_1 WHERE ' @@ -144,7 +145,7 @@ class CompileTest(fixtures.TestBase, AssertsCompiledSQL): 'DELETE FROM [banana split].paj.test WHERE ' '[banana split].paj.test.id = :id_1') s = select([tbl.c.id]).where(tbl.c.id == 1) - self.assert_compile(tbl.delete().where(tbl.c.id == s), + self.assert_compile(tbl.delete().where(tbl.c.id.in_(s)), 'DELETE FROM [banana split].paj.test WHERE ' '[banana split].paj.test.id IN (SELECT ' 'test_1.id FROM [banana split].paj.test AS ' @@ -160,7 +161,7 @@ class CompileTest(fixtures.TestBase, AssertsCompiledSQL): 'space].test WHERE [banana split].[paj ' 'with a space].test.id = :id_1') s = select([tbl.c.id]).where(tbl.c.id == 1) - self.assert_compile(tbl.delete().where(tbl.c.id == s), + self.assert_compile(tbl.delete().where(tbl.c.id.in_(s)), 'DELETE FROM [banana split].[paj with a ' 'space].test WHERE [banana split].[paj ' 'with a space].test.id IN (SELECT ' |