diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2006-03-06 17:14:50 +0000 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2006-03-06 17:14:50 +0000 |
| commit | 34cd446912bbff2426a6e6a0dd78b490b8c54e43 (patch) | |
| tree | e986a2456085b2272ddf418b0b32b6431b094af4 /lib/sqlalchemy/databases/sqlite.py | |
| parent | 1644a44628f6a09bb992752bf266994afe0e98df (diff) | |
| download | sqlalchemy-34cd446912bbff2426a6e6a0dd78b490b8c54e43.tar.gz | |
sqlite likes OFFSET with LIMIT else its buggy
Diffstat (limited to 'lib/sqlalchemy/databases/sqlite.py')
| -rw-r--r-- | lib/sqlalchemy/databases/sqlite.py | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/lib/sqlalchemy/databases/sqlite.py b/lib/sqlalchemy/databases/sqlite.py index 6dc880b05..18a97e3f7 100644 --- a/lib/sqlalchemy/databases/sqlite.py +++ b/lib/sqlalchemy/databases/sqlite.py @@ -222,6 +222,8 @@ class SQLiteCompiler(ansisql.ANSICompiler): if select.limit is None: text += " \n LIMIT -1" text += " OFFSET " + str(select.offset) + else: + text += " OFFSET 0" return text def binary_operator_string(self, binary): if isinstance(binary.type, sqltypes.String) and binary.operator == '+': |