Automatic column naming for aggregation functions is inconsistent

Detail name	Value
Changelog Number	11357
Type	Bug
Status	Open
Affected Versions	Exasol 6.2.0, Exasol 7.0.0, Exasol 7.1.0, Exasol 8.0.0, Exasol 8.29.0, Exasol 2025.1.0, Exasol 2025.2.0

Description

The automatic column naming for aggregation functions is inconsistent.
When column names are created automatically with aggregation functions, most of the column names are consistently upper-case characters, but COUNT with a column as an argument is written using CamelCase.

Example SQL:

create or replace table t(a dec);
insert into t values 1;

select count(a),count(*),sum(a),avg(a)
from t;

Example Output:

Count(T.A)  COUNT(*)      SUM(T.A)    AVG(T.A)
1           1             1           1

Workaround

Prevent automatic column naming by using column aliases.

Fix

Automatic column naming for aggregation functions will be consistent.
A list of all aggregation functions can be found in the user documentation.
(see: https://docs.exasol.com/sql_references/functions/aggregatefunctions.htm)