Documentation Source Text

     the [SQLITE_ENABLE_DESERIALIZE] compile-time option is used.
<li> Recognize TRUE and FALSE as constants.  (For compatibility, if there
     are columns named "true" or "false", then the identifiers refer to the
     columns rather than Boolean constants.)
<li> Support operators IS TRUE, IS FALSE, IS NOT TRUE, and IS NOT FALSE.
<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> Added the [SQLITE_DBSTATUS_CACHE_SPILL] option to [sqlite3_db_status()] for
     reporting the number of cache spills that have occurred.
<li> The "alternate-form-2" flag ("!") on the [built-in printf] implemention
     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

  <li> Assertion fault in FTS4.
       Ticket [https://www.sqlite.org/src/info/d6ec09eccf68cfc|d6ec09eccf68cfc]
  <li> Incorrect result on the less-than operator in [row values].
       Ticket [https://www.sqlite.org/src/info/f484b65f3d62305|f484b65f3d62305]
  <li> Always interpret non-zero floating-point values as TRUE, even if
       the integer part is zero.
       Ticket [https://www.sqlite.org/src/info/36fae083b450e3a|36fae083b450e3a]
  <li> Fix an issue in the fsdir(PATH) [table-valued function] to the
       [https://sqlite.org/src/file/ext/misc/fileio.c|fileio.c] extension,
       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]
</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.