Attachment: console-output-when-run-on-fb-25-vs-30.zip [ 12871 ]

description: 1. Create two databases, on in FB 2.5 and second in FB 3.0, and assign aliases for them; in following example these aliases are: 'e25' and 'e30'.
2. Create script (let's with name = 'ct.sql'):

set bail on;

set term ^;
create or alter trigger trg_connect active on connect position 0 as
begin
end
^

create or alter trigger trg_disc active on disconnect position 0 as
begin
end
^
set term ;^
commit;

recreate table log(what_happened varchar(20), when_it_was timestamp default 'now');
commit;

set term ^;

execute block as
begin
rdb$set_context('USER_SESSION','INITIAL_DDL','1');
end
^

create or alter trigger trg_connect active on connect position 0 as
begin
execute statement 'insert into log(what_happened) values(''connect'')'
with autonomous transaction;
end
^

create or alter trigger trg_disc active on disconnect position 0 as
begin
if ( rdb$get_context('USER_SESSION','INITIAL_DDL') is null ) then
execute statement 'insert into log(what_happened) values(''disconnect'')'
with autonomous transaction;
end
^
set term ;^
commit;

set echo on;

show table log;

show trigger;
quit;

3. Run following sequence of commands:

3.1. For working with FB 2.5 that is listening to the port = 3255:

%FB25_BIN%\isql /3255:e25 -i ct.sql
echo set count on; select * from log; | %FB25_BIN%\isql /3255:e25
echo set count on; select * from log; | %FB25_BIN%\isql /3255:e25
echo set count on; select * from log; | %FB25_BIN%\isql /3255:e25
%FB25_BIN%\isql /3255:e25 -i ct.sql
echo set count on; select * from log; | %FB25_BIN%\isql /3255:e25

3.2. For working with FB 3.0 that is listening to the port = 3333:

%FB30_BIN%\isql /3333:e30 -i ct.sql
echo set count on; select * from log; | %FB30_BIN%\isql /3333:e30
echo set count on; select * from log; | %FB30_BIN%\isql /3333:e30
echo set count on; select * from log; | %FB30_BIN%\isql /3333:e30
%FB30_BIN%\isql /3333:e30 -i ct.sql -------------------------------------------------------------------- [!!!]
echo set count on; select * from log; | %FB30_BIN%\isql /3333:e30

Output in 3.0 differs from 2.5:
1) 'disconnect' event is NOT written into log (and exactly because of ES, i.e. dynamic SQL; when 'insert' statement is written as static statement in trigger body - no problem);
2) FB 3.0 will crash after DDL script ('ct.sql') will be executes 2nd time - see marked line "[!!!]"; console will contain: Statement failed, SQLSTATE = 08006 / Error reading data from the connection; firebird.log will contain:

CSPROG Thu Jan 14 23:11:34 2016
Access violation.
The code attempted to access a virtual
address without privilege to do so.
This exception will cause the Firebird server
to terminate abnormally.

CSPROG Thu Jan 14 23:11:34 2016
INET/inet_error: read errno = 10054, server host = csprog, address = 192.168.43.154/3333

Both logs of output see in attached file.

PS. WI-V3.0.0.32272

=>

1. Create two databases, first on FB 2.5 and second on FB 3.0, and assign aliases for them; in following example these aliases are: 'e25' and 'e30'.
2. Create script (let's with name = 'ct.sql'):

set bail on;

set term ^;
create or alter trigger trg_connect active on connect position 0 as
begin
end
^

create or alter trigger trg_disc active on disconnect position 0 as
begin
end
^
set term ;^
commit;

recreate table log(what_happened varchar(20), when_it_was timestamp default 'now');
commit;

set term ^;

execute block as
begin
rdb$set_context('USER_SESSION','INITIAL_DDL','1');
end
^

create or alter trigger trg_connect active on connect position 0 as
begin
execute statement 'insert into log(what_happened) values(''connect'')'
with autonomous transaction;
end
^

create or alter trigger trg_disc active on disconnect position 0 as
begin
if ( rdb$get_context('USER_SESSION','INITIAL_DDL') is null ) then
execute statement 'insert into log(what_happened) values(''disconnect'')'
with autonomous transaction;
end
^
set term ;^
commit;

set echo on;

show table log;

show trigger;
quit;

3. Run following sequence of commands:

3.1. For working with FB 2.5 that is listening to the port = 3255:

%FB25_BIN%\isql /3255:e25 -i ct.sql
echo set count on; select * from log; | %FB25_BIN%\isql /3255:e25
echo set count on; select * from log; | %FB25_BIN%\isql /3255:e25
echo set count on; select * from log; | %FB25_BIN%\isql /3255:e25
%FB25_BIN%\isql /3255:e25 -i ct.sql
echo set count on; select * from log; | %FB25_BIN%\isql /3255:e25

3.2. For working with FB 3.0 that is listening to the port = 3333:

%FB30_BIN%\isql /3333:e30 -i ct.sql
echo set count on; select * from log; | %FB30_BIN%\isql /3333:e30
echo set count on; select * from log; | %FB30_BIN%\isql /3333:e30
echo set count on; select * from log; | %FB30_BIN%\isql /3333:e30
%FB30_BIN%\isql /3333:e30 -i ct.sql -------------------------------------------------------------------- [!!!]
echo set count on; select * from log; | %FB30_BIN%\isql /3333:e30

Output in 3.0 differs from 2.5:
1) 'disconnect' event is NOT written into log (and exactly because of ES, i.e. dynamic SQL; when 'insert' statement is written as static statement in trigger body - no problem);
2) FB 3.0 will crash after DDL script ('ct.sql') will be executes 2nd time - see marked line "[!!!]"; console will contain: Statement failed, SQLSTATE = 08006 / Error reading data from the connection; firebird.log will contain:

CSPROG Thu Jan 14 23:11:34 2016
Access violation.
The code attempted to access a virtual
address without privilege to do so.
This exception will cause the Firebird server
to terminate abnormally.

CSPROG Thu Jan 14 23:11:34 2016
INET/inet_error: read errno = 10054, server host = csprog, address = 192.168.43.154/3333

Both logs of output see in attached file.

PS. WI-V3.0.0.32272

assignee: Vlad Khorsun [ hvlad ]

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 3.0 RC2 [ 10048 ]

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: No test => Done successfully

status: Resolved [ 5 ] => Closed [ 6 ]