context already in use (BLR error) [CORE1004] #1415
Assignees
Comments
Modified by: @dyemanovstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 2.0.1 [ 10090 ] Fix Version: 2.1 [ 10041 ] |
|
Commented by: @pmakowski Q/A test made |
Modified by: @pmakowskistatus: Resolved [ 5 ] => Closed [ 6 ] |
Modified by: @pcisarVersion: 2.1 Initial [ 10160 ] Version: 2.0.0 [ 10091 ] => Version: 2.1.0 [ 10041 ] => |
Modified by: @pcisarVersion: 2.0.0 [ 10091 ] |
|
Commented by: @pcisar Reopened to update ticket information. |
Modified by: @pcisarWorkflow: jira [ 11320 ] => Firebird [ 15421 ] |
Modified by: @pavel-zotovQA Status: No test |
Modified by: @pavel-zotovQA Status: No test => Done successfully |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Submitted by: @hvlad
Is related to QA26
Original issue was found by Alexey Khayanok. This is a short example :
CREATE OR ALTER PROCEDURE GET_REL_NAME (REL_ID INT) RETURNS (REL_NAME VARCHAR(32))
AS
BEGIN
FOR SELECT R.RDB$RELATION_NAME
FROM RDB$RELATIONS R
WHERE R.RDB$RELATION_ID = :REL_ID
INTO :REL_NAME
DO
SUSPEND;
END;
COMMIT;
CREATE OR ALTER PROCEDURE BUG
AS
DECLARE C CURSOR FOR (
SELECT (SELECT REL_NAME FROM GET_REL_NAME(R.RDB$RELATION_ID))
FROM RDB$RELATIONS R
);
DECLARE REL_NAME VARCHAR(32);
BEGIN
OPEN C;
WHILE (1 = 1) DO
BEGIN
FETCH C INTO :REL_NAME;
END
CLOSE C;
END;
COMMIT;
Cannot commit transaction:
Invalid token.
invalid request BLR at offset 157.
context already in use (BLR error).
Commits: 8ea7c4f e48713a
The text was updated successfully, but these errors were encountered: