[tracker/wip/carlosg/sparql1.1: 153/201] libtracker-data: Don't use UNION ALL in property path queries



commit 0d28d74b8d08e927d0c5d86ca85f373a5d230284
Author: Carlos Garnacho <carlosg gnome org>
Date:   Tue Jul 9 14:08:55 2019 +0200

    libtracker-data: Don't use UNION ALL in property path queries
    
    We just need to report back each subject-to-object connection once.

 src/libtracker-data/tracker-sparql.c | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)
---
diff --git a/src/libtracker-data/tracker-sparql.c b/src/libtracker-data/tracker-sparql.c
index bd4f63283..af4581e55 100644
--- a/src/libtracker-data/tracker-sparql.c
+++ b/src/libtracker-data/tracker-sparql.c
@@ -620,7 +620,7 @@ _prepend_path_element (TrackerSparql      *sparql,
                                       "\"%s\" (ID, value, graph, ID_type, value_type) AS "
                                       "(SELECT ID, value, graph, ID_type, value_type "
                                       "FROM \"%s\" "
-                                      "UNION ALL "
+                                      "UNION "
                                       "SELECT ID, value, graph, ID_type, value_type "
                                       "FROM \"%s\") ",
                                       path_elem->name,
@@ -660,7 +660,7 @@ _prepend_path_element (TrackerSparql      *sparql,
                                       "\"%s\" (ID, value, graph, ID_type, value_type) AS "
                                       "(SELECT ID, ID, graph, ID_type, ID_type "
                                       "FROM \"%s\" "
-                                      "UNION ALL "
+                                      "UNION "
                                       "SELECT ID, value, graph, ID_type, value_type "
                                       "FROM \"%s\") ",
                                       path_elem->name,


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