Date: 2014-07-18 11:45:12 +0200
From: Martin van Dinther <<martin.van.dinther>>
To: SQL devs <>
Version: 11.17.17 (Jan2014-SP2)

Last updated: 2014-07-31 09:50:15 +0200

Comment 19910

Date: 2014-07-18 11:45:12 +0200
From: Martin van Dinther <<martin.van.dinther>>

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

mserver5: gdk_select.c:622: BAT_scanselect: Assertion `b->T->type != 6 || equi || b->T->nonil' failed.

Reproducible: Always

Steps to Reproduce:

1.compile monetdb with --enable-assert
2.start mserver5
3.make connection e.g. via mclient
4.Issue follwing SQL statements:
CREATE TABLE OID_TBL(f1 oid);
INSERT INTO OID_TBL(f1) VALUES ('1234');
INSERT INTO OID_TBL(f1) VALUES ('1235');
SELECT * FROM OID_TBL WHERE f1 = 1234;
SELECT * FROM OID_TBL WHERE f1 <> 1234;
SELECT * FROM OID_TBL WHERE f1 = '1234';

INSERT INTO OID_TBL(f1) VALUES (' ');
SELECT * FROM OID_TBL WHERE f1 = 1234;
SELECT * FROM OID_TBL WHERE f1 <> 1234;
SELECT * FROM OID_TBL WHERE f1 = '1234';

Actual Results:

builtin opt gdk_dbpath = /ufs/dinther/MonetDB201407/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.17 "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

Bulk operator required for str.stringleft
Bulk operator required for str.stringleft
mserver5: gdk_select.c:622: BAT_scanselect: Assertion `b->T->type != 6 || equi || b->T->nonil' failed.
./start_mserver5.sh: line 3: 4197 Aborted ./MonetDB201407/bin/mserver5 -d10

Expected Results:

no crash

The "INSERT INTO OID_TBL(f1) VALUES (' ');" creates a nil value.
The nil is causing the crash during the queries.

Comment 19911

Date: 2014-07-18 12:18:21 +0200
From: MonetDB Mercurial Repository <>

Changeset 16629eb81fbc 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=16629eb81fbc

Changeset description:

Fixed assertion.
This fixes bug #3514.

Comment 19912

Date: 2014-07-18 12:21:23 +0200
From: MonetDB Mercurial Repository <>

Changeset 688c75ff08c2 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=688c75ff08c2

Changeset description:

Added test for bug #3514.