What's the (SQL-)type of your column COLUMN_NAME?Which version of MonetDB are you using?Which version of the MonetDB ODBC driver are you using?Which compiler did you use to compile MonetDB on which OS?What did configure say about what the largest supported integer type is?
-------- Original message --------From: "Sharma, Sreejith" Date: 12/31/17 18:33 (GMT+01:00) To: users-list@monetdb.org Subject: RE: MonetDB header Datatype Question
All,
Here is the specifics of error –
typeODBC: SQL_UNKNOWN_TYPE mDataType: HG_NULL_VALUE(hgColumnType) precision: 0 scale: 0 nullable: true Column name: L6.
Regards,
Sreejith
From: Sharma, Sreejith
Sent: Sunday, December 31, 2017 11:21 AM
To: users-list@monetdb.org
Subject: MonetDB header Datatype Question
All,
I would like to know what is the MonetDB header datatype if no alias or column name provided? In my BI application, am getting an error while using SELECT SUM(DISTINCT COLUMN_NAME) FROM TABLE_NAME. I see it
works in 11.27.9 build when installed in CentOS. However, when i download the source tarball and recompile the code, this fox seems to be lost. Is there anywhere this can be identified? Or fixed?
Regards,
Sreejith
