Date: 2015-07-19 22:29:32 +0200
From: 357416268
To: SQL devs <>
Version: 11.19.15 (Oct2014-SP4)
CC: 357416268, @njnes

Last updated: 2015-08-28 13:42:49 +0200

Comment 21025

Date: 2015-07-19 22:29:32 +0200
From: 357416268

User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/43.0.2357.134 Safari/537.36
Build Identifier:

Reproducible: Always

Steps to Reproduce:

create table uniquecatalog11(id bigint PRIMARY KEY
, targetid bigint
, ra_avg double
, decl_avg double
, flux_ref double
, datapoints int
, zone smallint
, x double
, y double
, z double
, INACTIVE BOOLEAN
);

2. create function neighbor30()
   returns table (ra_avg double)
   begin
   declare table uzone (id bigint, ra_avg double);
   insert into uzone select id, ra_avg from uniquecatalog11;
   return table( select ra_avg
   from uzone as u0
   where id between 10 and 20
   and ra_avg between 10 and 20
   );
   end;

Actual Results:

monetdb crashed.

Expected Results:

a udf defined successfully.

default and July branches are tested on.

Comment 21050

Date: 2015-07-22 22:52:46 +0200
From: @njnes

added more protection against declared tables (as they do not have a schema)

Comment 21051

Date: 2015-07-22 22:54:05 +0200
From: MonetDB Mercurial Repository <>

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

Changeset description:

fix for bug #3770, ie protect agains missing schema names

Comment 21217

Date: 2015-08-28 13:42:49 +0200
From: @sjoerdmullender

Jul2015 has been released.