[Firebird-devel] Specifying transaction in isc_open_blob2()

[Ivan P. <Iva...@se...>]

Can anybody explain to me why
  isc_open_blob2()
call needs transaction handle ?

Blob-ids are not under version/transaction control like rdb$db_keys,
where one needs both rdb$db_key _and_ transaction handle
to get correct version of row.

Small example (using isql):
Insert new row containing blob into the table,
select from that table to obtain its blob-id, but do not commit.
Now in another isql instance use this blob-id
in BLOBDUMP command, and you will get contents
of these uncommitted data.

Ivan