[tracker] libtracker-data: Fixup consistency check



commit a4982b23c574b09c3de1d0e72f978dcf4a387776
Author: Carlos Garnacho <carlosg gnome org>
Date:   Thu Aug 8 01:02:10 2019 +0200

    libtracker-data: Fixup consistency check
    
    The query was almost it, but not quite.

 src/libtracker-data/tracker-data-manager.c | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)
---
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);


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]