Sqlitelogictest: Case statement subquery missing

[monetdb-team]

Date: 2018-01-25 11:16:26 +0100
From: @PedroTadim
To: SQL devs <>
Version: -- development
CC: @njnes

Last updated: 2018-02-12 16:12:08 +0100

Comment 26117

Date: 2018-01-25 11:16:26 +0100
From: @PedroTadim

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

The following select query with a case gets a compilation error.

Reproducible: Always

Steps to Reproduce:

1. SELECT CASE WHEN 18 IN ( AVG ( + 12 ) + - + ( - 29 ) + - SUM ( + + 53 ) * - ( 73 ) ) THEN NULL WHEN ( - COUNT ( * ) * - SUM ( DISTINCT 80 ) ) IS NOT NULL THEN 15 END + CASE 27 WHEN - 68 * + CAST ( COALESCE ( 42, + 57 * 20 ) AS INTEGER ) THEN + 11 * 11 + - CASE - 16 + 25 WHEN 37 + 24 THEN 51 + 41 END / 4 END * + 0 AS col1;

Actual Results:

The error:
SELECT: subquery result missing

Expected Results:

A single NULL value.

Comment 26123

Date: 2018-01-25 13:34:50 +0100
From: MonetDB Mercurial Repository <>

Changeset 32dc8a911410 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=32dc8a911410

Changeset description:

Added tests for bugs 6522 and 6523

Comment 26134

Date: 2018-01-29 06:45:29 +0100
From: MonetDB Mercurial Repository <>

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

Changeset description:

handle multiple aggregates in an in expression in the selection
fixes bug #6523

Comment 26135

Date: 2018-01-29 06:45:46 +0100
From: @njnes

fixed

Comment 26165

Date: 2018-02-05 10:00:34 +0100
From: MonetDB Mercurial Repository <>

Changeset fa7d796dadb4 made by Sjoerd Mullender sjoerd@acm.org in the MonetDB repo, refers to this bug.

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

Changeset description:

Add test for bug #6523.