Date: 2012-04-27 07:38:02 +0200
From: @mlkersten
To: SQL devs <>
Version: -- development
CC: @njnes

Last updated: 2012-05-25 12:58:48 +0200

Comment 17176

Date: 2012-04-27 07:38:02 +0200
From: @mlkersten

User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.7; rv:11.0) Gecko/20100101 Firefox/11.0
Build Identifier:

Name resolution gets corrupted when multiple schema references are used in a procedure definition.

Reproducible: Always

Steps to Reproduce:

create table runningcatalog(
tag timestamp
);

create table datacell.lta(
tag timestamp
);

create procedure datacell.archive()
begin
insert into runningcatalog select * from datacell.lta;
end;
call datacell.archive();

Actual Results:

operation successful
operation successful
operation successful
TypeException:user.s0_1[2]:'user.archive' undefined in: _3:any := user.archive()
39000!program contains errors

Comment 17193

Date: 2012-04-27 16:35:49 +0200
From: @njnes

Changeset d6365fe49c70 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=d6365fe49c70

Changeset description:

fixed bug #3074, ie switch to the schema of the to be created function.

Comment 17194

Date: 2012-04-27 16:37:08 +0200
From: @njnes

we now switch to the schema of the to be created function. In the example the create procedure will than fail with a unknown table (runningcatalog).