SQLite Release 3.2.3 On 2005 August 21 (3.2.3)

*** DRAFT ***

Changes associated with this release include the following:

Added support for the CAST operator
Tcl interface allows BLOB values to be transferred to user-defined functions
Added the "transaction" method to the Tcl interface
Allow the DEFAULT value of a column to call functions that have constant operands
Added the ANALYZE command for gathering statistics on indices and using those statistics when picking an index in the optimizer
Remove the limit (formerly 100) on the number of terms in the WHERE clause
The right-hand side of the IN operator can now be a list of expressions instead of just a list of constants
Rework the optimizer so that it is able to make better use of indices
The order of tables in a join is adjusted automatically to make better use of indices
The IN operator is now a candidate for optimization even if the left-hand side is not the left-most term of the index. Multiple IN operators can be used with the same index.
WHERE clause expressions using BETWEEN and OR are now candidates for optimization
Added the "case_sensitive_like" pragma and the SQLITE_CASE_SENSITIVE_LIKE compile-time option to set its default value to "on".
Use indices to help with GLOB expressions and LIKE expressions too when the case_sensitive_like pragma is enabled
Added support for grave-accent quoting for compatibility with MySQL
Improved test coverage
Dozens of minor bug fixes

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