Documentation Source Text

Check-in [5b3b975982]
Login

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

Overview
Comment:Mention the automerge enhancement in the release notes.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 5b3b975982874fb6d8bbcfae51ec2d8a27439fbe
User & Date: drh 2014-05-19 19:55:26.527
Context
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)
2014-05-16
11:28
Update fts3.html for recent changes to FTS. (check-in: ae994ce63a user: dan tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/changes.in.
19
20
21
22
23
24
25


26
27
28
29
30
31
32
}

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>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.







>
>







19
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.