Date: 2017-06-06 10:29:59 +0200
From: @PedroTadim
To: SQL devs <>
Version: -- development
CC: @njnes

Last updated: 2017-07-17 16:07:18 +0200

Comment 25372

Date: 2017-06-06 10:29:59 +0200
From: @PedroTadim

User-Agent: Mozilla/5.0 (X11; Fedora; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.86 Safari/537.36
Build Identifier:

The mserver crashes after executing two SELECT queries consecutively. The first one throws a MAL exception. Then after executing the second one, the server crashes.

Reproducible: Always

Steps to Reproduce:

1. CREATE TABLE tab0(col0 INTEGER, col1 INTEGER, col2 INTEGER);
2. SELECT DISTINCT col1 * + + col1 + + col2 * 0 / + - CAST ( + - col0 AS INTEGER ) AS col1 FROM tab0 cor0;
3. SELECT ALL + 93 + col0 FROM tab0 AS cor0;

Actual Results:

During the first query, the following error exception is thrown:
TypeException:user.main[19]:'bat.append' undefined in: bat.append(X_24937:bat[:lng],X_24943:bte);

During the second one, the server gets a SIGSEV.

Expected Results:

A empty result set for both SELECT queries.

While running the first SELECT query the following warning is thrown

WARNING To speedup calc./ a bulk operator implementation is needed
X_455:bat[:lng] := mal.multiplex("calc":str,"/":str,0:bte,X_454:bat[:int]);

The bt of the SIGSEV:

0 0x00007ffff4c0e92a in __memset_avx2_erms () from /lib64/libc.so.6
1 0x00007ffff75e8b87 in GDKfree (blk=0x7fffb010fa60) at gdk_utils.c:1745
2 0x00007ffff797c070 in freeInstruction (p=0x7fffb010fa60) at mal_instruction.c:482
3 0x00007ffff79a9946 in MSresetInstructions (mb=0x7fffb00cf2a0, start=1) at mal_session.c:372
4 0x00007fffe8c958c1 in SQLengineIntern (c=0x7fffea35b328, be=0x7fffb00c1b00) at sql_execute.c:717
5 0x00007fffe8c929ea in SQLengine (c=0x7fffea35b328) at sql_scenario.c:1192
6 0x00007ffff79a80b8 in runPhase (c=0x7fffea35b328, phase=4) at mal_scenario.c:517
7 0x00007ffff79a8291 in runScenarioBody (c=0x7fffea35b328) at mal_scenario.c:559
8 0x00007ffff79a839f in runScenario (c=0x7fffea35b328) at mal_scenario.c:579
9 0x00007ffff79a9dd6 in MSserveClient (dummy=0x7fffea35b328) at mal_session.c:448
10 0x00007ffff79a98db in MSscheduleClient (command=0x7fffb00008d0 "0", challenge=0x7fffc46cedf0 "VKaSG5wf", fin=0x7fffb0002980, fout=0x7fffbc002b60) at mal_session.c:339
11 0x00007ffff7a49d19 in doChallenge (data=0x7fffbc0008d0) at mal_mapi.c:188
12 0x00007ffff762d0f1 in thread_starter (arg=0x7fffbc004c50) at gdk_system.c:485
13 0x00007ffff4e8c6ca in start_thread () from /lib64/libpthread.so.0
14 0x00007ffff4bc6f7f in clone () from /lib64/libc.so.6

Comment 25391

Date: 2017-06-22 14:29:21 +0200
From: MonetDB Mercurial Repository <>

Changeset 3e038283a86f 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=3e038283a86f

Changeset description:

Add test for bug #6332

Comment 25395

Date: 2017-06-28 10:12:32 +0200
From: @njnes

fixed bug in optimizer