Sqlitelogictest crash in aggregation query

[monetdb-team]

Date: 2017-09-28 11:08:37 +0200
From: @PedroTadim
To: SQL devs <>
Version: -- development
CC: @njnes

Last updated: 2017-10-26 14:01:26 +0200

Comment 25671

Date: 2017-09-28 11:08:37 +0200
From: @PedroTadim

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

Mserver5 receives a SIGSEGV while compiling a sqlitelogictest aggregation query.

Reproducible: Always

Steps to Reproduce:

1. CREATE TABLE tab0 (col0 INTEGER, col1 INTEGER, col2 INTEGER);
2. SELECT DISTINCT + 38 AS col2 FROM tab0 AS cor0 WHERE NOT NULL IS NOT NULL OR NULL IN ( + col1, col0, - 97, + col2 ) GROUP BY col1;

Actual Results:

Mserver5 receives a SIGSEGV while compiling the query in a exp_name function call.

Expected Results:

An empty result set.

GDB information:

Thread 7 "mserver5" received signal SIGSEGV, Segmentation fault.
0x00007fffe8b0992c in exp_name (e=0x0) at rel_exp.c:696
696 if (e->name)

Backtrace:

0 0x00007fffe8b0992c in exp_name (e=0x0) at rel_exp.c:696
1 0x00007fffe8ae5d5e in rel_logical_exp (sql=0x7fffb800ab40, rel=0x7fffb80726a0, sc=0x7fffb8070f50, f=1) at rel_select.c:2633
2 0x00007fffe8ae4639 in rel_logical_exp (sql=0x7fffb800ab40, rel=0x7fffb80711e0, sc=0x7fffb8070fd0, f=1) at rel_select.c:2370
3 0x00007fffe8af09de in rel_select_exp (sql=0x7fffb800ab40, rel=0x7fffb80711e0, sn=0x7fffb8071160, ek=...) at rel_select.c:4792
4 0x00007fffe8af1cc6 in rel_query (sql=0x7fffb800ab40, rel=0x0, sq=0x7fffb8071160, toplevel=1, ek=..., apply=8) at rel_select.c:5088
5 0x00007fffe8af35a6 in rel_subquery (sql=0x7fffb800ab40, rel=0x0, sq=0x7fffb8071160, ek=..., apply=8) at rel_select.c:5453
6 0x00007fffe8af36cd in rel_selects (sql=0x7fffb800ab40, s=0x7fffb8071160) at rel_select.c:5474
7 0x00007fffe8ad950f in rel_semantic (sql=0x7fffb800ab40, s=0x7fffb8071160) at rel_semantic.c:225
8 0x00007fffe8a1ab09 in sql_symbol2relation (c=0x7fffb800ab40, sym=0x7fffb8071160) at sql.c:117
9 0x00007fffe8a39940 in SQLparser (c=0x7fffea11f338) at sql_scenario.c:1129
10 0x00007ffff7a15768 in runPhase (c=0x7fffea11f338, phase=1) at mal_scenario.c:506
11 0x00007ffff7a158ac in runScenarioBody (c=0x7fffea11f338) at mal_scenario.c:539
12 0x00007ffff7a15a4f in runScenario (c=0x7fffea11f338) at mal_scenario.c:568
13 0x00007ffff7a17541 in MSserveClient (dummy=0x7fffea11f338) at mal_session.c:467
14 0x00007ffff7a17031 in MSscheduleClient (command=0x7fffb80008d0 "0", challenge=0x7fffcd398deb "STelO9tk0WD", fin=0x7fffb80028f0, fout=0x7fffc4002b70, protocol=PROTOCOL_9, blocksize=8190,
compute_column_widths=0) at mal_session.c:358
15 0x00007ffff7aba460 in doChallenge (data=0x7fffc40008d0) at mal_mapi.c:273
16 0x00007ffff769180c in thread_starter (arg=0x7fffc4004c60) at gdk_system.c:485
17 0x00007ffff4ca536d in start_thread () from /lib64/libpthread.so.0
18 0x00007ffff49ddbbf in clone () from /lib64/libc.so.6

Comment 25672

Date: 2017-09-28 11:17:22 +0200
From: MonetDB Mercurial Repository <>

Changeset 3a21d4ec5b84 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=3a21d4ec5b84

Changeset description:

Added test for bug #6411

Comment 25682

Date: 2017-10-07 14:08:31 +0200
From: @njnes

fixed crash, reimplemented large part of the in handling.

Comment 25689

Date: 2017-10-11 16:35:55 +0200
From: MonetDB Mercurial Repository <>

Changeset b7681c154e83 made by Niels Nes niels@cwi.nl in the MonetDB repo, refers to this bug.

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

Changeset description:

reimplemented IN/NOT IN. Fixed bug #6411