Small. Fast. Reliable.
Choose any three.

About Documentation Download License Support Purchase |

## SQLite Release 3.2.3 On 2005-08-21

- 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 and a chronology are both also available. A detailed history of every check-in is available at SQLite version control site.