Documentation Source Text

Check-in [6aca55b1f8]
Login

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

Overview
Comment:Fix typo in the change log.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 6aca55b1f88e97d7904dcba03737eb0868f7d379815cf10bf21db8e68aed05ad
User & Date: drh 2017-05-12 02:13:35.712
Context
2017-05-12
20:17
Mention the anycollseq.c loadable extension in the release notes. (check-in: c7eb4e0706 user: drh tags: trunk)
02:13
Fix typo in the change log. (check-in: 6aca55b1f8 user: drh tags: trunk)
2017-05-11
18:44
Add the json_extract() enhancement to the change log. (check-in: 48487a9f5c user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/changes.in.
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
<li> On a DISTINCT query that uses an index, try to skip ahead to the next distinct
     entry using the index rather that stepping through rows, when an appropriate
     index is available.
<li> Avoid unnecessary invalidation of [sqlite3_blob] handles when making
     changes to unrelated tables.
<li> Transfer any terms of the HAVING clause that use only columns mentioned in
     the GROUP BY clause over to the WHERE clause for faster processing.
<li> Reuse the same materialization of a VIEW if that VIEW appears more then
     once in the same query.
<li> Enhance [PRAGMA integrity_check] so that it identifies tables that have two
     or more rows with the same [rowid].
<li> Enhance the [FTS5] query syntax so that [FTS5 column filters|column filters]
     may be applied to arbitrary expressions.
<li> Enhance the [json_extract()] function to cache and reuse parses of JSON
     input text.







|







37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
<li> On a DISTINCT query that uses an index, try to skip ahead to the next distinct
     entry using the index rather that stepping through rows, when an appropriate
     index is available.
<li> Avoid unnecessary invalidation of [sqlite3_blob] handles when making
     changes to unrelated tables.
<li> Transfer any terms of the HAVING clause that use only columns mentioned in
     the GROUP BY clause over to the WHERE clause for faster processing.
<li> Reuse the same materialization of a VIEW if that VIEW appears more than
     once in the same query.
<li> Enhance [PRAGMA integrity_check] so that it identifies tables that have two
     or more rows with the same [rowid].
<li> Enhance the [FTS5] query syntax so that [FTS5 column filters|column filters]
     may be applied to arbitrary expressions.
<li> Enhance the [json_extract()] function to cache and reuse parses of JSON
     input text.