Subject Fetch and isc_req_sync error
Author maverickthunder
Hi, I'm new to firebird and make this simple test table with an index
in Nombre and a generator in ID:

CREATE TABLE "Data" (
ID INTEGER NOT NULL,
"Nombre" VARCHAR(60) NOT NULL,
"Fecha_Nacimiento" TIMESTAMP NOT NULL,
"Foto" BLOB SUB_TYPE BINARY SEGMENT SIZE 2048,
/* Keys */
PRIMARY KEY (ID)
);

The table has 8 registers and some of them has Foto with NULL

I build a simple query: SELECT * FROM "Data"; by using prepare,
describe and isc_dsql_execute.

But when I use isc_dsql_fetch (all calls using SQL_DIALECT_V6) I got
the 8 registers and in the ninth call instead of getting an EOF, I got
a duplicate of the last register without errors and in the next call I
got "isc_req_sync" error.

The isc_req_sync error sounds logic but I don't know why I does not get
the EOF signal using FB 2.1.1.17910

Best regards,
Mauro H. Leggieri