Hi Jennie,

Thanks for your attention, both uniquecatalog11 and uzone can be empty table.
schema is:

create sequence "unique_seq" as bigint;

create table uniquecatalog11(id bigint PRIMARY KEY
DEFAULT NEXT VALUE FOR "unique_seq"
, targetid bigint 
, ra_avg double
, decl_avg double
, flux_ref double
, datapoints int
, zone smallint
, x double
, y double
, z double
, INACTIVE BOOLEAN
);
uzone table is declared within the udf.

Bests,
Meng
------------------ Original ------------------
From:  "Ying Zhang";<Y.Zhang@cwi.nl>;
Date:  Jul 19, 2015
To:  "Communication channel for MonetDB users"<users-list@monetdb.org>;
Subject:  Re: combined conditions in user defined function made monetdb exited.


> On Jul 19, 2015, at 15:27 , integrity <357416268@qq.com> wrote:
>
> Dear experts,
>
> I tried to create an function in monetdb, but the first one successful, the second one successful, but the combo failed.
>
> create function neighbor19()
> 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
> );
> end;
> successful.
>
> create function neighbor20()
> 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 ra_avg between 10 and 20
> );
> end;
> successful.
>
> 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;
> failed with monetdb exited.

Hai Meng,

Can you please provide the schema of uniquecatalog11 and uzone?
Does the crash also happen if these two tables are empty?  Otherwise, weˇŻll need some data to reproduce the crash as well.  Thanks,

Jennie



>
> in merovingian.log:
> 2015-07-19 13:34:36 MSG merovingian[25753]: database 'gwacdb' (633) was killed by signal SIGSEGV
>
> I tried on default and Jul2015 branch, all the same with each other.
> Any help or hints are appreciated!
>
> Best,
> Meng
> _______________________________________________
> users-list mailing list
> users-list@monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list