Documentation Source Text

set nChng 0
proc chng {date desc {options {}}} {
  global nChng aChng xrefChng
  set aChng($nChng) [list $date $desc $options]
  set xrefChng($date) $nChng
  incr nChng
}

chng {2017-00-00 (3.19.0)} {
<li> When using an index on an expression, try to use expression values already
     available in the index, rather than loading the original columns and recomputing
     the expression.
<li> Enhance the [flattening optimization] so that it is able to flatten views
     on the right-hand side of a LEFT JOIN.
<li> Use [replace()] instead of [char()] for escaping newline and carriage-return
     characters embedded in strings in the .dump output from the [command-line shell].
<li> Avoid unnecessary foreign key processing in UPDATE statements that do not
     touch the columns that are constrained by the foreign keys.
<li> On a DISTINCT query that uses an index, try to skip ahead to the next distinct
     entry using the index rather that stepping through rows, when an appropriate
     index is available.
<p><b>Bug Fixes:</b>
<li> Fix a problem in [PRAGMA integrity_check] that was causing a subsequent
     [VACUUM] to behave suboptimally.
<li> Fix the [PRAGMA foreign_key_check] command so that it works correctly with
     foreign keys on [WITHOUT ROWID] tables.
<li> Disallow leading zeros in numeric constants in JSON.  Fix for ticket
     [https://www.sqlite.org/src/info/b93be8729a895a528e2|b93be8729a895a528e2].
<li> Disallow control characters inside of strings in JSON.  Fix for ticket
     [https://www.sqlite.org/src/info/6c9b5514077fed34551|6c9b5514077fed34551].
<li> Limit the depth of recursion for JSON objects and arrays in order to avoid
     excess stack usage in the recursive descent parser.  Fix for ticket
     [https://www.sqlite.org/src/info/981329adeef51011052|981329adeef51011052].
}

chng {2017-03-30 (3.18.0)} {
<li>Added the [PRAGMA optimize] command
<li>The SQLite version identifier returned by the [sqlite_source_id()] SQL function
    and the [sqlite3_sourceid()] C API and found in the [SQLITE_SOURCE_ID] macro is
    now a 64-digit SHA3-256 hash instead of a 40-digit SHA1 hash.
<li>Added the [json_patch()] SQL function to the [json1|JSON1 extension].

#    ORDER BY mtime DESC;
#
# A small amount of manual editing and de-duplication followed.
#
# Manually edit the list for each subsequent release.
#      
foreach line [split {
xxxxxxxxxx|(pending)|version 3.19.0
424a0d3803|2017-03-28|version 3.18.0
ada05cfa86|2017-02-13|version 3.17.0
a65a62893c|2017-01-06|version 3.16.2
979f043928|2017-01-03|Version 3.16.1
04ac0b75b1|2017-01-02|Version 3.16.0
bbd85d235f|2016-11-28|Version 3.15.2
1136863c76|2016-11-04|Version 3.15.1

[full-featured SQL|full-featured], [public-domain],
SQL database engine.
SQLite is the [most used] database engine in the world.
<a class="button" href="about.html">More Info</a></p>

<hr class="xhr">
<span class="hdrfont">Latest Release:&nbsp;&nbsp;</span>
<a href="releaselog/3_19_0.html">Version 3.19.0</a> ([dateof:3.19.0]).
<a class="button" href="download.html">Download</a>
<a class="button" href="chronology.html">Prior Releases</a>

<div class="mobileonly">
<hr class="xhr">
<h3>Common Links</h3>
<tcl>common_links</tcl>