Documentation Source Text
Check-in [638d9567ad3546fe287fde37d47b912bdd9e1167]
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 Ignore Whitespace Patch

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.