Documentation Source Text

Check-in [22f1dff034]
Login

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

Overview
Comment:Update the change log.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256:22f1dff034873f32936cc4c821d07334ca8fabeb87a86863467f7d338b5acee6
User & Date: drh 2018-12-10 11:48:59
Context
2018-12-10
12:08
Improvements to the homepage. check-in: 893d161a74 user: drh tags: trunk
11:48
Update the change log. check-in: 22f1dff034 user: drh tags: trunk
00:52
Begin a new change log entries for 3.27.0. check-in: 41f9becb46 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to pages/changes.in.

    21     21     incr nChng
    22     22   }
    23     23   
    24     24   chng {2019-02-00 (3.27.0)} {
    25     25   <li>Added the [VACUUM INTO] command
    26     26   <li>Issue an SQLITE_WARNING message on the [error log] if a 
    27     27   [double-quoted string literal] is used.
           28  +<li>The [sqlite3_normalized_sql()] interface works on any prepared statement
           29  +created using [sqlite3_prepare_v2()] or [sqlite3_prepare_v3()].  It is no
           30  +longer necessary to use [sqlite3_prepare_v3()] with [SQLITE_PREPARE_NORMALIZE]
           31  +in order to use [sqlite3_normalized_sql()].
           32  +<li>Add the remove_diacritics=2 option to [FTS3] and [FTS5].
           33  +<p><b>Bug fixes:</b>
           34  +<li>Do not use a partial index to do a table scan on an IN operator.
           35  +Ticket [https://www.sqlite.org/src/info/1d958d90596593a774|1d958d90596593a774].
           36  +<li>Fix the [query flattener] so that it works on queries that contain
           37  +subqueries that use [window functions].
           38  +Ticket [https://www.sqlite.org/src/info/f09fcd17810f65f717|709fcd17810f65f717]
           39  +<li>Ensure that ALTER TABLE modifies table and column names embedded in WITH
           40  +clauses that are part of views and triggers.
           41  +<li>Fix a parser bug that prevented the use of parentheses around table-valued
           42  +functions.
    28     43   }
    29     44   
    30     45   chng {2018-12-01 (3.26.0)} {
    31     46   <li>Optimization: When doing an [UPDATE] on a table with [indexes on expressions],
    32     47       do not update the expression indexes if they do not refer to any of the columns
    33     48       of the table being updated.
    34     49   <li>Allow the [xBestIndex()] method of [virtual table] implementations to return