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

Sqlitelogictest: Case statement subquery missing #6523

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

Sqlitelogictest: Case statement subquery missing #6523

monetdb-team opened this issue Nov 30, 2020 · 0 comments
Labels
bug Something isn't working minor SQL

Comments

@monetdb-team
Copy link

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.
@monetdb-team monetdb-team added bug Something isn't working minor SQL labels Nov 30, 2020
@sjoerdmullender sjoerdmullender added this to the Ancient Release milestone Feb 7, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working minor SQL
Projects
None yet
Development

No branches or pull requests

2 participants