[tracker/wip/carlosg/test-fixes: 2/2] libtracker-data: Use correct fts_view when deleting a resource entirely

[Carlos Garnacho <carlosg src gnome org>]

commit b6e2fee9864f1cadb229d88bd8ff6d5744a1ab0d
Author: Carlos Garnacho <carlosg gnome org>
Date:   Sat Dec 7 14:34:21 2019 +0100

    libtracker-data: Use correct fts_view when deleting a resource entirely
    
    This fast path was "inserting" the delete operations in the right FTS5
    table, but was possibly looking up the values in the wrong fts_view.
    The FTS view and tables are per-database, so they should always match.

 src/libtracker-data/tracker-db-interface-sqlite.c | 5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)
---
diff --git a/src/libtracker-data/tracker-db-interface-sqlite.c 
b/src/libtracker-data/tracker-db-interface-sqlite.c
index 9bbb7b64f..8ae2155c1 100644
--- a/src/libtracker-data/tracker-db-interface-sqlite.c
+++ b/src/libtracker-data/tracker-db-interface-sqlite.c
@@ -2180,11 +2180,12 @@ tracker_db_interface_sqlite_fts_create_delete_all_query (TrackerDBInterface *db_
        insert_str = g_string_new (NULL);
        g_string_append_printf (insert_str,
                                "INSERT INTO \"%s\".fts5 (fts5, rowid %s) "
-                               "SELECT 'delete', rowid %s FROM fts_view "
+                               "SELECT 'delete', rowid %s FROM \"%s\".fts_view "
                                "WHERE rowid = ?",
                                database,
                                db_interface->fts_properties,
-                               db_interface->fts_properties);
+                               db_interface->fts_properties,
+                               database);
        return g_string_free (insert_str, FALSE);
 }