Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Sqlitelogictest crash in IN query with division #6546

monetdb-team opened this issue Nov 30, 2020 · 0 comments

Sqlitelogictest crash in IN query with division #6546

monetdb-team opened this issue Nov 30, 2020 · 0 comments


Copy link

@monetdb-team monetdb-team commented Nov 30, 2020

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:

  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 * 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.

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 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 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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
1 participant