Documentation Source Text

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

Changes to pages/changes.in.

    16     16   set nChng 0
    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  +
           24  +chng {2018-07-00 (3.24.0)} {
           25  +<li> Add support for PostgreSQL-style UPSERT.
           26  +<li> Enhance [ALTER TABLE] so that it recognizes "true" and "false" as
           27  +     valid arguments to DEFAULT.
           28  +<li> Added the sorter-reference optimization as a compile-time option.
           29  +     Only available if compiled with SQLITE_ENABLE_SORTER_REFERENCES.
           30  +}
    23     31   
    24     32   chng {2018-04-10 (3.23.1)} {
    25     33   <li> Fix two problems in the new [LEFT JOIN strength reduction optimization].
    26     34        Tickets [https://sqlite.org/src/info/1e39b966ae9ee739|1e39b966ae9ee739]
    27     35        and [https://sqlite.org/src/info/fac496b61722daf2|fac496b61722daf2].
    28     36   <li> Fix misbehavior of the FTS5 xBestIndex method.  Ticket
    29     37        [https://sqlite.org/src/info/2b8aed9f7c9e61e8|2b8aed9f7c9e61e8].

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

Changes to pages/index.in.

    10     10   [full-featured SQL|full-featured], [public-domain],
    11     11   SQL database engine.
    12     12   SQLite is the [most used] database engine in the world.
    13     13   <a class="button" href="about.html">More Info</a></p>
    14     14   
    15     15   <hr class="xhr">
    16     16   <span class="hdrfont">Latest Release:&nbsp;&nbsp;</span>
    17         -<a href="releaselog/3_23_1.html">Version 3.23.1</a> ([dateof:3.23.1]).
           17  +<a href="releaselog/3_24_0.html">Version 3.24.0</a> ([dateof:3.24.0]).
    18     18   <a class="button" href="download.html">Download</a>
    19     19   <a class="button" href="chronology.html">Prior Releases</a>
    20     20   
    21     21   <div class="mobileonly">
    22     22   <hr class="xhr">
    23     23   <h3>Common Links</h3>
    24     24   <tcl>common_links</tcl>