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.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: c00394dd14f66dd1c77f126b7f7f196f4033f128
User & Date: drh 2013-10-14 13:15:29
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
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to pages/changes.in.

    14     14   set nChng 0
    15     15   proc chng {date desc {options {}}} {
    16     16     global nChng aChng
    17     17     set aChng($nChng) [list $date $desc $options]
    18     18     incr nChng
    19     19   }
    20     20   
    21         -chng {2013-10-?? (3.8.1)} {
           21  +chng {2013-10-18 (3.8.1)} {
    22     22   <li>Added the [unlikely()] and [likelihood()] SQL functions to be used
    23     23       as hints to the query planner.
    24         -<li>Added the [soft_heap_limit pragma].
    25         -<li>Enhancements the query planner:
           24  +<li>Enhancements to the query planner:
    26     25   <ul>
    27         -<li>Take into account WHERE clause terms that cannot be used with indices.
           26  +<li>Take into account the fact WHERE clause terms that cannot be used with indices
           27  +    still probably reduce the number of output rows.
    28     28   <li>Estimate the sizes of table and index rows and use the smallest applicable B-Tree
    29     29       for full scans and "count(*)" operations.
    30     30   </ul>
           31  +<li>Added the [soft_heap_limit pragma].
    31     32   <li>Added support for [SQLITE_ENABLE_STAT4]
    32     33   <li>Added support for "sz=NNN" parameters at the end of sqlite_stat1.stat fields
    33     34       used to specify the average length in bytes for table and index rows.
    34     35   <li>Avoid running foreign-key constraint checks on an UPDATE if none of the
    35     36       modified columns are associated with foreign keys.
    36     37   <li>Added the [SQLITE_MINIMUM_FILE_DESCRIPTOR] compile-time option
    37         -<li>Added the win32-longpath VFS on windows.
           38  +<li>Added the win32-longpath VFS on windows, permitting filenames up to 32K
           39  +    characters in length.
    38     40   <li>The [Date And Time Functions] are enhanced so that the current time
    39     41       (ex: julianday('now')) is always the same for multiple function invocations
    40     42       within the same [sqlite3_step()] call.
    41     43   <li>[FTS4] queries are better able to make use of docid<$limit constraints to
    42     44       limit the amount of I/O required.
    43     45   <li>The [VACUUM] command packs the database about 1% tighter.
    44     46   <li>The sqlite3_analyzer utility program is updated to provide better descriptions