From db307d2149ac79cbe99837071a06fdf221f4a9ae Mon Sep 17 00:00:00 2001
From: Michael Trier <mtrier@gmail.com>
Date: Thu, 29 Jan 2009 17:03:30 +0000
Subject: [PATCH] Fixed up some of the mssql dialect tests for date handling.

---
 test/dialect/mssql.py | 14 +++++++++++---
 1 file changed, 11 insertions(+), 3 deletions(-)

diff --git a/test/dialect/mssql.py b/test/dialect/mssql.py
index ad54282bbb..ace572fd54 100755
--- a/test/dialect/mssql.py
+++ b/test/dialect/mssql.py
@@ -579,15 +579,23 @@ class TypesTest(TestBase, AssertsExecutionResults):
              'DATE', ['>=', (10,)]),
             (types.Date, [], {},
              'DATE', ['>=', (10,)]),
-            (types.DATE, [], {},
-             'DATETIME', ['<', (10,)], mssql.MSDateTime),
             (types.Date, [], {},
              'DATETIME', ['<', (10,)], mssql.MSDateTime),
+            (mssql.MSDate, [], {},
+             'DATE', ['>=', (10,)]),
+            (mssql.MSDate, [], {},
+             'DATETIME', ['<', (10,)], mssql.MSDateTime),
 
+            (types.TIME, [], {},
+             'TIME', ['>=', (10,)]),
+            (types.Time, [], {},
+             'TIME', ['>=', (10,)]),
             (mssql.MSTime, [], {},
              'TIME', ['>=', (10,)]),
-            (mssql.MSTime, [1], {},
+            (types.Time, [1], {},
              'TIME(1)', ['>=', (10,)]),
+            (types.Time, [], {},
+             'DATETIME', ['<', (10,)], mssql.MSDateTime),
             (mssql.MSTime, [], {},
              'DATETIME', ['<', (10,)], mssql.MSDateTime),
 
-- 
2.47.3