Invalid Blob ID on simple join query
------------------------------------
Key: CORE-6119
URL: http://tracker.firebirdsql.org/browse/CORE-6119
Project: Firebird Core
Issue Type: Bug
Affects Versions: 2.5.9
Reporter: Arioch
Attachments: FB25_InvBLOB_dbExpress.zip
Discussion:
https://www.sql.ru/forum/1315766/traceapi-2-5-razdelit-chtenie-rows-i-chtenie-blob-ov-v-etih-rows
Happens on FB 2.1.7 win32, FB 2.5.5 Win64, FB 2.5.9 Win64
Did not test on FB3.
The bug is dependent upon closed-souce dbExpress library (part of many Delphi
releases).
The same query when run in IB Expert (Delphi application too but using FIB+
library instead of DBX) works like charm!
I **suspect** that triggering the bug is fetching of blobs after a whole batch
of many rows were fetched, as compared with another possible strategy of
fetchign blobs immediately after fetching every single row.
Trace API fails to expose row fetch and blob fetch events, so can not verify
that hypothesis.
Sample exe attached, create Firebird database and supply connection string
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
