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-issue-importer opened this issue Mar 30, 2011 · 9 comments
Closed

Comments

@firebird-issue-importer

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Mar 30, 2011

Modified by: @hvlad

assignee: Vlad Khorsun [ hvlad ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Mar 31, 2011

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Mar 31, 2011

Commented by: @hvlad

All 2.1.x also affected

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Mar 31, 2011

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Mar 31, 2011

Commented by: @hvlad

Correct description a bit

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Mar 31, 2011

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented May 16, 2012

Modified by: @pmakowski

Link: This issue relate to QA457 [ QA457 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented May 16, 2012

Modified by: @pmakowski

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jul 15, 2015

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