#17 Cannot use ORDER in SVN

open
nobody
None
5
2007-01-04
2007-01-04
No

Hi,

Using ORDER BY makes ts-query crash (using SVN, works fine with latest .tgz)

alex@ns23383:/opt/threestore/src$ ts-query "SELECT ?s ?p ?o WHERE { ?s ?p ?o } ORDER BY ASC(?s) LIMIT 3" -d rdf_doap

<?xml version="1.0"?>
<sparql xmlns="http://www.w3.org/2005/sparql-results#">
<head>
<error><![CDATA[
SQL error in 'SELECT v0.lexical AS `s`, v1.lexical AS `p`, v2.lexical AS `o`, v2.datatype AS o_dt, v2.language AS o_lang
FROM ((SELECT t0.object AS `o`, t0.predicate AS `p`, t0.subject AS `s`
FROM (triples t0)
) AS `tmp0_4f6`, symbols v0, symbols v1, symbols v2)
WHERE tmp0_4f6.s=v0.hash && tmp0_4f6.p=v1.hash && tmp0_4f6.o=v2.hash
ORDER BY ((v1.hash >= 0)*2 - (v1.hash < 0 && LEFT(v1.lexical, 2)='_:')) ASC, !TYPE ERROR in ts_symbol_valtbl_type!.val ASC, v1.lexical ASC, v1.datatype ASC
LIMIT 3' 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ERROR in ts_symbol_valtbl_type!.val ASC, v1.lexical ASC, v1.datatype ASC
LIMIT 3' at line 6
]]></error>
</head>
</sparql>

Discussion


Log in to post a comment.