W3C

Aggregates

Copyright © 2010 W3C® (MIT, ERCIM, Keio), All Rights Reserved. W3C liability, trademark, and document use rules apply.


Abstract

This page describes W3C SPARQL Working Group's SPARQL1.0 test suite.

Contributing Tests

The test manifests and entries are built automatically from manifest.ttl using a Rake task. Tests may be contributed via pull request to https://github.com/w3c/rdf-tests with suitable changes to the manifest.ttl and referenced files.

Distribution

Distributed under both the W3C Test Suite License and the W3C 3-clause BSD License. To contribute to a W3C Test Suite, see the policies and contribution forms.

Disclaimer

UNDER BOTH MUTUALLY EXCLUSIVE LICENSES, THIS DOCUMENT AND ALL DOCUMENTS, TESTS AND SOFTWARE THAT LINK THIS STATEMENT ARE PROVIDED "AS IS," AND COPYRIGHT HOLDERS MAKE NO REPRESENTATIONS OR WARRANTIES, EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, NON-INFRINGEMENT, OR TITLE; THAT THE CONTENTS OF THE DOCUMENT ARE SUITABLE FOR ANY PURPOSE; NOR THAT THE IMPLEMENTATION OF SUCH CONTENTS WILL NOT INFRINGE ANY THIRD PARTY PATENTS, COPYRIGHTS, TRADEMARKS OR OTHER RIGHTS. COPYRIGHT HOLDERS WILL NOT BE LIABLE FOR ANY DIRECT, INDIRECT, SPECIAL OR CONSEQUENTIAL DAMAGES ARISING OUT OF ANY USE OF THE DOCUMENT OR THE PERFORMANCE OR IMPLEMENTATION OF THE CONTENTS THEREOF.

Test Descriptions

http://www.w3.org/2009/sparql/docs/tests/data-sparql11/aggregates/manifest#agg01: COUNT 1

Simple count

type
mf:QueryEvaluationTest
approval
dawgt:Approved
approvedBy
http://www.w3.org/2009/sparql/meeting/2012-01-31#resolution_3
action
query
agg01.rq
data
agg01.ttl
result
agg01.srx
http://www.w3.org/2009/sparql/docs/tests/data-sparql11/aggregates/manifest#agg02: COUNT 2

Count with grouping

type
mf:QueryEvaluationTest
approval
dawgt:Approved
approvedBy
http://www.w3.org/2009/sparql/meeting/2012-01-31#resolution_3
action
query
agg02.rq
data
agg01.ttl
result
agg02.srx
http://www.w3.org/2009/sparql/docs/tests/data-sparql11/aggregates/manifest#agg03: COUNT 3

Count with grouping and HAVING clause

type
mf:QueryEvaluationTest
approval
dawgt:Approved
approvedBy
http://www.w3.org/2009/sparql/meeting/2012-01-31#resolution_3
action
query
agg03.rq
data
agg01.ttl
result
agg03.srx
http://www.w3.org/2009/sparql/docs/tests/data-sparql11/aggregates/manifest#agg04: COUNT 4

Count(*)

type
mf:QueryEvaluationTest
approval
dawgt:Approved
approvedBy
http://www.w3.org/2009/sparql/meeting/2012-01-31#resolution_3
action
query
agg04.rq
data
agg01.ttl
result
agg04.srx
http://www.w3.org/2009/sparql/docs/tests/data-sparql11/aggregates/manifest#agg05: COUNT 5

Count(*) with grouping

type
mf:QueryEvaluationTest
approval
dawgt:Approved
approvedBy
http://www.w3.org/2009/sparql/meeting/2012-01-31#resolution_3
action
query
agg05.rq
data
agg01.ttl
result
agg05.srx
http://www.w3.org/2009/sparql/docs/tests/data-sparql11/aggregates/manifest#agg06: COUNT 6

Count() with HAVING Count()

type
mf:QueryEvaluationTest
approval
dawgt:Approved
approvedBy
http://www.w3.org/2009/sparql/meeting/2012-01-31#resolution_3
action
query
agg06.rq
data
agg01.ttl
result
agg06.srx
http://www.w3.org/2009/sparql/docs/tests/data-sparql11/aggregates/manifest#agg07: COUNT 7

Count() with grouping and HAVING Count()

