You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
SET TERM ^ ;
CREATE OR ALTER TRIGGER TRG$START
INACTIVE ON TRANSACTION START POSITION 0
AS
BEGIN
RDB$SET_CONTEXT('USER_SESSION', 'TRANS_ID', CURRENT_TRANSACTION);
END
^
SET TERM ; ^
SELECT RDB$GET_CONTEXT('USER_SESSION', 'TRANS_ID') FROM RDB$DATABASE;
Returns value of CURRENT_TRANSACTION, while result should be NULL.
description: After execute this query db-trigger is active:
CREATE OR ALTER TRIGGER TRG$START
INACTIVE ON TRANSACTION START POSITION 0
AS
BEGIN
RDB$SET_CONTEXT('USER_SESSION', 'TRANS_ID', CURRENT_TRANSACTION);
END
^
SET TERM ; ^
=>
After execute this query db-trigger is active:
SET TERM ^ ;
CREATE OR ALTER TRIGGER TRG$START
INACTIVE ON TRANSACTION START POSITION 0
AS
BEGIN
RDB$SET_CONTEXT('USER_SESSION', 'TRANS_ID', CURRENT_TRANSACTION);
END
^
SET TERM ; ^
SELECT RDB$GET_CONTEXT('USER_SESSION', 'TRANS_ID') FROM RDB$DATABASE;
Returns value of CURRENT_TRANSACTION, while result should be NULL.
summary: Inactive DB-trigger after Create/Alter Is Active => Database trigger created as INACTIVE is really active
Submitted by: Maxim Kuzmin (cybermax)
Relate to QA457
After execute this query db-trigger is active:
SET TERM ^ ;
CREATE OR ALTER TRIGGER TRG$START
INACTIVE ON TRANSACTION START POSITION 0
AS
BEGIN
RDB$SET_CONTEXT('USER_SESSION', 'TRANS_ID', CURRENT_TRANSACTION);
END
^
SET TERM ; ^
SELECT RDB$GET_CONTEXT('USER_SESSION', 'TRANS_ID') FROM RDB$DATABASE;
Returns value of CURRENT_TRANSACTION, while result should be NULL.
Commits: 13d1b93 61ccac3 d8d7fcc 005ef46 90f9d90 44f1446
====== Test Details ======
Confirmed bug on WI-V2.5.0.26074.
The text was updated successfully, but these errors were encountered: