Date: 2013-07-09 09:24:31 +0200
From: @drstmane
To: SQL devs <>
Version: 11.15.11 (Feb2013-SP3)
CC: @njnes

Last updated: 2013-09-27 13:47:17 +0200

Comment 18908

Date: 2013-07-09 09:24:31 +0200
From: @drstmane

While INSERT appears to work fine, UPDATE does not work with / does not see DECLAREd TABLE in SQL FUNCTION:

$ cat /tmp/x.sql
create function MyFunc1()
returns int
begin
declare table t (a int);
insert into t values (1);
update t set i = 0;
return 0;
end;

select MyFunc1();

drop function MyFunc1;

$ mclient /tmp/x.sql
UPDATE: no such table 't'
SELECT: no such operator 'myfunc1'
DROP FUNCTION: no such function 'myfunc1'

Comment 18955

Date: 2013-07-31 10:45:41 +0200
From: @njnes

fixed, ie we now properly find declared tables also in the update_table code

Comment 18958

Date: 2013-07-31 10:49:30 +0200
From: MonetDB Mercurial Repository <>

Changeset 6b9d21862a6a made by Niels Nes niels@cwi.nl in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=6b9d21862a6a

Changeset description:

fixed bug #3329, ie handle abort on error bit on subavg call
fixed bug #3319, return error on unique/primary/foreign constraints on declared tables
fixed bug #3318, correctly find the declared tables