Subject Re: [Firebird-Java] Re: SUM()
Author Haris Papadopoulos
> > Are you implying this is normal behaviour? Other drivers like
> > Interclient with Firebird or JConnect with Sybase return INTEGER
> > though and the numbers I've been testing with are very small.
>
> As far as I know, JayBird simply translates you server response. If
> server decided that sum() must be INT64, we translate it into the
> BIGINT. InterClient should return BIGINT in this case too.
>
I agree. However, I get a column of type NUMERIC and not INTEGER or BIGINT.
Here is the simple query:
select SUM(VFTVOTES) from voteForTab where VFTVOTES is of type INTEGER.
The value of sum in my test is 19.

Haris.