skip dupe order by test on mssql

SQL Server wants to complain if ORDER BY specifies the same
expression more than once, so just skip this test added in
aaba0650d7410f579b2c14f8f1b0680a1d1852c4 as this only needs
to test ORM functionality.

Change-Id: I857746771ed9c661043d7a8661efe9f47449c466

2 files changed, 10 insertions, 0 deletions

diff --git a/test/orm/test_dynamic.py b/test/orm/test_dynamic.py
index 68547b153..b4ab4047d 100644
--- a/test/orm/test_dynamic.py
+++ b/test/orm/test_dynamic.py
@@ -343,6 +343,7 @@ class DynamicTest(_DynamicFixture, _fixtures.FixtureTest, AssertsCompiledSQL):
             ],
         )
 
+    @testing.requires.dupe_order_by_ok
     def test_order_by_composition_uses_immutable_tuple(self):
         addresses = self.tables.addresses
         User, Address = self._user_address_fixture(
diff --git a/test/requirements.py b/test/requirements.py
index 6628d9ef3..86ae3d4b5 100644
--- a/test/requirements.py
+++ b/test/requirements.py
@@ -706,6 +706,15 @@ class DefaultRequirements(SuiteRequirements):
         )
 
     @property
+    def dupe_order_by_ok(self):
+        """target db wont choke if ORDER BY specifies the same expression
+        more than once
+
+        """
+
+        return skip_if("mssql")
+
+    @property
     def order_by_col_from_union(self):
         """target database supports ordering by a column from a SELECT
         inside of a UNION