*** DRAFT ***

About Sitemap Documentation Download License News Support |

## SQLite Release 3.2.6 On 2005 September 17 (3.2.6)

Changes associated with this release include the following:

- 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.

*** DRAFT ***