SQLite (32-bit) 歷史版本列表
更新時間：2020-06-18
更新細節：
What's new in this version:
- Various minor bug fixes including fixes for tickets
更新時間：2020-06-04
更新細節：
What's new in this version:
- Fix a long-standing bug in the byte-code engine that can cause a COMMIT command report as success when in fact it failed to commit
更新時間：2020-05-25
更新細節：
更新時間：2020-05-23
更新細節：
更新時間：2020-01-28
更新細節：
更新時間：2020-01-24
更新細節：
更新時間：2019-10-11
更新細節：
What's new in this version:
- Fix a bug in the query flattener that might cause a segfault for nested queries that use the new FILTER clause on aggregate functions
- Cherrypick fixes for other obscure problems found since the 3.30.0 release
更新時間：2019-10-04
更新細節：
What's new in this version:
- Add support for the FILTER clause on aggregate functions
- Add support for the NULLS FIRST and NULLS LAST syntax in ORDER BY clauses
- The index_info and index_xinfo pragmas are enhanced to provide information about the on-disk representation of WITHOUT ROWID tables
- Add the sqlite3_drop_modules() interface, allowing applications to disable automatically loaded virtual tables that they do not need
- Improvements to the .recover dot-command in the CLI so that it recovers more content from corrupt database files
- Enhance the RBU extension to support indexes on expressions
- Change the schema parser so that it will error out if any of the type, name, and tbl_name columns of the sqlite_master table have been corrupted and the database connection is not in writable_schema mode
- The PRAGMA function_list, PRAGMA module_list, and PRAGMA pragma_list commands are now enabled in all builds by default. Disable them using -DSQLITE_OMIT_INTROSPECTION_PRAGMAS
- Add the SQLITE_DBCONFIG_ENABLE_VIEW option for sqlite3_db_config()
- Added the TCL Interface config method in order to be able to disable SQLITE_DBCONFIG_ENABLE_VIEW as well as control other sqlite3_db_config() options from TCL
- Added the SQLITE_DIRECTONLY flag for application-defined SQL functions to prevent those functions from being used inside triggers and views
- The legacy SQLITE_ENABLE_STAT3 compile-time option is now a no-op
更新時間：2019-07-11
更新細節：
What's new in this version:
- Added the SQLITE_DBCONFIG_DQS_DML and SQLITE_DBCONFIG_DQS_DDL actions to sqlite3_db_config() for activating and deactivating the double-quoted string literal misfeature. Both default to "on" for legacy compatibility, but developers are encouraged to turn them "off", perhaps using the -DSQLITE_DQS=0 compile-time option
- DSQLITE_DQS=0 is now a recommended compile-time option
Improvements to the query planner:
- Improved optimization of AND and OR operators when one or the other operand is a constant
- Enhancements to the LIKE optimization for cases when the left-hand side column has numeric affinity
- Added the "sqlite_dbdata" virtual table for extracting raw low-level content from an SQLite database, even a database that is corrupt
Enhancements to the CLI:
- Add the ".recover" command which tries to recover as much content as possible from a corrupt database file
- Add the ".filectrl" command useful for testing
- Add the long-standing ".testctrl" command to the ".help" menu
- Added the ".dbconfig" command
Hashes:
- SQLITE_SOURCE_ID: 2019-07-10 17:32:03 fc82b73eaac8b36950e527f12c4b5dc1e147e6f4ad2217ae43ad82882a88bfa6
- SHA3-256 for sqlite3.c: d9a5daf7697a827f4b2638276ce639fa04e8e8bb5fd3a6b683cfad10f1c81b12
更新時間：2019-04-17
更新細節：
What's new in this version:
Enhanced window functions:
- Add support the EXCLUDE clause
- Add support for window chaining
- Add support for GROUPS frames
- Add support for " PRECEDING" and " FOLLOWING" boundaries in RANGE frames
- Added the new sqlite3_stmt_isexplain(S) interface for determining whether or not a prepared statement is an EXPLAIN
- Enhanced VACUUM INTO so that it works for read-only databases
New query optimizations:
- Enable the LIKE optimization for cases when the ESCAPE keyword is present and PRAGMA case_sensitive_like is on
- In queries that are driven by a partial index, avoid unnecessary tests of the constraint named in the WHERE clause of the partial index, since we know that constraint must always be true
Enhancements to the TCL Interface:
- Added the -returntype option to the function method
- Added the new bind_fallback method
Enhancements to the CLI:
- Added support for bound parameters and the .parameter command
- Fix the readfile() function so that it returns an empty BLOB rather than throwing an out-of-memory error when reading an empty file
- Fix the writefile() function so that when it creates new directories along the path of a new file, it gives them umask permissions rather than the same permissions as the file
- Change --update option in the .archive command so that it skips files that are already in the archive and are unchanged. Add the new --insert option that works like --update used to work
- Added the fossildelta.c extension that can create, apply, and deconstruct the Fossil DVCS file delta format that is used by the RBU extension
- Added the SQLITE_DBCONFIG_WRITABLE_SCHEMA verb for the sqlite3_db_config() interface, that does the same work as PRAGMA writable_schema without using the SQL parser
- Added the sqlite3_value_frombind() API for determining if the argument to an SQL function is from a bound parameter
Security and compatibilities enhancements to fts3_tokenizer():
- The fts3_tokenizer() function always returns NULL unless either the legacy application-defined FTS3 tokenizers interface are enabled using the sqlite3_db_config(SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER) setting, or unless the first argument to fts3_tokenizer() is a bound parameter
- The two-argument version of fts3_tokenizer() accepts a pointer to the tokenizer method object even without the sqlite3_db_config(SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER) setting if the second argument is a bound parameter
- Improved robustness against corrupt database files
- Miscellaneous performance enhancements
- Established a Git mirror of the offical SQLite source tree. The canonical sources for SQLite are maintained using the Fossil DVCS