Date: 2018-02-19 10:15:31 +0100
From: @PedroTadim
To: SQL devs <>
Version: -- development
CC: @njnes

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

Comment 26218

Date: 2018-02-19 10:15:31 +0100
From: @PedroTadim

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

The query bellow crashes in MonetDB with an assertion error in rel_bin.c

Reproducible: Always

Steps to Reproduce:

1. CREATE TABLE tab0(col0 INTEGER, col1 INTEGER, col2 INTEGER);
2. INSERT INTO tab0 VALUES (97,1,99), (15,81,47), (87,21,10);
3. SELECT DISTINCT * FROM tab0 AS cor0 WHERE - 60 + ( + - col0 ) IN ( + - CAST ( 35 AS INTEGER ) * + ( - 3 ) * - 91 * + + 87, - col0 * + col2 * 18 );

Actual Results:

Assertion error in rel_bin.c

Expected Results:

Empty result set

The assertion error:
mserver5: rel_bin.c:576: exp_bin: Assertion `s' failed

Backtrace:

0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51
1 0x00007ffff4748381 in __GI_abort () at abort.c:79
2 0x00007ffff473e8fa in __assert_fail_base (fmt=0x7ffff48b9c28 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x7fffe84cbd58 "s", file=file@entry=0x7fffe84cbce8 "rel_bin.c",
line=line@entry=576, function=function@entry=0x7fffe84cc518 <PRETTY_FUNCTION.18615> "exp_bin") at assert.c:92
3 0x00007ffff473e972 in __GI___assert_fail (assertion=0x7fffe84cbd58 "s", file=0x7fffe84cbce8 "rel_bin.c", line=576, function=0x7fffe84cc518 <PRETTY_FUNCTION.18615> "exp_bin") at assert.c:101
4 0x00007fffe8350b22 in exp_bin (be=0x7fffb4002b60, e=0x7fffb41f6b50, left=0x7fffb41fed20, right=0x7fffb41ff450, grp=0x0, ext=0x0, cnt=0x0, sel=0x0) at rel_bin.c:576
5 0x00007fffe8359e17 in rel2bin_project (be=0x7fffb4002b60, rel=0x7fffb41f6be0, refs=0x7fffb41fbfe0, topn=0x0) at rel_bin.c:2481
6 0x00007fffe836596a in subrel_bin (be=0x7fffb4002b60, rel=0x7fffb41f6be0, refs=0x7fffb41fbfe0) at rel_bin.c:5053
7 0x00007fffe8359d44 in rel2bin_project (be=0x7fffb4002b60, rel=0x7fffb41fa040, refs=0x7fffb41fbfe0, topn=0x0) at rel_bin.c:2469
8 0x00007fffe836596a in subrel_bin (be=0x7fffb4002b60, rel=0x7fffb41fa040, refs=0x7fffb41fbfe0) at rel_bin.c:5053
9 0x00007fffe8358506 in rel2bin_union (be=0x7fffb4002b60, rel=0x7fffb41f9030, refs=0x7fffb41fbfe0) at rel_bin.c:2160
10 0x00007fffe83658de in subrel_bin (be=0x7fffb4002b60, rel=0x7fffb41f9030, refs=0x7fffb41fbfe0) at rel_bin.c:5041
11 0x00007fffe8357537 in rel2bin_semijoin (be=0x7fffb4002b60, rel=0x7fffb41f51c0, refs=0x7fffb41fbfe0) at rel_bin.c:1939
12 0x00007fffe83658b0 in subrel_bin (be=0x7fffb4002b60, rel=0x7fffb41f51c0, refs=0x7fffb41fbfe0) at rel_bin.c:5037
13 0x00007fffe8359d44 in rel2bin_project (be=0x7fffb4002b60, rel=0x7fffb41f7ac0, refs=0x7fffb41fbfe0, topn=0x0) at rel_bin.c:2469
14 0x00007fffe836596a in subrel_bin (be=0x7fffb4002b60, rel=0x7fffb41f7ac0, refs=0x7fffb41fbfe0) at rel_bin.c:5053
15 0x00007fffe835acd2 in rel2bin_groupby (be=0x7fffb4002b60, rel=0x7fffb41f5260, refs=0x7fffb41fbfe0) at rel_bin.c:2686
16 0x00007fffe83659c6 in subrel_bin (be=0x7fffb4002b60, rel=0x7fffb41f5260, refs=0x7fffb41fbfe0) at rel_bin.c:5061
17 0x00007fffe8365c52 in _subrel_bin (be=0x7fffb4002b60, rel=0x7fffb41f5260, refs=0x7fffb41fbfe0) at rel_bin.c:5115
18 0x00007fffe8365d6a in output_rel_bin (be=0x7fffb4002b60, rel=0x7fffb41f5260) at rel_bin.c:5138
19 0x00007fffe8382471 in sql_relation2stmt (be=0x7fffb4002b60, r=0x7fffb41f5260) at sql_gencode.c:532
20 0x00007fffe8382664 in backend_dumpstmt (be=0x7fffb4002b60, mb=0x7fffb41ea7b0, r=0x7fffb41f5260, top=1, add_end=0,
query=0x7fffb423b3c0 "select distinct * from tab0 as cor0 where - 60 + ( + - col0 ) in ( + - cast ( 35 as integer ) * + ( - 3 ) * - 91 * + + 87, - col0 * + col2 * 18 );") at sql_gencode.c:572
21 0x00007fffe8344bd8 in SQLparser (c=0x7fffe970d368) at sql_scenario.c:1195
22 0x00007ffff7a0d039 in runPhase (c=0x7fffe970d368, phase=1) at mal_scenario.c:510
23 0x00007ffff7a0d142 in runScenarioBody (c=0x7fffe970d368, once=0) at mal_scenario.c:532
24 0x00007ffff7a0d3fb in runScenario (c=0x7fffe970d368, once=0) at mal_scenario.c:569
25 0x00007ffff7a0f336 in MSserveClient (dummy=0x7fffe970d368) at mal_session.c:514
26 0x00007ffff7a0ee85 in MSscheduleClient (command=0x7fffb4000b30 "0+", challenge=0x7fffcb392d9b "41Q48ySCa", fin=0x7fffc4000ca0, fout=0x7fffc4002d90, protocol=PROTOCOL_9, blocksize=8190,
compute_column_widths=0) at mal_session.c:397
27 0x00007ffff7aaf07e in doChallenge (data=0x7fffc4000cb0) at mal_mapi.c:288
28 0x00007ffff7694a72 in thread_starter (arg=0x7fffc4000ce0) at gdk_system.c:476
29 0x00007ffff4af961b in start_thread (arg=0x7fffcb393700) at pthread_create.c:465
30 0x00007ffff482698f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Comment 26220

Date: 2018-02-19 10:43:48 +0100
From: @PedroTadim

This crash only happens when I compile MonetDB without hugeint support.

Comment 26222

Date: 2018-02-19 10:48:02 +0100
From: MonetDB Mercurial Repository <>

Changeset e156ab0c6065 made by Pedro Ferreira pedro.ferreira@monetdbsolutions.com in the MonetDB repo, refers to this bug.

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

Changeset description:

Added tests for bugs 6545 and 6546

Comment 26238

Date: 2018-03-01 19:34:57 +0100
From: @njnes

resolved after fixes for bug #6529

Comment 26310

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

The Mar2018 version has been released.