diff options
Diffstat (limited to 'test')
| -rw-r--r-- | test/dialect/test_sybase.py | 23 |
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")) |