Documentation Source Text

Check-in [b65a1fd59e]
Login

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

Overview
Comment:Mention the FTS5 column filter enhancement in the change log.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: b65a1fd59eb13184c84360d1fb3cf0cac5b185c39c18cdc3e7a81c97b47411cd
User & Date: drh 2017-05-11 15:55:20.331
Context
2017-05-11
18:44
Add the json_extract() enhancement to the change log. (check-in: 48487a9f5c user: drh tags: trunk)
15:55
Mention the FTS5 column filter enhancement in the change log. (check-in: b65a1fd59e user: drh tags: trunk)
13:36
Fix the description of the SQLITE_READ authorizer change in the change log. (check-in: fd8d8bb382 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/changes.in.
41
42
43
44
45
46
47


48
49
50
51
52
53
54
     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].


<p><b>Bug Fixes:</b>
<li> Fix a problem in [REPLACE] that can result in a corrupt database containing
     two ore more rows with the same [rowid].  Fix for ticket
     [https://www.sqlite.org/src/info/f68dc596c4e6018d|f68dc596c4e6018d].
<li> Fix a problem in [PRAGMA integrity_check] that was causing a subsequent
     [VACUUM] to behave suboptimally.
<li> Fix the [PRAGMA foreign_key_check] command so that it works correctly with







>
>







41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
     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.
<p><b>Bug Fixes:</b>
<li> Fix a problem in [REPLACE] that can result in a corrupt database containing
     two ore more rows with the same [rowid].  Fix for ticket
     [https://www.sqlite.org/src/info/f68dc596c4e6018d|f68dc596c4e6018d].
<li> Fix a problem in [PRAGMA integrity_check] that was causing a subsequent
     [VACUUM] to behave suboptimally.
<li> Fix the [PRAGMA foreign_key_check] command so that it works correctly with