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 (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.
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:
Comment 26955
Date: 2019-04-16 13:58:44 +0200
From: @yzchang
Created attachment 615
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:
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:
The text was updated successfully, but these errors were encountered: