diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2013-02-02 16:17:58 -0500 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2013-02-02 16:17:58 -0500 |
| commit | cb19f227f31701322f398b5bdd77427dfc81da0d (patch) | |
| tree | 644fb3803e3948888b61ff5b4af804615c66ee8a /test/dialect | |
| parent | da3d817f3624d5f631956e33d92799572f47e52f (diff) | |
| download | sqlalchemy-cb19f227f31701322f398b5bdd77427dfc81da0d.tar.gz | |
The :meth:`.ColumnOperators.in_` operator will now coerce
values of ``None`` to :func:`.null`.
[ticket:2496]
Diffstat (limited to 'test/dialect')
| -rw-r--r-- | test/dialect/test_mssql.py | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/test/dialect/test_mssql.py b/test/dialect/test_mssql.py index 210f8c748..52ba77310 100644 --- a/test/dialect/test_mssql.py +++ b/test/dialect/test_mssql.py @@ -171,6 +171,10 @@ class CompileTest(fixtures.TestBase, AssertsCompiledSQL): select([t]).where(t.c.foo.in_(['x', 'y', 'z'])), "SELECT sometable.foo FROM sometable WHERE sometable.foo " "IN ('x', 'y', 'z')", + ), + ( + t.c.foo.in_([None]), + "sometable.foo IN (NULL)" ) ]: self.assert_compile(expr, compile, dialect=mxodbc_dialect) |