Subject Re: [firebird-support] Question re: inserting data w/ Select and Concat
Author Michael Weissenbacher
Hi,
> Yes, this normally works, but you insert into the same table you do the
> select from.
> I guess this will lead to something like 'title-2-2-2-2-2-2-2-2-2-2' ...
> until the field length is exceeded.
IIRC Firebird <2.0 starts a never ending loop on this kind of query. So the
explaination is that eventually the size of the field WILL get too small, no
matter how long it is. Then you get the String Truncation error.

Michael