Re: [Virtuoso-users] MD5 function

Mon, 25 Jun 2012 14:35:14 +0000 

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

Reply via email to