Documentation Source Text

Check-in [c00394dd14]
Login

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

Overview
Comment:Tweaks to the change log. Set an estimated release date for 3.8.1 of 2013-10-18.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: c00394dd14f66dd1c77f126b7f7f196f4033f128
User & Date: drh 2013-10-14 13:15:29.445
Context
2013-10-14
17:31
Add a mention of the SQLITE_TMPDIR environment variable in the change log. (check-in: b5aece674f user: drh tags: trunk)
13:15
Tweaks to the change log. Set an estimated release date for 3.8.1 of 2013-10-18. (check-in: c00394dd14 user: drh tags: trunk)
2013-10-12
20:43
Update the change log and the pragma documentation to reflect restoring PRAGMA index_list to its old behavior. (check-in: d585c58e71 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/changes.in.
14
15
16
17
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
set nChng 0
proc chng {date desc {options {}}} {
  global nChng aChng
  set aChng($nChng) [list $date $desc $options]
  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>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







|


<
|

|
>



>






|
>







14
15
16
17
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
set nChng 0
proc chng {date desc {options {}}} {
  global nChng aChng
  set aChng($nChng) [list $date $desc $options]
  incr nChng
}

chng {2013-10-18 (3.8.1)} {
<li>Added the [unlikely()] and [likelihood()] SQL functions to be used
    as hints to the query planner.

<li>Enhancements to the query planner:
<ul>
<li>Take into account the fact WHERE clause terms that cannot be used with indices
    still probably reduce the number of output rows.
<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 the [soft_heap_limit pragma].
<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>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, permitting filenames up to 32K
    characters in length.
<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