[DBD-SQLite] [Fwd: [sqlite] SQLite version 3.6.12]

[Darren Duncan]

FYI, a new SQLite library was released today, 3.6.12, and I have forwarded the 
announcement.  See also http://sqlite.org/changes.html for a list of all the 
changes.  This update was recommended for all SQLite users. -- Darren Duncan

-------- Original Message --------
Subject: [sqlite] SQLite version 3.6.12
Date: Tue, 31 Mar 2009 09:41:30 -0400
From: D. Richard Hipp <drh at hwaci.com>
Reply-To: General Discussion of SQLite Database <sqlite-users at sqlite.org>
To: General Discussion of SQLite Database <sqlite-users at sqlite.org>, 
sqlite-announce at sqlite.org

SQLite version 3.6.12 is now available on the SQLite website

       http://www.sqlite.org/

During release testing for 3.6.12, we stumbled over a critical bug
that has existed in SQLite since version 3.4.0.  This bug will cause
corruption of in-memory databases if an incremental vacuum is rolled
back.  The corruption is virtually guaranteed if you rollback an
incremental vacuum in an in-memory database.  Presumably not many
people are doing that or we would have seen this sooner.  As far as we
are aware, incremental vacuum works correctly for on-disk databases.
We will continue to study this issue over the next weeks and release
additional patches if we find new problems.

A manual code review uncovered another bug in the lookaside memory
allocator which can result in a segfault when shared cache is
enabled.  At the very least, users of shared cache should disable
lookaside memory.  A better solution is to update to version 3.6.12.

New features added to version 3.6.12 include the
sqlite3_unlock_notify() interface and the reverse_unordered_selects
PRAGMA.  Additional information about both is available on the website.

Because of the incremental vacuum and lookaside memory allocator
issues identified above, we recommend that everyone update to SQLite
version 3.6.12.

D. Richard Hipp
drh at hwaci.com