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 #6545

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

Sqlitelogictest crash in IN query #6545

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

Comments

@monetdb-team
Copy link

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

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.

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

Successfully merging a pull request may close this issue.

None yet
1 participant