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

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

Comment 26264

Date: 2018-03-14 13:22:47 +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:

MonetDB generates redundant columns in query stated bellow.

Reproducible: Always

Steps to Reproduce:

1. SELECT DISTINCT CASE WHEN + CASE + - COUNT ( * ) WHEN - 10 THEN NULL WHEN + - 23 - 53 THEN ( COUNT ( DISTINCT + ( + 21 ) ) ) * 72 + COALESCE ( + + 45, 9 ) WHEN - 40 + - 7 + - 1 THEN NULL END NOT IN ( + 14 + + 18 ) THEN NULL ELSE ( - - 46 ) END;

Actual Results:

This result set:
+------+------+------+------+------+
| L3 | L4 | L5 | L6 | L10 |
+======+======+======+======+======+
| 1 | 1 | 1 | 1 | 46 |
+------+------+------+------+------+

Expected Results:

This result set:
+------+
| L10 |
+======+
| 46 |
+------+

Comment 26268

Date: 2018-03-14 13:55:03 +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 26270

Date: 2018-03-14 16:28:18 +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 26299

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

The Mar2018 version has been released.