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