Documentation Source Text

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

Changes to pages/changes.in.

    34     34        now causes string substitutions to measure the width and precision in
    35     35        characters instead of bytes.
    36     36   <li> If the [xColumn] method in a [virtual table] implementation returns
    37     37        an error message using [sqlite3_result_error()] then give that error
    38     38        message preference over internally-generated messages.
    39     39   <li> Added the -A command-line option to the [CLI] to make it easier to manage
    40     40        [SQLite Archive files].
           41  +<li> Enhance the [sqlite3changeset_apply()] interface so that it is hardened
           42  +     against attacks from deliberately corrupted [changeset] objects.
    41     43   <li> Query optimizer enhancements:
    42     44   <ol type='a'>
    43     45     <li> Improve the [omit-left-join optimization] so that it works in cases where
    44     46          the right-hand table is UNIQUE but not necessarily NOT NULL.
    45     47     <li> Improve the [push-down optimization] so that it works for many LEFT JOINs.
    46     48     <li> Add the [LEFT JOIN strength reduction optimization] that converts a LEFT
    47     49          JOIN into an ordinary JOIN if there exist terms in the WHERE clause