Documentation Source Text

     now causes string substitutions to measure the width and precision in
     characters instead of bytes.
<li> If the [xColumn] method in a [virtual table] implementation returns
     an error message using [sqlite3_result_error()] then give that error
     message preference over internally-generated messages.
<li> Added the -A command-line option to the [CLI] to make it easier to manage
     [SQLite Archive files].
<li> Add support for INSERT OR REPLACE, INSERT OR IGNORE, and UPDATE OR REPLACE
     in the [Zipfile virtual table].
<li> Enhance the [sqlite3changeset_apply()] interface so that it is hardened
     against attacks from deliberately corrupted [changeset] objects.
<li> Added the [https://sqlite.org/src/file/ext/misc/normalize.c|sqlite3_normalize()]
     extension function.
<li> Query optimizer enhancements:
<ol type='a'>
  <li> Improve the [omit-left-join optimization] so that it works in cases where
       the right-hand table is UNIQUE but not necessarily NOT NULL.
  <li> Improve the [push-down optimization] so that it works for many LEFT JOINs.
  <li> Add the [LEFT JOIN strength reduction optimization] that converts a LEFT
       JOIN into an ordinary JOIN if there exist terms in the WHERE clause

       that caused a segfault if the fsdir() table was used as the inner table
       of a join. Problem reported on the mailing list and fixed by check-in
       [https://www.sqlite.org/src/info/7ce4e71c1b7251be|7ce4e71c1b7251be]
  <li> Issue an error rather instead of an assertion-fault or null-pointer
       dereference when the sqlite_master table is corrupted so that the
       sqlite_sequence table root page is really a btree-index page. Check-in
       [https://www.sqlite.org/src/info/525deb7a67fbd647|525deb7a67fbd647]
  <li> Fix the [ANALYZE] command so that it computes statistics on tables
       whose names begin with "sqlite".  Check-in
       [https://sqlite.org/src/info/0249d9aecf69948d|0249d9aecf69948d]
</ol>
<li> Additional fixes for issues detected by
     [https://github.com/google/oss-fuzz|OSSFuzz]:
<ol type='a'>
  <li> Fix a possible infinite loop on VACUUM for corrupt database files.
       Check-in [https://www.sqlite.org/src/info/27754b74ddf64|27754b74ddf64]
  <li> Disallow [parameters] in the [WITH clause] of triggers and views.