Submitted by: @sim1984

Bidirectional cursor is not positioned by the first call of FETCH LAST

EXECUTE BLOCK
RETURNS (
NAME CHAR(31),
RC INT)
AS
DECLARE C SCROLL CURSOR FOR (
SELECT RDB$FIELD_NAME
FROM RDB$FIELDS);
BEGIN
OPEN C;
FETCH FIRST FROM C
INTO :NAME;
RC = ROW_COUNT;
SUSPEND;
FETCH LAST FROM C
INTO :NAME;
RC = ROW_COUNT;
SUSPEND;
CLOSE C;
END

Result:

NAME RC
--------------------------------
RDB$VIEW_CONTEXT 1
RDB$19775 1

EXECUTE BLOCK
RETURNS (
NAME CHAR(31),
RC INT)
AS
DECLARE C SCROLL CURSOR FOR (
SELECT RDB$FIELD_NAME
FROM RDB$FIELDS);
BEGIN
OPEN C;
/*
FETCH FIRST FROM C
INTO :NAME;
RC = ROW_COUNT;
SUSPEND;
*/
FETCH LAST FROM C
INTO :NAME;
RC = ROW_COUNT;
SUSPEND;
CLOSE C;
END

Result:

NAME RC
----------------------
<null> 0

Commits: ffbc33c FirebirdSQL/fbt-repository@735d29f