Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Record the incremental vacuum enhancements in the change-log for 3.7.16. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: | 638d9567ad3546fe287fde37d47b912bdd9e1167 |
| User & Date: | drh 2013-02-25 15:48:38 |
Context
|
2013-03-02
| ||
| 16:20 | Move future downloads into subdirectories to try to stem the growth in the number of files in the root directory of the website. check-in: 4d9a64a055 user: drh tags: trunk | |
|
2013-02-25
| ||
| 15:48 | Record the incremental vacuum enhancements in the change-log for 3.7.16. check-in: 638d9567ad user: drh tags: trunk | |
| 14:52 | Add documentation for the unicode() and char() functions. check-in: 0b81bc6851 user: drh tags: trunk | |
Changes
Changes to pages/changes.in.
42 43 44 45 46 47 48 49 50 51 52 53 54 55 |
}
}
chng {2013-03-12 (3.7.16)} {
<li>Added the [PRAGMA foreign_key_check] command.
<li>Added new extended error codes for all SQLITE_CONSTRAINT errors
<li>Added SQL functions [unicode(A)] and [char(X1,...,XN)].
<li>Improved optimization of queries containing aggregate min() or max().
<li>Enhance virtual tables so that they can potentially use an index when
the WHERE clause contains the IN operator.
<li>Allow indices to be used for sorting even if prior terms of the index
are constrained by IN operators in the WHERE clause.
<li>Enhance the [PRAGMA table_info] command so that the "pk" column is an
increasing integer to show the order of columns in the primary key.
|
> > > |
42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 |
}
}
chng {2013-03-12 (3.7.16)} {
<li>Added the [PRAGMA foreign_key_check] command.
<li>Added new extended error codes for all SQLITE_CONSTRAINT errors
<li>Added SQL functions [unicode(A)] and [char(X1,...,XN)].
<li>Performance improvements for [PRAGMA incremental_vacuum], especially in
cases where the number of free pages is greater than what will fit on a
single trunk page of the freelist.
<li>Improved optimization of queries containing aggregate min() or max().
<li>Enhance virtual tables so that they can potentially use an index when
the WHERE clause contains the IN operator.
<li>Allow indices to be used for sorting even if prior terms of the index
are constrained by IN operators in the WHERE clause.
<li>Enhance the [PRAGMA table_info] command so that the "pk" column is an
increasing integer to show the order of columns in the primary key.
|