Date: 2018-03-14 13:13:54 +0100
From: @PedroTadim
To: SQL devs <>
Version: -- development
CC: @njnes

Last updated: 2018-03-29 15:39:25 +0200

Comment 26263

Date: 2018-03-14 13:13:54 +0100
From: @PedroTadim

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

Mserver gets a stack overflow in the rel_optimizer while optimizing the query bellow.

Reproducible: Always

Steps to Reproduce:

1. SELECT 50, CASE WHEN NOT - COUNT ( * ) IN ( - - 41 * + 92 * + + ( + + 10 ) + - MAX ( DISTINCT + 74 ), + 14, + 11 * + COUNT ( * ) * + ( - + CASE + 77 WHEN - 52 THEN + + 43 + + 71 + - AVG ( ALL + + 93 ) + 12 / - - COUNT ( * ) ELSE NULL END ), COUNT ( - 91 ) + + + 71 * + + CASE - + 53 WHEN - + 94 + - 39 - + - 10 + 13 + SUM ( DISTINCT - + 24 ) THEN NULL WHEN - AVG ( ALL 53 ) THEN 76 ELSE - 17 END ) THEN - AVG ( ALL - ( + 63 ) ) END * + 62 AS col0;

Actual Results:

Stack overflow in the rel_optimizer.

Expected Results:

A single result set with values 50, NULL

Backtrace:

0 0x00007fffe8468f10 in rel_reset_subquery (rel=0x7fffb0102a30) at rel_optimizer.c:9281
1 0x00007fffe8468f15 in rel_reset_subquery (rel=0x7fffb01025a0) at rel_optimizer.c:9281
2 0x00007fffe8468f15 in rel_reset_subquery (rel=0x7fffb0102a30) at rel_optimizer.c:9281
...

Comment 26267

Date: 2018-03-14 13:55:01 +0100
From: MonetDB Mercurial Repository <>

Changeset 55091706b910 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=55091706b910

Changeset description:

Added tests for bugs 6554, 6555 and 65556

Comment 26269

Date: 2018-03-14 16:28:16 +0100
From: MonetDB Mercurial Repository <>

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

Changeset description:

fixes for bugs 6554 and 6555

Comment 26325

Date: 2018-03-29 15:39:25 +0200
From: @sjoerdmullender

The Mar2018 version has been released.