Documentation Source Text

Check-in [3b8a91bbce]
Login

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

Overview
Comment:Merge changes from the 3.25 branch.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 3b8a91bbce5ced4dc5f8383c92a72eae6ee36647bd87ce7b923a99d687f18210
User & Date: drh 2018-11-07 20:07:33
Context
2018-11-12
13:39
Begin adding a change log for version 3.26.0. check-in: a74a421c12 user: drh tags: trunk
2018-11-07
20:07
Merge changes from the 3.25 branch. check-in: 3b8a91bbce user: drh tags: trunk
17:35
Improvements to the documentation of the busy method in the TCL interface. Words contributed by flightaware. check-in: bf23032b75 user: drh tags: branch-3.25
2018-10-25
20:19
Merge changes from the 3.25 branch. check-in: efd5b055b2 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Deleted images/foreignlogos/bloomberg.gif.

cannot compute difference between binary files

Added images/foreignlogos/bloomberg.png.

cannot compute difference between binary files

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-11-05 (3.25.3)} {
           25  +<li> Disallow the use of [window functions] in the recursive part of
           26  +     a CTE. Ticket [https://sqlite.org/src/info/e8275b415a2f03bee|e8275b415a2f03bee]
           27  +<li> Fix the behavior of typeof() and length() on virtual tables.  Ticket
           28  +     [https://sqlite.org/src/info/69d642332d25aa3b7315a6d385|69d642332d25aa3b7315a6d385]
           29  +<li> Strengthen defenses against deliberately corrupted database files.
           30  +<li> Fix a problem in the query planner that results when a row-value expression
           31  +     is used with a PRIMARY KEY with redundant columns.  Ticket
           32  +     [https://sqlite.org/src/info/1a84668dcfdebaf12415d|1a84668dcfdebaf12415d]
           33  +<li> Fix the query planner so that it works correctly for IS NOT NULL operators
           34  +     in the ON clause of a LEFT JOIN with the SQLITE_ENABLE_STAT4 compile-time option.
           35  +     [https://sqlite.org/src/info/65eb38f6e46de8c75e188a17ec|65eb38f6e46de8c75e188a17ec]
           36  +<p><b>Hashes:</b>
           37  +<li>SQLITE_SOURCE_ID: "2018-11-05 20:37:38 89e099fbe5e13c33e683bef07361231ca525b88f7907be7092058007b75036f2"
           38  +<li>SHA3-256 for sqlite3.c: 45586e4df74de3a43f3a1f8c7a78c3c3f02edce01af7d10cafe68bb94476a5c5
           39  +} {patchagainst 1 patchagainst 2 patchagainst 3}
           40  +
    24     41   chng {2018-09-25 (3.25.2)} {
    25     42   <li> Add the [PRAGMA legacy_alter_table=ON] command that causes the
    26     43        "ALTER TABLE RENAME" command to behave as it did in SQLite versions 3.24.0
    27     44        and earlier: references to the renamed table inside the bodies of triggers
    28     45        and views are not updated.  This new pragma provides a compatibility
    29     46        work around for older programs that expected the older, wonky behavior
    30     47        of ALTER TABLE RENAME.

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  +89e099fbe5|2018-11-05|Version 3.25.3
    31     32   fb90e7189a|2018-09-25|Version 3.25.2
    32     33   2ac9003de4|2018-09-18|Version 3.25.1
    33     34   b63af6c3bd|2018-09-15|Version 3.25.0
    34     35   c7ee083322|2018-06-04|Version 3.24.0
    35     36   4bb2294022|2018-04-10|Version 3.23.1
    36     37   736b53f57f|2018-04-02|Version 3.23.0
    37     38   0c55d17973|2018-01-22|Version 3.22.0

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_25_2.html">Version 3.25.2</a> ([dateof:3.25.2]).
           17  +<a href="releaselog/3_25_3.html">Version 3.25.3</a> ([dateof:3.25.3]).
    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>
................................................................................
    47     47     {name   Mozilla
    48     48      url    https://www.mozilla.com/
    49     49      image  mozilla.gif
    50     50      blurb  "Working to preserve choice and innovation on the internet."
    51     51     }
    52     52     {name   Bloomberg
    53     53      url    https://www.bloomberg.com/
    54         -   image  bloomberg.gif
           54  +   image  bloomberg.png
    55     55      blurb  "A world leader in financial-information technology."
    56     56     }
    57     57     {name   Bentley
    58     58      url    https://www.bentley.com/
    59     59      image  bentley.gif
    60     60      blurb  "Comprehensive software solutions for Sustaining Infrastructure."
    61     61     }

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 {2018-11-05} {Release 3.25.3} {
           23  +SQLite [version 3.25.3] is a third patch against 3.25.0 that fixes various
           24  +problems that have come to light and which seem serious enough to 
           25  +justify a patch.
           26  +}
    21     27   
    22     28   newsitem {2018-09-25} {Release 3.25.2} {
    23     29   SQLite [version 3.25.2] is another patch against 3.25.0 that fixes still
    24     30   more problems associated with the new [window function] feature and the
    25     31   [ALTER TABLE] enhancements.  Of particular note is the new
    26     32   [PRAGMA legacy_alter_table=ON] command, which causes the ALTER TABLE RENAME
    27     33   command to behave in the same goofy way that it did before the enhancements

Changes to pages/prosupport.in.

   240    240   a suite of test cases for SQLite that provide 100% branch test coverage
   241    241   (and 100% modified condition/decision coverage) for the core SQLite in
   242    242   an as-deployed configuration using only published and documented interfaces.
   243    243   TH3 is designed for use with embedded devices, and is compatible with
   244    244   DO-178B.  Every release of the public-domain SQLite is tested using TH3,
   245    245   and so all users benefit from the TH3 tests.  But the TH3 tests are not
   246    246   themselves public.  Hardware or system manufactures who want to have
   247         -TH3 test run on their systems can negotiation a service agreement to have
          247  +TH3 test run on their systems can negotiate a service agreement to have
   248    248   the SQLite Developers run those tests.</p>
   249    249   
   250    250   <h2>About The SQLite Team</h2>
   251    251   
   252    252   <p>Paid support options and products are provided by
   253    253   Hipp, Wyrick &amp; Company, Inc., (Hwaci), a 
   254    254   <a href="http://en.wikipedia.org/wiki/Georgia_(U.S._state)">Georgia</a>

Changes to pages/tclsqlite.in.

   531    531   it is invoke.  The argument is the number of prior calls to the busy
   532    532   callback for the current locking event.  It is intended that
   533    533   the callback will do some other useful work for a short while 
   534    534   (such as service GUI events) then return
   535    535   so that the lock can be tried again.  The callback procedure should
   536    536   return "0" if it wants SQLite to try again to open the database and
   537    537   should return "1" if it wants SQLite to abandon the current operation.
          538  +<p>
          539  +If the busy method is invoked without an argument, the name of the callback
          540  +procedure last set by the busy method is returned.  If no callback procedure
          541  +has been set, an empty string is returned.
   538    542   }
   539    543   
   540    544   ##############################################################################
   541    545   METHOD enable_load_extension {
   542    546   
   543    547   <p>The extension loading mechanism of SQLite (accessed using the
   544    548   [load_extension()] SQL function) is turned off by default.  This is