[Firebird-devel] FB 3.0.1 - Different concatenation result to FB 2.5.6

2016-10-10 Thread Slavomir Skopalik
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 =

Re: [Firebird-devel] FB 3.0.1 - Different concatenation result to FB 2.5.6

2016-10-10 Thread Alex Peshkoff
On 10/10/16 13:10, Slavomir Skopalik wrote: > 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

Re: [Firebird-devel] FB 3.0.1 - Different concatenation result to FB 2.5.6

2016-10-10 Thread Dimitry Sibiryakov
10.10.2016 17:04, Alex Peshkoff wrote: > To be precise the result in FB3 is: > > T2 > == > T1 _SUFIX > T1234567890_SUFIX > > where _SUFIX starts exactly at position == 31 (see message text with > monospace font

Re: [Firebird-devel] FB 3.0.1 - Different concatenation result to FB 2.5.6

2016-10-10 Thread Alex Peshkoff
On 10/10/16 18:21, Dimitry Sibiryakov wrote: 10.10.2016 17:04, Alex Peshkoff wrote: To be precise the result in FB3 is: T2 == T1 _SUFIX T1234567890_SUFIX where _SUFIX starts exactly at position == 31 (see m

Re: [Firebird-devel] FB 3.0.1 - Different concatenation result to FB 2.5.6

2016-10-10 Thread Slavomir Skopalik
Hi Alex, I'm not worry about 2.5. I was just put here for info. Slavek PS: Spaces was deleted by HTML in E-mail :( > T2 > == > T1 _SUFIX > T1234567890_SUFIX > > where _SUFIX starts exactly at position == 31 (s