Date: 2019-04-16 13:56:51 +0200
From: @yzchang
To: MonetDB5 devs <>
Version: 11.31.13 (Aug2018-SP2)
CC: @mlkersten, @yzchang

Last updated: 2020-11-13 18:48:19 +0100

Comment 26954

Date: 2019-04-16 13:56:51 +0200
From: @yzchang

User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_6) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/12.1 Safari/605.1.15
Build Identifier:

The attached query has 40+ conditions in its CASE statement. Its EXPLAIN output shows that from the 13th ifthenelse, the duplicate ">" operations are not eliminated.

Reproducible: Always

Steps to Reproduce:

1. run the attached query to get the EXPLAIN output

Comment 26955

Date: 2019-04-16 13:58:44 +0200
From: @yzchang

Created attachment 615
query with 40+ CASE conditions

Attached file: task.sql (text/plain, 7645 bytes)
Description: query with 40+ CASE conditions

Comment 26956

Date: 2019-04-16 14:06:59 +0200
From: MonetDB Mercurial Repository <>

Changeset e98be92db6cd made by Ying Zhang y.zhang@cwi.nl in the MonetDB repo, refers to this bug.

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

Changeset description:

Added test for Bug #6697
Stable output will be added later, because it's too long to be manually approved.

Comment 27185

Date: 2019-07-28 20:50:54 +0200
From: @mlkersten

The latest version of the commonterms optimizer finds them.

Comment 28269

Date: 2020-11-13 18:48:19 +0100
From: MonetDB Mercurial Repository <>

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

Changeset description:

Use traces instead of explain statements for duplicates-not-eliminated-long-CASE-stmt.Bug-6697 test