> We recently converted our applications from Interbase 5.6 to Firebird
> 1.5.3 Classic on linux. So far it has gone well and there have been a
> lot of nice query speed-ups without us having to do anything! However,
> I just received a defect notice from one of our developers that a report
> is now failing our regression tests. We traced it down to a "select
> sum" query that is adding up an integer column. We are using Dialect 1
> since we are still in the middle of converting our trigger and stored
> procedure code as well as trying to move off of the date-time fields.
> Selecting a sum of integers where the result would overflow an integer
> seems to work in Dialect 3, but not in Dialect 1. We can work around it
> by casting the field to a double which seems to cause the sum to return
> a double rather than an integer. However, I would prefer not to have to
> find out where else in the code this might happen. I am not even sure
> if this would overflow in Interbase since we never saw this behavior
> before. We converted all of our test servers over, so I will have to
> set one up and try it out...
>
> Anyways my question is: Is this a bug in Firebird with Dialect 1?

One possibility is that it is a bug in FB (although I am not aware of it).
Can you send reproducible test case ?

The other possibility is that it is a bug in IB - perhaps the overflow exception
is correct (for given data and datatype), but IB will send you wrong result instead.
Are you sure the results in IB5.6 are always correct ?

Ivan
http://www.volny.cz/iprenosil/interbase/