Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Update docs for the 3.10.1 release. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | branch-3.10 |
Files: | files | file ages | folders |
SHA1: |
b01206d6afcd59d516e19494225f635f |
User & Date: | drh 2016-01-13 18:40:37.788 |
Context
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) | |
18:40 | Update docs for the 3.10.1 release. (check-in: b01206d6af user: drh tags: branch-3.10) | |
2016-01-12
| ||
13:44 | Fix typos in the TCL interface documentation. (check-in: 217ea4895f user: drh tags: branch-3.10) | |
Changes
Changes to pages/changes.in.
︙ | ︙ | |||
15 16 17 18 19 20 21 22 23 24 25 26 27 28 | <tcl> set nChng 0 proc chng {date desc {options {}}} { global nChng aChng set aChng($nChng) [list $date $desc $options] incr nChng } 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 | > > > > > > > | 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 | <tcl> set nChng 0 proc chng {date desc {options {}}} { global nChng aChng set aChng($nChng) [list $date $desc $options] incr nChng } chng {2016-01-14 (3.10.1)} { <li>Add the [SQLITE_FCNTL_JOURNAL_POINTER] file control. <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]. } {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/index.in.
︙ | ︙ | |||
106 107 108 109 110 111 112 | </td> <td width="20"></td><td bgcolor="#044a64" width="1"></td><td width="20"></td> <td valign="top"> <h3>Current Status</h3> <p><ul> | | | 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 | </td> <td width="20"></td><td bgcolor="#044a64" width="1"></td><td width="20"></td> <td valign="top"> <h3>Current Status</h3> <p><ul> <li><a href="releaselog/3_10_1.html">Version 3.10.1</a> of SQLite is recommended for all new development. </li> </ul></p> <h3>Common Links</h3> <p><ul> |
︙ | ︙ |
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> |
︙ | ︙ |