Stream table gives segfault

[monetdb-team]

Date: 2016-03-13 09:21:05 +0100
From: @mlkersten
To: SQL devs <>
Version: 11.17.13 (Jan2014-SP1)
CC: @njnes

Last updated: 2016-03-25 09:59:50 +0100

Comment 21880

Date: 2016-03-13 09:21:05 +0100
From: @mlkersten

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

sql>create stream table temp(t timestamp, room integer, payload decimal(8,2));
operation successful (21.739ms)
sql>insert into temp values(timestamp '2016-03-13 08:58:14', 1, 23.4);

Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 0x7fb7e7760700 (LWP 24216)]
0x00007fb7fa56510e in timestamp_delta (d=0x0, ts=10) at /export/scratch1/mk/iothings//package/sql/storage/bat/bat_storage.c:21
21 while (d->next && d->wtime > ts)

(gdb) where
0 0x00007fb7fa56510e in timestamp_delta (d=0x0, ts=10) at /export/scratch1/mk/iothings//package/sql/storage/bat/bat_storage.c:21
1 0x00007fb7fa5680d4 in append_col (tr=0x638c3d0, c=0x7fb7dc27b6e0, i=0x7fb7dc10cdd0, tpe=24) at /export/scratch1/mk/iothings//package/sql/storage/bat/bat_storage.c:636
2 0x00007fb7fa3f7220 in mvc_append_wrap....

Reproducible: Always

Comment 21884

Date: 2016-03-13 19:46:24 +0100
From: MonetDB Mercurial Repository <>

Changeset 882cc12f4831 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=882cc12f4831

Changeset description:

add checks to disallow inserts into stream's fixes bug #3952

Comment 21885

Date: 2016-03-13 19:46:53 +0100
From: @njnes

fixed, ie added checks

Comment 21977

Date: 2016-03-25 09:59:50 +0100
From: @sjoerdmullender

Jul2015-SP3 has been released.