Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| SHA1 Hash: | 638d9567ad3546fe287fde37d47b912bdd9e1167 |
|---|---|
| Date: | 2013-02-25 15:48:38 |
| User: | drh |
| Comment: | Record the incremental vacuum enhancements in the change-log for 3.7.16. |
Tags And Properties
- branch=trunk inherited from [b2e03e19ab]
- sym-trunk inherited from [b2e03e19ab]
Context
|
2013-03-02
| ||
| 16:20 | [4d9a64a055] Move future downloads into subdirectories to try to stem the growth in the number of files in the root directory of the website. (user: drh, tags: trunk) | |
|
2013-02-25
| ||
| 15:48 | [638d9567ad] Record the incremental vacuum enhancements in the change-log for 3.7.16. (user: drh, tags: trunk) | |
| 14:52 | [0b81bc6851] Add documentation for the unicode() and char() functions. (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.
|