Hi Fabian,
I just checked, I cannot reproduce the bug, for me the query translates
just fine into SQL and gives the expected results:
SELECT P1.object AS V3, P1.predicate AS V2, P1.subject AS V1
FROM triples P1
INNER JOIN nodes AS P1_subject_V1 ON P1.subject = P1_subject_V1.id
INNER JOIN nodes AS P1_predicate_V2 ON P1.predicate =
P1_predicate_V2.id
INNER JOIN nodes AS P1_object_V3 ON P1.object = P1_object_V3.id
WHERE P1.deleted = false
There is one issue I discovered, though: in case your Marmotta database
user is not a PostgreSQL superuser you have to manually run
"CREATE EXTENSION pgcrypto" for the database you are using. Still thinking
about ways how to solve this (the extension is necessary for some SPARQL
functions like UUID and md5).
Greetings,
Sebastian
2014-09-23 15:57 GMT+02:00 Sebastian Schaffert <
[email protected]>:
> Hi Fabian,
>
> I will have a look, it might be an error in the translation.
>
> Greetings,
>
> Sebastian
>
> 2014-09-23 9:25 GMT+02:00 Fabian Cretton <[email protected]>:
>
>> Hi,
>>
>> I did upgrade my fork from Marmotta/develop yesterday, and I now have a
>> "error while evaluating query" on the squebi interface for a query as
>> "SELECT * WHERE {?subject ?property ?object} LIMIT 10"
>> But that one works (not using the *): "SELECT ?subject WHERE {?subject
>> ?property ?object} LIMIT 10"
>>
>> The sample query "select first 10 triples" gives the same error.
>>
>> Is it a bug you can reproduce or did I do something wrong during the
>> merge process ?
>>
>> Also my logging functionality seems to be altered:
>> each day a new "marmotta-security.log" is generated as expected, but
>> since the merge, no new "marmotta-main.log" was generated today.
>>
>> Thank you
>> Fabian
>>
>>
>>
>
>
