Sqlitelogictest crash in a IN query (8th)

[monetdb-team]

Date: 2017-05-22 18:50:11 +0200
From: @PedroTadim
To: SQL devs <>
Version: -- development
CC: @njnes

Last updated: 2017-07-17 16:07:35 +0200

Comment 25346

Date: 2017-05-22 18:50:11 +0200
From: @PedroTadim

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

The mserver gets a SIGABRT while performing the SELECT query described bellow. This happened in the latest changeset of Jul2017 branch.

Reproducible: Always

Steps to Reproduce:

1. CREATE TABLE tab0(pk INTEGER PRIMARY KEY, col0 INTEGER, col1 FLOAT, col2 TEXT, col3 INTEGER, col4 FLOAT, col5 TEXT);
2. SELECT col2 FROM tab0 AS cor0 WHERE + col4 NOT IN ( + 0 + + col1 );

Actual Results:

The server gets a SIGABRT while performing the query.

Expected Results:

An empty result set.

Assertion error:

mserver5: rel_bin.c:677: exp_bin: Assertion `0' failed.

Backtrace:

0 0x00007ffff4b6591f in raise () from /lib64/libc.so.6
1 0x00007ffff4b6751a in abort () from /lib64/libc.so.6
2 0x00007ffff4b5dda7 in __assert_fail_base () from /lib64/libc.so.6
3 0x00007ffff4b5de52 in __assert_fail () from /lib64/libc.so.6
4 0x00007fffe8d0fd84 in exp_bin (be=0x7fffb00cb0c0, e=0x7fffb00e3240, left=0x7fffb00e67f0, right=0x7fffb00e6a70, grp=0x0, ext=0x0, cnt=0x0, sel=0x0) at rel_bin.c:677
5 0x00007fffe8d15567 in rel2bin_semijoin (be=0x7fffb00cb0c0, rel=0x7fffb00e32d0, refs=0x7fffb00e58d0) at rel_bin.c:1925
6 0x00007fffe8d2214e in subrel_bin (be=0x7fffb00cb0c0, rel=0x7fffb00e32d0, refs=0x7fffb00e58d0) at rel_bin.c:4773
7 0x00007fffe8d17ac1 in rel2bin_project (be=0x7fffb00cb0c0, rel=0x7fffb00e38b0, refs=0x7fffb00e58d0, topn=0x0) at rel_bin.c:2418
8 0x00007fffe8d22208 in subrel_bin (be=0x7fffb00cb0c0, rel=0x7fffb00e38b0, refs=0x7fffb00e58d0) at rel_bin.c:4789
9 0x00007fffe8d224ff in output_rel_bin (be=0x7fffb00cb0c0, rel=0x7fffb00e38b0) at rel_bin.c:4854
10 0x00007fffe8d3c02e in sql_relation2stmt (be=0x7fffb00cb0c0, r=0x7fffb00e38b0) at sql_gencode.c:472
11 0x00007fffe8d3c38d in backend_dumpstmt (be=0x7fffb00cb0c0, mb=0x7fffb00cb680, r=0x7fffb00e38b0, top=1, add_end=0, query=0x7fffb010cb60 "select col2 from tab0 as cor0 where + col4 not in ( + 0 + + col1 );")
at sql_gencode.c:513
12 0x00007fffe8d02f83 in SQLparser (c=0x7fffea3cc338) at sql_scenario.c:1119
13 0x00007ffff7a1aab7 in runPhase (c=0x7fffea3cc338, phase=1) at mal_scenario.c:517
14 0x00007ffff7a1abfb in runScenarioBody (c=0x7fffea3cc338) at mal_scenario.c:550
15 0x00007ffff7a1ad9e in runScenario (c=0x7fffea3cc338) at mal_scenario.c:579
16 0x00007ffff7a1c844 in MSserveClient (dummy=0x7fffea3cc338) at mal_session.c:462
17 0x00007ffff7a1c334 in MSscheduleClient (command=0x7fffb00008d0 "0", challenge=0x7fffc54f5df0 "HEbVkmmQg", fin=0x7fffb0002990, fout=0x7fffbc002b70, protocol=PROTOCOL_9, blocksize=8190,
compute_column_widths=0) at mal_session.c:353
18 0x00007ffff7abd5b4 in doChallenge (data=0x7fffbc0008d0) at mal_mapi.c:269
19 0x00007ffff76a242b in thread_starter (arg=0x7fffbc004c60) at gdk_system.c:485
20 0x00007ffff4efd6ca in start_thread () from /lib64/libpthread.so.0
21 0x00007ffff4c37f7f in clone () from /lib64/libc.so.6

Comment 25366

Date: 2017-05-31 17:34:18 +0200
From: @njnes

fixed, the simplify math optimizer failed to pass a column alias

Comment 25367

Date: 2017-05-31 17:34:49 +0200
From: MonetDB Mercurial Repository <>

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

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=42e07c317685

Changeset description:

fixes for bug #6324