INSERT INTO a MERGE TABLE crashes mserver5

[monetdb-team]

Date: 2015-04-16 11:28:17 +0200
From: @yzchang
To: SQL devs <>
Version: 11.19.9 (Oct2014-SP2)
CC: @njnes

Last updated: 2015-05-07 12:38:02 +0200

Comment 20799

Date: 2015-04-16 11:28:17 +0200
From: @yzchang

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

INSERT INTO a MERGE TABLE crashes mserver5. GDB info:

Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 0x7fffecd89700 (LWP 23059)]
0x00007fffef9fd622 in timestamp_delta (d=0x0, ts=15)
at /ufs/zhang/monet/Oct2014/sql/storage/bat/bat_storage.c:32
32 while (d->next && d->wtime > ts)

Reproducible: Always

Steps to Reproduce:

A minimal query set to trigger the crash:

create table t1 (i int);
create table t2 (i int);
create merge table m (i int);
alter table m add table t1;
alter table m add table t2;
insert into m values (1);

Actual Results:

crash

Expected Results:

An error message is expected.

Comment 20805

Date: 2015-04-16 17:00:52 +0200
From: MonetDB Mercurial Repository <>

Changeset 810b430bcf72 made by Jennie Zhang y.zhang@cwi.nl in the MonetDB repo, refers to this bug.

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

Changeset description:

Added test for bug #3703

Comment 20808

Date: 2015-04-17 13:25:56 +0200
From: @njnes

added checks to disallow inserting into merge table