summaryrefslogtreecommitdiff
path: root/test/dialect/test_mssql.py
diff options
context:
space:
mode:
authorMike Bayer <mike_mp@zzzcomputing.com>2013-05-15 15:46:29 -0400
committerMike Bayer <mike_mp@zzzcomputing.com>2013-05-15 15:46:29 -0400
commitcfb0f9ca14f82c9ba06c4d5cbc992f821eb2234e (patch)
treec3609c16161619b0405873b60632972f7fa4b568 /test/dialect/test_mssql.py
parentf574bcf98de0d30f0a28bf82aae84098157de0f4 (diff)
downloadsqlalchemy-cfb0f9ca14f82c9ba06c4d5cbc992f821eb2234e.tar.gz
Regression from this ticket caused the unsupported keyword
"true" to render, added logic to convert this to 1/0 for SQL server. [ticket:2682]
Diffstat (limited to 'test/dialect/test_mssql.py')
-rw-r--r--test/dialect/test_mssql.py11
1 files changed, 11 insertions, 0 deletions
diff --git a/test/dialect/test_mssql.py b/test/dialect/test_mssql.py
index f1cd3fe85..7b8f53390 100644
--- a/test/dialect/test_mssql.py
+++ b/test/dialect/test_mssql.py
@@ -17,10 +17,21 @@ from sqlalchemy.testing import emits_warning_on, assert_raises_message
import decimal
from sqlalchemy.engine.reflection import Inspector
from sqlalchemy.util.compat import b
+from sqlalchemy import sql
+
class CompileTest(fixtures.TestBase, AssertsCompiledSQL):
__dialect__ = mssql.dialect()
+ def test_true_false(self):
+ self.assert_compile(
+ sql.false(), "0"
+ )
+ self.assert_compile(
+ sql.true(),
+ "1"
+ )
+
def test_select(self):
t = table('sometable', column('somecolumn'))
self.assert_compile(t.select(),