Hi Pierre,

I tried out the line:

FILTER(sameTerm(?prot,cco:CCO_B0001243) = false)

and some variants like:

FILTER(sameTerm(?prot,cco:CCO_B0001243) = 'false')

I've got the following message:

37000 Error SQ074: Line 9: syntax error at '=' before 'isnull'

SPARQL query:
define sql:signal-void-variables 1 define output:valmode "LONG" define 
input:default-graph-uri <http://www.cellcycleontology.org/ontology/rdf/CCO> PREFIX 
rdfs:<http://www.w3.org/2000/01/rdf-schema#>
PREFIX cco:<http://www.cellcycleontology.org/ontology/rdf/CCO#>

SELECT ?prot
WHERE{
  cco:CCO_B0001243 cco:is_a ?ortholog_cluster .
  ?prot cco:is_a ?ortholog_cluster .
  FILTER(sameTerm(?prot,cco:CCO_B0001243)=false)
}



We will probably then install 5.0.4, unless you have any other suggestion?

thanks,
Erick

Pierre De Wilde wrote:
Hi Erick,

In 5.0.3, FILTER(!...) may not work properly. Instead, try this: FILTER(sameTerm(?prot,cco:CCO_B0001243) = false)
In 5.0.4, FILTER(!...) seems to work properly.

Pierre

