[redland-dev] SQLite Storage Bug

[Darrin Thompson]

All,

I've been attempting to use the sqlite storage for redland, but get the
following error:

  File "/usr/lib/python2.3/site-packages/RDF.py", line 852, in
find_statements
    statement._statement)
RDF.RedlandError: SQLite database rdf SQL compile 'SELECT
  SubjectURIs.uri     AS subjectUri,
  SubjectBlanks.blank AS subjectBlank,
  PredicateURIs.uri   AS predicateUri,
  ObjectURIs.uri      AS objectUri,
  ObjectBlanks.blank  AS objectBlank,
  ObjectLiterals.text AS objectLiteralText,
  ObjectLiterals.language AS objectLiteralLanguage,
  ObjectLiterals.datatype AS objectLiteralDatatype,
  ObjectDatatypeURIs.uri  AS objectLiteralDatatypeUri,
  ContextURIs.uri         AS contextUri
FROM triples AS T
  LEFT JOIN uris     AS SubjectURIs    ON SubjectURIs.id    =
T.subjectUri
  LEFT JOIN blanks   AS a' failed - near " ": syntax error (1)

Notice the garbage character at the end of the quote. Here is a snip
from hexdump -C, notice the 03.
000004c0  20 20 4c 45 46 54 20 4a  4f 49 4e 20 62 6c 61 6e  |  LEFT JOIN
blan|
000004d0  6b 73 20 20 20 41 53 20  61 03 27 20 66 61 69 6c  |ks   AS a.'
fail|

I'm using the redland packages from Debian.

$ apt-cache policy librdf0
librdf0:
  Installed: 1.0.0-2
  Candidate: 1.0.0-2
  Version Table:
 *** 1.0.0-2 0
        500 http://archive.progeny.com sarge/main Packages
        500 http://archive.progeny.com unstable/main Packages
        100 /var/lib/dpkg/status

I looked at the code myself but didn't see any obvious cause for this
problem.

--
Darrin