A SELECT query fails to produce some results #2879
Last updated: 2011-09-30 10:58:46 +0200
Date: 2011-09-13 12:59:32 +0200
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:6.0.2) Gecko/20100101 Firefox/6.0.2
DB dump and the SQL Query
SELECT M_1.VC_4 AS V_1, M_1.VC_3 AS V_2, M_1.VC_1 AS V_3, M_1.VC_2 AS V_4
CREATE TABLE triples (
INSERT INTO triples (s, p, o) VALUES
Steps to Reproduce:
http://example/x http://example/b http://example/y21 http://example/y21
http://example/x http://example/a http://example/z11 http://example/z21
Date: 2011-09-14 14:51:54 +0200
It looks like an operator priority issue in combination with presumed interpretation semantics.
Date: 2011-09-14 15:11:55 +0200
(In reply to comment 1)
The query has been automatically produced by a framework. It is impossible to significantly modify it without re-developing large parts of this framework.
Date: 2011-09-14 18:29:00 +0200
The please inform us and the community, which general available framework you have been using to generate these queries. As you can imagine, a bug resulting from an open-source and widely used package receives more attention.
Date: 2011-09-14 19:53:55 +0200
seems a bug in the outer join with 'or'
Date: 2011-09-14 20:41:37 +0200
(In reply to comment 3)
We are trying integrate Jena (Semantic Web framework for Java) (http://jena.sourceforge.net/).
Date: 2011-09-16 15:10:41 +0200
The Aug2011 version has been released.
Date: 2011-09-17 12:53:13 +0200
MonetDB is not integrated (yet) with Jena. We appreciate if you take the lead and run the SDB test set to assess what features are missing and/or related bugs.
Date: 2011-09-19 16:01:37 +0200
For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=248294d05358
Date: 2011-09-25 10:55:31 +0200
fixed the implementation of outerjoins
Date: 2011-09-30 10:58:46 +0200
Released in Aug2011-SP1
The text was updated successfully, but these errors were encountered: