Re: [DBpedia-discussion] SPARQL query failing with full text

2018-02-27 Thread Jean-Marc Vanel 
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 :

> On 2/1/18 3:46 PM, Jean-Marc Vanel wrote:
>
> Hi
>
> Here is what seems a Virtuoso issue :
> This fails:
>
> PREFIX rdf: 
> PREFIX rdfs: 
> PREFIX foaf: 
> PREFIX dbo: 
> PREFIX dbr: 
>
> SELECT * WHERE {
> *  BIND ( "PARIS"@fr AS ?CITY_string )   *
>   ?CITY a dbo:PopulatedPlace .
>   ?CITY rdfs:label ?lab .
> *  ?lab  ?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
> 
> 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: 
> 
> PREFIX rdfs: 
> 
> PREFIX foaf:  
> PREFIX dbo:  
> PREFIX dbr:  
>
> SELECT * WHERE
> {
>
>   ?sub foaf:based_near ?CITY_string .
>   filter( isLiteral( ?CITY_string ))  .
>   ## adding for excluding bad text values e.g., HTML  etc.. from my
> test instance
>  filter (! contains(str(?CITY_string),'span')) .
>
>
>   SERVICE  
>   {
> 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

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

Re: [DBpedia-discussion] SPARQL query failing with full text

2018-02-02 Thread Kingsley Idehen 
On 2/1/18 3:46 PM, Jean-Marc Vanel wrote:
> Hi
>
> Here is what seems a Virtuoso issue :
> This fails:
>
> PREFIX rdf:  >
> PREFIX rdfs:  >
> PREFIX foaf: 
> PREFIX dbo: 
> PREFIX dbr: 
>
> SELECT * WHERE {
> *  BIND ( "PARIS"@fr AS ?CITY_string )   *
>   ?CITY a dbo:PopulatedPlace .
>   ?CITY rdfs:label ?lab .
> *  ?lab  ?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
> 
> 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 


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: 
PREFIX rdfs: 
PREFIX foaf: 
PREFIX dbo: 
PREFIX dbr: 

SELECT * WHERE
{

  ?sub foaf:based_near ?CITY_string .
  filter( isLiteral( ?CITY_string ))  .
  ## adding for excluding bad text values e.g., HTML  etc.. from
my test instance
 filter (! contains(str(?CITY_string),'span')) .

 
  SERVICE 
  {
    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

Re: [DBpedia-discussion] SPARQL query failing with full text

2018-02-01 Thread Kingsley Idehen 
On 2/1/18 3:46 PM, Jean-Marc Vanel wrote:
> Hi
>
> Here is what seems a Virtuoso issue :
> This fails:
>
> PREFIX rdf:  >
> PREFIX rdfs:  >
> PREFIX foaf: 
> PREFIX dbo: 
> PREFIX dbr: 
>
> SELECT * WHERE {
> *  BIND ( "PARIS"@fr AS ?CITY_string )   *
>   ?CITY a dbo:PopulatedPlace .
>   ?CITY rdfs:label ?lab .
> *  ?lab  ?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
> 


See:

[1] https://tinyurl.com/y9epojvt -- altered the query to use bif: magic
predicate properly


-- 
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

[DBpedia-discussion] SPARQL query failing with full text

2018-02-01 Thread Jean-Marc Vanel 
Hi

Here is what seems a Virtuoso issue :
This fails:

PREFIX rdf: 
PREFIX rdfs: 
PREFIX foaf: 
PREFIX dbo: 
PREFIX dbr: 

SELECT * WHERE {
*  BIND ( "PARIS"@fr AS ?CITY_string )   *
  ?CITY a dbo:PopulatedPlace .
  ?CITY rdfs:label ?lab .
*  ?lab  ?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

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