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

7th sqllitelogictest crash :( #6297

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

7th sqllitelogictest crash :( #6297

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


Copy link

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

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/
1 0x00007ffff4afd51a in abort () from /lib64/
2 0x00007ffff4af3da7 in __assert_fail_base () from /lib64/
3 0x00007ffff4af3e52 in __assert_fail () from /lib64/
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/
17 0x00007ffff4bcdf7f in clone () from /lib64/

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