Hi Rumi
It works with the bif prefix.
Here is the output of virtuoso-t
I'm working on Ubuntu 10.10 so I have built it from the sources
several months ago.
regards
Lorena
lorena@lorena-virtual-machine:~$ virtuoso-t -?
Virtuoso Open Source Edition (multi threaded)
Version 6.1.4.3127-pthreads as of Dec 16 2011
Compiled for Linux (i686-pc-linux-gnu)
Copyright (C) 1998-2011 OpenLink Software
Usage:
virtuoso-t [-fcnCbDARwMKrBd] [+foreground] [+configfile arg] [+no-checkpoint]
[+checkpoint-only] [+backup-dump] [+crash-dump]
[+crash-dump-data-ini arg] [+restore-crash-dump] [+wait]
[+mode arg] [+dumpkeys arg] [+restore-backup arg]
[+backup-dirs arg] [+debug] [+pwdold arg] [+pwddba arg]
[+pwddav arg]
+foreground run in the foreground
+configfile use alternate configuration file
+no-checkpoint do not checkpoint on startup
+checkpoint-only exit as soon as checkpoint on startup is complete
+backup-dump dump database into the transaction log, then exit
+crash-dump dump inconsistent database into the
transaction log, then exit
+crash-dump-data-ini specify the DB ini to use for reading the data to dump
+restore-crash-dump restore from a crash-dump
+wait wait for background initialization to complete
+mode specify mode options for server startup (onbalr)
+dumpkeys specify key id(s) to dump on crash dump (default : all)
+restore-backup restore from online backup
+backup-dirs default backup directories
+debug Show additional debugging info
+pwdold Old DBA password
+pwddba New DBA password
+pwddav New DAV password
On Mon, Jun 25, 2012 at 4:34 PM, Rumi Tsekova <[email protected]> wrote:
> Hi Lorena,
>
>
> Could you send us the output of:
>
> virtuoso-t -?
>
>
> It seems you are having Virtuoso version that does not support the SPARQL
> 1.1 function extensions.
>
> What about if you try with bif:MD5 ?
> So for ex:
>
> SELECT bif:MD5 ('test') WHERE { ?s ?p ?o } LIMIT 10
>
>
> Best Regards,
> Rumi
>
>
> ----- Original Message -----
> From: "lorena" <[email protected]>
> To: "Rumi Tsekova" <[email protected]>
> Cc: <[email protected]>
> Sent: Monday, June 25, 2012 4:11 PM
> Subject: Re: [Virtuoso-users] MD5 function
>
>
> Hi Rumi:
>
> I've tried the query with the white space fix in both: conductor
> sparql section
> (http://localhost:8890/conductor/sparql_input.vspx?sid=d2143c610816358a747b0ed4154d812c&realm=virtuoso_admin)
> and the sparql endpoint at http://localhost:8890/sparql.
>
> In both cases I still get the same error:
>
> Virtuoso 37000 Error SP030: SPARQL compiler, line 3: syntax error at
> 'MD5' before '('
>
> SPARQL query:
> define sql:big-data-const 0
> #output-format:text/html
> define sql:signal-void-variables 1 SELECT MD5 ('test') WHERE { ?s ?p
> ?o } LIMIT 10
>
> thanks
> Lorena
>
>
> On Mon, Jun 25, 2012 at 3:55 PM, Rumi Tsekova <[email protected]>
> wrote:
>> Hi Lorena,
>>
>>> Hi!
>>>
>>> I'm trying this sample query, from
>>> http://www.openlinksw.com/dataspace/dav/wiki/Main/VirtTipsAndTricksSPARQL11FeaturesExamplesCollection,
>>> on my local Virtuoso Version: 06.01.3127.
>>>
>>> SELECT MD5 ('test')
>>> WHERE
>>> {
>>> ?s ?p ?o
>>> }
>>> LIMIT 10
>>>
>>> And I get the following error
>>>
>>> Virtuoso 37000 Error SP030: SPARQL compiler, line 3: syntax error at
>>> 'MD5' before '('
>>>
>>> SPARQL query:
>>> define sql:big-data-const 0
>>> #output-format:text/html
>>> SELECT MD5 (?s)
>>> WHERE
>>> {
>>> ?s ?p ?o
>>> }
>>> LIMIT 10
>>>
>>>
>>> Am I missing some prefix or is that this function is not supported on
>>> Virtuoso Version: 06.01.3127 ?
>>
>> It depends where you executed the query re. using prefix.
>> If it is from the SPARQL endpoint i.e. http://host:port/sparql then no
>> "sparql" infront, i.e.:
>> SELECT MD5 ('test') WHERE { ?s ?p ?o } LIMIT 10
>>
>> If you executed it from iSQL tool or from Conductor (
>> http://host:port/conductor -> Database -> Interactive SQL ) then you
>> should
>> use sparql placed infront of the query:
>>
>> i.e.:
>>
>> iSQL:
>> SQL > SPARQL SELECT MD5 ('test') WHERE { ?s ?p ?o } LIMIT 10
>>
>> or from Conductor:
>>
>> SPARQL SELECT MD5 ('test') WHERE { ?s ?p ?o } LIMIT 10
>>
>>
>> However I noticed your query from above is missing one white space after
>> ('test').
>> What if you try the query like this: SELECT MD5 ('test') WHERE { ?s ?p
>> ?o }
>> LIMIT 10
>>
>>
>> Please let us know if that worked for you.
>>
>> Best Regards,
>> Rumi
>>
>>
>>>
>>> thanks in advance
>>> Lorena
>>>
>>> ------------------------------------------------------------------------------
>>> Live Security Virtual Conference
>>> Exclusive live event will cover all the ways today's security and
>>> threat landscape has changed and how IT managers can respond. Discussions
>>> will include endpoint security, mobile security and the latest in malware
>>> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
>>> _______________________________________________
>>> Virtuoso-users mailing list
>>> [email protected]
>>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>>
>>
>> ------------------------------------------------------------------------------
>> Live Security Virtual Conference
>> Exclusive live event will cover all the ways today's security and
>> threat landscape has changed and how IT managers can respond. Discussions
>> will include endpoint security, mobile security and the latest in malware
>> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
>> _______________________________________________
>> Virtuoso-users mailing list
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>
>
>
> --
> Lorena Etcheverry
>
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> Virtuoso-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
--
Lorena Etcheverry
