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



commit 2f12eb41b69a2d98510c059fec0e9278cca3308a
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 d21beec6b..9c6065513 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]