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 | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
c00394dd14f66dd1c77f126b7f7f196f |
| 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
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
|