Hi,

I found different behavior of concatenation between FB2.5.6 and FB 3.0.1.

FB 2.5.6:

EXECUTE BLOCK RETURNS(T2 VARCHAR(70)) AS
DECLARE T1 RDB$RELATION_NAME = 'T1';
BEGIN
   T2 = T1 || '_SUFIX';
   SUSPEND;
   T1 = 'T1234567890';
   T2 = T1 || '_SUFIX';
   SUSPEND;
END

T2
=============================================================================== 


T1 _SUFIX
T1234567890_SUFIX

FB 3.0.1

EXECUTE BLOCK RETURNS(T2 VARCHAR(70)) AS
DECLARE T1 RDB$RELATION_NAME = 'T1';
BEGIN
   T2 = T1 || '_SUFIX';
   SUSPEND;
   T1 = 'T1234567890';
   T2 = T1 || '_SUFIX';
   SUSPEND;
END

T2
======================================================================

T1 _SUFIX
T1234567890 _SUFIX

Slavek

-- 
Ing. Slavomir Skopalik
Executive Head
Elekt Labs s.r.o.
Collection and evaluation of data from machines and laboratories
by means of system MASA (http://www.elektlabs.cz/m2demo)
-----------------------------------------------------------------
Address:
Elekt Labs s.r.o.
Chaloupky 158
783 72 Velky Tynec
Czech Republic
---------------------------------------------------------------
Mobile: +420 724 207 851
icq:199 118 333
skype:skopaliks
e-mail:skopa...@elektlabs.cz
http://www.elektlabs.cz



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most 
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to