Documentation Source Text

Check-in [9ae6f97cab]
Login

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

Overview
Comment:Version 3.19.0
Timelines: family | ancestors | descendants | both | trunk | release | version-3.19.0
Files: files | file ages | folders
SHA3-256: 9ae6f97cabf46394303977ac1d4fe601881784f06dd455a45978704eba7bad47
User & Date: drh 2017-05-22 14:02:27
Context
2017-05-22
19:23
Add a chart of raw data to the faster-than-filesystem page. check-in: 5f95a7df66 user: drh tags: trunk
14:02
Version 3.19.0 check-in: 9ae6f97cab user: drh tags: trunk, release, version-3.19.0
13:49
Fix typos in the opcodes.html document. check-in: d11890e573 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to pages/changes.in.

    17     17   proc chng {date desc {options {}}} {
    18     18     global nChng aChng xrefChng
    19     19     set aChng($nChng) [list $date $desc $options]
    20     20     set xrefChng($date) $nChng
    21     21     incr nChng
    22     22   }
    23     23   
    24         -chng {2017-06-00 (3.19.0)} {
           24  +chng {2017-05-22 (3.19.0)} {
    25     25   <li> The [SQLITE_READ] [authorizer callback] is invoked once
    26     26        with a column name that is an empty string
    27     27        for every table referenced in a query from which no columns are extracted.
    28     28   <li> When using an index on an expression, try to use expression values already
    29     29        available in the index, rather than loading the original columns and recomputing
    30     30        the expression.
    31     31   <li> Enhance the [flattening optimization] so that it is able to flatten views
................................................................................
    64     64   <li> Disallow leading zeros in numeric constants in JSON.  Fix for ticket
    65     65        [https://www.sqlite.org/src/info/b93be8729a895a528e2|b93be8729a895a528e2].
    66     66   <li> Disallow control characters inside of strings in JSON.  Fix for ticket
    67     67        [https://www.sqlite.org/src/info/6c9b5514077fed34551|6c9b5514077fed34551].
    68     68   <li> Limit the depth of recursion for JSON objects and arrays in order to avoid
    69     69        excess stack usage in the recursive descent parser.  Fix for ticket
    70     70        [https://www.sqlite.org/src/info/981329adeef51011052|981329adeef51011052].
           71  +<p><b>Hashes:</b>
           72  +<li>SQLITE_SOURCE_ID: "2017-05-22 13:58:13 28a94eb282822cad1d1420f2dad6bf65e4b8b9062eda4a0b9ee8270b2c608e40"
           73  +<li>SHA3-256 for sqlite3.c: c30326aa1a9cc342061b755725eac9270109acf878bc59200dd4b1cea6bc2908
    71     74   }
    72     75   
    73     76   chng {2017-03-30 (3.18.0)} {
    74     77   <li>Added the [PRAGMA optimize] command
    75     78   <li>The SQLite version identifier returned by the [sqlite_source_id()] SQL function
    76     79       and the [sqlite3_sourceid()] C API and found in the [SQLITE_SOURCE_ID] macro is
    77     80       now a 64-digit SHA3-256 hash instead of a 40-digit SHA1 hash.

Changes to pages/chronology.in.

    24     24   #    ORDER BY mtime DESC;
    25     25   #
    26     26   # A small amount of manual editing and de-duplication followed.
    27     27   #
    28     28   # Manually edit the list for each subsequent release.
    29     29   #      
    30     30   foreach line [split {
    31         -xxxxxxxxxx|(pending)|version 3.19.0
           31  +28a94eb282|2017-05-22|version 3.19.0
    32     32   424a0d3803|2017-03-28|version 3.18.0
    33     33   ada05cfa86|2017-02-13|version 3.17.0
    34     34   a65a62893c|2017-01-06|version 3.16.2
    35     35   979f043928|2017-01-03|Version 3.16.1
    36     36   04ac0b75b1|2017-01-02|Version 3.16.0
    37     37   bbd85d235f|2016-11-28|Version 3.15.2
    38     38   1136863c76|2016-11-04|Version 3.15.1

Changes to pages/news.in.

    14     14     hd_puts "<h3>$date - $title</h3>"
    15     15     regsub -all "\n( *\n)+" $text "</p>\n\n<p>" txt
    16     16     regsub -all {[Tt]icket #(\d+)} $txt \
    17     17         {<a href="http://www.sqlite.org/cvstrac/tktview?tn=\1">\0</a>} txt
    18     18     hd_resolve "<blockquote>$txt</blockquote>"
    19     19     hd_puts "<hr width=\"50%\">"
    20     20   }
           21  +
           22  +newsitem {2017-05-22} {Release 3.19.0} {
           23  +SQLite [version 3.19.0] is a regularly scheduled maintenance release.
           24  +<p>
           25  +The emphasis on this release is improvements to the query planner.
           26  +There are also some obscure bug fixes.  There is no reason to upgrade
           27  +unless you are having problems with a prior release.
           28  +}
    21     29   
    22     30   newsitem {2017-03-30} {Release 3.18.0} {
    23     31   SQLite [version 3.18.0] is a regularly scheduled maintenance release.
    24     32   <p>
    25     33   This release features an initial implementation the 
    26     34   "[PRAGMA optimize]" command.  This command can now be used to cause
    27     35   [ANALYZE] to be run on an as-needed basis.  Applications should invoke