[tracker/wip/carlosg/sparql1.1: 199/201] tests: Add test for GROUP BY (... AS ...)



commit 8e864f3ec75391a476af90592ebfec79d1d858d4
Author: Carlos Garnacho <carlosg gnome org>
Date:   Tue Sep 3 22:31:02 2019 +0200

    tests: Add test for GROUP BY (... AS ...)

 tests/libtracker-data/aggregates/aggregate-group-as-1.out | 2 ++
 tests/libtracker-data/aggregates/aggregate-group-as-1.rq  | 9 +++++++++
 tests/libtracker-data/tracker-sparql-test.c               | 1 +
 3 files changed, 12 insertions(+)
---
diff --git a/tests/libtracker-data/aggregates/aggregate-group-as-1.out 
b/tests/libtracker-data/aggregates/aggregate-group-as-1.out
new file mode 100644
index 000000000..3b41f134b
--- /dev/null
+++ b/tests/libtracker-data/aggregates/aggregate-group-as-1.out
@@ -0,0 +1,2 @@
+"http://example/x";     "2"     "8"     "string t|string y"
+"http://example/z";     "1"     "13"    "string u"
diff --git a/tests/libtracker-data/aggregates/aggregate-group-as-1.rq 
b/tests/libtracker-data/aggregates/aggregate-group-as-1.rq
new file mode 100644
index 000000000..dacf6b30e
--- /dev/null
+++ b/tests/libtracker-data/aggregates/aggregate-group-as-1.rq
@@ -0,0 +1,9 @@
+PREFIX : <http://example/> 
+
+SELECT ?g COUNT(DISTINCT ?b) SUM(?ib) GROUP_CONCAT(?sb, "|")
+{ ?a a :A ;
+     :b ?b .
+  ?b :ib ?ib .
+  ?b :sb ?sb .
+  FILTER (?ib>2) }
+GROUP BY (?a AS ?g)
diff --git a/tests/libtracker-data/tracker-sparql-test.c b/tests/libtracker-data/tracker-sparql-test.c
index c6030e402..004c34397 100644
--- a/tests/libtracker-data/tracker-sparql-test.c
+++ b/tests/libtracker-data/tracker-sparql-test.c
@@ -46,6 +46,7 @@ const TestInfo tests[] = {
        { "aggregates/aggregate-distinct-1", "aggregates/data-1", FALSE },
        { "aggregates/aggregate-group-1", "aggregates/data-1", FALSE },
        { "aggregates/aggregate-group-2", "aggregates/data-1", FALSE },
+       { "aggregates/aggregate-group-as-1", "aggregates/data-1", FALSE },
        { "algebra/two-nested-opt", "algebra/two-nested-opt", FALSE },
        { "algebra/two-nested-opt-alt", "algebra/two-nested-opt", FALSE },
        { "algebra/opt-filter-3", "algebra/opt-filter-3", FALSE },


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