Subject | Re: [Firebird-Java] Re: SUM() |
---|---|
Author | Haris Papadopoulos |
Post date | 2002-11-29T11:50:19Z |
> > Are you implying this is normal behaviour? Other drivers likeI agree. However, I get a column of type NUMERIC and not INTEGER or BIGINT.
> > 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.
>
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.