Bugcheck 249 when attempting to fetch outside the end-of-stream mark for the open PSQL cursor [CORE2101]

[firebird-automations]

Submitted by: @dyemanov

Is related to QA368

Test case:

CREATE TABLE T1 ( F1 SMALLINT );

CREATE PROCEDURE P1
AS
DECLARE VARIABLE V1 SMALLINT;
DECLARE C1 CURSOR FOR ( SELECT F1 FROM T1 );
BEGIN
OPEN C1;
WHILE (1=1) DO
BEGIN
FETCH C1 INTO :V1;
IF(ROW_COUNT = 1) THEN LEAVE;
END
CLOSE C1;
END;

COMMIT;

EXECUTE PROCEDURE P1;

Unsuccessful execution caused by a system error that precludes
successful execution of subsequent statements.
Internal gds software consistency check (pointer page vanished from DPM_next (249), file: dpm.cpp line: 1645).

While this example looks like an intentional infinite loop, I believe we should mirror our API behaviour for such situations and throw an error for the invalid (outside the EOF marker) fetch operation.

Commits: a2eee6c

[firebird-automations]

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ]

[firebird-automations]

Modified by: @dyemanov

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

Fix Version: 2.0.5 [ 10222 ]

Fix Version: 2.1.2 [ 10270 ]

Fix Version: 2.5 Beta 1 [ 10251 ]

[firebird-automations]

Modified by: @dyemanov

status: Open [ 1 ] => In Progress [ 3 ]

[firebird-automations]

Modified by: @dyemanov

status: In Progress [ 3 ] => Open [ 1 ]

[firebird-automations]

Modified by: @dyemanov

Fix Version: 2.0.5 [ 10222 ] =>

Fix Version: 2.1.2 [ 10270 ] =>

[firebird-automations]

Modified by: @dyemanov

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

resolution: Fixed [ 1 ]

[firebird-automations]

Modified by: @pcisar

Link: This issue is related to QA368 [ QA368 ]

[firebird-automations]

Commented by: @pcisar

QA test added.

[firebird-automations]

Modified by: @pcisar

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

[firebird-automations]

Modified by: @pavel-zotov

QA Status: No test

[firebird-automations]

Modified by: @pavel-zotov

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

QA Status: No test => Done successfully