Re: [sqlite] Regression with sqlite-snapshot-201007091257

2010-07-13 Thread Filip Navara
Hi Shane! I used two separate builds. One was built with the following command line: cl /DSQLITE_ENABLE_FTS3=1 /DSQLITE_ENABLE_COLUMN_METADATA=1 /DTHREADSAFE=1 /O2 /LD sqlite3.c sqlite3.def and the other was built from inside Visual Studio 2010 UI and reports the following compile options: sqli

Re: [sqlite] Regression with sqlite-snapshot-201007091257

2010-07-13 Thread Shane Harrelson
I tried to reproduce the issue with the latest version, as well as with the referenced snapshot, and could not. I ran two instances of the sqlite CLI as you indicated without issue. C:\work\sqlite\win32\Debug>sqlite_snapshot test.db SQLite version 3.7.0 Enter ".help" for instructions Enter SQL sta

Re: [sqlite] Regression with sqlite-snapshot-201007091257

2010-07-13 Thread Filip Navara
Steps to reproduce, run sqlite3 test.db twice. The first instance: SQLite version 3.7.0 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> pragma encoding="UTF-8"; sqlite> pragma auto_vacuum=incremental; sqlite> pragma journal_mode=truncate; truncate The second inst

Re: [sqlite] Regression with sqlite-snapshot-201007091257

2010-07-13 Thread Filip Navara
The second problem is definitely related to the change in the implementation of "pragma journal_mode" though I am not completely sure how. The previous version of our code did pragma encoding="UTF-8"; pragma auto_vacuum=incremental; pragma journal_mode=truncate; after opening the database file. W

Re: [sqlite] Regression with sqlite-snapshot-201007091257

2010-07-13 Thread Filip Navara
Btw, the failing application call is DeleteFileW. F. On Tue, Jul 13, 2010 at 5:02 PM, Filip Navara wrote: > Hi, > > for a few days we have been running our application with SQLite built from > the 201007091257 snapshot. The application runs on Windows 7 systems that > are fully updated. We didn'

[sqlite] Regression with sqlite-snapshot-201007091257

2010-07-13 Thread Filip Navara
Hi, for a few days we have been running our application with SQLite built from the 201007091257 snapshot. The application runs on Windows 7 systems that are fully updated. We didn't enable the WAL mode and the following two problems occurred: - Every time a database file is opened SQLite tries to