On 3 February 2012 10:27, Timo Kluck <[email protected]> wrote: > Dear Gnome-DB developers, > > I may have stumbled upon a bug in the SQLite engine having to do with > deleting rows after having selected fields containing BLOB values. > > It appears that libgda-4.0 does not delete rows if a blob has been > selected previously. In fact, it will seem to have been deleted to the > program itself, but in subsequent runs of the program, the row turns > out to have persisted. >
When a blob is selected, then a transaction is started (most of the database engines do or require this, see http://developer-next.gnome.org/libgda/stable/gen_blobs.html), and maybe your subsequent modifications are done within the transaction, which is not committed. Can you check? > > I have attached a testcase. It is in vala, but there's a shebang so > you should be able to execute it like a script. > > If you still have the bug after having checked for the transaction issue, tell me and I'll investigate using your testcase. Regards, Vivien
_______________________________________________ gnome-db-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnome-db-list
