Date: 2014-10-03 13:14:38 +0200
From: Martin van Dinther <<martin.van.dinther>>
To: SQL devs <>
Version: 11.17.21 (Jan2014-SP3)

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

Comment 20233

Date: 2014-10-03 13:14:38 +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:

Assertion failure in gdk_bat.c

Reproducible: Always

Steps to Reproduce:

1. start mserver5 (MonetDB 5 server v11.17.21 "Jan2014-SP3")
2. start mclient
3. execute SQL commands:
   CREATE TABLE FLOAT8_TBL(f1 double);
   INSERT INTO FLOAT8_TBL(f1) VALUES (' -34.84');
   select sign(f1) as sign_f1 from float8_tbl f;
   INSERT INTO FLOAT8_TBL(f1) VALUES ('1.2345678901234e+200');
   select sign(f1) as sign_f1 from float8_tbl f;

Actual Results:

bash-4.2$ ./start_mserver5.sh
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: gdk_bat.c:2855: BATassertHeadProps: Assertion `!b->H->revsorted || cmp >= 0' failed.
./start_mserver5.sh: line 4: 9843 Aborted ./MonetDB201408/bin/mserver5 -d10 --set mapi_port=49000
bash-4.2$

bash-4.2$ mclient -p 49000
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 FLOAT8_TBL(f1 double);
operation successful (59.434ms)
sql>INSERT INTO FLOAT8_TBL(f1) VALUES (' -34.84');
1 affected rows (2.739ms)
sql>select sign(f1) as sign_f1 from float8_tbl f;
+---------+
| sign_f1 |
+=========+
| -1 |
+---------+
1 tuple (1.067ms)
sql>INSERT INTO FLOAT8_TBL(f1) VALUES ('1.2345678901234e+200');
1 affected rows (2.325ms)
sql>select sign(f1) as sign_f1 from float8_tbl f;
sql>
bash-4.2$

Expected Results:

no assertion failure

Also reproducable in developers default branch (sources of 3 nov 2014):
gdk/gdk_bat.c:2902: BATassertHeadProps: Assertion `!b->H->revsorted || cmp >= 0' failed.

Comment 20234

Date: 2014-10-03 13:57:18 +0200
From: MonetDB Mercurial Repository <>

Changeset 771a0e3efdaa 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=771a0e3efdaa

Changeset description:

Typo.  This fixes bug #3594.

Comment 20239

Date: 2014-10-03 17:24:00 +0200
From: MonetDB Mercurial Repository <>

Changeset 23cf48780a55 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=23cf48780a55

Changeset description:

Improved float8.sql tests. Could not generate the float8.stable.* files due to Mtest.py aborted (see bug #3594 & 3596)

Comment 20377

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

Oct2014 has been released.