SQLite Release 3.2.6 On 2005-09-17

• Fix a bug that can cause database corruption if a VACUUM (or autovacuum) fails and is rolled back on a database that is larger than 1GiB
• LIKE optimization now works for columns with COLLATE NOCASE
• ORDER BY and GROUP BY now use bounded memory
• Added support for COUNT(DISTINCT expr)
• Change the way SUM() handles NULL values in order to comply with the SQL standard
• Use fdatasync() instead of fsync() where possible in order to speed up commits slightly
• Use of the CROSS keyword in a join turns off the table reordering optimization
• Added the experimental and undocumented EXPLAIN QUERY PLAN capability
• Use the unicode API in Windows

A complete list of SQLite releases in a single page is also available. A detailed history of every check-in is available at http://www.sqlite.org/src/timeline.