Documentation Source Text

Check-in [f120fbc6f8]
Login

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

Overview
Comment:Version 3.27.0
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk | release | version-3.27.0
Files: files | file ages | folders
SHA3-256: f120fbc6f89f4fc70dfdc89a7b83525d9380d5f41fcac0bc6efdef5fab016f41
User & Date: drh 2019-02-07 17:06:07.855
Context
2019-02-07
18:10
Fix the chronology entry for 3.27.0. (check-in: 79e69bbf6e user: drh tags: trunk)
17:06
Version 3.27.0 (check-in: f120fbc6f8 user: drh tags: trunk, release, version-3.27.0)
16:59
Update the size and performance graph spreadsheet. (check-in: 5c6358b7e1 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/changes.in.
93
94
95
96
97
98
99




100
101
102
103
104
105
106
Ticket [https://www.sqlite.org/src/info/d0866b26f83e9c55e3|d0866b26f83e9c55e3]
<li>Fix the [ALTER TABLE RENAME COLUMN] command so that it works for tables
that have redundant UNIQUE constraints.
Ticket [https://www.sqlite.org/src/info/bc8d94f0fbd633fd9a|bc8d94f0fbd633fd9a]
<li>Fix a bug that caused [zeroblob] values to be truncated when inserted into
a table that uses an [expression index].
Ticket [https://www.sqlite.org/src/info/bb4bdb9f7f654b0bb9|bb4bdb9f7f654b0bb9]




}

chng {2018-12-01 (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







>
>
>
>







93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
Ticket [https://www.sqlite.org/src/info/d0866b26f83e9c55e3|d0866b26f83e9c55e3]
<li>Fix the [ALTER TABLE RENAME COLUMN] command so that it works for tables
that have redundant UNIQUE constraints.
Ticket [https://www.sqlite.org/src/info/bc8d94f0fbd633fd9a|bc8d94f0fbd633fd9a]
<li>Fix a bug that caused [zeroblob] values to be truncated when inserted into
a table that uses an [expression index].
Ticket [https://www.sqlite.org/src/info/bb4bdb9f7f654b0bb9|bb4bdb9f7f654b0bb9]
<p><b>Hashes:</b>
<li>SQLITE_SOURCE_ID: "2019-02-07 17:02:52 97744701c3bd414e6c9d7182639d8c2ce7cf124c4fce625071ae65658ac61713
"
<li>SHA3-256 for sqlite3.c: ca011a10ee8515b33e5643444b98ee3d74dc45d3ac766c3700320def52bc6aba
}

chng {2018-12-01 (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