[sqlite] Version 2.8.10

[D. Richard Hipp]

D. Richard Hipp wrote:
Version 2.8.10 of SQLite is now available on the website.

    http://www.sqlite.org/

This version fixes a critical locking bug in Unix.  It turns out
that any call to close() clears all locks on file that was closed
(who knew?) which then left the database vulnerable to corruption
from other processes.  That bug has been cleared by embargoing
all close() calls until all locks of been released.
There are also some enhancements in corner cases and some very
obscure bug fixes.
Unix users should definately upgrade.  Upgrading for Windows users
is optional.
9 hours after publication, a minor bug is found.  So I'm going to
rush out 2.8.11 real quick, hoping that most users can avoid having
to upgrade twice.
The problem in 2.8.10 (introduced in that version) is that if
you have a lot of NULLs in the subquery of an IN expression:
    SELECT * FROM t1 WHERE a IN (SELECT stuff FROM t2)
                                 ^^^^^^^^^^^^^^^^^^^^
                                 lots of NULLs here
That situation will cause an assertion failure because the NULLs
were not being popped from the VDBEs execution stack.
Version 2.8.11 should be available in a few minutes.

--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]