From 34cd446912bbff2426a6e6a0dd78b490b8c54e43 Mon Sep 17 00:00:00 2001
From: Mike Bayer <mike_mp@zzzcomputing.com>
Date: Mon, 6 Mar 2006 17:14:50 +0000
Subject: [PATCH] sqlite likes OFFSET with LIMIT else its buggy

---
 lib/sqlalchemy/databases/sqlite.py | 2 ++
 1 file changed, 2 insertions(+)

diff --git a/lib/sqlalchemy/databases/sqlite.py b/lib/sqlalchemy/databases/sqlite.py
index 6dc880b051..18a97e3f78 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 == '+':
-- 
2.47.2