AV in engine when using SET TRANSACTION and ON TRANSACTION START trigger uses EXECUTE STATEMENT against current transaction [CORE6254] #6497
Labels
affect-version: 3.0.0
affect-version: 3.0.1
affect-version: 3.0.2
affect-version: 3.0.3
affect-version: 3.0.4
affect-version: 3.0.5
affect-version: 4.0 Alpha 1
affect-version: 4.0 Beta 1
affect-version: 4.0 Initial
component: engine
fix-version: 3.0.6
fix-version: 4.0 Beta 2
priority: major
qa: done successfully
type: bug
Submitted by: @hvlad
To reproduce, attach with isql to the any database and run:
set term ^;
create or alter trigger trg_tx_start on transaction start
as
declare tx int;
begin
execute statement ('select current_transaction from rdb$database')
into :tx;
end
^
set term ;^
commit;
-- new transaction using API, OK
select current_transaction from rdb$database;
commit;
-- new transaction using SQL, AV on commit
set transaction;
select current_transaction from rdb$database;
commit;
drop trigger trg_tx_start;
commit;
Commits: b205e04 7e5b0ce
The text was updated successfully, but these errors were encountered: