Documentation Source Text

Check-in [25c7b7896e]
Login

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

Overview
Comment:Updates to the 3.8.7 change log.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 25c7b7896ea56a59ffa8b45422286cc34f708f78
User & Date: drh 2014-10-08 18:30:56
Context
2014-10-11
10:52
Add the DESC GROUP BY ORDER BY bug to the changes page for 3.8.7. check-in: 78bc13ed79 user: drh tags: trunk
2014-10-08
18:30
Updates to the 3.8.7 change log. check-in: 25c7b7896e user: drh tags: trunk
2014-10-07
12:40
Add the not-found.html page. check-in: 2e2274895f user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/changes.in.

23
24
25
26
27
28
29
30
31
32
33
34
35
36
37



38
39
40
41
42
43
44
45
46
47
48
49

50
51

52
53
54
55
56
57
58
59
60











61
62
63
64
65
66
67
<li>Many micro-optimizations result in 18% more work for the same number
    of CPU cycles relative to the previous release. 
    The cumulative performance increase since [version 3.8.0] is 58%.
    (Measured using 
    [http://valgrind.org/docs/manual/cg-manual.html|cachegrind] on the
    [http://www.sqlite.org/src/artifact/83f6b3318f7ee|speedtest1.c] workload on
    Ubuntu 13.10 x64 with gcc 4.8.1 and -Os. Your performance may vary.)
<li>Provide the ability for the sorter to start and use auxiliary helper threads in order
    to increase real-time response.  This feature is off by default and may be
    enabled using the [PRAGMA threads] command or the [SQLITE_DEFAULT_WORKER_THREADS]
    compile-time option.
<li>Enhance the [skip-scan] optimization so that it is able to skip index terms that
    occur in the middle of the index, not just as the left-hand side of the index.
<li>The query planner is now able to do a better job of understanding constants that
    occur inside of [CAST] operators.



<li>Added new interfaces with 64-bit length parameters:
    [sqlite3_malloc64()],
    [sqlite3_realloc64()],
    [sqlite3_bind_blob64()],
    [sqlite3_result_blob64()],
    [sqlite3_bind_text64()], and
    [sqlite3_result_text64()].
<li>Added the new interface [sqlite3_msize()] that returns the size of a memory allocation
    obtained from [sqlite3_malloc64()] and its variants.
<p><b>New Features:</b>
<li>Added the [SQLITE_LIMIT_WORKER_THREADS] option to [sqlite3_limit()] and
    [PRAGMA threads] command for configuring the number of available worker threads.

<li>Added new options to the [command-line shell] for configuring auxiliary
    memory usage: --pagecache, --lookaside, and --scratch.

<p><b>Bug Fixes:</b>
<li>Fix a bug in the [partial index] implementation that might result in an incorrect
    answer if a partial index is used in a subquery or in a [view].
    Ticket [http://www.sqlite.org/src/info/98d973b8f5|98d973b8f5]
<li>Fix a bug in [sqlite3_trace()] that was causing it to sometimes fail to print
    an SQL statement if that statement needed to be re-prepared.
    Ticket [http://www.sqlite.org/src/info/11d5aa455e0d98f3c1e6a08|11d5aa455e0d98f3c1e6a08]
<li>Fix a faulty assert() statement.
    Ticket [http://www.sqlite.org/src/info/369d57fb8e5ccdff06f1|369d57fb8e5ccdff06f1]











}

chng {2014-08-15 (3.8.6)} {
<li>Added support for [hexadecimal integer literals] in the SQL parser.
    (Ex: 0x123abc)
<li>Enhanced the [PRAGMA integrity_check] command to detect [UNIQUE] and
    [NOT NULL] constraint violations.







|
|




<
|
>
>
>









<


>
|
|
>









>
>
>
>
>
>
>
>
>
>
>







23
24
25
26
27
28
29
30
31
32
33
34
35

36
37
38
39
40
41
42
43
44
45
46
47
48

49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
<li>Many micro-optimizations result in 18% more work for the same number
    of CPU cycles relative to the previous release. 
    The cumulative performance increase since [version 3.8.0] is 58%.
    (Measured using 
    [http://valgrind.org/docs/manual/cg-manual.html|cachegrind] on the
    [http://www.sqlite.org/src/artifact/83f6b3318f7ee|speedtest1.c] workload on
    Ubuntu 13.10 x64 with gcc 4.8.1 and -Os. Your performance may vary.)
<li>The sorter can use auxiliary helper threads to increase real-time response.
    This feature is off by default and may be
    enabled using the [PRAGMA threads] command or the [SQLITE_DEFAULT_WORKER_THREADS]
    compile-time option.
<li>Enhance the [skip-scan] optimization so that it is able to skip index terms that
    occur in the middle of the index, not just as the left-hand side of the index.

<li>Improved optimization of [CAST] operators.
<li>Various improvements in how the query planner uses [sqlite_stat4]
    information to estimate plan costs.
<p><b>New Features:</b>
<li>Added new interfaces with 64-bit length parameters:
    [sqlite3_malloc64()],
    [sqlite3_realloc64()],
    [sqlite3_bind_blob64()],
    [sqlite3_result_blob64()],
    [sqlite3_bind_text64()], and
    [sqlite3_result_text64()].
<li>Added the new interface [sqlite3_msize()] that returns the size of a memory allocation
    obtained from [sqlite3_malloc64()] and its variants.

<li>Added the [SQLITE_LIMIT_WORKER_THREADS] option to [sqlite3_limit()] and
    [PRAGMA threads] command for configuring the number of available worker threads.
<li>The [spellfix1] extension allows the application to optionally specify the rowid for
    each INSERT.
<li>Added the [http://www.sqlite.org/src/doc/trunk/ext/userauth/user-auth.txt|User Authentication]
    extension.
<p><b>Bug Fixes:</b>
<li>Fix a bug in the [partial index] implementation that might result in an incorrect
    answer if a partial index is used in a subquery or in a [view].
    Ticket [http://www.sqlite.org/src/info/98d973b8f5|98d973b8f5]
<li>Fix a bug in [sqlite3_trace()] that was causing it to sometimes fail to print
    an SQL statement if that statement needed to be re-prepared.
    Ticket [http://www.sqlite.org/src/info/11d5aa455e0d98f3c1e6a08|11d5aa455e0d98f3c1e6a08]
<li>Fix a faulty assert() statement.
    Ticket [http://www.sqlite.org/src/info/369d57fb8e5ccdff06f1|369d57fb8e5ccdff06f1]
<p><b>Test, Debug, and Analysis Changes:</b>
<li>Show ASCII-art abstract syntax tree diagrams using the ".selecttrace"
    and ".wheretrace" commands in the 
    [command-line shell] when compiled with [SQLITE_DEBUG], SQLITE_ENABLE_SELECTTRACE,
    and SQLITE_ENABLE_WHERETRACE.  Also provide the sqlite3TreeViewExpr() and
    sqlite3TreeViewSelect() entry points that can be invoked from with the
    debugger to show the parse tree when stopped at a breakpoint.
<li>Drop support for SQLITE_ENABLE_TREE_EXPLAIN.  The SELECTTRACE mechanism provides
    more useful diagnostics information.
<li>Added new options to the [command-line shell] for configuring auxiliary
    memory usage: --pagecache, --lookaside, and --scratch.
}

chng {2014-08-15 (3.8.6)} {
<li>Added support for [hexadecimal integer literals] in the SQL parser.
    (Ex: 0x123abc)
<li>Enhanced the [PRAGMA integrity_check] command to detect [UNIQUE] and
    [NOT NULL] constraint violations.