Date: 2017-04-28 16:32:47 +0200
From: @PedroTadim
To: SQL devs <>
Version: 11.25.15 (Dec2016-SP3)
CC: @njnes

Last updated: 2017-06-12 15:14:41 +0200

Comment 25272

Date: 2017-04-28 16:32:47 +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:

One more sqllitelogictest crash.

Reproducible: Always

Steps to Reproduce:

1. CREATE TABLE tab0(col0 INTEGER, col1 INTEGER, col2 INTEGER);
2. CREATE TABLE tab2(col0 INTEGER, col1 INTEGER, col2 INTEGER);
3. SELECT DISTINCT - COUNT ( DISTINCT 74 ) AS col1 FROM tab0 AS cor0 CROSS JOIN tab2 AS cor1;

Actual Results:

A result set with a -1 value.

Expected Results:

An empty result set.

0x00007fffe8d6c66f in rel_push_count_down (changes=0x7fffc49ed838, sql=0x7fffb000d4b0, rel=0x7fffb00f8010) at rel_optimizer.c:1652
1652 ((sql_exp *) rel->exps->h->data)->type == e_aggr &&

The backtrace:

0 0x00007fffe8d6c66f in rel_push_count_down (changes=0x7fffc49ed838, sql=0x7fffb000d4b0, rel=0x7fffb00f8010) at rel_optimizer.c:1652
1 0x00007fffe8d8b056 in rewrite_topdown (sql=0x7fffb000d4b0, rel=0x7fffb00f8010, rewriter=0x7fffe8d6c5ac <rel_push_count_down>, has_changes=0x7fffc49ed838) at rel_optimizer.c:8651
2 0x00007fffe8d8b189 in rewrite_topdown (sql=0x7fffb000d4b0, rel=0x7fffb00f79e0, rewriter=0x7fffe8d6c5ac <rel_push_count_down>, has_changes=0x7fffc49ed838) at rel_optimizer.c:8680
3 0x00007fffe8d8b189 in rewrite_topdown (sql=0x7fffb000d4b0, rel=0x7fffb00f6690, rewriter=0x7fffe8d6c5ac <rel_push_count_down>, has_changes=0x7fffc49ed838) at rel_optimizer.c:8680
4 0x00007fffe8d8b189 in rewrite_topdown (sql=0x7fffb000d4b0, rel=0x7fffb00f6810, rewriter=0x7fffe8d6c5ac <rel_push_count_down>, has_changes=0x7fffc49ed838) at rel_optimizer.c:8680
5 0x00007fffe8d8b7b6 in _rel_optimizer (sql=0x7fffb000d4b0, rel=0x7fffb00f6810, level=2) at rel_optimizer.c:8800
6 0x00007fffe8d8bbe7 in _rel_optimizer (sql=0x7fffb000d4b0, rel=0x7fffb00f6810, level=2) at rel_optimizer.c:8867
7 0x00007fffe8d8bbe7 in _rel_optimizer (sql=0x7fffb000d4b0, rel=0x7fffb00f6810, level=1) at rel_optimizer.c:8867
8 0x00007fffe8d8bc3a in rel_optimizer (sql=0x7fffb000d4b0, rel=0x7fffb00f6810) at rel_optimizer.c:8875
9 0x00007fffe8c72c94 in sql_symbol2relation (c=0x7fffb000d4b0, sym=0x7fffb00f5fb0) at sql.c:121
10 0x00007fffe8c9830c in SQLparser (c=0x7fffea362328) at sql_scenario.c:1091
11 0x00007ffff79a7f0a in runPhase (c=0x7fffea362328, phase=1) at mal_scenario.c:517
12 0x00007ffff79a804e in runScenarioBody (c=0x7fffea362328) at mal_scenario.c:550
13 0x00007ffff79a81f1 in runScenario (c=0x7fffea362328) at mal_scenario.c:579
14 0x00007ffff79a9d37 in MSserveClient (dummy=0x7fffea362328) at mal_session.c:448
15 0x00007ffff79a97e1 in MSscheduleClient (command=0x7fffb00008d0 "0", challenge=0x7fffc49eddf0 "14tudnr0Wn", fin=0x7fffb0002980, fout=0x7fffbc002b60) at mal_session.c:339
16 0x00007ffff7a49858 in doChallenge (data=0x7fffbc0008d0) at mal_mapi.c:197
17 0x00007ffff7633bca in thread_starter (arg=0x7fffbc004c50) at gdk_system.c:485
18 0x00007ffff4e936ca in start_thread () from /lib64/libpthread.so.0
19 0x00007ffff4bcdf7f in clone () from /lib64/libc.so.6

Comment 25273

Date: 2017-04-28 16:34:10 +0200
From: @PedroTadim

The actual result is a SIGSEV. The expected result is a -1.

Comment 25277

Date: 2017-04-30 23:29:57 +0200
From: MonetDB Mercurial Repository <>

Changeset e4578a201e15 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=e4578a201e15

Changeset description:

fixes for the bugs 6297, 6296, 6294, 6291 and 6291
problems were in various relational optimizers

Comment 25294

Date: 2017-05-11 15:01:12 +0200
From: MonetDB Mercurial Repository <>

Changeset e5b199766548 made by Martin van Dinther martin.van.dinther@monetdbsolutions.com in the MonetDB repo, refers to this bug.

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

Changeset description:

Add test for Bug #6296