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
If stored procedure or trigger contains query with PLAN ORDER it could fail after disconnect of attachment where procedure\trigger executed first time [CORE2817]
#3204
CREATE OR ALTER PROCEDURE SP_TEST
AS
DECLARE DUMMY INT;
BEGIN
FOR SELECT 1 FROM RDB$RELATION_FIELDS F ORDER BY F.RDB$FIELD_NAME
INTO :DUMMY
DO BEGIN
END
END
isql 1
EXECUTE PROCEDURE SP_TEST;
isql 2
EXECUTE PROCEDURE SP_TEST;
isql 1
EXIT;
isql 2
EXECUTE PROCEDURE SP_TEST;
Statement failed, SQLSTATE = 42000
At procedure 'SP_TEST'
The issue was introduced by fix for CORE2616 and affects only v2.5 as previous versions (2.1.4 and 2.0.6) used another implementation of BtrPageGCLock class.
Submitted by: @hvlad
CREATE OR ALTER PROCEDURE SP_TEST
AS
DECLARE DUMMY INT;
BEGIN
FOR SELECT 1 FROM RDB$RELATION_FIELDS F ORDER BY F.RDB$FIELD_NAME
INTO :DUMMY
DO BEGIN
END
END
isql 1
EXECUTE PROCEDURE SP_TEST;
isql 2
EXECUTE PROCEDURE SP_TEST;
isql 1
EXIT;
isql 2
EXECUTE PROCEDURE SP_TEST;
Statement failed, SQLSTATE = 42000
At procedure 'SP_TEST'
Commits: 12cf2ed b5bbe96
The text was updated successfully, but these errors were encountered: