Subject Re: [firebird-support] Arithmetic overflow in views
Author Ivan Prenosil
>> I have just found a very strange problem with my database (Firebird
>> 1.5.2.4731/WinXP): Some views have recently started to crash with
>> "arithmetic exception, numeric overflow, or string truncation" when
> I try
>> to read data from them. Using the original select statements, from
> which
>> the views were created, works correctly. Backing up and restoring
> the
>> whole database has no effect on this, but dropping and recreating
> the
>> views works.

Your views had problem that manifests with certain data only.
If recreating views helped, it means that either
- the new view definitions are not identical to old ones, or
- original view was created under different conditions,
i.e. either different dialect or character set

Can you compare BLR of new and old views ? (if you still have it)

Ivan