Sqlite 发布3.23版本

今天无意中看见 Sqlite 更新了

具体更新信息如下：

 

2005 August 21 (3.2.3)

• 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

英语不是太好，怕翻译错了

所以没有翻译

下载地址：
http://sqlite.org/download.html