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



commit 96212d001e3de519d0af44fd9f203676e748aaa5
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 7d6ed3f98..555d8260c 100644
--- a/src/libtracker-data/tracker-sparql.c
+++ b/src/libtracker-data/tracker-sparql.c
@@ -613,7 +613,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,
@@ -653,7 +653,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]