Subject Re: URGENT - CONCATENATION ERROR - BUG
Author crizoo4712
sure, on my installation it does.
--- In firebird-support@yahoogroups.com, Dmitry Yemanov <dimitr@...>
wrote:
>
> crizoo4712 wrote:
> > since the password is moved to another field (2000 characters
long), it
> > really doesn't matter how long the default value for it is.
>
> Wrong. The default value is assigned in the line the variable is
> declared at.
>
> > in the worst case, it's just truncated.
>
> Wrong. You cannot assign a long string to a shorter
column/variable. A
> string truncation error occurs.
>
> > and the sp crashes "long" before the reference of the password.
>
> It crashes even if the SP body is empty. See above.
>
> > i shortened it to 20 characters and the sp crashed again.
>
> Nope, it doesn't crash anymore after the change.
>
>
> Dmitry
>