type
mf:QueryEvaluationTest
approval
dawgt:Approved
approvedBy
http://www.w3.org/2009/sparql/meeting/2012-01-31#resolution_3
action
query
agg07.rq
data
agg01.ttl
result
agg07.srx
http://www.w3.org/2009/sparql/docs/tests/data-sparql11/aggregates/manifest#agg08: COUNT 8

grouping by expression, done wrong

type
mf:NegativeSyntaxTest11
approval
dawgt:Approved
approvedBy
http://www.w3.org/2009/sparql/meeting/2012-01-31#resolution_3
action
agg08.rq
http://www.w3.org/2009/sparql/docs/tests/data-sparql11/aggregates/manifest#agg08b: COUNT 8b

grouping by expression, done correctly

type
mf:QueryEvaluationTest
approval
dawgt:Approved
approvedBy
http://www.w3.org/2009/sparql/meeting/2012-01-31#resolution_3
action
query
agg08b.rq
data
agg08.ttl
result
agg08b.srx
http://www.w3.org/2009/sparql/docs/tests/data-sparql11/aggregates/manifest#agg09: COUNT 9

Projection of an ungrouped variable (not appearing in the GROUP BY expression)

type
mf:NegativeSyntaxTest11
approval
dawgt:Approved
approvedBy
http://www.w3.org/2009/sparql/meeting/2012-01-31#resolution_3
action
agg09.rq
http://www.w3.org/2009/sparql/docs/tests/data-sparql11/aggregates/manifest#agg10: COUNT 10

Projection of an ungrouped variable (no GROUP BY expression at all)

type
mf:NegativeSyntaxTest11
approval
dawgt:Approved
approvedBy
http://www.w3.org/2009/sparql/meeting/2012-01-31#resolution_3
action
agg10.rq
http://www.w3.org/2009/sparql/docs/tests/data-sparql11/aggregates/manifest#agg11: COUNT 11

Use of an ungrouped variable in a project expression

type
mf:NegativeSyntaxTest11
approval
dawgt:Approved
approvedBy
http://www.w3.org/2009/sparql/meeting/2012-01-31#resolution_3
action
agg11.rq
http://www.w3.org/2009/sparql/docs/tests/data-sparql11/aggregates/manifest#agg12: COUNT 12

Use of an ungrouped variable in a project expression, where the variable appears in a GROUP BY expression

