Submissions pagination total count and collection size are not the same

[syphax-bouazzouni]

When we do this request https://data.stageportal.lirmm.fr/submissions?display_links=false&display_context=false&include_status=RDF&page=1&pagesize=5&hasDomain=BIODIV,PLANT&order_by=ontology_name

it says the totalCount is 6 but only 5 elements are returned

[syphax-bouazzouni]

The request behind

SELECT DISTINCT ?id 
FROM <http://data.bioontology.org/metadata/OntologySubmission> 
FROM <http://data.bioontology.org/metadata/SubmissionStatus> 
FROM <http://data.bioontology.org/metadata/Ontology> 
FROM <http://data.bioontology.org/metadata/Category> 
WHERE { 
		?id a <http://data.bioontology.org/metadata/OntologySubmission> . 
		?id <http://data.bioontology.org/metadata/submissionStatus> ?internal_join_var_0 . 
		?internal_join_var_0 <http://data.bioontology.org/metadata/code> "RDF" . 
		?id <http://data.bioontology.org/metadata/ontology> ?internal_join_var_1 . 
		?internal_join_var_1 <http://omv.ontoware.org/2005/05/ontology#hasDomain> ?internal_join_var_2 . 
		?internal_join_var_2 <http://data.bioontology.org/metadata/acronym> ?internal_join_var_3 . 
		OPTIONAL { ?id <http://data.bioontology.org/metadata/ontology> ?internal_join_var_4 .  } 
		OPTIONAL { ?internal_join_var_4 <http://data.bioontology.org/metadata/viewOf> ?internal_join_var_5 .  } 
		OPTIONAL { ?id <http://data.bioontology.org/metadata/ontology> ?internal_join_var_6 .  } 
		OPTIONAL { ?internal_join_var_6 <http://omv.ontoware.org/2005/05/ontology#name> ?internal_join_var_7 .  }
		FILTER(REGEX(STR(?internal_join_var_3) , "BIODIV", "i") || REGEX(STR(?internal_join_var_3), "PLANT", "i") || REGEX(STR(?internal_join_var_3) , "GENPLANT", "i")) 
		FILTER(!BOUND(?internal_join_var_5)) 
} ORDER BY ASC(?internal_join_var_7) OFFSET 5 LIMIT 5

Bu this change the offset to 4 works, where it should not (the page 2 offset is 5)

SELECT DISTINCT ?id 
FROM <http://data.bioontology.org/metadata/OntologySubmission> 
FROM <http://data.bioontology.org/metadata/SubmissionStatus> 
FROM <http://data.bioontology.org/metadata/Ontology> 
FROM <http://data.bioontology.org/metadata/Category> 
WHERE { 
		?id a <http://data.bioontology.org/metadata/OntologySubmission> . 
		?id <http://data.bioontology.org/metadata/submissionStatus> ?internal_join_var_0 . 
		?internal_join_var_0 <http://data.bioontology.org/metadata/code> "RDF" . 
		?id <http://data.bioontology.org/metadata/ontology> ?internal_join_var_1 . 
		?internal_join_var_1 <http://omv.ontoware.org/2005/05/ontology#hasDomain> ?internal_join_var_2 . 
		?internal_join_var_2 <http://data.bioontology.org/metadata/acronym> ?internal_join_var_3 . 
		OPTIONAL { ?id <http://data.bioontology.org/metadata/ontology> ?internal_join_var_4 .  } 
		OPTIONAL { ?internal_join_var_4 <http://data.bioontology.org/metadata/viewOf> ?internal_join_var_5 .  } 
		OPTIONAL { ?id <http://data.bioontology.org/metadata/ontology> ?internal_join_var_6 .  } 
		OPTIONAL { ?internal_join_var_6 <http://omv.ontoware.org/2005/05/ontology#name> ?internal_join_var_7 .  }
		FILTER(REGEX(STR(?internal_join_var_3) , "BIODIV", "i") || REGEX(STR(?internal_join_var_3), "PLANT", "i") || REGEX(STR(?internal_join_var_3) , "GENPLANT", "i")) 
		FILTER(!BOUND(?internal_join_var_5)) 
} ORDER BY ASC(?internal_join_var_7) OFFSET 4 LIMIT 5

[syphax-bouazzouni]

duplicate of #25 and related only to 4store