diff options
Diffstat (limited to 'src/datastore/plugin_datastore_sqlite.c')
-rw-r--r-- | src/datastore/plugin_datastore_sqlite.c | 12 |
1 files changed, 4 insertions, 8 deletions
diff --git a/src/datastore/plugin_datastore_sqlite.c b/src/datastore/plugin_datastore_sqlite.c index c5952bcb0..2620c3682 100644 --- a/src/datastore/plugin_datastore_sqlite.c +++ b/src/datastore/plugin_datastore_sqlite.c | |||
@@ -326,15 +326,12 @@ database_setup (const struct GNUNET_CONFIGURATION_Handle *cfg, | |||
326 | (sq_prepare | 326 | (sq_prepare |
327 | (plugin->dbh, | 327 | (plugin->dbh, |
328 | "SELECT type,prio,anonLevel,expire,hash,value,_ROWID_ " | 328 | "SELECT type,prio,anonLevel,expire,hash,value,_ROWID_ " |
329 | "FROM gn090 INDEXED BY idx_repl_rvalue " | 329 | "FROM gn090 INDEXED BY idx_repl_rvalue WHERE repl=?2 AND " |
330 | "WHERE repl=?2 AND " | ||
331 | " (rvalue>=?1 OR " | 330 | " (rvalue>=?1 OR " |
332 | " NOT EXISTS (SELECT 1 FROM gn090 INDEXED BY idx_repl_rvalue WHERE repl=?2 AND rvalue>=?1 LIMIT 1) ) " | 331 | " NOT EXISTS (SELECT 1 FROM gn090 INDEXED BY idx_repl_rvalue WHERE repl=?2 AND rvalue>=?1 LIMIT 1) ) " |
333 | "ORDER BY rvalue ASC LIMIT 1", | 332 | "ORDER BY rvalue ASC LIMIT 1", &plugin->selRepl) != SQLITE_OK) || |
334 | &plugin->selRepl) != SQLITE_OK) || | ||
335 | (sq_prepare | 333 | (sq_prepare |
336 | (plugin->dbh, | 334 | (plugin->dbh, "SELECT MAX(repl) FROM gn090 INDEXED BY idx_repl_rvalue", |
337 | "SELECT MAX(repl) FROM gn090 INDEXED BY idx_repl_rvalue", | ||
338 | &plugin->maxRepl) != SQLITE_OK) || | 335 | &plugin->maxRepl) != SQLITE_OK) || |
339 | (sq_prepare | 336 | (sq_prepare |
340 | (plugin->dbh, | 337 | (plugin->dbh, |
@@ -355,8 +352,7 @@ database_setup (const struct GNUNET_CONFIGURATION_Handle *cfg, | |||
355 | "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)", | 352 | "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)", |
356 | &plugin->insertContent) != SQLITE_OK) || | 353 | &plugin->insertContent) != SQLITE_OK) || |
357 | (sq_prepare | 354 | (sq_prepare |
358 | (plugin->dbh, | 355 | (plugin->dbh, "DELETE FROM gn090 WHERE _ROWID_ = ?", |
359 | "DELETE FROM gn090 WHERE _ROWID_ = ?", | ||
360 | &plugin->delRow) != SQLITE_OK)) | 356 | &plugin->delRow) != SQLITE_OK)) |
361 | { | 357 | { |
362 | LOG_SQLITE (plugin, NULL, GNUNET_ERROR_TYPE_ERROR, "precompiling"); | 358 | LOG_SQLITE (plugin, NULL, GNUNET_ERROR_TYPE_ERROR, "precompiling"); |