Hello Lorena,
I don't know exact version you're using but there's one more (less
convenient but reliable) way of getting the sql text:
set blobs on;
select sparql_to_sql_text ('SELECT ...') as X long varchar;
That will work with any combination of an isql client and the server.
The disadvantages are
1. The text of the query in quotes should have leading SPARQL removed,
too easy to forget that, esp. keeping in mind that the leading SPARQL is
required in similar call of explain() function.
2. Single quotes should all be replaced with pairs of consequent double
quotes (i.e, '', not ")
3. SPARQL comments that begin with # and ends with end of line become
confusing because ISQL client tends to concatenate all lines of the
query and the comment can continue till the end of the query, breaking
the syntax of the SPARQL query in question.
Best Regards,
Ivan.
On Thu, 2015-06-18 at 17:33 -0300, Lorena Etcheverry wrote:
> Hi
>
> I'm still having this problem.
> Any suggestions?
> best regards
> Lorena
>
>
> -------- Forwarded Message --------
> Subject:
> Long SPARQL query translation to
> SQL
> Date:
> Tue, 26 May 2015 13:23:54 -0300
> From:
> Lorena Etcheverry
> <lore...@fing.edu.uy>
> To:
> virtuoso-users@lists.sourceforge.net <Virtuoso-users@lists.sourceforge.net>
>
>
> Hi
>
> I'm following the indications found in
> http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtTipsAndTricksAanalyzingSPARQLQuery
> to obtain a explain plan of a long SPARQL query under Virtuoso 7.
>
> Although I have set blobs on, I receive the following error when trying
> to obtain the SQL expression equivalent to my query
>
> Warning 01004: [Virtuoso Driver]CL077: Data truncated in column 1 of the
> result-se(SPARQL_TO_SQL_TEXT, type 182)
> in lines 113-114 of Top-Level:
> #line 113 "(console)"
>
> The output is certainly truncated, the output is not a valid SQL query.
>
> Any ideas on how to deal with this?
>
>
> best regards,
> Lorena
>
>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
Monitor 25 network devices or servers for free with OpManager!
OpManager is web-based network management software that monitors
network devices and physical & virtual servers, alerts via email & sms
for fault. Monitor 25 devices for free with no restriction. Download now
http://ad.doubleclick.net/ddm/clk/292181274;119417398;o
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
