I see below issue is happening only if base column datatype is integer. All other types working fine.

From: Sharma, Sreejith
Sent: Saturday, January 06, 2018 8:24 PM
To: users-list@monetdb.org
Subject: MonetDB - Column Header Question

All,

Quick question –

For a specific scenario I would like to understand below -

If  we don’t specify column header in SQL or alias, how is MonetDB picks up the column header? And what is the datatype for it? I saw it’s hge (scalar type) is it so? Also, I would like to know where in source code it’s happening.

Example:

SELECT SUM(COLUMN_NAME) FROM TABLE_NAME;

------------------+

| L3                  |

------------------+

|123456678  |

------------------+

Regards,

Sreejith