Documentation Source Text

Check-in [14b1451274]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Add the SQLITE_CONSTRAINT return from xBestIndex to the change log.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 14b145127498c4165ceb179ad3127144c5e035df812f4d6be2a33c042c740fba
User & Date: drh 2018-11-16 14:35:07.063
Context
2018-11-16
17:33
Update the speed-and-size chart for version 3.26.0 (beta). (check-in: f7ada093c1 user: drh tags: trunk)
14:35
Add the SQLITE_CONSTRAINT return from xBestIndex to the change log. (check-in: 14b1451274 user: drh tags: trunk)
14:33
More fixes to the virtual table documentation. (check-in: 70c4eaad4d user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/changes.in.
21
22
23
24
25
26
27



28
29
30
31
32
33
34
  incr nChng
}

chng {2018-12-00 (3.26.0)} {
<li>Optimization: When doing an [UPDATE] on a table with [indexes on expressions],
    do not update the expression indexes if they do not refer to any of the columns
    of the table being updated.



<li>Added the [SQLITE_DBCONFIG_DEFENSIVE] option which disables the ability to 
    create corrupt database files using ordinary SQL.
<li>Added support for read-only [shadow tables] when the [SQLITE_DBCONFIG_DEFENSIVE]
    option is enabled.
<li>Added the [PRAGMA legacy_alter_table] command, which if enabled causes the
    [ALTER TABLE] command to behave like older version of SQLite (prior to
    version 3.25.0) for compatibility.







>
>
>







21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
  incr nChng
}

chng {2018-12-00 (3.26.0)} {
<li>Optimization: When doing an [UPDATE] on a table with [indexes on expressions],
    do not update the expression indexes if they do not refer to any of the columns
    of the table being updated.
<li>Allow the [xBestIndex()] method of [virtual table] implementations to return
    [SQLITE_CONSTRAINT] to indicate that the proposed query plan is unusable and
    should not be given further consideration.
<li>Added the [SQLITE_DBCONFIG_DEFENSIVE] option which disables the ability to 
    create corrupt database files using ordinary SQL.
<li>Added support for read-only [shadow tables] when the [SQLITE_DBCONFIG_DEFENSIVE]
    option is enabled.
<li>Added the [PRAGMA legacy_alter_table] command, which if enabled causes the
    [ALTER TABLE] command to behave like older version of SQLite (prior to
    version 3.25.0) for compatibility.