Documentation Source Text

Check-in [83657094be]
Login

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

Overview
Comment:Update the change log to comment on the NOT NULL and CHECK constraint optimization.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 83657094beaddb3d56b458e8147fdfcb0ab01228
User & Date: drh 2016-02-10 19:16:14.032
Context
2016-02-12
05:18
Merge changes from the 3.10 branch. (check-in: 09a0fd52d7 user: drh tags: trunk)
2016-02-10
19:16
Update the change log to comment on the NOT NULL and CHECK constraint optimization. (check-in: 83657094be user: drh tags: trunk)
13:51
Merge download page enhancements from the 3.10 branch. (check-in: dd43be4bec user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/changes.in.
︙︙
27
28
29
30
31
32
33


34
35
36
37
38
39
40
41
42

<li>Added the [FTS5 detail option].
<li>Added the "EXTRA" option to [PRAGMA synchronous] that does a sync of the
    containing directory when a rollback journal is unlinked in DELETE mode,
    for better durability.  The [SQLITE_EXTRA_DURABLE] compile-time option enables
    [PRAGMA synchronous=EXTRA] by default.
<li>Enhanced the [query planner] so that it is able to use
    a [covering index] as part of the [OR optimization].


<li>Many micro-optimizations, resulting in a library that is both smaller
    and faster than the previous release.
<p><b>Enhancements to the [command-line shell]:</b>
<li>By default, the shell is now in "auto-explain" mode.  The output of
    [EXPLAIN] commands is automatically formatted.
<li>Added the ".vfslist" [dot-commands|dot-command].
<li>The [SQLITE_ENABLE_EXPLAIN_COMMENTS] compile-time option is now turned
    on by default in the standard builds.
<p><b>Enhancements to the [TCL Interface]:</b>








>
>
|
|








27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44

<li>Added the [FTS5 detail option].
<li>Added the "EXTRA" option to [PRAGMA synchronous] that does a sync of the
    containing directory when a rollback journal is unlinked in DELETE mode,
    for better durability.  The [SQLITE_EXTRA_DURABLE] compile-time option enables
    [PRAGMA synchronous=EXTRA] by default.
<li>Enhanced the [query planner] so that it is able to use
    a [covering index] as part of the [OR optimization].
<li>Avoid recomputing [NOT NULL] and [CHECK constraints] on unchanged
    columns in [UPDATE] statement.
<li>Many micro-optimizations, resulting in a library that is 
    faster than the previous release.
<p><b>Enhancements to the [command-line shell]:</b>
<li>By default, the shell is now in "auto-explain" mode.  The output of
    [EXPLAIN] commands is automatically formatted.
<li>Added the ".vfslist" [dot-commands|dot-command].
<li>The [SQLITE_ENABLE_EXPLAIN_COMMENTS] compile-time option is now turned
    on by default in the standard builds.
<p><b>Enhancements to the [TCL Interface]:</b>
︙︙