Documentation Source Text

Check-in [4a562f8d21]
Login

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

Overview
Comment:Change log updates due to review of sqlite3.c diffs from prior release.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256:4a562f8d21958e3ca2f61db0eb32c90abfab593b8e94b8577dd6288135a30d00
User & Date: drh 2018-05-29 15:55:30
Context
2018-05-29
18:35
Document (with links) that SQLite is a LoC Recommended Storage Format. check-in: 2ab12e598f user: drh tags: trunk
15:55
Change log updates due to review of sqlite3.c diffs from prior release. check-in: 4a562f8d21 user: drh tags: trunk
2018-05-26
01:59
Show the apSqlParam field that was added to the sqlite3_rtree_query_info object in version 3.8.11. check-in: b5582fa868 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to pages/changes.in.

    58     58   <li> The [OR optimization] is allowed to proceed
    59     59        even if the OR expression has also been converted into an IN
    60     60        expression.  Uses of the OR optimization are now also 
    61     61        [eqp-or-opt|more clearly shown] in the [EXPLAIN QUERY PLAN] output.
    62     62   <li> The query planner is more aggressive about using
    63     63        [automatic indexes] for views and subqueries for which it is
    64     64        not possible to create a persistent index.
           65  +<li> Make use of the one-pass UPDATE and DELETE query plans in the
           66  +     [R-Tree extension] where appropriate.
    65     67   <li> Performance improvements in the LEMON-generated parser.
    66     68   <p><b>Bug fixes:</b>
    67     69   <li> For the right-hand table of a LEFT JOIN, compute the values
    68     70        of expressions directly rather than loading precomputed values
    69     71        out of an [expression index] as the expression index might
    70     72        not contain the correct value.  Ticket
    71     73        [https://sqlite.org/src/info/7fa8049685b50b5aeb0c2|7fa8049685b50b5aeb0c2]
................................................................................
    74     76        [https://sqlite.org/src/info/4ba5abf65c5b0f9a96a7a|4ba5abf65c5b0f9a96a7a]
    75     77   <li> Fix a memory leak that can occur following a failure to open error
    76     78        in the [CSV virtual table]
    77     79   <li> Fix a long-standing problem wherein a corrupt schema on the
    78     80        [sqlite_sequence] table used by [AUTOINCREMENT] can lead to
    79     81        a crash. Ticket
    80     82        [https://www.sqlite.org/src/info/d8dc2b3a58cd5dc29|d8dc2b3a58cd5dc2918a1]
           83  +<li> Fix the [json_each()] function so that it returns
           84  +     valid results on its "fullkey" column when the input is a simple value
           85  +     rather than an array or object.
    81     86   <p><b>Hashes:</b>
    82     87   <li>SQLITE_SOURCE_ID: <i>pending</i>
    83     88   <li>SHA3-256 for sqlite3.c: <i>pending</i>
    84     89   }
    85     90   
    86     91   
    87     92   chng {2018-04-10 (3.23.1)} {