Date: 2011-06-04 23:03:01 +0200
From: @mlkersten
To: SQL devs <>
Version: 11.3.7 (Apr2011-SP2) [obsolete]
CC: @njnes, @drstmane

Last updated: 2011-09-16 15:04:40 +0200

Comment 15832

Date: 2011-06-04 23:03:01 +0200
From: @mlkersten

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

Operator resolution issue. User defined function in specific schema not found.

Reproducible: Always

Steps to Reproduce:

create schema datacell;
create table datacell.basket_X(
id integer auto_increment,
tag timestamp default now(),
payload integer
);

create function datacell.basket_X()
returns table (id integer, tag timestamp, payload integer)
begin
return select * from datacell.basket_X;
end;

select * from datacell.basket_X();

Actual Results:

!SELECT: no such operator 'basket_x'

Comment 15846

Date: 2011-06-13 22:33:46 +0200
From: @mlkersten

Problem is fixed in the default.

Comment 15958

Date: 2011-07-17 15:44:27 +0200
From: @drstmane

Changeset bed1350dc1be made by Stefan Manegold Stefan.Manegold@cwi.nl in the MonetDB repo, refers to this bug.

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

Changeset description:

added test for bug #2817

Comment 15959

Date: 2011-07-17 16:06:06 +0200
From: @drstmane

Re-opened as

(1)
it still fails as originally reported in Apr2011 branch
(admittedly, it has never been fixed there)

(2)
it causes a server crash (segfault) in Aug2011 branch

Comment 15960

Date: 2011-07-17 16:14:39 +0200
From: @drstmane

crash also occurs in default branch

Comment 15987

Date: 2011-07-27 17:29:54 +0200
From: @njnes

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

Changeset description:

fixes for bug #2817, keep 'generated types' in schema sys.
Put function in passed schema (not in the current schema).

Comment 15989

Date: 2011-07-27 20:02:13 +0200
From: @njnes

test is now running also on the april branch

Comment 16049

Date: 2011-07-29 11:03:54 +0200
From: @sjoerdmullender

Apr2011-SP2 has been released.

Comment 16253

Date: 2011-09-16 15:04:40 +0200
From: @sjoerdmullender

The Aug2011 version has been released.