[tracker/wip/carlosg/sparql1.1: 122/145] libtracker-data: Don't use UNION ALL in property path queries
- From: Carlos Garnacho <carlosg src gnome org>
- To: commits-list gnome org
- Cc:
- Subject: [tracker/wip/carlosg/sparql1.1: 122/145] libtracker-data: Don't use UNION ALL in property path queries
- Date: Thu, 18 Jul 2019 22:34:17 +0000 (UTC)
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]