Small, Fast, Reliable.
Choose any three.

About Sitemap Documentation Download License News Developers Support

## SQLite Release of 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 optiization 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 pages is also available. A detailed history of every check-in is available at http://www.sqlite.org/cvstrac/timeline.

This page last modified 2007/11/27 18:34:37 UTC