SQL query kills the mserver5 (Segmentation fault)

[monetdb-team]

Date: 2014-06-06 18:52:47 +0200
From: Martin van Dinther <<martin.van.dinther>>
To: SQL devs <>
Version: 11.17.17 (Jan2014-SP2)
CC: @njnes

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

Comment 19833

Date: 2014-06-06 18:52:47 +0200
From: Martin van Dinther <<martin.van.dinther>>

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

Executing SQL query:
SELECT 1 AS one WHERE 1 IN (SELECT 1);
kills the mserver5 (Segmentation fault)

Reproducible: Always

Steps to Reproduce:

1. start mserver5
2. start SQL Frontend (I tested via SQuirreL and mclient), connect to running mserver5
3. Execute SQL query:
   SELECT 1 AS one WHERE 1 IN (SELECT 1)

Actual Results:

bash-4.2$ /ufs/dinther/MonetDB201405/bin/mserver5 -d10
builtin opt gdk_dbpath = /ufs/dinther/MonetDB201405/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
MonetDB 5 server v11.17.15 "Jan2014-SP2"
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:50000/
MonetDB/GIS module loaded
MonetDB/JAQL module loaded
MonetDB/SQL module loaded

Segmentation fault
bash-4.2$

Expected Results:

no crashed server
and
a result of the query

It also crashes with following SQL queries:
SELECT 1 AS zero WHERE 1 NOT IN (SELECT 1);
and
SELECT 1 AS zero WHERE 1 IN (SELECT 2);

However it does NOT crash with SQL query;
SELECT 1 AS one WHERE 1 = 1 AND 1 IN (SELECT 1)

Comment 19896

Date: 2014-07-09 15:46:39 +0200
From: MonetDB Mercurial Repository <>

Changeset d207b2b7ece5 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=d207b2b7ece5

Changeset description:

fixed bug #3491, ie not need for a crossproduct if both left and right are only expressions, not relations.

Comment 20010

Date: 2014-08-07 15:35:58 +0200
From: @njnes

was fixed some time ago

Comment 20011

Date: 2014-08-07 15:37:04 +0200
From: MonetDB Mercurial Repository <>

Changeset 4cf5c1650534 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=4cf5c1650534

Changeset description:

added test for bug #3491

Comment 20371

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

Oct2014 has been released.