Documentation Source Text

Check-in [8e7e750269]
Login

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

Overview
Comment:Website updates in preparation for the 3.7.16.1 patch release.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 8e7e750269837068ee3c95f254af1c492c82dd65
User & Date: drh 2013-03-27 20:24:03
Context
2013-03-28
17:51
Update the compile-time options page. Change all dates on the release history to ISO8601 format. check-in: ce11667ff6 user: drh tags: trunk
2013-03-27
20:24
Website updates in preparation for the 3.7.16.1 patch release. check-in: 8e7e750269 user: drh tags: trunk
19:06
Update the omitted.html page. check-in: d4dfc5ce44 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to pages/changes.in.

    37     37         <a href="http://www.sqlite.org/src/timeline">
    38     38         http://www.sqlite.org/src/timeline</a>.</p>
    39     39       }
    40     40       hd_close_aux
    41     41       hd_enable_main 1
    42     42     }
    43     43   }
           44  +
           45  +chng {2013-04-03 (3.7.16.1)} {
           46  +<li>Fix for a bug in the ORDER BY optimizer that was introduced in
           47  +    [version 3.7.15] which would sometimes optimize out the sorting step
           48  +    when in fact the sort was required.
           49  +    Ticket [http://www.sqlite.org/src/info/a179fe7465 | a179fe7465]
           50  +<li>Fix a long-standing bug in the [CAST expression] that would recognize UTF16
           51  +    characters as digits even if their most-significant-byte was not zero.
           52  +    Ticket [http://www.sqlite.org/src/info/689137afb6da41 | 689137afb6da41].
           53  +<li>Fix a bug in the NEAR operator of [FTS3] when applied to subfields.
           54  +    Ticket [http://www.sqlite.org/src/info/38b1ae018f | 38b1ae018f].
           55  +<li>Fix a long-standing bug in the storage engine that would (very rarely)
           56  +    cause a spurious report of an SQLITE_CORRUPT error but which was otherwise
           57  +    harmless.
           58  +    Ticket [http://www.sqlite.org/src/info/6bfb98dfc0c | 6bfb98dfc0c].
           59  +<li>Fixed lots of spelling errors in the source-code comments
           60  +}
    44     61   
    45     62   chng {2013-03-18 (3.7.16)} {
    46     63   <li>Added the [PRAGMA foreign_key_check] command.
    47     64   <li>Added new extended error codes for all SQLITE_CONSTRAINT errors
    48     65   <li>Added the SQLITE_READONLY_ROLLBACK extended error code for when a database
    49     66       cannot be opened because it needs rollback recovery but is read-only.
    50     67   <li>Added SQL functions [unicode(A)] and [char(X1,...,XN)].

Changes to pages/index.in.

    91     91   
    92     92   </td>
    93     93   <td width="20"></td><td bgcolor="#044a64" width="1"></td><td width="20"></td>
    94     94   <td valign="top">
    95     95   <h3>Current Status</h3>
    96     96   
    97     97   <p><ul>
    98         -<li><a href="releaselog/3_7_16.html">Version 3.7.16</a>
           98  +<li><a href="releaselog/3_7_16_1.html">Version 3.7.16.1</a>
    99     99   of SQLite is recommended for all new development.
   100    100   Upgrading from all other SQLite versions
   101    101   is recommended.</li>
   102    102   </ul></p>
   103    103   
   104    104   <h3>Common Links</h3>
   105    105   

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 {2013-Apr-03} {Release 3.7.16.1} {
           23  +  SQLite [version 3.7.16.1] is a bug fix release that fixes a few problems
           24  +  that were present in the previous releases.
           25  +
           26  +  The primary motivation for version 3.7.16.1 is to fix a bug in the
           27  +  query optimizer that was introduced as part of [version 3.7.15].  The
           28  +  query optimizer was being a little overzealous in optimizing out some
           29  +  ORDER BY clauses, which resulted in sorting being omitted on occasions
           30  +  where sorting is required to get the correct answer.  See
           31  +  ticket [http://www.sqlite.org/src/info/a179fe7465 | a179fe7465] for
           32  +  details.
           33  +
           34  +  In addition to the ORDER BY fix, several other patches to fix obscure
           35  +  (and mostly harmless) bugs and to fix spelling errors in source code
           36  +  comments are also included in this release.
           37  +}
    21     38   
    22     39   newsitem {2013-Mar-18} {Release 3.7.16} {
    23     40     SQLite [version 3.7.16] is a regularly scheduled release of SQLite.
    24     41     This release contains several langauge enhancements and improvements
    25     42     to the query optimizer.  A list of the major enhancements and optimizations
    26     43     can be see on the [version 3.7.16 | change log].
    27     44