diff options
Diffstat (limited to 'test/dialect/test_mssql.py')
| -rw-r--r-- | test/dialect/test_mssql.py | 11 |
1 files changed, 5 insertions, 6 deletions
diff --git a/test/dialect/test_mssql.py b/test/dialect/test_mssql.py index 74e96c8ef..6ae0dfc45 100644 --- a/test/dialect/test_mssql.py +++ b/test/dialect/test_mssql.py @@ -183,10 +183,9 @@ 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. + """Test removal of legacy behavior that converted "x==subquery" + to use IN. """ @@ -194,14 +193,14 @@ class CompileTest(fixtures.TestBase, AssertsCompiledSQL): self.assert_compile(t.select().where(t.c.somecolumn == t.select()), 'SELECT sometable.somecolumn FROM ' - 'sometable WHERE sometable.somecolumn IN ' + 'sometable WHERE sometable.somecolumn = ' '(SELECT sometable.somecolumn FROM ' 'sometable)') self.assert_compile(t.select().where(t.c.somecolumn != t.select()), 'SELECT sometable.somecolumn FROM ' - 'sometable WHERE sometable.somecolumn NOT ' - 'IN (SELECT sometable.somecolumn FROM ' + 'sometable WHERE sometable.somecolumn != ' + '(SELECT sometable.somecolumn FROM ' 'sometable)') def test_count(self): |