summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorCarlos Garnacho <carlosg@gnome.org>2019-08-08 01:02:10 +0200
committerCarlos Garnacho <carlosg@gnome.org>2019-08-08 01:13:14 +0200
commita4982b23c574b09c3de1d0e72f978dcf4a387776 (patch)
treef50cc952b86e1d563a7fa3a17b8a4997249328d6
parentf92fdc90c85db856d20bdf84a2f3f88efdd1fee2 (diff)
downloadtracker-a4982b23c574b09c3de1d0e72f978dcf4a387776.tar.gz
libtracker-data: Fixup consistency check
The query was almost it, but not quite.
-rw-r--r--src/libtracker-data/tracker-data-manager.c4
1 files changed, 3 insertions, 1 deletions
diff --git a/src/libtracker-data/tracker-data-manager.c b/src/libtracker-data/tracker-data-manager.c
index 010c4755c..dadb0f585 100644
--- a/src/libtracker-data/tracker-data-manager.c
+++ b/src/libtracker-data/tracker-data-manager.c
@@ -4158,7 +4158,9 @@ check_db_consistency (TrackerDBInterface *iface)
stmt = tracker_db_interface_create_statement (iface, TRACKER_DB_STATEMENT_CACHE_TYPE_SELECT, NULL,
"SELECT ID FROM \"rdfs:Resource\" "
- "LEFT OUTER JOIN Resource ON ID LIMIT 1");
+ "EXCEPT "
+ "SELECT ID FROM Resource "
+ "LIMIT 1");
if (stmt) {
cursor = tracker_db_statement_start_cursor (stmt, NULL);