Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Duplicate expressions not eliminated with long CASE statement #6697

Closed
monetdb-team opened this issue Nov 30, 2020 · 0 comments
Closed

Duplicate expressions not eliminated with long CASE statement #6697

monetdb-team opened this issue Nov 30, 2020 · 0 comments

Comments

@monetdb-team
Copy link

@monetdb-team monetdb-team commented Nov 30, 2020

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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
1 participant