Documentation Source Text

Check-in [c508b3c51a]
Login

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

Overview
Comment:Edits to the change log.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: c508b3c51a5ca1e10ba64b7a5524c158d625c7fc
User & Date: drh 2013-10-11 14:18:23.823
Context
2013-10-11
20:16
Improve the text (rephrasing, not changing the meaning) of some requirements related to functions and pragmas. Improve or correct requirements marks. (check-in: 77dee5dcd0 user: drh tags: trunk)
14:18
Edits to the change log. (check-in: c508b3c51a user: drh tags: trunk)
2013-10-08
15:07
Revise the description of the Tcler's wiki database corruption event. (check-in: 63ad7e56b1 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/changes.in.
︙︙
18
19
20
21
22
23
24
25

26



27







28
29
30
31
32
33
34
35
36
37

38
39
40
41
42
43
44

  incr nChng
}

chng {2013-10-?? (3.8.1)} {
<li>Added the [unlikely()] and [likelihood()] SQL functions to be used
    as hints to the query planner.
<li>Added the [soft_heap_limit pragma].
<li>Tweaked the query planner to take into account WHERE clause terms

    that cannot be used with indices.



<li>Added support for [SQLITE_ENABLE_STAT4]







<li>Added the [SQLITE_MINIMUM_FILE_DESCRIPTOR] compile-time option
<li>Added the win32-longpath VFS on windows.
<li>The [Date And Time Functions] are enhanced so that the current time
    (ex: julianday('now')) is always the same for multiple function invocations
    within the same [sqlite3_step()] call.
<li>[FTS4] queries are better able to make use of docid<$limit constraints to
    limit the amount of I/O required.
<li>The [VACUUM] command packs the database about 1% tighter.
<li>The sqlite3_analyzer utility program is updated to provide better descriptions
    and to compute a more accurate estimate for "Non-sequential pages"

<li><b>Bug fix:</b> Return the correct answer for "SELECT count(*) FROM table" even if
    there is a [partial index] on the table. Ticket
    [http://www.sqlite.org/src/info/a5c8ed66ca|a5c8ed66ca].
}

chng {2013-09-03 (3.8.0.2)} {
<li>Fix a bug in the optimization that attempts to omit unused LEFT JOINs








|
>
|
>
>
>

>
>
>
>
>
>
>










>








18
19
20
21
22
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

  incr nChng
}

chng {2013-10-?? (3.8.1)} {
<li>Added the [unlikely()] and [likelihood()] SQL functions to be used
    as hints to the query planner.
<li>Added the [soft_heap_limit pragma].
<li>Enhancements the query planner:
<ul>
<li>Take into account WHERE clause terms that cannot be used with indices.
<li>Estimate the sizes of table and index rows and use the smallest applicable B-Tree
    for full scans and "count(*)" operations.
</ul>
<li>Added support for [SQLITE_ENABLE_STAT4]
<li>Added support for "sz=NNN" parameters at the end of sqlite_stat1.stat fields
    used to specify the average length in bytes for table and index rows.
<li>Changed the [index_list pragma] so that it shows the estimated size of index
    rows and so that it shows a new row for the PRIMARY KEY index that gives the
    estimated size of table rows.
<li>Avoid running foreign-key constraint checks on an UPDATE if none of the
    modified columns are associated with foreign keys.
<li>Added the [SQLITE_MINIMUM_FILE_DESCRIPTOR] compile-time option
<li>Added the win32-longpath VFS on windows.
<li>The [Date And Time Functions] are enhanced so that the current time
    (ex: julianday('now')) is always the same for multiple function invocations
    within the same [sqlite3_step()] call.
<li>[FTS4] queries are better able to make use of docid<$limit constraints to
    limit the amount of I/O required.
<li>The [VACUUM] command packs the database about 1% tighter.
<li>The sqlite3_analyzer utility program is updated to provide better descriptions
    and to compute a more accurate estimate for "Non-sequential pages"
<li>Refactor the implementation of PRAGMA statements to improve parsing performance.
<li><b>Bug fix:</b> Return the correct answer for "SELECT count(*) FROM table" even if
    there is a [partial index] on the table. Ticket
    [http://www.sqlite.org/src/info/a5c8ed66ca|a5c8ed66ca].
}

chng {2013-09-03 (3.8.0.2)} {
<li>Fix a bug in the optimization that attempts to omit unused LEFT JOINs
︙︙