Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Database trigger created as INACTIVE is really active [CORE3418] #3781

Closed
firebird-automations opened this issue Mar 30, 2011 · 9 comments
Closed

Comments

@firebird-automations
Copy link
Collaborator

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.

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

assignee: Vlad Khorsun [ hvlad ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

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

resolution: Fixed [ 1 ]

Fix Version: 2.5.1 [ 10333 ]

Fix Version: 3.0 Alpha 1 [ 10331 ]

Fix Version: 2.1.5 [ 10420 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

All 2.1.x also affected

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

Version: 2.1.4 [ 10361 ]

Version: 2.1.3 [ 10302 ]

Version: 2.1.2 [ 10270 ]

Version: 2.1.1 [ 10223 ]

Version: 2.1.0 [ 10041 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

Correct description a bit

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

Component: Engine [ 10000 ]

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @pmakowski

Link: This issue relate to QA457 [ QA457 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pmakowski

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

QA Status: Done successfully

Test Details: Confirmed bug on WI-V2.5.0.26074.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment