Thanks Stefan for your suggestion. I will try and let you know.
-----Original Message-----
From: users-list [mailto:users-list-bounces+sreejith.sharma=harman.com@monetdb.org] On Behalf Of Stefan Manegold
Sent: Thursday, January 18, 2018 12:03 AM
To: Communication channel for MonetDB users
All,
Here is a quick question. I have compiled “MonetDB v11.27.9 (Jul2017-SP2)” version of source code and while running below sample SQL am finding an issue. Could anyone help me to trace issue? Is this due to the compiler version?
Issue Details:
While using SUM() or any function without an alias the header datatype returned is showing as HUGEINT for base INTEGER column, where as it should have been BIGINT. This is causing a failure in my BI application as it’s having issues in identifying HUGEINT.
Below are the details.
Source Code Version : MonetDB v11.27.9 (Jul2017-SP2)
Linux OS Version : CentOS release 6.3 (Final)
C Compile Version : gcc version 4.4.7 20120313 (Red Hat 4.4.7-16) (GCC)
Also, I see below note in MonetDB documentation. Which version of GCC should be appropriate for compilation with __128 bit integer.
Note : HUGEINT is only available since the Jul2015 release and on platforms with a C-compiler that supports the __int128 or __int128_t data type (e.g., recent gcc, clang, & icc on Linux or MacOS X)
Sample Table DDL :
CREATE TABLE INT_VALID (COL_INT INTEGER, COL_BIGINT BIGINT, COL_HUGEINT HUGEINT, COL_DOUBLE DOUBLE, COL_NUMERIC NUMERIC(10));
Compiled Version
sql>SELECT SUM(col_int) FROM INT_VALID;
mapi_query_part:36:SELECT SUM(col_int) FROM INT_VALID;
fetch next block: start at:10093
got next block: length:105
text:&1 4 1 1 1 2452
% DM_POS_TSV_MRT_P6A.L4 # table_name
% L3 # name
% hugeint # type
% 5 # length
[ 11110 ]
Binary Version
sql>SELECT SUM(col_int) FROM INT_VALID;
mapi_query_part:36:SELECT SUM(col_int) FROM INT_VALID;
fetch next block: start at:1168
got next block: length:105
text:&1 4 1 1 1 13998
% DM_POS_TSV_MRT_P6A.L4 # table_name
% L3 # name
% bigint # type
% 5 # length
[ 11110 ]
+---------+------------+--------------------------+-------------+
| col_int | col_bigint | col_double | col_numeric |
+=========+============+==========================+=============+
| 1111 | 1234567 | 1234.44 | 1111 |
| 2222 | 2345678 | 34355.66 | 2222 |
| 3333 | 3456789 | 66423.66 | 3333 |
| 4444 | 45678912 | 8765.66 | 4444 |
+---------+------------+--------------------------+-------------+
Regards,
Sreejith
_______________________________________________ users-list mailing list users-list@monetdb.org https://clicktime.symantec.com/a/1/PBHZ6d6Ct9H92RlEAQHNLsc5R3qz7xYvM4M hjAOjmNU=?d=TSqK0IGPM-XP_noQ5QNg6_s30FM0SVKfJzVmDVHvN0jNBkIWhw6izV9JP4 seY3jUR0HwOAQ43yyYalrGpjCYca-4zSv_hbnN7jPwC2g2cuhfe7yV0AvWrcS1CtMwfEoQ O9MXkqOJ9kcbW9CLYaCPcLyS3bTJwqwoMZ9ah-d40RmP6UNh2zkDGlb9hVUr21JLbJHWY- SQKZmKL-_h-3Lcw58_VpPwv9sJkczoL1s7REKQv7PaL0y-wo6orFfwcgWKhUeyIsU1JAjk m5bELKrIv7wSH5z6yyiFVyqo9_cYfwq_9OnQGVEizQFsHKxUnL72UTFTBL9gxLILbtvWdx UcZA2MU3Cf6XDrp3zVhkaJjiO_lMKdUQ9ljz_H2SrWLubdM3wU1flvingEtxNCovk2hwDn eZF3KF7hWQVLXQVB8y3baUbwvwFSv7TP9_gD22vRknU-kGVs&u=https%3A%2F%2Fwww.m onetdb.org%2Fmailman%2Flistinfo%2Fusers-list
-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) | _______________________________________________ users-list mailing list users-list@monetdb.org https://clicktime.symantec.com/a/1/PBHZ6d6Ct9H92RlEAQHNLsc5R3qz7xYvM4MhjAOjmNU=?d=TSqK0IGPM-XP_noQ5QNg6_s30FM0SVKfJzVmDVHvN0jNBkIWhw6izV9JP4seY3jUR0HwOAQ43yyYalrGpjCYca-4zSv_hbnN7jPwC2g2cuhfe7yV0AvWrcS1CtMwfEoQO9MXkqOJ9kcbW9CLYaCPcLyS3bTJwqwoMZ9ah-d40RmP6UNh2zkDGlb9hVUr21JLbJHWY-SQKZmKL-_h-3Lcw58_VpPwv9sJkczoL1s7REKQv7PaL0y-wo6orFfwcgWKhUeyIsU1JAjkm5bELKrIv7wSH5z6yyiFVyqo9_cYfwq_9OnQGVEizQFsHKxUnL72UTFTBL9gxLILbtvWdxUcZA2MU3Cf6XDrp3zVhkaJjiO_lMKdUQ9ljz_H2SrWLubdM3wU1flvingEtxNCovk2hwDneZF3KF7hWQVLXQVB8y3baUbwvwFSv7TP9_gD22vRknU-kGVs&u=https%3A%2F%2Fwww.monetdb.org%2Fmailman%2Flistinfo%2Fusers-list