|Subject||Re: [Firebird-Java] SUM()|
> On Tuesday 26 November 2002 13:46, you wrote:results
> > SELECT SUM(some_column_name) FROM some_table
> > where some_column_name is of type INTEGER
> > returns a BIGDECIMAL number where, obviously, an INTEGER is expected.
> Depends. It is more than possible that a sum of a number of integers
> in a number too big to fit in to an integer.Thanx for your reply.
> 2147483640 + 8
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.