summaryrefslogtreecommitdiff
path: root/test/sql
diff options
context:
space:
mode:
authorMike Bayer <mike_mp@zzzcomputing.com>2014-07-22 13:41:47 -0400
committerMike Bayer <mike_mp@zzzcomputing.com>2014-07-22 13:42:38 -0400
commit63c6aa01040831f2bad52c1f7099a78676ac207a (patch)
treea7e8f6cfb73d3895badfa19ee42da0640e14b328 /test/sql
parent76e127450c4bb7047a9babd5263a80e3c6f4cbf9 (diff)
downloadsqlalchemy-63c6aa01040831f2bad52c1f7099a78676ac207a.tar.gz
- update some SQL server tests, support
- add support for IDENTITY INSERT setting for INSERT with inline VALUES
Diffstat (limited to 'test/sql')
-rw-r--r--test/sql/test_join_rewriting.py2
-rw-r--r--test/sql/test_types.py10
2 files changed, 9 insertions, 3 deletions
diff --git a/test/sql/test_join_rewriting.py b/test/sql/test_join_rewriting.py
index 035f60d60..c8b24e2f2 100644
--- a/test/sql/test_join_rewriting.py
+++ b/test/sql/test_join_rewriting.py
@@ -631,6 +631,8 @@ class JoinExecTest(_JoinRewriteTestBase, fixtures.TestBase):
assert col in result._metadata._keymap
@testing.skip_if("oracle", "oracle's cranky")
+ @testing.skip_if("mssql", "can't query EXISTS in the columns "
+ "clause w/o subquery")
def test_a_atobalias_balias_c_w_exists(self):
super(JoinExecTest, self).test_a_atobalias_balias_c_w_exists()
diff --git a/test/sql/test_types.py b/test/sql/test_types.py
index 852591543..b88edbe59 100644
--- a/test/sql/test_types.py
+++ b/test/sql/test_types.py
@@ -900,9 +900,13 @@ class UnicodeTest(fixtures.TestBase):
def test_native_unicode(self):
"""assert expected values for 'native unicode' mode"""
- if (testing.against('mssql+pyodbc') and
- not testing.db.dialect.freetds) \
- or testing.against('mssql+mxodbc'):
+ if testing.against('mssql+pyodbc'):
+ eq_(
+ testing.db.dialect.returns_unicode_strings,
+ 'conditional'
+ )
+
+ elif testing.against('mssql+mxodbc'):
eq_(
testing.db.dialect.returns_unicode_strings,
'conditional'