mserver5 crash on SQL: SELECT COUNT(*) FROM SYS.TABLES HAVING COUNT(*) > 0

[monetdb-team]

Date: 2014-03-28 12:55:29 +0100
From: Martin van Dinther <<martin.van.dinther>>
To: SQL devs <>
Version: 11.17.13 (Jan2014-SP1)
CC: @hannesmuehleisen, @njnes

Last updated: 2014-05-22 09:52:27 +0200

Comment 19709

Date: 2014-03-28 12:55:29 +0100
From: Martin van Dinther <<martin.van.dinther>>

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

MonetDB 5 server v11.17.9 "Jan2014"
Serving database 'demo', using 8 threads
Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked
Found 7.733 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/SQL module loaded

./start_mserver5: line 1: 7467 Segmentation fault ./MonetDBFebr2014/bin/mserver5

Reproducible: Always

Steps to Reproduce:

1. start mserver5
2. start SQuirreL connecting to demo database
3. execute SQL query: SELECT COUNT() FROM SYS.TABLES HAVING COUNT() > 0

Actual Results:

MonetDB 5 server v11.17.9 "Jan2014"
Serving database 'demo', using 8 threads
Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked
Found 7.733 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/SQL module loaded

./start_mserver5: line 1: 7467 Segmentation fault ./MonetDBFebr2014/bin/mserver5

Expected Results:

1 row, 1 col with value 40

query
SELECT COUNT(*) FROM SYS.TABLES
works fine
but adding the HAVING-clause causes the server to crash immediately (Segmentation fault).

The SQL query is correct SQL (as it works on DB2, Oracle, etc).

Comment 19710

Date: 2014-03-28 13:02:32 +0100
From: MonetDB Mercurial Repository <>

Changeset db58be30cce8 made by Sjoerd Mullender sjoerd@acm.org in the MonetDB repo, refers to this bug.

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

Changeset description:

Added test for bug #3458.

Comment 19712

Date: 2014-03-28 14:32:52 +0100
From: @hannesmuehleisen

Good one, confirmed.

Comment 19716

Date: 2014-03-29 14:17:52 +0100
From: @njnes

fixed, ie. properly initialize a select relational operator

Comment 19719

Date: 2014-03-29 14:23:50 +0100
From: MonetDB Mercurial Repository <>

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

Changeset description:

fixed bugs 3458, 3461 and 3462

3461 added missing select
3462 check number of columns