SQLite version 3.2.0 is now available on the website. http://www.sqlite.org/
Version 3.2.0 adds support for the ALTER TABLE ADD COLUMN command. The ADD COLUMN command operates in constant time. It takes the same amount of time regardless of how many rows of data exist in the database ahead of time. However, older versions of the SQLite may not be able to read a database that has had the ADD COLUMN command applied until after the database has been VACUUMed. That is why this release increments the second term in the version number. Except for the inability of older versions of SQLite to read or write databases that have had ADD COLUMN applied, the new release of SQLite is fully forwards and backwards compatible, both in the database file format and in the library API. The new ADD COLUMN functionality is made possible by AOL developers supporting and embracing great open- source software. Thanks AOL! Just prior to the release of 3.2.0, an important bug was discovered and fixed in the rollback logic. If you start a multi-statement transaction and a large INSERT or UPDATE within that transaction fails due to a constraint error, then you rollback the whole transaction, the rollback might not occur correctly and parts of the database might be changed. This is a corner case, but it is still and important bug. All users should upgrade to version 3.2.0 as soon as practical. As always, please let me know if you find any other problems. -- D. Richard Hipp <[EMAIL PROTECTED]>
