Merge lp:~voluntatefaber/lingo-dictionary/recents-fixes into lp:lingo-dictionary

[Andrea Basso]

[Cody Garver (codygarver)]

review: Approve

[Cody Garver (codygarver)]

This has been superseded by commit 152.

review: Disapprove

[Cody Garver (codygarver)]

Ignore that comment, it's on the wrong branch..

review: Approve

=== modified file 'src/lingo-database.vala'
--- src/lingo-database.vala	2012-02-11 19:39:21 +0000
+++ src/lingo-database.vala	2012-03-03 22:37:37 +0000
@@ -303,7 +303,7 @@
             execute_statement(stmt);
 
             // Deep magic begins here ...
-            execute_sql ("DELETE FROM recent WHERE id = CASE WHEN (SELECT COUNT(word) FROM recent) > 10 THEN (SELECT MIN(id) FROM recent) ELSE (SELECT (MIN(word) + 1) FROM recent) END");
+            execute_sql ("DELETE FROM recent WHERE id = CASE WHEN (SELECT COUNT(word) FROM recent) > 10 THEN (SELECT MIN(id) FROM recent) ELSE (SELECT (-1) FROM recent) END");
         }
 
         public void clear_recents () {