Share

3store

Tracker: Bugs

5 Unable to submit requests - ID: 1604367
Last Update: Comment added ( denis_pitzalis )

when I try to do a query I get an error in mysql syntax:

ts-query "SELECT ?x ?y WHERE { ?x
<http://www.w3.org/1999/02/22-rdf-syntax-ns#type> ?y . } LIMIT 10"

<?xml version="1.0"?>
<sparql xmlns="http://www.w3.org/2005/sparql-results#">
<head>
<error><![CDATA[
SQL error in 'SELECT v0.lexical AS `x`, v1.lexical AS `y`, v1.datatype AS
y_dt, v1.language AS y_lang
FROM ((SELECT t1.object AS `y`, t0.object AS `_TV0`, t0.subject AS `x`
FROM triples t0, triples t1
WHERE t1.predicate=-5275523445234180533
AND t1.subject=t0.object
AND t0.predicate=-4085280037482734459

LIMIT 10) AS `tmp0_116b`, symbols v0, symbols v1)
WHERE tmp0_116b.x=v0.hash && tmp0_116b.y=v1.hash

LIMIT 10' 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
'AS `tmp0_116b`, symbols v0, symbols v1)
WHERE tmp0_116b.x=v0.hash && tmp0_116b.y' at line 8
]]></error>
</head>
</sparql>


Denis Pitzalis ( denis_pitzalis ) - 2006-11-28 10:14

5

Closed

None

Nobody/Anonymous

None

None

Public


Comments ( 3 )




Date: 2006-11-29 13:48
Sender: denis_pitzalisAccepting Donations


sorry, I was using mysql 4...
upgrading the system to mysql 5 solved the problem.
Cheers and thank,
Denis


Date: 2006-11-29 12:49
Sender: theno23Project Admin


What version of MySQL are you using?

There have been problems with bugs in versions of MySQL 4 and 5 as of
about 6 months ago.


Date: 2006-11-29 12:48
Sender: theno23Project Admin


What version of MySQL are you using?

There have been problems with bugs in versions of MySQL 4 and 5 as of
about 6 months ago.


Log in to comment.

Attached File

No Files Currently Attached

Changes ( 4 )

Field Old Value Date By
status_id Deleted 2006-11-29 13:48 denis_pitzalis
close_date 2006-11-28 17:05 2006-11-29 13:48 denis_pitzalis
status_id Open 2006-11-28 17:05 denis_pitzalis
close_date - 2006-11-28 17:05 denis_pitzalis