Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Update to the change log. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA3-256: |
f9f945c599f732c40485349527e4fb0a |
User & Date: | drh 2019-02-05 16:45:35.629 |
Context
2019-02-07
| ||
13:42 | Add news for 3.27.0 (check-in: 7a25788e4c user: drh tags: trunk) | |
2019-02-05
| ||
16:45 | Update to the change log. (check-in: f9f945c599 user: drh tags: trunk) | |
12:58 | Clarification to the VACUUM INTO documentation. (check-in: c7001012e1 user: drh tags: trunk) | |
Changes
Changes to pages/changes.in.
︙ | ︙ | |||
55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 | source tree. <li> Add support for the "--maxsize N" option on ".open --deserialize". <li> Add the "--memtrace" command-line option, to show all memory allocations and deallocations. <li> Add the ".eqp trace" option on builds with SQLITE_DEBUG, to enable bytecode program listing with indentation and [PRAGMA vdbe_trace] all in one step. <li> Add the "--async" option to the ".backup" command. <li> Add options "--expanded", "--normalized", "--plain", "--profile", "--row", "--stmt", and "--close" to the ".trace" command. </ol> <li> Omit deprecated PRAGMA statements when compiling with [SQLITE_OMIT_DEPRECATED]. <p><b>Bug fixes:</b> <li>Do not use a partial index to do a table scan on an IN operator. Ticket [https://www.sqlite.org/src/info/1d958d90596593a774|1d958d90596593a774]. <li>Fix the [query flattener] so that it works on queries that contain subqueries that use [window functions]. Ticket [https://www.sqlite.org/src/info/f09fcd17810f65f717|709fcd17810f65f717] <li>Ensure that ALTER TABLE modifies table and column names embedded in WITH clauses that are part of views and triggers. <li>Fix a parser bug that prevented the use of parentheses around table-valued functions. } 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 | > > > > > > > > > > > > > > > > > > > > > > > | 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 | source tree. <li> Add support for the "--maxsize N" option on ".open --deserialize". <li> Add the "--memtrace" command-line option, to show all memory allocations and deallocations. <li> Add the ".eqp trace" option on builds with SQLITE_DEBUG, to enable bytecode program listing with indentation and [PRAGMA vdbe_trace] all in one step. <li> Add the ".progress" command for accessing the [sqlite3_progress_handler()] interface. <li> Add the "--async" option to the ".backup" command. <li> Add options "--expanded", "--normalized", "--plain", "--profile", "--row", "--stmt", and "--close" to the ".trace" command. </ol> <li> Omit deprecated PRAGMA statements when compiling with [SQLITE_OMIT_DEPRECATED]. <li> Increased robustness against malicious SQL that is run against a maliciously corrupted database. <p><b>Bug fixes:</b> <li>Do not use a partial index to do a table scan on an IN operator. Ticket [https://www.sqlite.org/src/info/1d958d90596593a774|1d958d90596593a774]. <li>Fix the [query flattener] so that it works on queries that contain subqueries that use [window functions]. Ticket [https://www.sqlite.org/src/info/f09fcd17810f65f717|709fcd17810f65f717] <li>Ensure that ALTER TABLE modifies table and column names embedded in WITH clauses that are part of views and triggers. <li>Fix a parser bug that prevented the use of parentheses around table-valued functions. <li>Fix a problem with the [OR optimization] on [indexes on expressions]. Ticket [https://www.sqlite.org/src/info/d96eba87698a428c1d|d96eba87698a428c1d]. <li>Fix a problem with the [LEFT JOIN strength reduction optimization] in which the optimization was being applied inappropriately due to an IS NOT NULL operator. Ticket [https://www.sqlite.org/src/info/5948e09b8c415bc45d|5948e09b8c415bc45d]. <li>Fix the [REPLACE] command so that it is no longer able to sneak a NULL value into a NOT NULL column even if the NOT NULL column has a default value of NULL. Ticket [https://www.sqlite.org/src/info/e6f1f2e34dceeb1ed6|e6f1f2e34dceeb1ed6] <li>Fix a problem with the use of [window functions] used within [correlated subqueries]. 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 |
︙ | ︙ |