Documentation Source Text

Check-in [6d211fe371]
Login

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

Overview
Comment:Updates to the change log.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256:6d211fe371cf7200fc4fc81f8a2d5bd3955eebcf0e702c5953f7eff706c07f5a
User & Date: drh 2018-04-25 00:02:23
Context
2018-04-30
22:27
Update the change log. Fix typo in virtual table documentation. check-in: 32c5dad1b2 user: drh tags: trunk
2018-04-25
00:02
Updates to the change log. check-in: 6d211fe371 user: drh tags: trunk
2018-04-20
00:00
Document the fact that UPSERTs count INSERT operations but not UPDATEs. check-in: fcfd6e8be6 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to pages/changes.in.

    23     23   
    24     24   chng {2018-07-00 (3.24.0)} {
    25     25   <li> Add support for PostgreSQL-style [UPSERT].
    26     26   <li> Enhance [ALTER TABLE] so that it recognizes "true" and "false" as
    27     27        valid arguments to DEFAULT.
    28     28   <li> Added the sorter-reference optimization as a compile-time option.
    29     29        Only available if compiled with SQLITE_ENABLE_SORTER_REFERENCES.
           30  +<li> The [CLI] automatically intercepts the raw [EXPLAIN QUERY PLAN] 
           31  +     output an reformats it into an ASCII-art graph.
           32  +<li> Enhance the query planner to allow the [OR optimization] to proceed
           33  +     even if the OR expression has also been converted into an IN
           34  +     expression.
           35  +<li> Performance improvements in the LEMON-generated parser.
           36  +<p><b>Bug fixes:</b>
           37  +<li> For the right-hand table of a LEFT JOIN, compute the values
           38  +     of expressions directly rather than loading precomputed values
           39  +     out of an [expression index] as the expression index might
           40  +     not contain the correct value.  Ticket
           41  +     [https://sqlite.org/src/info/7fa8049685b50b5aeb0c2|7fa8049685b50b5aeb0c2]
           42  +<li> Do not attempt to use terms from the WHERE clause to enable
           43  +     indexed lookup of the right-hand table of a LEFT JOIN.  Ticket
           44  +     [https://sqlite.org/src/info/4ba5abf65c5b0f9a96a7a|4ba5abf65c5b0f9a96a7a]
           45  +<li> Fix a memory leak that can occur following a failure to open error
           46  +     in the [CSV virtual table]
           47  +<p><b>Hashes:</b>
           48  +<li>SQLITE_SOURCE_ID: <i>pending</i>
           49  +<li>SHA3-256 for sqlite3.c: <i>pending</i>
    30     50   }
           51  +
    31     52   
    32     53   chng {2018-04-10 (3.23.1)} {
    33     54   <li> Fix two problems in the new [LEFT JOIN strength reduction optimization].
    34     55        Tickets [https://sqlite.org/src/info/1e39b966ae9ee739|1e39b966ae9ee739]
    35     56        and [https://sqlite.org/src/info/fac496b61722daf2|fac496b61722daf2].
    36     57   <li> Fix misbehavior of the FTS5 xBestIndex method.  Ticket
    37     58        [https://sqlite.org/src/info/2b8aed9f7c9e61e8|2b8aed9f7c9e61e8].