[tracker/wip/carlosg/sparql1.1: 153/201] 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: 153/201] libtracker-data: Don't use UNION ALL in property path queries
- Date: Mon, 9 Sep 2019 22:31:40 +0000 (UTC)
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]