Documentation Source Text

Check-in [c0ce61ad28]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Clarification in the text of the release notes for 3.8.5.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: c0ce61ad28f33eefa0f28802244c8b7f9c55460e
User & Date: drh 2014-05-19 20:00:53.096
Context
2014-05-24
16:20
Update the change log for 3.8.5. Fix a typo in the isolation.html document. (check-in: ee616cbbb3 user: drh tags: trunk)
2014-05-22
10:00
Fix a typo in FAQ item 14. (check-in: 1b0ed95a32 user: dan tags: trunk)
2014-05-19
20:00
Clarification in the text of the release notes for 3.8.5. (check-in: c0ce61ad28 user: drh tags: trunk)
19:55
Mention the automerge enhancement in the release notes. (check-in: 5b3b975982 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/changes.in.
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34

chng {2014-06-?? (3.8.5)} {
<li>Added support for sorting subsets of the result when the result comes out of the query
    engine already partially sorted.
<li>Enhance the query planner so that it always prefers an index that uses a superset of
    WHERE clause terms relative to some other index.
<li>Improvements to the [automerge command] of [FTS4] to better control the index size
    for a full-text index on a FIFO of documents.
<li>Added the [SQLITE_TESTCTRL_BYTEORDER] test control.
<li>Added the [sqlite3_rtree_query_callback()] interface to [R-Tree extension]
<li>Added the [SQLITE_IOCAP_IMMUTABLE] bit to the set of bits that can be returned by
    the xDeviceCharacteristics method of a [VFS].
<li>Added new [URI query parameters] "nolock" and "immutable".
query<p><b>Bug Fixes:</b>
<li>OFFSET clause ignored on queries without a FROM clause.







|







20
21
22
23
24
25
26
27
28
29
30
31
32
33
34

chng {2014-06-?? (3.8.5)} {
<li>Added support for sorting subsets of the result when the result comes out of the query
    engine already partially sorted.
<li>Enhance the query planner so that it always prefers an index that uses a superset of
    WHERE clause terms relative to some other index.
<li>Improvements to the [automerge command] of [FTS4] to better control the index size
    for a full-text index that is subject to a large number of updates.
<li>Added the [SQLITE_TESTCTRL_BYTEORDER] test control.
<li>Added the [sqlite3_rtree_query_callback()] interface to [R-Tree extension]
<li>Added the [SQLITE_IOCAP_IMMUTABLE] bit to the set of bits that can be returned by
    the xDeviceCharacteristics method of a [VFS].
<li>Added new [URI query parameters] "nolock" and "immutable".
query<p><b>Bug Fixes:</b>
<li>OFFSET clause ignored on queries without a FROM clause.