Hi Lorena,
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
Your Virtuoso server version does not support the SPARQL 1.1. Syntax
extensions.
You need to update to newer version of the Virtuso server in order
MD5('test') to work.
Best Regards,
Rumi
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 <rtsek...@openlinksw.com>
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" <lore...@fing.edu.uy>
To: "Rumi Tsekova" <rtsek...@openlinksw.com>
Cc: <virtuoso-users@lists.sourceforge.net>
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 <rtsek...@openlinksw.com>
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
Virtuoso-users@lists.sourceforge.net
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
Virtuoso-users@lists.sourceforge.net
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
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
--
Lorena Etcheverry