Bugs item #2807336, was opened at 2009-06-16 21:27
Message generated for change (Comment added) made by sjoerd
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2807336&group_id=56967
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: SQL/Core
Group: MonetDB5 CVS Head
Status: Open
Resolution: None
Priority: 5
Private: Yes
Submitted By: Stefan de Konink (skinkie)
Assigned to: Niels Nes (nielsnes)
Summary: UPDATE Assertion `re->type == e_column'
Initial Comment:
>mserver5: ../../../src/server/rel_select.mx:4289: rel_select_exp: Assertion
>`re->type == e_column' failed.
Is caused by:
update anbi set kvk = (select kvk from kvk,anbi where lower(naam) =
lower(bedrijfsnaam) and lower(plaats) = lower(vestigingsplaats));
Now I know this query might not be valid... but I was toying around :)
----------------------------------------------------------------------
>Comment By: Sjoerd Mullender (sjoerd)
Date: 2009-06-24 14:12
Message:
Sorry:
sql>update anbi set kvk = (select kvk from kvk,anbi where lower(naam) =
lower(bedrijfsnaam) and lower(plaats) = lower(vestigingsplaats));
!UPDATE: no such column 'anbi.kvk'
The schema does not match the query.
----------------------------------------------------------------------
Comment By: Stefan de Konink (skinkie)
Date: 2009-06-24 12:00
Message:
CREATE TABLE "sys"."anbi" (
"naam" varchar(256),
"vestigingsplaats" varchar(32),
"beschikking" date,
"intrekking" date
);
CREATE TABLE "sys"."kvk" (
"kvk" bigint,
"bedrijfsnaam" varchar(255),
"adres" varchar(64),
"postcode" varchar(6),
"plaats" varchar(32),
"type" varchar(16)
);
The data is available with Niels, but I have kindly requested not to
incorporate the entire database in a public test suite until further
notice.
----------------------------------------------------------------------
Comment By: Sjoerd Mullender (sjoerd)
Date: 2009-06-24 11:57
Message:
database schema?
Presumably we don't need data, but this cannot be tested without a
database schema.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2807336&group_id=56967
------------------------------------------------------------------------------
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
