You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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:
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
...
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:
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:
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:
Comment 26325
Date: 2018-03-29 15:39:25 +0200
From: @sjoerdmullender
The Mar2018 version has been released.
The text was updated successfully, but these errors were encountered: