From ab1799a2a1951fe8f188b6395fde04a233a3ac0d Mon Sep 17 00:00:00 2001
From: Elkin <elkin@raketa.im>
Date: Wed, 5 Feb 2020 09:51:14 -0500
Subject: MSSQL 2014 OFFSET/FETCH syntax support

SQL Server OFFSET and FETCH keywords are now used for limit/offset, rather
than using a window function, for SQL Server versions 11 and higher. TOP is
still used for a query that features only LIMIT.   Pull request courtesy
Elkin.

Fixes: #5084
Closes: #5125
Pull-request: https://github.com/sqlalchemy/sqlalchemy/pull/5125
Pull-request-sha: a45b7f73090d2053e3a7020d4e3d7fabb0c5627d

Change-Id: Id6a01ba30caac87d7d3d92c3903cdfd77fbcee5e
---
 test/sql/test_query.py | 1 -
 1 file changed, 1 deletion(-)

(limited to 'test/sql')

diff --git a/test/sql/test_query.py b/test/sql/test_query.py
index 9e56b6489..ce57260b7 100644
--- a/test/sql/test_query.py
+++ b/test/sql/test_query.py
@@ -1013,7 +1013,6 @@ class LimitTest(fixtures.TestBase):
         self.assert_(r[0] != r[1] and r[1] != r[2], repr(r))
 
     @testing.requires.offset
-    @testing.fails_on("mssql", "FIXME: unknown")
     def test_select_distinct_offset(self):
         """Test the interaction between distinct and offset"""
 
-- 
cgit v1.2.1