Documentation Source Text

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

Changes to pages/changes.in.

    42     42       hd_enable_main 1
    43     43       incr nChng
    44     44       if {$nChng==1 && [file exists $DEST/$filename]} {
    45     45         file copy -force $DEST/$filename $DEST/releaselog/current.html
    46     46       }
    47     47     }
    48     48   }
           49  +
           50  +chng {2013-08-29 (3.8.0.1)} {
           51  +<li>Fix an off-by-one error that caused quoted empty string at the end of a 
           52  +CRNL-terminated line of CSV input to be misread by the command-line shell.
           53  +<li>Fix a query planner bug involving a LEFT JOIN with a BETWEEN or LIKE/GLOB
           54  +constraint and then another INNER JOIN to the right that involves an OR constraint.
           55  +<li>Fix a query planner bug that could result in a segfault when querying tables
           56  +with a UNIQUE or PRIMARY KEY constraint with more than four columns.
           57  +}
    49     58   
    50     59   chng {2013-08-26 (3.8.0)} {
    51     60   <li>Add support for [partial indexes]</li>
    52     61   <li>Cut-over to the [next generation query planner] for faster and better query plans.
    53     62   <li>The [EXPLAIN QUERY PLAN] output no longer shows an estimate of the number of 
    54     63       rows generated by each loop in a join.
    55     64   <li>Added the [FTS4 notindexed option], allowing non-indexed columns in an FTS4 table.

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_8_0.html">Version 3.8.0</a>
           98  +<li><a href="releaselog/3_8_0_1.html">Version 3.8.0.1</a>
    99     99   of SQLite is recommended for all new development.
   100         -Upgrading from version 3.7.17 is optional.
          100  +Upgrading from version 3.7.17 and 3.8.0 is optional.
   101    101   Upgrading from all other prior versions of SQLite
   102    102   is recommended.</li>
   103    103   </ul></p>
   104    104   
   105    105   <h3>Common Links</h3>
   106    106   
   107    107   <p><ul>

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-08-29} {Release 3.8.0.1} {
           23  +  <p>SQLite [version 3.8.0.1] fixes some obscure bugs that were uncovered by
           24  +  users in the 3.8.0 release.  Changes from 3.8.0 are minimal.
           25  +}
    21     26   
    22     27   newsitem {2013-08-26} {Release 3.8.0} {
    23     28     <b>Do not fear the zero!</b>
    24     29   
    25     30     <p>SQLite [version 3.8.0] might easily have been called "3.7.18" instead.
    26     31     However, this release features the cutover of the
    27     32     [next generation query planner] or [NGQP], and there is a small chance of