Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Merge the 3.10.1 documentation changes. Update the change log for 3.11.0. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
e9bf814a4defafe2b1f96f118a6efb12 |
User & Date: | drh 2016-01-14 15:48:09.964 |
Context
2016-01-14
| ||
15:52 | Remove the AWK dependency from the amalgamation page. (check-in: fbbbdbca17 user: drh tags: trunk) | |
15:48 | Merge the 3.10.1 documentation changes. Update the change log for 3.11.0. (check-in: e9bf814a4d user: drh tags: trunk) | |
2016-01-13
| ||
21:46 | Add the release hashes to the change log for 3.10.1. (check-in: 9c12cf4cea user: drh tags: branch-3.10) | |
20:52 | Add documentation for the fts5 detail= option. (check-in: 08f6990b8a user: dan tags: trunk) | |
Changes
Changes to pages/changes.in.
︙ | ︙ | |||
20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 | incr nChng } chng {2016-03-00 (3.11.0)} { <p><b>General improvements:</b> <li>Enhanced [WAL mode] so that it works efficiently with transactions that are larger than the [cache_size]. } chng {2016-01-06 (3.10.0)} { <p><b>General improvements:</b> <li>Added support for [LIKE], [GLOB], and [REGEXP] operators on [virtual tables]. <li>Added the [colUsed field] to [sqlite3_index_info] for use by the [sqlite3_module.xBestIndex] method. <li>Enhance the [PRAGMA cache_spill] statement to accept a 32-bit integer | > > > > > > > > > > > > > > > > | 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 | incr nChng } chng {2016-03-00 (3.11.0)} { <p><b>General improvements:</b> <li>Enhanced [WAL mode] so that it works efficiently with transactions that are larger than the [cache_size]. <li>Added the [FTS5 detail option]. <li>Various performance optimizations. <p><b>Enhancements to the [command-line shell]:</b> <li>Added the ".vfslist" [dot-commands|dot-command]. } chng {2016-01-14 (3.10.1)} { <p><b>New feature:</b> <li>Add the [SQLITE_FCNTL_JOURNAL_POINTER] file control. <p><b>Bug fix:</b> <li>Fix a 16-month-old bug in the query planner that could generate incorrect results when a scalar subquery attempts to use the [block sorting] optimization. Ticket [https://www.sqlite.org/src/info/cb3aa0641d9a4|cb3aa0641d9a4]. <p><b>Hashes:</b> <li>SQLITE_SOURCE_ID: "2016-01-13 21:41:56 254419c36766225ca542ae873ed38255e3fb8588" <li>SHA1 for sqlite3.c: 1398ba8e4043550a533cdd0834bfdad1c9eab0f4 } {patchagainst 1} chng {2016-01-06 (3.10.0)} { <p><b>General improvements:</b> <li>Added support for [LIKE], [GLOB], and [REGEXP] operators on [virtual tables]. <li>Added the [colUsed field] to [sqlite3_index_info] for use by the [sqlite3_module.xBestIndex] method. <li>Enhance the [PRAGMA cache_spill] statement to accept a 32-bit integer |
︙ | ︙ |
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 {2016-01-06} {Release 3.10.0} { <p>SQLite [version 3.10.0] is a regularly scheduled maintenance release. } newsitem {2015-11-02} {Release 3.9.2} { <p>SQLite [version 3.9.2] is a patch release fixing two obscure bugs. | > > > > > > > > > | 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 | 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 {2016-01-14} {Release 3.10.1} { <p>SQLite [version 3.10.1] is a bug-fix release primarily targeting the fix for the query planner bug [https://www.sqlite.org/src/info/cb3aa0641d9a4|cb3aa0641d9a4] discovered by Mapscape. Also included is a minor API enhancement requested by the Firefox developers at Mozilla. The differences from version 3.10.0 are minimal. } newsitem {2016-01-06} {Release 3.10.0} { <p>SQLite [version 3.10.0] is a regularly scheduled maintenance release. } newsitem {2015-11-02} {Release 3.9.2} { <p>SQLite [version 3.9.2] is a patch release fixing two obscure bugs. |
︙ | ︙ |
Changes to pages/queryplanner.in.
︙ | ︙ | |||
674 675 676 677 678 679 680 | <p> The same basic algorithm is followed, except this time the matching rows of the index are scanned from bottom to top instead of from top to bottom, so that the states will appear in descending order. </p> | | | | 674 675 676 677 678 679 680 681 682 683 684 685 686 687 688 689 | <p> The same basic algorithm is followed, except this time the matching rows of the index are scanned from bottom to top instead of from top to bottom, so that the states will appear in descending order. </p> <tcl>hd_fragment {partialsort} {partial sorting by index} {block sorting}</tcl> <h3>3.2 Partial Sorting Using An Index (a.k.a. Block Sorting)</h3> <p> Sometimes only part of an ORDER BY clause can be satisfied using indexes. Consider, for example, the following query: </p> <tcl> |
︙ | ︙ |