Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Update changes and news in preparation for the 3.7.9 release. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
b78d9767b255507effe2445cd83bbacc |
User & Date: | drh 2011-10-31 17:20:37.083 |
Context
2011-11-01
| ||
13:14 | Add SHA1 hashes to the change-log for 3.7.9. (check-in: b2eb449d5e user: drh tags: trunk) | |
2011-10-31
| ||
17:20 | Update changes and news in preparation for the 3.7.9 release. (check-in: b78d9767b2 user: drh tags: trunk) | |
2011-10-21
| ||
18:36 | Add documentation for the SQLITE_DIRECT_OVERFLOW_READ compile-time option. (check-in: 02ece32458 user: drh tags: trunk) | |
Changes
Changes to pages/changes.in.
︙ | ︙ | |||
38 39 40 41 42 43 44 | http://www.sqlite.org/src/timeline</a>.</p> } hd_close_aux hd_enable_main 1 } } | | | 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 | http://www.sqlite.org/src/timeline</a>.</p> } hd_close_aux hd_enable_main 1 } } chng {2011 November 1 (3.7.9)} { <li>If a search token (on the right-hand side of the MATCH operator) in [FTS4] begins with "^" then that token must be the first in its field of the document. <b>** Potentially Incompatible Change **</b> <li>Added options [SQLITE_DBSTATUS_CACHE_HIT] and [SQLITE_DBSTATUS_CACHE_MISS] to the [sqlite3_db_status()] interface. <li>Removed support for [SQLITE_ENABLE_STAT2], replacing it with the much more capable [SQLITE_ENABLE_STAT3] option. |
︙ | ︙ | |||
75 76 77 78 79 80 81 82 83 84 85 86 87 88 | multiple aggregate functions whose arguments contain complicated expressions that differ only in the case of string literals contained within those expressions. <li>Fix a bug that prevented the [page_count] and [quick_check] pragmas from working correctly if their names were capitalized. <li>Fix a bug that caused [VACUUM] to fail if the [count_changes pragma] was engaged. } chng {2011 September 19 (3.7.8)} { <li> Orders of magnitude performance improvement for [CREATE INDEX] on very large tables. <li> Improved the windows VFS to better defend against interference from anti-virus software. | > > > | 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 | multiple aggregate functions whose arguments contain complicated expressions that differ only in the case of string literals contained within those expressions. <li>Fix a bug that prevented the [page_count] and [quick_check] pragmas from working correctly if their names were capitalized. <li>Fix a bug that caused [VACUUM] to fail if the [count_changes pragma] was engaged. <li>Fix a bug in [virtual table] implementation that causes a crash if an [FTS4] table is [DROP TABLE | dropped] inside a transaction and a [SAVEPOINT] occurs afterwards. } chng {2011 September 19 (3.7.8)} { <li> Orders of magnitude performance improvement for [CREATE INDEX] on very large tables. <li> Improved the windows VFS to better defend against interference from anti-virus software. |
︙ | ︙ |
Changes to pages/news.in.
︙ | ︙ | |||
14 15 16 17 18 19 20 21 22 23 24 25 26 27 | hd_puts "<h3>$date - $title</h3>" regsub -all "\n( *\n)+" $text "</p>\n\n<p>" txt regsub -all {[Tt]icket #(\d+)} $txt \ {<a href="http://www.sqlite.org/cvstrac/tktview?tn=\1">\0</a>} txt hd_resolve "<blockquote>$txt</blockquote>" hd_puts "<hr width=\"50%\">" } newsitem {2011-September-19} {Version 3.7.8} { SQLite [version 3.7.8] is a quarterly maintenance release. Upgrading from versions 3.7.6.3, 3.7.7, or 3.7.7.1 is optional. Upgrading from other versions is recommended. This release features a new "external merge sort" algorithm used to | > > > > > > > > > > > > > > > > > > > > > > > > > | 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 | hd_puts "<h3>$date - $title</h3>" regsub -all "\n( *\n)+" $text "</p>\n\n<p>" txt regsub -all {[Tt]icket #(\d+)} $txt \ {<a href="http://www.sqlite.org/cvstrac/tktview?tn=\1">\0</a>} txt hd_resolve "<blockquote>$txt</blockquote>" hd_puts "<hr width=\"50%\">" } newsitem {2011-November-01} {Version 3.7.9} { SQLite [version 3.7.9] is a regularly scheduled maintenance release. Upgrading from version 3.7.6.3, 3.7.7, 3.7.7.1, and 3.7.8 is optional. Upgrading from other versions is recommended. The [SQLITE_ENABLE_STAT2] compile-time option is no a no-op. The enhanced query-planner functionality formerly available using SQLITE_ENABLE_STAT2 is now available through [SQLITE_ENABLE_STAT3]. The enhanced query planning is still disabled by default. However, future releases of SQLite might convert STAT3 from and enable-option to a disable-option so that it is available by default and is only omitted upon request. The [FTS4] full-text search engine has been enhanced such that tokens in the search string that begin with "^" must be the first token in their respective columns in order to match. Formerly, "^" characters in the search string were simply ignored. Hence, if a legacy application was including "^" characters in FTS4 search strings, thinking that they would always be ignored, then those legacy applications might break with this update. The fix is simply remove the "^" characters from the search string. See the [version 3.7.9 | change summary] for additional changes associated with this release. } newsitem {2011-September-19} {Version 3.7.8} { SQLite [version 3.7.8] is a quarterly maintenance release. Upgrading from versions 3.7.6.3, 3.7.7, or 3.7.7.1 is optional. Upgrading from other versions is recommended. This release features a new "external merge sort" algorithm used to |
︙ | ︙ |