2008/2/6, Erick Antezana <er...@psb.ugent.be <mailto:er...@psb.ugent.be>>:

    Hi,

      we're running 5.0.3 on a linux box. So far everything was going
    perfectly until we tested the following query which is very simple
    against a huge graph (that could be found here:
    http://www.cellcycleontology.org/ontology/rdf/cco.rdf):

    PREFIX rdfs:<http://www.w3.org/2000/01/rdf-schema#>
    PREFIX cco:<http://www.cellcycleontology.org/ontology/rdf/CCO#>

    SELECT ?prot
    WHERE{
       cco:CCO_B0001243 cco:is_a ?ortholog_cluster .
       ?prot cco:is_a ?ortholog_cluster .
       FILTER(!sameTerm(?prot,cco:CCO_B0001243))
    }

    the endpoint is: http://crunch.fvms.ugent.be:8890/sparql

    It seems that the "sameTerm" is causing this problem. I tried to play
    with the parameters int he INI file by increasing the buffers,
    etc, etc
    but no success...Any hints would be appreciated.

    In the logs, we got:

    15:11:52 LTRS_1 0 130.88.195.199 <http://130.88.195.199> Internal
    Commit transact 0x354ffcf890 0
    15:11:52 LTRS_2 0 130.88.195.199 <http://130.88.195.199> Internal
    Restart transact 0x354ffcf890
    15:11:52 LTRS_1 0 130.88.195.199 <http://130.88.195.199> Internal
    Commit transact 0x354ffcf890 0
    15:11:52 LTRS_2 0 130.88.195.199 <http://130.88.195.199> Internal
    Restart transact 0x354ffcf890
    15:14:38 LTRS_1 0 130.88.195.199 <http://130.88.195.199> Internal
    Commit transact 0x354ffcf890 0
    15:14:38 LTRS_2 0 130.88.195.199 <http://130.88.195.199> Internal
    Restart transact 0x354ffcf890
    15:14:38 COMP_2 0 130.88.195.199 <http://130.88.195.199> Internal
    Compile text:  isnull
    (sparql_to_sql_text (?))
    15:14:38 COMP_2 0 130.88.195.199 <http://130.88.195.199> Internal
    Compile text:  sparql define
    output:valmode "LONG" define input:default-graph-uri
    <http://www.cellcycleontology.org/ontology/rdf/CCO> PREFIX
    rdfs:<http://www.w3.org/2000/01/rdf-schema#>
    PREFIX cco:<http://www.cellcycleontology.org/ontology/rdf/CCO#>

    SELECT ?prot
    WHERE{
       cco:CCO_B0001243 cco:is_a ?ortholog_cluster .
       ?prot cco:is_a ?ortholog_cluster .
       FILTER(!sameTerm(?prot,cco:CCO_B0001243))
    }

    and we also got:

    15:11:52 LTRS_1 0 130.88.195.199 <http://130.88.195.199> Internal
    Commit transact 0x354ffcf890 0
    15:11:52 LTRS_2 0 130.88.195.199 <http://130.88.195.199> Internal
    Restart transact 0x354ffcf890
    15:11:52 LTRS_1 0 130.88.195.199 <http://130.88.195.199> Internal
    Commit transact 0x354ffcf890 0
    15:11:52 LTRS_2 0 130.88.195.199 <http://130.88.195.199> Internal
    Restart transact 0x354ffcf890
    15:14:38 LTRS_1 0 130.88.195.199 <http://130.88.195.199> Internal
    Commit transact 0x354ffcf890 0
    15:14:38 LTRS_2 0 130.88.195.199 <http://130.88.195.199> Internal
    Restart transact 0x354ffcf890
    15:14:38 COMP_2 0 130.88.195.199 <http://130.88.195.199> Internal
    Compile text:  isnull
    (sparql_to_sql_text (?))
    15:14:38 COMP_2 0 130.88.195.199 <http://130.88.195.199> Internal
    Compile text:  sparql define
    output:valmode "LONG" define input:default-graph-uri
    <http://www.cellcycleontology.org/ontology/rdf/CCO> PREFIX
    rdfs:<http://www.w3.org/2000/01/rdf-schema#>
    PREFIX cco:<http://www.cellcycleontology.org/ontology/rdf/CCO#>

    SELECT ?prot
    WHERE{
       cco:CCO_B0001243 cco:is_a ?ortholog_cluster .
       ?prot cco:is_a ?ortholog_cluster .
       FILTER(!sameTerm(?prot,cco:CCO_B0001243))
    }

    thanks,
    Erick
    p.s. Here it is the HTTP line:
    
http://crunch.fvms.ugent.be:8890/sparql?default-graph-uri=http%3A%2F%2Fwww.cellcycleontology.org%2Fontology%2Frdf%2FCCO&query=PREFIX+rdfs%3A%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0D%0APREFIX+cco%3A%3Chttp%3A%2F%2Fwww.cellcycleontology.org%2Fontology%2Frdf%2FCCO%23%3E%0D%0A%0D%0ASELECT+%3Fprot%0D%0AWHERE%7B%0D%0A+++cco%3ACCO_B0001243+cco%3Ais_a+%3Fortholog_cluster+.%0D%0A+++%3Fprot+cco%3Ais_a+%3Fortholog_cluster+.%0D%0A+++FILTER%28%21sameTerm%28%3Fprot%2Ccco%3ACCO_B0001243%29%29%0D%0A%7D&format=text%2Fhtml&debug=on
    
<http://crunch.fvms.ugent.be:8890/sparql?default-graph-uri=http%3A%2F%2Fwww.cellcycleontology.org%2Fontology%2Frdf%2FCCO&query=PREFIX+rdfs%3A%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0D%0APREFIX+cco%3A%3Chttp%3A%2F%2Fwww.cellcycleontology.org%2Fontology%2Frdf%2FCCO%23%3E%0D%0A%0D%0ASELECT+%3Fprot%0D%0AWHERE%7B%0D%0A+++cco%3ACCO_B0001243+cco%3Ais_a+%3Fortholog_cluster+.%0D%0A+++%3Fprot+cco%3Ais_a+%3Fortholog_cluster+.%0D%0A+++FILTER%28%21sameTerm%28%3Fprot%2Ccco%3ACCO_B0001243%29%29%0D%0A%7D&format=text%2Fhtml&debug=on>


    -------------------------------------------------------------------------
    This SF.net email is sponsored by: Microsoft
    Defy all challenges. Microsoft(R) Visual Studio 2008.
    http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
    _______________________________________________
    Virtuoso-users mailing list
    Virtuoso-users@lists.sourceforge.net
    <mailto:Virtuoso-users@lists.sourceforge.net>
    https://lists.sourceforge.net/lists/listinfo/virtuoso-users


------------------------------------------------------------------------

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
------------------------------------------------------------------------

_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users


Reply via email to