semsol / arc2

ARC RDF Classes for PHP
Other
332 stars 90 forks source link

COUNT(distinct ?s) doesn't work with a remote endpoint #54

Open rudenis opened 11 years ago

rudenis commented 11 years ago

This test query -

select ?s (COUNT(distinct ?s) AS ?count)
where {
?s a ?Concept .
FILTER (?s = http://dbpedia.org/ontology/deathDate)
}
GROUP BY ?s
LIMIT 1

should work at the dbpedia endpoint.

With arc2 it works only without 'distinct', i.e. as -

select ?s (COUNT(?s) AS ?count)

EDIT by @k00ni: Formatted the SPARQL queries.

ross-spencer commented 8 years ago

I'm finding the same for a local endpoint, so query:

No result bindings specified. in ARC2_SPARQLPlusParser

SELECT (COUNT(DISTINCT ?s) as ?total)
WHERE {
{
 ?s  <http://digipres.org/formats/sources/pronom/formats/#hasMagic> "true" . 
} UNION {
 ?s  <http://the-fr.org/prop/format-registry/hasPRONOMContainerMagic> "true" .
}
}

Endpoint: http://the-fr.org/public/sparql/endpoint.php?

Query URL: http://the-fr.org/public/sparql/endpoint.php?query=SELECT+%28COUNT%28DISTINCT+%3Fs%29+as+%3Ftotal%29%0D%0AWHERE+%7B%0D%0A%7B%0D%0A+%3Fs++%3Chttp%3A%2F%2Fdigipres.org%2Fformats%2Fsources%2Fpronom%2Fformats%2F%23hasMagic%3E+%22true%22+.+%0D%0A%7D+UNION+%7B%0D%0A+%3Fs++%3Chttp%3A%2F%2Fthe-fr.org%2Fprop%2Fformat-registry%2FhasPRONOMContainerMagic%3E+%22true%22+.%0D%0A%7D%0D%0A%7D%0D%0A&output=tsv&jsonp=&key=&show_inline=1

johanneshahn commented 8 years ago

Sehr geehrte Damen und Herren,

bitte beachten Sie, dass ich bis 06.09.2016 nicht zu erreichen bin. Ihre Anfrage wird nach meiner Rückkehr schnellstmöglich bearbeitet. Vielen Dank.


Thank you for your email.

I will be out of the office until 06.09.2016. Your email will not be forwarded but I will deal with it on my return.

Johannes Hahn

Geschäftsführer - Mediadevelopment

eccence Weimarstrasse 1 • D-70176 Stuttgart

fon +49(0)711.4 77 88 77 9

email j.hahn@eccence.de
web www.eccence.de

Geschäftsführer: Gerd Freiwald & Johannes Hahn Umsatzsteuer-Identifikationsnummer gemäß § 27 a Umsatzsteuergesetz: DE259976593

k00ni commented 6 years ago

Hi, anyone find a solution/workaround for this?