Sqlitelogictest error message in group by with coalesce

[monetdb-team]

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).