Documentation Source Text
Check-in [638d9567ad]
Not logged in

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
Changes
hide diffs unified diffs patch

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.