Re: Problem: Relational query without result

Hi, indeed ;-) For all Oct2014 releases (including Oct2014-SP2 aka. 11.19.9) I get "relational query without result". In other words, other than you reported, also with 11.19.9 aka. Oct2014-SP2, your query does not work on your schema for me. However, with the latest Jul2015 release candidate branch, I get SELECT: no such column 'samples.disease_id' and indeed, the "samples" table has no column "disease_id". With the Jul2015 release due soon (though maybe not by the end of this month), and the problem seemingly fix / no longer occuring with Jul2015, we most probably will not further investigate, let alone fix the problem on the Oct2014 branch. Best, Stefan ----- On Jul 22, 2015, at 2:27 PM, Martin Schwitalla MSchwitalla1@gmx.de wrote:

Hi,

that was it! One column had a false name in the create table statement and hadn`t been recognized in my query. But the error massage could be a little bit helpfuler ;) But thanks!

Kind regards, Martin

...

Am 22.07.2015 um 14:16 schrieb Radovan Bičiště :

Hi, It is usually syntax error in the query like misnamed column etc. I would to try to comment out part of the query and see if syntax analyzer would give me better hint on what's wrong.

Radovan

On 07/22/2015 01:09 PM, Martin Schwitalla wrote:

...

Hi,

I have a problem. I have tested on MonetDB 11.19.9 a query and wanted to test the same query on a better Workstation and installed MonetDB 11.19.15. But now I get every time the message „realtional query without result“ when I try to run the query. Can anybody help?

Kind regards, Martin _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

--

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |