Re: [Virtuoso-users] Bug with upgrade Virtuoso 6.1.6 to 7.0.0

2013-10-25 Thread Julien Plu
Hi Hugh, Ok, I will let you know about this new query monday, because I don't have access to this Virtuoso instance for now. Best. Julien. 2013/10/25 Hugh Williams > Hi Julien, > > I don't see how that query can fails with a No table error as the > RDF_QUAD table holds all your RDF triples

Re: [Virtuoso-users] Bug with datatype SPARQL function

2013-10-25 Thread Julien Plu
Hi Hugh, I just cloned and compiled the develop/7 git branch, and the bug is not solved. The dataset is just DBpedia. Best. Julien. 2013/10/25 Hugh Williams > Hi Julien, > > Is would be useful to try against a develop/7 git branch which has more > recent fixes ? Or if you can provide a point

Re: [Virtuoso-users] Bug with upgrade Virtuoso 6.1.6 to 7.0.0

2013-10-25 Thread Hugh Williams
Hi Julien, I don't see how that query can fails with a No table error as the RDF_QUAD table holds all your RDF triples ? Can you try fully qualifying it with: select distinct count(distinct g) from DB.DBA.RDF_QUAD; Which should also be visible in the in the database schema ... Best R

Re: [Virtuoso-users] Bug with datatype SPARQL function

2013-10-25 Thread Hugh Williams
Hi Julien, Is would be useful to try against a develop/7 git branch which has more recent fixes ? Or if you can provide a pointer to the datasets to load to recreate this problem then we can load them into a latest commercial build from out latest internal archive to check against that ... Be

Re: [Virtuoso-users] Bug with datatype SPARQL function

2013-10-25 Thread Julien Plu
I compiled the stable version from here : https://github.com/openlink/virtuoso-opensource/tree/stable/7 Best. Julien. 2013/10/25 Kingsley Idehen > On 10/25/13 2:28 PM, Julien Plu wrote: > > The query works on a Virtuoso 6 yes : > http://fr.dbpedia.org/sparql?default-graph-uri=&query=select+

Re: [Virtuoso-users] Bug with datatype SPARQL function

2013-10-25 Thread Kingsley Idehen
On 10/25/13 2:28 PM, Julien Plu wrote: The query works on a Virtuoso 6 yes : http://fr.dbpedia.org/sparql?default-graph-uri=&query=select+distinct+count%28%3Fbirth%29+count%28%3Fdeath%29%0D%0Awhere+%7B++%0D%0A%3Fentity+%3Chttp%3A%2F%2Fdbpedia.org%2Fontology%2FbirthDate%3E+%3Fbirth

Re: [Virtuoso-users] Bug with datatype SPARQL function

2013-10-25 Thread Julien Plu
The query works on a Virtuoso 6 yes : http://fr.dbpedia.org/sparql?default-graph-uri=&query=select+distinct+count%28%3Fbirth%29+count%28%3Fdeath%29%0D%0Awhere+%7B++%0D%0A%3Fentity+%3Chttp%3A%2F%2Fdbpedia.org%2Fontology%2FbirthDate%3E+%3Fbirth+.+%0D%0Afilter%28datatype%28%3Fb

Re: [Virtuoso-users] Bug with datatype SPARQL function

2013-10-25 Thread Kingsley Idehen
On 10/25/13 11:35 AM, Julien Plu wrote: select distinct count(?birth) count(?death) where { ?entity ?birth . filter(datatype(?birth) = xsd:date). OPTIONAL {?entity ?death . filter(datatype(?death) = xsd:

Re: [Virtuoso-users] Bug with datatype SPARQL function

2013-10-25 Thread Julien Plu
I didn't tried but yes it has to work like that too. Best. Julien. 2013/10/25 Joshua TAYLOR > """ > it doesn't works with the "prefix version" but only with the "full > version" of a type. > """ > > it does work with str(xsd:date), though, right? > > On Fri, Oct 25, 2013 at 12:23 PM, Julien P

Re: [Virtuoso-users] Bug with datatype SPARQL function

2013-10-25 Thread Joshua TAYLOR
""" it doesn't works with the "prefix version" but only with the "full version" of a type. """ it does work with str(xsd:date), though, right? On Fri, Oct 25, 2013 at 12:23 PM, Julien Plu wrote: > I use a private version of DBpedia on a Virtuoso 7 compiled by myself from > the stable branch. > >

Re: [Virtuoso-users] Bug with datatype SPARQL function

2013-10-25 Thread Julien Plu
I use a private version of DBpedia on a Virtuoso 7 compiled by myself from the stable branch. Yes, "http://www.w3.org/2001/XMLSchema#date"; is the same thing than str(xsd:date). But yes your post is approximatively the same thing than my problem, so I think the problem come from this function bec

Re: [Virtuoso-users] Bug with datatype SPARQL function

2013-10-25 Thread Joshua TAYLOR
Also, just to be clear, filter(datatype(?death) = "http://www.w3.org/2001/XMLSchema#date";). should be the same as filter(datatype(?death) = str(xsd:date) ). right? On Fri, Oct 25, 2013 at 12:09 PM, Joshua TAYLOR wrote: > Are you querying locally, or against the public endpoint? Have a look

Re: [Virtuoso-users] Bug with datatype SPARQL function

2013-10-25 Thread Joshua TAYLOR
Are you querying locally, or against the public endpoint? Have a look at the "Additional Strange Results" in this Stack Overflow question and answer: http://stackoverflow.com/a/18793319/1281433 I had some weird results while querying DBpedia and trying to work with dates and datetimes. This may

[Virtuoso-users] Bug with datatype SPARQL function

2013-10-25 Thread Julien Plu
Hi, I think I found a bug with the datatype SPARQL function. This query as zero results : select distinct count(?birth) count(?death) where { ?entity ?birth . filter(datatype(?birth) = xsd:date). OPTIONAL {?entity