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 error message in group by with coalesce #6608

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

Sqlitelogictest error message in group by with coalesce #6608

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-05-24 09:43:20 +0200
From: @PedroTadim
To: SQL devs <>
Version: 11.29.7 (Mar2018-SP1)
CC: @njnes

Last updated: 2019-04-30 12:36:04 +0200

Comment 26466

Date: 2018-05-24 09:43:20 +0200
From: @PedroTadim

User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.117 Safari/537.36
Build Identifier:

When using a COALESCE function call in a non-aggregated column in a aggregation query, MonetDB generates an error message difficult to understand. It should generate a more user friendly message like: cannot use non GROUP BY column '...' in query results without an aggregate function.

Reproducible: Always

Steps to Reproduce:

  1. CREATE TABLE tab0(col0 INTEGER, col1 INTEGER, col2 INTEGER);
  2. SELECT DISTINCT - COALESCE ( - 86, + cor0.col1, cor0.col1, - cor0.col0 ) AS col2 FROM tab0 AS cor0 GROUP BY cor0.col2, cor0.col0;

Actual Results:

The error message:
SELECT: no such aggregate 'sql_neg'

Expected Results:

The error message:
cannot use non GROUP BY column 'cor0.col1' in query results without an aggregate function.

Comment 26467

Date: 2018-05-24 09:49:07 +0200
From: MonetDB Mercurial Repository <>

Changeset 232e9b446772 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=232e9b446772

Changeset description:

Added test for Bug #6608

Comment 26782

Date: 2019-01-09 11:49:51 +0100
From: MonetDB Mercurial Repository <>

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

Changeset description:

We will approve bug #6608 error messages (same issue as in bug #3340).
@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