Thanks, a call to gda_connection_commit_transaction fixed the issue. Perhaps it makes sense to put this call in the examples on
http://developer-next.gnome.org/libgda/stable/blobs_example.html as well. Even though no subsequent modifications to the database are done in those examples, it is pretty confusing that the example code implicitly modifies the state of the connection. Thanks again, Timo 2012/2/3 Vivien Malerba <[email protected]>: > > > 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
