Date: 2017-04-28 16:46:46 +0200
From: @PedroTadim
To: SQL devs <>
Version: 11.25.15 (Dec2016-SP3)
CC: @njnes

Last updated: 2017-06-12 15:14:39 +0200

Comment 25274

Date: 2017-04-28 16:46:46 +0200
From: @PedroTadim

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

The server gets a SIGABRT signal (assertion error).

Reproducible: Always

Steps to Reproduce:

1. CREATE TABLE tab1(col0 INTEGER, col1 INTEGER, col2 INTEGER);
2. CREATE TABLE tab2(col0 INTEGER, col1 INTEGER, col2 INTEGER);
3. SELECT ALL - COUNT ( * ) + - 12 * - COUNT ( * ) AS col2 FROM tab2, tab1 AS cor0;

Actual Results:

The server gets a SIGABRT signal.

Expected Results:

A result set with 0 value.

The backtrace:

0 0x00007ffff4afb91f in raise () from /lib64/libc.so.6
1 0x00007ffff4afd51a in abort () from /lib64/libc.so.6
2 0x00007ffff4af3da7 in __assert_fail_base () from /lib64/libc.so.6
3 0x00007ffff4af3e52 in __assert_fail () from /lib64/libc.so.6
4 0x00007fffe8cb1647 in rel2bin_project (sql=0x7fffb000d4b0, rel=0x7fffb010f910, refs=0x7fffb0113200, topn=0x0) at rel_bin.c:2433
5 0x00007fffe8cbbdbf in subrel_bin (sql=0x7fffb000d4b0, rel=0x7fffb010f910, refs=0x7fffb0113200) at rel_bin.c:4640
6 0x00007fffe8cbc0fe in output_rel_bin (sql=0x7fffb000d4b0, rel=0x7fffb010f910) at rel_bin.c:4708
7 0x00007fffe8c72d7f in sql_relation2stmt (c=0x7fffb000d4b0, r=0x7fffb010f910) at sql.c:141
8 0x00007fffe8c9832c in SQLparser (c=0x7fffea362328) at sql_scenario.c:1092
9 0x00007ffff79a7f0a in runPhase (c=0x7fffea362328, phase=1) at mal_scenario.c:517
10 0x00007ffff79a804e in runScenarioBody (c=0x7fffea362328) at mal_scenario.c:550
11 0x00007ffff79a81f1 in runScenario (c=0x7fffea362328) at mal_scenario.c:579
12 0x00007ffff79a9d37 in MSserveClient (dummy=0x7fffea362328) at mal_session.c:448
13 0x00007ffff79a97e1 in MSscheduleClient (command=0x7fffb00008d0 "0", challenge=0x7fffc49eddf0 "SeT4Bsaecx2", fin=0x7fffb0002980, fout=0x7fffbc002b60) at mal_session.c:339
14 0x00007ffff7a49858 in doChallenge (data=0x7fffbc0008d0) at mal_mapi.c:197
15 0x00007ffff7633bca in thread_starter (arg=0x7fffbc004c50) at gdk_system.c:485
16 0x00007ffff4e936ca in start_thread () from /lib64/libpthread.so.0
17 0x00007ffff4bcdf7f in clone () from /lib64/libc.so.6

Comment 25275

Date: 2017-04-28 16:51:46 +0200
From: @PedroTadim

The assertion error:

mserver5: rel_bin.c:2433: rel2bin_project: Assertion `0' failed.

Comment 25278

Date: 2017-04-30 23:29:59 +0200
From: MonetDB Mercurial Repository <>

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

Changeset description:

fixes for the bugs 6297, 6296, 6294, 6291 and 6291
problems were in various relational optimizers

Comment 25295

Date: 2017-05-11 15:10:11 +0200
From: MonetDB Mercurial Repository <>

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

Changeset description:

Add test for Bug #6297