You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
INSERT INTO tab0 VALUES (97,1,99),(15,81,47),(87,21,10);
SELECT * FROM tab0 cor0 WHERE ( col1 ) IN ( + 57, + col1 / - col2 );
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=0x7fffb4147130, left=0x7fffb414d5a0, right=0x7fffb414db80, grp=0x0, ext=0x0, cnt=0x0, sel=0x0) at rel_bin.c:576
5 0x00007fffe8359e17 in rel2bin_project (be=0x7fffb4002b60, rel=0x7fffb41471c0, refs=0x7fffb414b840, topn=0x0) at rel_bin.c:2481
6 0x00007fffe836596a in subrel_bin (be=0x7fffb4002b60, rel=0x7fffb41471c0, refs=0x7fffb414b840) at rel_bin.c:5053
7 0x00007fffe8359d44 in rel2bin_project (be=0x7fffb4002b60, rel=0x7fffb4149b70, refs=0x7fffb414b840, topn=0x0) at rel_bin.c:2469
8 0x00007fffe836596a in subrel_bin (be=0x7fffb4002b60, rel=0x7fffb4149b70, refs=0x7fffb414b840) at rel_bin.c:5053
9 0x00007fffe8358506 in rel2bin_union (be=0x7fffb4002b60, rel=0x7fffb4148e10, refs=0x7fffb414b840) at rel_bin.c:2160
10 0x00007fffe83658de in subrel_bin (be=0x7fffb4002b60, rel=0x7fffb4148e10, refs=0x7fffb414b840) at rel_bin.c:5041
11 0x00007fffe8357537 in rel2bin_semijoin (be=0x7fffb4002b60, rel=0x7fffb4146160, refs=0x7fffb414b840) at rel_bin.c:1939
12 0x00007fffe83658b0 in subrel_bin (be=0x7fffb4002b60, rel=0x7fffb4146160, refs=0x7fffb414b840) at rel_bin.c:5037
13 0x00007fffe8359d44 in rel2bin_project (be=0x7fffb4002b60, rel=0x7fffb4146200, refs=0x7fffb414b840, topn=0x0) at rel_bin.c:2469
14 0x00007fffe836596a in subrel_bin (be=0x7fffb4002b60, rel=0x7fffb4146200, refs=0x7fffb414b840) at rel_bin.c:5053
15 0x00007fffe8365c52 in _subrel_bin (be=0x7fffb4002b60, rel=0x7fffb4146200, refs=0x7fffb414b840) at rel_bin.c:5115
16 0x00007fffe8365d6a in output_rel_bin (be=0x7fffb4002b60, rel=0x7fffb4146200) at rel_bin.c:5138
17 0x00007fffe8382471 in sql_relation2stmt (be=0x7fffb4002b60, r=0x7fffb4146200) at sql_gencode.c:532
18 0x00007fffe8382664 in backend_dumpstmt (be=0x7fffb4002b60, mb=0x7fffb40e8a80, r=0x7fffb4146200, top=1, add_end=1, query=0x7fffb41398a0 "select * from tab0 cor0 where ( col1 ) in ( + 57, + col1 / - col2 );")
at sql_gencode.c:572
19 0x00007fffe8382edc in backend_dumpproc (be=0x7fffb4002b60, c=0x7fffe970d368, cq=0x7fffb411d5d0, r=0x7fffb4146200) at sql_gencode.c:702
20 0x00007fffe8344f71 in SQLparser (c=0x7fffe970d368) at sql_scenario.c:1233
21 0x00007ffff7a0d039 in runPhase (c=0x7fffe970d368, phase=1) at mal_scenario.c:510
22 0x00007ffff7a0d142 in runScenarioBody (c=0x7fffe970d368, once=0) at mal_scenario.c:532
23 0x00007ffff7a0d3fb in runScenario (c=0x7fffe970d368, once=0) at mal_scenario.c:569
24 0x00007ffff7a0f336 in MSserveClient (dummy=0x7fffe970d368) at mal_session.c:514
25 0x00007ffff7a0ee85 in MSscheduleClient (command=0x7fffb4000b30 "0", challenge=0x7fffcb392d9b "9VJwBVfN", fin=0x17f9200, fout=0x7fffc4002d90, protocol=PROTOCOL_9, blocksize=8190, compute_column_widths=0)
at mal_session.c:397
26 0x00007ffff7aaf07e in doChallenge (data=0x17f9210) at mal_mapi.c:288
27 0x00007ffff7694a72 in thread_starter (arg=0x7fffc4004e80) at gdk_system.c:476
28 0x00007ffff4af961b in start_thread (arg=0x7fffcb393700) at pthread_create.c:465
29 0x00007ffff482698f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
Date: 2018-02-19 10:27:47 +0100
From: @PedroTadim
To: SQL devs <>
Version: -- development
CC: @njnes
Last updated: 2018-03-29 15:39:10 +0200
Comment 26219
Date: 2018-02-19 10:27:47 +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:
Mserver5 crashes while compiling a SELECT query with IN operator.
Reproducible: Always
Steps to Reproduce:
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=0x7fffb4147130, left=0x7fffb414d5a0, right=0x7fffb414db80, grp=0x0, ext=0x0, cnt=0x0, sel=0x0) at rel_bin.c:576
5 0x00007fffe8359e17 in rel2bin_project (be=0x7fffb4002b60, rel=0x7fffb41471c0, refs=0x7fffb414b840, topn=0x0) at rel_bin.c:2481
6 0x00007fffe836596a in subrel_bin (be=0x7fffb4002b60, rel=0x7fffb41471c0, refs=0x7fffb414b840) at rel_bin.c:5053
7 0x00007fffe8359d44 in rel2bin_project (be=0x7fffb4002b60, rel=0x7fffb4149b70, refs=0x7fffb414b840, topn=0x0) at rel_bin.c:2469
8 0x00007fffe836596a in subrel_bin (be=0x7fffb4002b60, rel=0x7fffb4149b70, refs=0x7fffb414b840) at rel_bin.c:5053
9 0x00007fffe8358506 in rel2bin_union (be=0x7fffb4002b60, rel=0x7fffb4148e10, refs=0x7fffb414b840) at rel_bin.c:2160
10 0x00007fffe83658de in subrel_bin (be=0x7fffb4002b60, rel=0x7fffb4148e10, refs=0x7fffb414b840) at rel_bin.c:5041
11 0x00007fffe8357537 in rel2bin_semijoin (be=0x7fffb4002b60, rel=0x7fffb4146160, refs=0x7fffb414b840) at rel_bin.c:1939
12 0x00007fffe83658b0 in subrel_bin (be=0x7fffb4002b60, rel=0x7fffb4146160, refs=0x7fffb414b840) at rel_bin.c:5037
13 0x00007fffe8359d44 in rel2bin_project (be=0x7fffb4002b60, rel=0x7fffb4146200, refs=0x7fffb414b840, topn=0x0) at rel_bin.c:2469
14 0x00007fffe836596a in subrel_bin (be=0x7fffb4002b60, rel=0x7fffb4146200, refs=0x7fffb414b840) at rel_bin.c:5053
15 0x00007fffe8365c52 in _subrel_bin (be=0x7fffb4002b60, rel=0x7fffb4146200, refs=0x7fffb414b840) at rel_bin.c:5115
16 0x00007fffe8365d6a in output_rel_bin (be=0x7fffb4002b60, rel=0x7fffb4146200) at rel_bin.c:5138
17 0x00007fffe8382471 in sql_relation2stmt (be=0x7fffb4002b60, r=0x7fffb4146200) at sql_gencode.c:532
18 0x00007fffe8382664 in backend_dumpstmt (be=0x7fffb4002b60, mb=0x7fffb40e8a80, r=0x7fffb4146200, top=1, add_end=1, query=0x7fffb41398a0 "select * from tab0 cor0 where ( col1 ) in ( + 57, + col1 / - col2 );")
at sql_gencode.c:572
19 0x00007fffe8382edc in backend_dumpproc (be=0x7fffb4002b60, c=0x7fffe970d368, cq=0x7fffb411d5d0, r=0x7fffb4146200) at sql_gencode.c:702
20 0x00007fffe8344f71 in SQLparser (c=0x7fffe970d368) at sql_scenario.c:1233
21 0x00007ffff7a0d039 in runPhase (c=0x7fffe970d368, phase=1) at mal_scenario.c:510
22 0x00007ffff7a0d142 in runScenarioBody (c=0x7fffe970d368, once=0) at mal_scenario.c:532
23 0x00007ffff7a0d3fb in runScenario (c=0x7fffe970d368, once=0) at mal_scenario.c:569
24 0x00007ffff7a0f336 in MSserveClient (dummy=0x7fffe970d368) at mal_session.c:514
25 0x00007ffff7a0ee85 in MSscheduleClient (command=0x7fffb4000b30 "0", challenge=0x7fffcb392d9b "9VJwBVfN", fin=0x17f9200, fout=0x7fffc4002d90, protocol=PROTOCOL_9, blocksize=8190, compute_column_widths=0)
at mal_session.c:397
26 0x00007ffff7aaf07e in doChallenge (data=0x17f9210) at mal_mapi.c:288
27 0x00007ffff7694a72 in thread_starter (arg=0x7fffc4004e80) at gdk_system.c:476
28 0x00007ffff4af961b in start_thread (arg=0x7fffcb393700) at pthread_create.c:465
29 0x00007ffff482698f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
Comment 26223
Date: 2018-02-19 10:48:03 +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:
Comment 26239
Date: 2018-03-01 19:35:56 +0100
From: @njnes
resolved after fixes for bug #6529
Comment 26306
Date: 2018-03-29 15:39:10 +0200
From: @sjoerdmullender
The Mar2018 version has been released.
The text was updated successfully, but these errors were encountered: