SQLite 歷史版本列表
SQLite (32-bit)SQLite (64-bit)
更新時間：2016-10-18
更新細節：
What's new in this version:
- Added support for row values
- Allow deterministic SQL functions in the WHERE clause of a partial index
- Added the "modeof=filename" URI parameter on the unix VFS
- Added support for SQLITE_DBCONFIG_MAINDBNAME
- Added the ability to VACUUM an ATTACH-ed database
Enhancements to the command-line shell:
- Add the ".testcase" and ".check" dot-commands
- Added the --new option to the ".open" dot-command, causing any prior content in the database to be purged prior to opening
- Enhance the fts5vocab virtual table to handle "ORDER BY term" efficiently
- Miscellaneous micro-optimizations reduce CPU usage by more than 7% on common workloads. Most optimization in this release has been on the front-end (sqlite3_prepare_v2()).
Bug Fixes:
- The multiply operator now correctly detects 64-bit integer overflow and promotes to floating point in all corner-cases. Fix for ticket 1ec41379c9c1e400.
- Correct handling of columns with redundant unique indexes when those columns are used on the LHS of an IN operator. Fix for ticket 0eab1ac759.
- Skip NULL entries on range queries in indexes on expressions. Fix for ticket 4baa46491212947.
- Ensure that the AUTOINCREMENT counters in the sqlite_sequence table are initialized doing "Xfer Optimization" on "INSERT ... SELECT" statements. Fix for ticket 7b3328086a5c116c.
- Make sure the ORDER BY LIMIT optimization (from check-in 559733b09e) works with IN operators on INTEGER PRIMARY KEYs. Fix for ticket 96c1454c
更新時間：2016-10-18
更新細節：
What's new in this version:
- Added support for row values
- Allow deterministic SQL functions in the WHERE clause of a partial index
- Added the "modeof=filename" URI parameter on the unix VFS
- Added support for SQLITE_DBCONFIG_MAINDBNAME
- Added the ability to VACUUM an ATTACH-ed database
Enhancements to the command-line shell:
- Add the ".testcase" and ".check" dot-commands
- Added the --new option to the ".open" dot-command, causing any prior content in the database to be purged prior to opening
- Enhance the fts5vocab virtual table to handle "ORDER BY term" efficiently
- Miscellaneous micro-optimizations reduce CPU usage by more than 7% on common workloads. Most optimization in this release has been on the front-end (sqlite3_prepare_v2()).
Bug Fixes:
- The multiply operator now correctly detects 64-bit integer overflow and promotes to floating point in all corner-cases. Fix for ticket 1ec41379c9c1e400.
- Correct handling of columns with redundant unique indexes when those columns are used on the LHS of an IN operator. Fix for ticket 0eab1ac759.
- Skip NULL entries on range queries in indexes on expressions. Fix for ticket 4baa46491212947.
- Ensure that the AUTOINCREMENT counters in the sqlite_sequence table are initialized doing "Xfer Optimization" on "INSERT ... SELECT" statements. Fix for ticket 7b3328086a5c116c.
- Make sure the ORDER BY LIMIT optimization (from check-in 559733b09e) works with IN operators on INTEGER PRIMARY KEYs. Fix for ticket 96c1454c
更新時間：2016-05-09
更新細節：
What's new in this version:
- Local (unofficial) release (shows version 2.84)
Local Changes:
- Fix spurious stopped announce
- Added SSL support for remote sessions
- Added automatic redirection when remote session's daemon has a modified path
- Fixed sparse .part file allocation
- Built with gcc 6.1.0
- Using curl 7.48.0
- Using OpenSSL 1.0.2h
- Installer built with InstallBuilder 16.4.0
更新時間：2015-11-24
更新細節：
更新時間：2013-08-30
更新細節：
What's new in this version:
- New: Latvian, Bulgarian translation
- Fixed: minor configuration problems
- Updated group policy file