[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[GNUnet-SVN] r5967 - GNUnet/src/applications/sqstore_sqlite
From: |
gnunet |
Subject: |
[GNUnet-SVN] r5967 - GNUnet/src/applications/sqstore_sqlite |
Date: |
Wed, 19 Dec 2007 10:55:42 -0700 (MST) |
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 > ?) "\
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [GNUnet-SVN] r5967 - GNUnet/src/applications/sqstore_sqlite,
gnunet <=