Yuri wrote: > even updates to other tables invalidate the blob handle. Please see the > example below.
This is a bug. Apparently, it was introduced in commit f17ef37897da9bca, where the function invalidateIncrblobCursors() forgets to check the pgnoRoot parameter, which means that blob cursors are invalidated by changes to any row with the same rowid, even in some other table. (Commit 257e9b575029f632 then removed that unused parameter without noticing that it should have been used.) Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users