From 61016f17d1a5aff1224d6609d74952be1d6e09ad Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Wed, 20 Jan 2016 16:32:27 -0500 Subject: - The unsupported Sybase dialect now raises ``NotImplementedError`` when attempting to compile a query that includes "offset"; Sybase has no straightforward "offset" feature. fixes #2278 --- lib/sqlalchemy/dialects/sybase/base.py | 6 +----- 1 file changed, 1 insertion(+), 5 deletions(-) (limited to 'lib/sqlalchemy/dialects') diff --git a/lib/sqlalchemy/dialects/sybase/base.py b/lib/sqlalchemy/dialects/sybase/base.py index b3f8e307a..187521831 100644 --- a/lib/sqlalchemy/dialects/sybase/base.py +++ b/lib/sqlalchemy/dialects/sybase/base.py @@ -336,11 +336,7 @@ class SybaseSQLCompiler(compiler.SQLCompiler): s += "TOP %s " % (limit,) offset = select._offset if offset: - if not limit: - # FIXME: sybase doesn't allow an offset without a limit - # so use a huge value for TOP here - s += "TOP 1000000 " - s += "START AT %s " % (offset + 1,) + raise NotImplementedError("Sybase ASE does not support OFFSET") return s def get_from_hint_text(self, table, text): -- cgit v1.2.1