Date: 2014-09-19 18:15:58 +0200
From: Martin van Dinther <<martin.van.dinther>>
To: SQL devs <>
Version: 11.17.21 (Jan2014-SP3)
CC: @njnes

Last updated: 2014-10-31 14:14:46 +0100

Comment 20170

Date: 2014-09-19 18:15:58 +0200
From: Martin van Dinther <<martin.van.dinther>>

User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:32.0) Gecko/20100101 Firefox/32.0
Build Identifier:

mserver5: 8347 Segmentation fault ./MonetDB201408/bin/mserver5 -d10 --set mapi_port=49000

after running SQL:
select oid > 0, * from altstartwith;

Reproducible: Always

Steps to Reproduce:

1. Start mserver5 (MonetDB 5 server v11.17.21 "Jan2014-SP3")
2. Start mclient
3. Run SQL commands:
   create table altstartwith (oid oid GENERATED ALWAYS AS IDENTITY, col integer);
   select * from altstartwith;
   select oid > 0, * from altstartwith;

Actual Results:

bash-4.2$ start_mserver5
builtin opt gdk_dbpath = /ufs/dinther/MonetDB201408/var/monetdb5/dbfarm/demo
builtin opt gdk_debug = 0
builtin opt gdk_vmtrim = no
builtin opt monet_prompt = >
builtin opt monet_daemon = no
builtin opt mapi_port = 50000
builtin opt mapi_open = false
builtin opt mapi_autosense = false
builtin opt sql_optimizer = default_pipe
builtin opt sql_debug = 0
cmdline opt mapi_port = 49000
MonetDB 5 server v11.17.21 "Jan2014-SP3"
Serving database 'demo', using 8 threads
Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked
Found 15.356 GiB available main-memory.
Copyright (c) 1993-July 2008 CWI.
Copyright (c) August 2008-2014 MonetDB B.V., all rights reserved
Visit http://www.monetdb.org/ for further information
Listening for connection requests on mapi:monetdb://127.0.0.1:49000/
MonetDB/GIS module loaded
MonetDB/JAQL module loaded
MonetDB/SQL module loaded

mserver5: 8347 Segmentation fault ./MonetDB201408/bin/mserver5 -d10 --set mapi_port=49000
bash-4.2$

Welcome to mclient, the MonetDB/SQL interactive terminal (unreleased)
Database: MonetDB v11.17.21 (Jan2014-SP3), 'demo'
Type \q to quit, ? for a list of available commands
auto commit mode: on
sql>create table altstartwith (oid oid GENERATED ALWAYS AS IDENTITY, col integer);
operation successful (273.312ms)
sql>select * from altstartwith;
+-----+-----+
| oid | col |
+=====+=====+
+-----+-----+
0 tuples (1.870ms)
sql>select oid > 0, * from altstartwith;
bash-4.2$

Expected Results:

No segmentation fault in mserver5 process

Problem also occurs with version MonetDB 5 server v11.20.0, default branch version compiled on 19 sept 2014.

Comment 20171

Date: 2014-09-19 18:51:22 +0200
From: MonetDB Mercurial Repository <>

Changeset d287936fddd5 made by Martin van Dinther martin.van.dinther@monetdbsolutions.com in the MonetDB repo, refers to this bug.

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

Changeset description:

Saving changes made to alter_table.sql tests
Due to a crashing mserver5 (see bug #3579) the final stable.out and stable.err are not available yet.

Comment 20178

Date: 2014-09-21 16:54:22 +0200
From: @njnes

handle empty void bats in calc compare.

Comment 20179

Date: 2014-09-21 17:28:29 +0200
From: MonetDB Mercurial Repository <>

Changeset 3c7675b36829 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=3c7675b36829

Changeset description:

fixes for bug #3579 and bug #3575

Comment 20391

Date: 2014-10-31 14:14:46 +0100
From: @sjoerdmullender

Oct2014 has been released.