[GNUnet-SVN] r5967 - GNUnet/src/applications/sqstore_sqlite

[gnunet]

Author: grothoff
Date: 2007-12-19 10:55:42 -0700 (Wed, 19 Dec 2007)
New Revision: 5967

Modified:
   GNUnet/src/applications/sqstore_sqlite/sqlite.c
Log:
stupid order by

Modified: GNUnet/src/applications/sqstore_sqlite/sqlite.c
===================================================================
--- GNUnet/src/applications/sqstore_sqlite/sqlite.c     2007-12-19 17:54:22 UTC 
(rev 5966)
+++ GNUnet/src/applications/sqstore_sqlite/sqlite.c     2007-12-19 17:55:42 UTC 
(rev 5967)
@@ -53,7 +53,7 @@
 
 #define SELECT_IT_LOW_PRIORITY_1 \
   "SELECT size,type,prio,anonLevel,expire,hash,value,_ROWID_ FROM gn070 WHERE 
(prio = ? AND hash > ?) "\
-  "ORDER BY prio ASC, hash ASC LIMIT 1"
+  "ORDER BY hash ASC LIMIT 1"
 
 #define SELECT_IT_LOW_PRIORITY_2 \
   "SELECT size,type,prio,anonLevel,expire,hash,value,_ROWID_ FROM gn070 WHERE 
(prio > ?) "\
@@ -61,7 +61,7 @@
 
 #define SELECT_IT_NON_ANONYMOUS_1 \
   "SELECT size,type,prio,anonLevel,expire,hash,value,_ROWID_ FROM gn070 WHERE 
(prio = ? AND hash < ? AND anonLevel = 0) "\
-  " ORDER BY prio DESC, hash DESC LIMIT 1"
+  " ORDER BY hash DESC LIMIT 1"
 
 #define SELECT_IT_NON_ANONYMOUS_2 \
   "SELECT size,type,prio,anonLevel,expire,hash,value,_ROWID_ FROM gn070 WHERE 
(prio < ? AND anonLevel = 0)"\
@@ -69,7 +69,7 @@
 
 #define SELECT_IT_EXPIRATION_TIME_1 \
   "SELECT size,type,prio,anonLevel,expire,hash,value,_ROWID_ FROM gn070 WHERE 
(expire = ? AND hash > ?) "\
-  " ORDER BY expire ASC, hash ASC LIMIT 1"
+  " ORDER BY hash ASC LIMIT 1"
 
 #define SELECT_IT_EXPIRATION_TIME_2 \
   "SELECT size,type,prio,anonLevel,expire,hash,value,_ROWID_ FROM gn070 WHERE 
(expire > ?) "\