Date: 2018-02-15 16:27:47 +0100
From: Martin van Dinther <<martin.van.dinther>>
To: SQL devs <>
Version: 11.27.13 (Jul2017-SP4)
CC: @njnes

Last updated: 2018-03-29 15:39:00 +0200

Comment 26201

Date: 2018-02-15 16:27:47 +0100
From: Martin van Dinther <<martin.van.dinther>>

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

SQL query: select count(*) from sys.commented_function_signatures;
produces assertion failure:
mserver5: ../../../../dev/sql/backends/monet5/rel_bin.c:575: exp_bin: Assertion `s' failed.
Occurs on Mar2018 release, but potentially also on Jul2017 release.

Note the view sys.commented_function_signatures is introduced in Mar2018 release, see https://dev.monetdb.org/hg/MonetDB/file/Mar2018/sql/scripts/97_comments.sql

Reproducible: Always

Steps to Reproduce:

1. The view sys.commented_function_signatures is introduced in March2018 release
2. so compile March2018 release with assertions enabled
3. run query: select count(*) from sys.commented_function_signatures;

Actual Results:

bash-4.4$ ./start_INSTALL_mserver5.sh
builtin opt gdk_dbpath = /export/scratch1/dinther/INSTALL/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 embedded_r = true
cmdline opt embedded_py = true
cmdline opt mapi_port = 41000
cmdline opt gdk_debug = 10
MonetDB 5 server v11.29.0
This is an unreleased version
Serving database 'demo', using 4 threads
Compiled for x86_64-unknown-linux-gnu/64bit with 128bit integers
Found 31.307 GiB available main-memory.
Copyright (c) 1993 - July 2008 CWI.
Copyright (c) August 2008 - 2018 MonetDB B.V., all rights reserved
Visit https://www.monetdb.org/ for further information
Listening for connection requests on mapi:monetdb://127.0.0.1:41000/
MonetDB/GIS module loaded
MonetDB/SQL module loaded
MonetDB/Python2 module loaded
MonetDB/R module loaded

could not find L37.L37
f.id
L2.fid
mserver5: ../../../../dev/sql/backends/monet5/rel_bin.c:575: exp_bin: Assertion `s' failed.
./start_INSTALL_mserver5.sh: line 7: 3531 Aborted (core dumped) /export/scratch1/dinther/INSTALL/bin/mserver5 -d10 --set embedded_r=true --set embedded_py=true --set mapi_port=41000
bash-4.4$

Expected Results:

no assertion failure.
a normal count(*) result returned.

Comment 26205

Date: 2018-02-15 18:45:31 +0100
From: MonetDB Mercurial Repository <>

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

For complete details, see https//devmonetdborg/hg/MonetDB?cmd=changeset;node=d3b3b1e73871

Changeset description:

Add test for bug #6542

Comment 26297

Date: 2018-03-29 15:39:00 +0200
From: @sjoerdmullender

The Mar2018 version has been released.