Documentation Source Text

Check-in [c300836d83]
Login

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

Overview
Comment:Add the final date and various hashes for the 3.24.0 release.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: c300836d839035f205f3b0360327498324335619c200003ba71dc3381450c8d7
User & Date: drh 2018-06-04 19:28:23
Context
2018-06-04
19:41
Add the upsert-clause.gif image. check-in: 7d927bcea1 user: drh tags: trunk
19:28
Add the final date and various hashes for the 3.24.0 release. check-in: c300836d83 user: drh tags: trunk
2018-06-01
17:41
Add the Sanderson book to the books.html page. check-in: 97f6d1477c 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 {2018-07-00 (3.24.0)} {
           24  +chng {2018-06-04 (3.24.0)} {
    25     25   <li> Add support for PostgreSQL-style [UPSERT].
    26     26   <li> Add support for [auxiliary columns in r-tree tables].
    27     27   <li> Add C-language APIs for discovering SQL keywords used by
    28     28        SQLite: [sqlite3_keyword_count()], [sqlite3_keyword_name()], and
    29     29        [sqlite3_keyword_check()].
    30     30   <li> Add C-language APIs for dynamic strings based on the
    31     31        [sqlite3_str] object.
................................................................................
    80     80        [sqlite_sequence] table used by [AUTOINCREMENT] can lead to
    81     81        a crash. Ticket
    82     82        [https://www.sqlite.org/src/info/d8dc2b3a58cd5dc29|d8dc2b3a58cd5dc2918a1]
    83     83   <li> Fix the [json_each()] function so that it returns
    84     84        valid results on its "fullkey" column when the input is a simple value
    85     85        rather than an array or object.
    86     86   <p><b>Hashes:</b>
    87         -<li>SQLITE_SOURCE_ID: <i>pending</i>
    88         -<li>SHA3-256 for sqlite3.c: <i>pending</i>
           87  +<li>SQLITE_SOURCE_ID: "2018-06-04 19:24:41 c7ee0833225bfd8c5ec2f9bf62b97c4e04d03bd9566366d5221ac8fb199a87ca"
           88  +<li>SHA3-256 for sqlite3.c: 0d384704e1c66026228336d1e91771d295bf688c9c44c7a44f25a4c16c26ab3c
    89     89   }
    90     90   
    91     91   
    92     92   chng {2018-04-10 (3.23.1)} {
    93     93   <li> Fix two problems in the new [LEFT JOIN strength reduction optimization].
    94     94        Tickets [https://sqlite.org/src/info/1e39b966ae9ee739|1e39b966ae9ee739]
    95     95        and [https://sqlite.org/src/info/fac496b61722daf2|fac496b61722daf2].

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         -0000000000|pending|Version 3.24.0
           31  +c7ee083322|2018-06-04|Version 3.24.0
    32     32   4bb2294022|2018-04-10|Version 3.23.1
    33     33   736b53f57f|2018-04-02|Version 3.23.0
    34     34   0c55d17973|2018-01-22|Version 3.22.0
    35     35   1a584e4999|2017-10-24|Version 3.21.0
    36     36   8d3a7ea6c5|2017-08-24|Version 3.20.1
    37     37   9501e22dfe|2017-08-01|Version 3.20.0
    38     38   036ebf729e|2017-06-17|Version 3.18.2

Changes to pages/news.in.

    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     21   
    22         -newsitem {2018-06-01} {Release 3.24.0} {
           22  +newsitem {2018-06-04} {Release 3.24.0} {
    23     23   SQLite [version 3.24.0] is a regularly scheduled maintenance release.
    24     24   Highlights of this release include support for PostgreSQL-style
    25     25   UPSERT and improved performance, especially for ORDER BY LIMIT queries.
    26     26   }
    27     27   
    28     28   newsitem {2018-04-10} {Release 3.23.1} {
    29     29   The [version 3.23.1] release fixes a bug in the new