type
mf:NegativeSyntaxTest11
approval
dawgt:Approved
approvedBy
http://www.w3.org/2009/sparql/meeting/2012-01-31#resolution_3
action
agg12.rq
http://www.w3.org/2009/sparql/docs/tests/data-sparql11/aggregates/manifest#agg-groupconcat-01: GROUP_CONCAT 1
type
mf:QueryEvaluationTest
approval
dawgt:Approved
approvedBy
http://www.w3.org/2009/sparql/meeting/2010-09-07#resolution_2
action
query
agg-groupconcat-1.rq
data
agg-groupconcat-1.ttl
result
agg-groupconcat-1.srx
http://www.w3.org/2009/sparql/docs/tests/data-sparql11/aggregates/manifest#agg-groupconcat-02: GROUP_CONCAT 2
type
mf:QueryEvaluationTest
approval
dawgt:Approved
approvedBy
http://www.w3.org/2009/sparql/meeting/2010-09-07#resolution_2
action
query
agg-groupconcat-2.rq
data
agg-groupconcat-1.ttl
result
agg-groupconcat-2.srx
http://www.w3.org/2009/sparql/docs/tests/data-sparql11/aggregates/manifest#agg-groupconcat-03: GROUP_CONCAT with SEPARATOR
type
mf:QueryEvaluationTest
approval
dawgt:Approved
approvedBy
http://www.w3.org/2009/sparql/meeting/2010-09-07#resolution_2
action
query
agg-groupconcat-3.rq
data
agg-groupconcat-1.ttl
result
agg-groupconcat-3.srx
http://www.w3.org/2009/sparql/docs/tests/data-sparql11/aggregates/manifest#agg-sum-01: SUM
type
mf:QueryEvaluationTest
approval
dawgt:Approved
approvedBy
http://www.w3.org/2009/sparql/meeting/2010-09-07#resolution_2
action
query
agg-sum-01.rq
data
agg-numeric.ttl
result
agg-sum-01.srx
http://www.w3.org/2009/sparql/docs/tests/data-sparql11/aggregates/manifest#agg-sum-02: SUM with GROUP BY
type
mf:QueryEvaluationTest
approval
dawgt:Approved
approvedBy
http://www.w3.org/2009/sparql/meeting/2010-09-07#resolution_2
action
query
agg-sum-02.rq
data
agg-numeric2.ttl
result
agg-sum-02.srx
http://www.w3.org/2009/sparql/docs/tests/data-sparql11/aggregates/manifest#agg-avg-01: AVG
type
mf:QueryEvaluationTest
approval
dawgt:Approved
approvedBy
http://www.w3.org/2009/sparql/meeting/2010-09-07#resolution_2
action
query
agg-avg-01.rq
data
agg-numeric.ttl
result
agg-avg-01.srx
http://www.w3.org/2009/sparql/docs/tests/data-sparql11/aggregates/manifest#agg-avg-02: AVG with GROUP BY
type
mf:QueryEvaluationTest
approval
dawgt:Approved
approvedBy
http://www.w3.org/2009/sparql/meeting/2010-09-07#resolution_2
action
query
agg-avg-02.rq
data
agg-numeric2.ttl
result
agg-avg-02.srx
http://www.w3.org/2009/sparql/docs/tests/data-sparql11/aggregates/manifest#agg-min-01: MIN
type
mf:QueryEvaluationTest
approval
dawgt:Approved
approvedBy
http://www.w3.org/2009/sparql/meeting/2010-09-07#resolution_2
action
query
agg-min-01.rq
data
agg-numeric.ttl
result
agg-min-01.srx
http://www.w3.org/2009/sparql/docs/tests/data-sparql11/aggregates/manifest#agg-min-02: MIN with GROUP BY
type
mf:QueryEvaluationTest
approval
dawgt:Approved
approvedBy
http://www.w3.org/2009/sparql/meeting/2010-09-07#resolution_2
action
query
agg-min-02.rq
data
agg-numeric.ttl
result
agg-min-02.srx
http://www.w3.org/2009/sparql/docs/tests/data-sparql11/aggregates/manifest#agg-max-01: MAX
type
mf:QueryEvaluationTest
approval
dawgt:Approved
approvedBy
http://www.w3.org/2009/sparql/meeting/2010-09-07#resolution_2
action
query
agg-max-01.rq
data
agg-numeric.ttl
result
agg-max-01.srx
http://www.w3.org/2009/sparql/docs/tests/data-sparql11/aggregates/manifest#agg-max-02: MAX with GROUP BY
type
mf:QueryEvaluationTest
approval
dawgt:Approved
approvedBy
http://www.w3.org/2009/sparql/meeting/2010-09-07#resolution_2
action
query
agg-max-02.rq
data
agg-numeric.ttl
result
agg-max-02.srx
http://www.w3.org/2009/sparql/docs/tests/data-sparql11/aggregates/manifest#agg-sample-01: SAMPLE
type
mf:QueryEvaluationTest
approval
dawgt:Approved
approvedBy
http://www.w3.org/2009/sparql/meeting/2010-09-07#resolution_2
action
query
agg-sample-01.rq
data
agg-numeric.ttl
result
agg-sample-01.srx
http://www.w3.org/2009/sparql/docs/tests/data-sparql11/aggregates/manifest#agg-err-01: Error in AVG

Error in AVG return no binding

type
mf:QueryEvaluationTest
approval
dawgt:Approved
approvedBy
http://www.w3.org/2009/sparql/meeting/2010-09-07#resolution_2
action
query
agg-err-01.rq
data
agg-err-01.ttl
result
agg-err-01.srx
http://www.w3.org/2009/sparql/docs/tests/data-sparql11/aggregates/manifest#agg-err-02: Protect from error in AVG

Protect from error in AVG using IF and COALESCE

type
mf:QueryEvaluationTest
approval
dawgt:Approved
approvedBy
http://www.w3.org/2009/sparql/meeting/2010-09-07#resolution_2
action
query
agg-err-02.rq
data
agg-err-02.ttl
result
agg-err-02.srx
http://www.w3.org/2009/sparql/docs/tests/data-sparql11/aggregates/manifest#agg-empty-group2: ["agg empty group", "Aggregate over empty group resulting in a row with unbound variables"]
type
mf:QueryEvaluationTest
approval
dawgt:Approved
approvedBy
http://www.w3.org/2009/sparql/meeting/2012-10-30#resolution_2
action
query
agg-empty-group.rq
data
empty.ttl
result
agg-empty-group2.srx