Hi Lei, This is due to bad data in the latest DBpedia 2014 datasets it seems ie <http://dbpedia.org/resource/Aunt_Phillis\u0027s_Cabin> dbpedia-owl:numberOfPages “0”^^xsd:positiveInteger . ; as the problem does not occur against the previous 3.9 datasets still hosted in LOD Cloud Cache instance, see:
http://dbpedia.org/sparql/?default-graph-uri=http%3A%2F%2Fdbpedia.org&qtxt=PREFIX+%3A+%3Chttp%3A%2F%2Fdbpedia.org%2Fresource%2F%3E%0D%0APREFIX+rdf%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0D%0APREFIX+rdfs%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0D%0APREFIX+dbpedia-owl%3A+%3Chttp%3A%2F%2Fdbpedia.org%2Fontology%2F%3E%0D%0A%0D%0ASELECT+%3Fauthor_name+%3Ftitle+%3Fpages%0D%0AFROM+%3Chttp%3A%2F%2Fdbpedia.org%2F%3E%0D%0AWHERE+%7B%0D%0A%3Fauthor+rdf%3Atype+dbpedia-owl%3AWriter+.%0D%0A%3Fauthor+rdfs%3Alabel+%3Fauthor_name+%0D%0AFILTER+%28LANG%28%3Fauthor_name%29%3D%22en%22%29+.+%0D%0A%3Fauthor+dbpedia-owl%3AnotableWork+%3Fwork+.%0D%0A%3Fwork+dbpedia-owl%3AnumberOfPages+%3Fpages%0D%0AFILTER+%28%3Fpages+%3E+500%29+.%0D%0A%3Fwork+rdfs%3Alabel+%3Ftitle+%0D%0AFILTER+%28LANG%28%3Ftitle%29%3D%22en%22%29.%0D%0A%7D+%0D%0AORDER+BY+%28%3Fpages%29%0D%0ALIMIT+100&format=text%2Fhtml&timeout=30000&debug=on vs: http://lod.openlinksw.com/sparql?default-graph-uri=&qtxt=PREFIX+%3A+%3Chttp%3A%2F%2Fdbpedia.org%2Fresource%2F%3E%0D%0APREFIX+rdf%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0D%0APREFIX+rdfs%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0D%0APREFIX+dbpedia-owl%3A+%3Chttp%3A%2F%2Fdbpedia.org%2Fontology%2F%3E%0D%0A%0D%0ASELECT+%3Fauthor_name+%3Ftitle+%3Fpages%0D%0AFROM+%3Chttp%3A%2F%2Fdbpedia.org%3E%0D%0AWHERE+%7B%0D%0A%3Fauthor+rdf%3Atype+dbpedia-owl%3AWriter+.%0D%0A%3Fauthor+rdfs%3Alabel+%3Fauthor_name+%0D%0AFILTER+%28LANG%28%3Fauthor_name%29%3D%22en%22%29+.+%0D%0A%3Fauthor+dbpedia-owl%3AnotableWork+%3Fwork+.%0D%0A%3Fwork+dbpedia-owl%3AnumberOfPages+%3Fpages%0D%0AFILTER+%28%3Fpages+%3E+500%29+.%0D%0A%3Fwork+rdfs%3Alabel+%3Ftitle+%0D%0AFILTER+%28LANG%28%3Ftitle%29%3D%22en%22%29.%0D%0A%7D+%0D%0AORDER+BY+%28%3Fpages%29%0D%0ALIMIT+100&format=text%2Fhtml&CXML_redir_for_subjs=121&CXML_redir_for_hrefs=&timeout=30000&debug=on Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink-software/ Twitter -- http://twitter.com/OpenLink Google+ -- http://plus.google.com/100570109519069333827/ Facebook -- http://www.facebook.com/OpenLinkSoftware Universal Data Access, Integration, and Management Technology Providers On 12 Sep 2014, at 14:42, Lei Niu <lei.niu...@gmail.com> wrote: > > * Query Examples on dbpedia.org/sparql/ > ** 1) > PREFIX : http://dbpedia.org/resource/ > PREFIX rdf: http://www.w3.org/1999/02/22-rdf-syntax-ns# > PREFIX rdfs: http://www.w3.org/2000/01/rdf-schema# > PREFIX dbpedia-owl: http://dbpedia.org/ontology/ > > SELECT ?author_name ?title ?pages > FROM http://dbpedia.org/ > WHERE { > ?author rdf:type dbpedia-owl:Writer . > ?author rdfs:label ?author_name > FILTER (LANG(?author_name)="en") . > ?author dbpedia-owl:notableWork ?work . > ?work dbpedia-owl:numberOfPages ?pages > FILTER (?pages > 500) . > ?work rdfs:label ?title > FILTER (LANG(?title)="en"). > } > LIMIT 100 > > RESULT: > author_name title pages > ... > "Seth and Mary Eastman"@en "Aunt Phillis's Cabin"@en > "0"^^http://www.w3.org/2001/XMLSchema#positiveInteger > ... > ** 2) > PREFIX : http://dbpedia.org/resource/ > PREFIX rdf: http://www.w3.org/1999/02/22-rdf-syntax-ns# > PREFIX rdfs: http://www.w3.org/2000/01/rdf-schema# > PREFIX dbpedia-owl: http://dbpedia.org/ontology/ > > SELECT ?author_name ?title ?pages > FROM http://dbpedia.org/ > WHERE { > ?author rdf:type dbpedia-owl:Writer . > ?author rdfs:label ?author_name > FILTER (LANG(?author_name)="en") . > ?author dbpedia-owl:notableWork ?work . > ?work dbpedia-owl:numberOfPages ?pages > FILTER (?pages > 500) . > ?work rdfs:label ?title > FILTER (LANG(?title)="en"). > } > ORDER BY (?pages) > LIMIT 100 > > RESULT: > "Seth and Mary Eastman"@en "Aunt Phillis's Cabin"@en 140156966022648 > > > * Summary and potential reason of this bug > > There is no page for "Aunt Phillis's Cabin". > The numberOfPages is http://www.w3.org/2001/XMLSchema#positiveInteger. > When do the query, the triples will be > "Seth and Mary Eastman"@en "Aunt Phillis's Cabin"@en > "0"^^http://www.w3.org/2001/XMLSchema#positiveInteger > > However 0 is not positive integer. > > The invalid result happens when ORDER BY used. > > ------------------------------------------------------------------------------ > Want excitement? > Manually upgrade your production database. > When you want reliability, choose Perforce > Perforce version control. Predictably reliable. > http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk_______________________________________________ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------ Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
