Hi all, I am trying to update our application to use latest SQLite library. In many places of the code we were using data returned from INSERT, UPDATE, DELETE commands when count_changes pragma is set to 1. First thing I noticed is that this pragma is now deprecated. But, it still works correctly.
Problems started when i tried to vacuum the database. In the scenario when count_changes=1, executing vacuum fails with "Attempted to read or write protected memory. This is often an indication that other memory is corrupt." on sqlite3_step function. As we were using our own .NET wrapper, I also decided to give System.Data.SQLite a try. But the results are the same. Error is still there. One workaround might be to disable pragma before executing vacuum, and enable it afterwards. But I'm sure something like that could be broken in multithreaded or multiuser scenario (doing insert right after pragma is disabled and relying on returned data). So maybe this could be fixed in library? Best regards, RS _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
