|
If you were logged in you would be able to see more operations.
|
|
|
| Planning Status: |
Unspecified
|
|
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.
|
|
Description
|
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. |
Show » |
|
Bug
Closed
Major
Database trigger created as INACTIVE is really active