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]
Changes
Changes to pages/changes.in
42 } 42 } 43 } 43 } 44 44 45 chng {2013-03-12 (3.7.16)} { 45 chng {2013-03-12 (3.7.16)} { 46 <li>Added the [PRAGMA foreign_key_check] command. 46 <li>Added the [PRAGMA foreign_key_check] command. 47 <li>Added new extended error codes for all SQLITE_CONSTRAINT errors 47 <li>Added new extended error codes for all SQLITE_CONSTRAINT errors 48 <li>Added SQL functions [unicode(A)] and [char(X1,...,XN)]. 48 <li>Added SQL functions [unicode(A)] and [char(X1,...,XN)]. > 49 <li>Performance improvements for [PRAGMA incremental_vacuum], especially in > 50 cases where the number of free pages is greater than what will fit on a > 51 single trunk page of the freelist. 49 <li>Improved optimization of queries containing aggregate min() or max(). 52 <li>Improved optimization of queries containing aggregate min() or max(). 50 <li>Enhance virtual tables so that they can potentially use an index when 53 <li>Enhance virtual tables so that they can potentially use an index when 51 the WHERE clause contains the IN operator. 54 the WHERE clause contains the IN operator. 52 <li>Allow indices to be used for sorting even if prior terms of the index 55 <li>Allow indices to be used for sorting even if prior terms of the index 53 are constrained by IN operators in the WHERE clause. 56 are constrained by IN operators in the WHERE clause. 54 <li>Enhance the [PRAGMA table_info] command so that the "pk" column is an 57 <li>Enhance the [PRAGMA table_info] command so that the "pk" column is an 55 increasing integer to show the order of columns in the primary key. 58 increasing integer to show the order of columns in the primary key.