Re: [sqlite] SQLite version 3.7.0

2010-07-22 Thread Eric Smith
Darren Duncan wrote: > I don't have time to investigate right now, but both failing tests seem > to be connected with concurrent access to a table by two forked processes > (the test script forks a child, which does concurrent access). > > At least in the second case, the DROP TABLE and

Re: [sqlite] SQLite version 3.7.0

2010-07-22 Thread Darren Duncan
Dan Kennedy wrote: > Is there any way your tests could be deleting a database > file while there is still an open sqlite connection to it? > > With 3.7.0, if the underlying database file is unlinked > while you are connected to it, then you try to write to > the database, you get

Re: [sqlite] SQLite version 3.7.0

2010-07-22 Thread Filip Navara
On Thu, Jul 22, 2010 at 1:31 PM, Dan Kennedy wrote: [snip] > You cannot delete a file while it is open on windows, so > this doesn't come up on win32. Sure you can, except: - The correct sharing rights have to be specified for this to be allowed (FILE_SHARE_DELETE). As far

Re: [sqlite] SQLite version 3.7.0

2010-07-22 Thread Dan Kennedy
On Jul 22, 2010, at 1:08 PM, Darren Duncan wrote: > Roger Binns wrote: >> On 07/21/2010 08:01 PM, Darren Duncan wrote: >>> Simply substituting in 3.7.0 causes a few new test failures for me >>> with the Perl >>> binding, DBD::SQLite, citing "disk I/O error". >> >> I can't speak for the Perl

Re: [sqlite] SQLite version 3.7.0

2010-07-22 Thread Darren Duncan
Roger Binns wrote: > On 07/21/2010 08:01 PM, Darren Duncan wrote: >> Simply substituting in 3.7.0 causes a few new test failures for me with the >> Perl >> binding, DBD::SQLite, citing "disk I/O error". > > I can't speak for the Perl binding, but some of the underlying error > handling (invalid

Re: [sqlite] SQLite version 3.7.0

2010-07-21 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 07/21/2010 08:01 PM, Darren Duncan wrote: > Simply substituting in 3.7.0 causes a few new test failures for me with the > Perl > binding, DBD::SQLite, citing "disk I/O error". I can't speak for the Perl binding, but some of the underlying error

Re: [sqlite] SQLite version 3.7.0

2010-07-21 Thread Darren Duncan
D. Richard Hipp wrote: > Of course, if you do happen to run into problems, please let me know at once. > Thanks! Simply substituting in 3.7.0 causes a few new test failures for me with the Perl binding, DBD::SQLite, citing "disk I/O error". However, it is more likely that the problem is in

[sqlite] SQLite version 3.7.0

2010-07-21 Thread D. Richard Hipp
SQLite version 3.7.0 is now available on the website http://www.sqlite.org/ The most important change in version 3.7.0 is that SQLite now supports write-ahead logs as an optional method for transaction control, for improved performance and concurrency. Additional information can be found