Issue Details (XML | Word | Printable)

Key: CORE-6254
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Vlad Khorsun
Reporter: Vlad Khorsun
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
Firebird Core

AV in engine when using SET TRANSACTION and ON TRANSACTION START trigger uses EXECUTE STATEMENT against current transaction

Created: 20/Feb/20 04:31 PM   Updated: 21/Feb/20 05:53 AM
Component/s: Engine
Affects Version/s: 4.0 Initial, 3.0.0, 3.0.1, 3.0.2, 4.0 Alpha 1, 3.0.3, 3.0.4, 4.0 Beta 1, 3.0.5
Fix Version/s: 4.0 Beta 2, 3.0.6

QA Status: Done successfully


 Description  « Hide
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;



 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.