Hi Kingsley
After 25 days the bug is still here :( .
Do you know the URL of the relevant bug report ?
Many thanks for your help, and hosting dbPedia .
Jean-Marc
2018-02-02 14:02 GMT+01:00 Kingsley Idehen <kide...@openlinksw.com>:
> 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#>
> 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 {
> * 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
>
> --
> 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 <+33%206%2089%2016%2029%2052>
> Twitter: @jmvanel , @jmvanel_fr ; chat: irc://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#>
> <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/> <http://xmlns.com/foaf/0.1/>
> PREFIX dbo: <http://dbpedia.org/ontology/> <http://dbpedia.org/ontology/>
> PREFIX dbr: <http://dbpedia.org/resource/> <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> <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
>
>
> ------------------------------------------------------------
> ------------------
> 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
>
>
--
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
------------------------------------------------------------------------------
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
