While looking at the diff in opimd, I found that I made a wrong commit
removing some fixed code by Daniele Ricci.

This commit reverts back his code, merging it with mine.
From 09075a8fe80020b4d6437f534c4957958f4e8927 Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?Marco=20Trevisan=20(Trevi=C3=B1o)?= <[email protected]>
Date: Tue, 22 Feb 2011 20:23:44 +0100
Subject: [PATCH] Revert back Daniele's fixes for limit

This fixes my bad removal in commit 5cc3ef0, that removed the fix made by Daniele Ricci in  5e5970b48
---
 framework/subsystems/opimd/db_handler.py |    3 +--
 1 files changed, 1 insertions(+), 2 deletions(-)

diff --git a/framework/subsystems/opimd/db_handler.py b/framework/subsystems/opimd/db_handler.py
index 070850c..dcde817 100644
--- a/framework/subsystems/opimd/db_handler.py
+++ b/framework/subsystems/opimd/db_handler.py
@@ -405,10 +405,9 @@ class DbHandler(object):
                 raise InvalidField("_limit should be an integer value")
 
         if (limit_start != 0 or limit_end != -1):
-            query = query + " LIMIT ?,?"
+            query = "SELECT * FROM (" + query + ") LIMIT ?,?"
             params.extend([limit_start, limit_end])
 
-
         return {'Query':query, 'Parameters':params}
 
     def sanitize_result(self, raw):
-- 
1.7.1

_______________________________________________
Shr-devel mailing list
[email protected]
http://lists.shr-project.org/mailman/listinfo/shr-devel

Reply via email to