Documentation Source Text

Check-in [f9f945c599]

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

Comment:Update to the change log.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: f9f945c599f732c40485349527e4fb0a22dd1dd46415ad3120539e313ee9a166
User & Date: drh 2019-02-05 16:45:35
Add news for 3.27.0 check-in: 7a25788e4c user: drh tags: trunk
Update to the change log. check-in: f9f945c599 user: drh tags: trunk
Clarification to the VACUUM INTO documentation. check-in: c7001012e1 user: drh tags: trunk
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to pages/

    55     55        source tree.
    56     56   <li> Add support for the "--maxsize N" option on ".open --deserialize".
    57     57   <li> Add the "--memtrace" command-line option, to show all memory allocations
    58     58        and deallocations.
    59     59   <li> Add the ".eqp trace" option on builds with SQLITE_DEBUG, to enable
    60     60        bytecode program listing with indentation and 
    61     61        [PRAGMA vdbe_trace] all in one step.
           62  +<li> Add the ".progress" command for accessing
           63  +     the [sqlite3_progress_handler()] interface.
    62     64   <li> Add the "--async" option to the ".backup" command.
    63     65   <li> Add options "--expanded", "--normalized", "--plain", "--profile", "--row",
    64     66        "--stmt", and "--close" to the ".trace" command.
    65     67   </ol>
    66     68   <li> Omit deprecated PRAGMA statements when compiling with [SQLITE_OMIT_DEPRECATED].
           69  +<li> Increased robustness against malicious SQL that is run against a 
           70  +     maliciously corrupted database.
    67     71    <p><b>Bug fixes:</b>
    68     72   <li>Do not use a partial index to do a table scan on an IN operator.
    69     73   Ticket [|1d958d90596593a774].
    70     74   <li>Fix the [query flattener] so that it works on queries that contain
    71     75   subqueries that use [window functions].
    72     76   Ticket [|709fcd17810f65f717]
    73     77   <li>Ensure that ALTER TABLE modifies table and column names embedded in WITH
    74     78   clauses that are part of views and triggers.
    75     79   <li>Fix a parser bug that prevented the use of parentheses around table-valued
    76     80   functions.
           81  +<li>Fix a problem with the [OR optimization] on [indexes on expressions].
           82  +Ticket [|d96eba87698a428c1d].
           83  +<li>Fix a problem with the
           84  +[LEFT JOIN strength reduction optimization] in which the optimization
           85  +was being applied inappropriately due to an IS NOT NULL operator.
           86  +Ticket [|5948e09b8c415bc45d].
           87  +<li>Fix the [REPLACE] command so that it is no longer able to sneak a
           88  +NULL value into a NOT NULL column even if the NOT NULL column has a default
           89  +value of NULL.
           90  +Ticket [|e6f1f2e34dceeb1ed6]
           91  +<li>Fix a problem with the use of [window functions] used within 
           92  +[correlated subqueries].
           93  +Ticket [|d0866b26f83e9c55e3]
           94  +<li>Fix the [ALTER TABLE RENAME COLUMN] command so that it works for tables
           95  +that have redundant UNIQUE constraints.
           96  +Ticket [|bc8d94f0fbd633fd9a]
           97  +<li>Fix a bug that caused [zeroblob] values to be truncated when inserted into
           98  +a table that uses an [expression index].
           99  +Ticket [|bb4bdb9f7f654b0bb9]
    77    100   }
    78    101   
    79    102   chng {2018-12-01 (3.26.0)} {
    80    103   <li>Optimization: When doing an [UPDATE] on a table with [indexes on expressions],
    81    104       do not update the expression indexes if they do not refer to any of the columns
    82    105       of the table being updated.
    83    106   <li>Allow the [xBestIndex()] method of [virtual table] implementations to return