| Subject | Re: [firebird-support] Fake error "arithmetic exception, numeric overflow..." on stored procedure or trigger |
|---|---|
| Author | Mark Rotteveel |
| Post date | 2018-02-22T15:29:36Z |
On 21-2-2018 12:29, marco andreolli drazde@... [firebird-support]
wrote:
wider, but did not recompile the triggers or stored procedures. Those
are still using the older, smaller size and then break when confronted
with a value that is wider.
Mark
--
Mark Rotteveel
wrote:
> Recently I have found the error /arithmetic exception, numeric overflow,AFAIK, this can happen if you changed the definition of a column to be
> or string truncation/
> /string right truncation
> At trigger 'XXXXX'
> /
> on different trigger or stored procedure.
> The strange thing is that are not true, in the trigger or procedure
> there isn't any operation that coud produce this exception!
>
> I "recompile" the trigger or procedure that are affected and the error
> disappear!.
> It could be a bug in my relase of Firebird?
wider, but did not recompile the triggers or stored procedures. Those
are still using the older, smaller size and then break when confronted
with a value that is wider.
Mark
--
Mark Rotteveel