On 2/1/18 3:46 PM, Jean-Marc Vanel wrote: > Hi > > Here is what seems a Virtuoso issue : > This fails: > > PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns# > <http://www.w3.org/1999/02/22-rdf-syntax-ns#>> > PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema# > <http://www.w3.org/2000/01/rdf-schema#>> > PREFIX foaf: <http://xmlns.com/foaf/0.1/> > PREFIX dbo: <http://dbpedia.org/ontology/> > PREFIX dbr: <http://dbpedia.org/resource/> > > SELECT * WHERE { > * BIND ( "PARIS"@fr AS ?CITY_string ) * > ?CITY a dbo:PopulatedPlace . > ?CITY rdfs:label ?lab . > * ?lab <bif:contains> ?CITY_string .* > ?CITY dbo:country dbr:France . > filter( ucase(str(?lab)) = str(?CITY_string) ) > } > > in YASGUI on http://dbpedia.org/sparql with this message: > Virtuoso 22023 Error SR468: contains() can not be called as plain built-in > function, it's a macro handled by SQL compiler > > FYI, *bif:contains* is the full text operator in Virtuoso. > > NOTE: this is part of a real-life federated query that fails too: > https://github.com/jmvanel/semantic_forms/blob/master/sparql/cities-to-URIs.rq > <https://github.com/jmvanel/semantic_forms/blob/master/sparql/cities-to-URIs.rq> > > > -- > Jean-Marc Vanel > http://www.semantic-forms.cc:9111/display?displayuri=http://jmvanel.free.fr/jmv.rdf%23me#subject > <http://www.semantic-forms.cc:9111/display?displayuri=http://jmvanel.free.fr/jmv.rdf%23me> > Déductions SARL - Consulting, services, training, > Rule-based programming, Semantic Web > +33 (0)6 89 16 29 52 > Twitter: @jmvanel , @jmvanel_fr ; chat: > irc://irc.freenode.net#eulergui <http://irc.freenode.net#eulergui>
There is a problem here that we are going to look into, regarding the SPARQL-FED variant. Basically, note this as a bug that we have accepted. Query: PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX foaf: <http://xmlns.com/foaf/0.1/> PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX dbr: <http://dbpedia.org/resource/> SELECT * WHERE { ?sub foaf:based_near ?CITY_string . filter( isLiteral( ?CITY_string )) . ## adding for excluding bad text values e.g., HTML <span/> etc.. from my test instance filter (! contains(str(?CITY_string),'span')) . SERVICE <http://dbpedia.org/sparql> { SELECT * WHERE { ?CITY a dbo:PopulatedPlace . ?CITY rdfs:label ?lab . ?lab bif:contains ?CITY_string . ?CITY dbo:country dbr:France . filter( ucase(str(?lab)) = ?CITY_string ) . } } } -- Regards, Kingsley Idehen Founder & CEO OpenLink Software (Home Page: http://www.openlinksw.com) Weblogs (Blogs): Legacy Blog: http://www.openlinksw.com/blog/~kidehen/ Blogspot Blog: http://kidehen.blogspot.com Medium Blog: https://medium.com/@kidehen Profile Pages: Pinterest: https://www.pinterest.com/kidehen/ Quora: https://www.quora.com/profile/Kingsley-Uyi-Idehen Twitter: https://twitter.com/kidehen Google+: https://plus.google.com/+KingsleyIdehen/about LinkedIn: http://www.linkedin.com/in/kidehen Web Identities (WebID): Personal: http://kingsley.idehen.net/public_home/kidehen/profile.ttl#i : http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this
smime.p7s
Description: S/MIME Cryptographic Signature
------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________ DBpedia-discussion mailing list DBpedia-discussion@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
