Subject Re: [ib-support] Re: UDF Failure
Author Dmitry Kuzmenko
Hello, Alex!

alex_vnru wrote:

> Claudio, I use build 796 and don't understand logic
>
> select Trim(cast ('c' as varchar (32000)) || Cast ('c' as varchar
> (32000))) from rdb$database
> Unsuccessful execution caused by an unavailable resource.
> Implementation limit exceeded.
> block size exceeds implementation restriction.
>
> OK, intermediate result greater than 32767. On FB1.1 it should occure

Mistake - not a RESULT is greater. Sum of declaration is greater,
which is invalid logic. Declared size must be checked only
when something is being assigned to string, to prevent character
overflow, which is already being checked.

--
Dmitry Kuzmenko, Epsylon Technologies.