Subject | Re: [firebird-support] Arithmetic overflow in views |
---|---|
Author | Ivan Prenosil |
Post date | 2007-01-21T16:35:55Z |
>> I have just found a very strange problem with my database (FirebirdYour views had problem that manifests with certain data only.
>> 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.
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