Merge "SYBASE: Added offset support"

1 files changed, 15 insertions, 8 deletions

diff --git a/test/dialect/test_sybase.py b/test/dialect/test_sybase.py
index b49c8cfb3..f41fe4846 100644
--- a/test/dialect/test_sybase.py
+++ b/test/dialect/test_sybase.py
@@ -2,7 +2,6 @@ from sqlalchemy import extract
 from sqlalchemy import select
 from sqlalchemy import sql
 from sqlalchemy.dialects import sybase
-from sqlalchemy.testing import assert_raises_message
 from sqlalchemy.testing import AssertsCompiledSQL
 from sqlalchemy.testing import fixtures
 
@@ -28,15 +27,23 @@ class CompileTest(fixtures.TestBase, AssertsCompiledSQL):
                 'SELECT DATEPART("%s", t.col1) AS anon_1 FROM t' % subst,
             )
 
-    def test_offset_not_supported(self):
-        stmt = select([1]).offset(10)
-        assert_raises_message(
-            NotImplementedError,
-            "Sybase ASE does not support OFFSET",
-            stmt.compile,
-            dialect=self.__dialect__,
+    def test_limit_offset(self):
+        stmt = select([1]).limit(5).offset(6)
+        assert stmt.compile().params == {"param_1": 5, "param_2": 6}
+        self.assert_compile(
+            stmt, "SELECT 1 ROWS LIMIT :param_1 OFFSET :param_2"
         )
 
+    def test_offset(self):
+        stmt = select([1]).offset(10)
+        assert stmt.compile().params == {"param_1": 10}
+        self.assert_compile(stmt, "SELECT 1 ROWS OFFSET :param_1")
+
+    def test_limit(self):
+        stmt = select([1]).limit(5)
+        assert stmt.compile().params == {"param_1": 5}
+        self.assert_compile(stmt, "SELECT 1 ROWS LIMIT :param_1")
+
     def test_delete_extra_froms(self):
         t1 = sql.table("t1", sql.column("c1"))
         t2 = sql.table("t2", sql.column("c1"))