We're updating the issue view to help you get more done. 

Workbench paging hides results when subquery contains LIMIT clause

Description

The paging functionality in Workbench incorrectly hides results when a subquery has a LIMIT clause. A query that has 9 results only shows 2 actual result rows:

but once the 'results per page' setting is manually modified, it correctly renders the result:

To reproduce, use the following data:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 @prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>. @prefix xsd: <http://www.w3.org/2001/XMLSchema#>. @prefix : <http://example.org/>. :a rdf:type :AClass . :a :hasName "a"^^xsd:string . :a :hasProperty :xa . :a :hasProperty :ya . :a :hasProperty :za . :b rdf:type :AClass . :b :hasName "b"^^xsd:string . :b :hasProperty :xb . :b :hasProperty :yb . :c rdf:type :AClass . :c :hasName "c"^^xsd:string . :c :hasProperty :xc .

and this SPARQL query:

1 2 3 4 5 6 7 8 prefix : <http://example.org/> SELECT ?s ?p ?o WHERE { { SELECT ?s WHERE { ?s a :AClass } LIMIT 2 } ?s ?p ?o }

Notice that the query has a LIMIT-clause with value 2, but this limit only applies to the inner query.

See this StackOverflow question for more details.

Environment

None

Status

Assignee

Dale W. Visser

Reporter

JeenB

Labels

None

Components

Fix versions

Affects versions

2.8.6
2.8.4

Priority

Minor