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 (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.
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:
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:
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:
The text was updated successfully, but these errors were encountered: