/ Check-in [7799a0b6]
Login

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

Overview
Comment:Changes in preparation for version 3.3.13. (CVS 3637)
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1:7799a0b63dd4ab6f422f138e5b423d6fb00529fb
User & Date: drh 2007-02-13 02:03:24
Context
2007-02-13
02:07
Change "UUID" to "GUID" in the documentation. (CVS 3638) check-in: dddd31f4 user: drh tags: trunk
02:03
Changes in preparation for version 3.3.13. (CVS 3637) check-in: 7799a0b6 user: drh tags: trunk
01:41
Explanation of the "fragmentation" line is added to the help message at the end of the output of sqlite3_analyzer. (CVS 3636) check-in: 31e5073c user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to VERSION.

     1         -3.3.12
            1  +3.3.13

Changes to www/changes.tcl.

    20     20     if {[regexp {\(([0-9.]+)\)} $date all vers]} {
    21     21       set label [string map {. _} $vers]
    22     22       puts "<A NAME=\"version_$label\">"
    23     23     }
    24     24     puts "<DT><B>$date</B></DT>"
    25     25     puts "<DD><P><UL>$desc</UL></P></DD>"
    26     26   }
           27  +
           28  +chng {2007 February 13 (3.3.13)} {
           29  +<li>Add a "fragmentation" measurement in the output of sqlite3_analyzer.</li>
           30  +<li>Add the COLLATE operator used to explicitly set the collating sequence
           31  +used by an expression.  This feature is considered experimental pending
           32  +additional testing.</li>
           33  +<li>Allow up to 64 tables in a join - the old limit was 32.</li>
           34  +<li>Added two new experimental functions:
           35  +<a href="lang_expr.html#randomblobFunc">randomBlob()</a> and
           36  +<a href="lang_expr.html#hexFunc">hex()</a>.
           37  +Their intended use is to facilitate generating 
           38  +<a href="http://en.wikipedia.org/wiki/UUID">UUIDs</a>.</li>
           39  +<li>Fix a problem where
           40  +<a href="pragma.html#pragma_count_changes">PRAGMA count_changes</a> was
           41  +causing incorrect results for updates on tables with triggers</li>
           42  +<li>Fix a bug in the ORDER BY clause optimizer for joins where the
           43  +left-most table in the join is constrained by a UNIQUE index.</li>
           44  +<li>Fixed a bug in the "copy" method of the TCL interface.</li>
           45  +<li>Bug fixes in fts1 and fts2 modules.</li>
           46  +}
    27     47   
    28     48   chng {2007 January 27 (3.3.12)} {
    29     49   <li>Fix another bug in the IS NULL optimization that was added in
    30     50   version 3.3.9.</li>
    31     51   <li>Fix a assertion fault that occurred on deeply nested views.</li>
    32     52   <li>Limit the amount of output that
    33     53   <a href="pragma.html#pragma_integrity_check">PRAGMA integrity_check</a>

Changes to www/index.tcl.

    62     62   
    63     63   proc newsitem {date title text} {
    64     64     puts "<h3>$date - $title</h3>"
    65     65     regsub -all "\n( *\n)+" $text "</p>\n\n<p>" txt
    66     66     puts "<p>$txt</p>"
    67     67     puts "<hr width=\"50%\">"
    68     68   }
           69  +
           70  +newsitem {2007-Feb-13} {Version 3.3.13} {
           71  +  This version fixes a subtle bug in the ORDER BY optimizer that can 
           72  +  occur when using joins.  There are also a few minor enhancements.
           73  +  Upgrading is recommended.
           74  +}
    69     75   
    70     76   newsitem {2007-Jan-27} {Version 3.3.12} {
    71     77     The first published build of the previous version used the wrong
    72     78     set of source files.  Consequently, many people downloaded a build
    73     79     that was labeled as "3.3.11" but was really 3.3.10.  Version 3.3.12
    74     80     is released to clear up the ambiguity.  A couple more bugs have
    75     81     also been fixed and <a href="pragma.html#pragma_integrity_check">
................................................................................
    82     88   }
    83     89   
    84     90   newsitem {2007-Jan-9} {Version 3.3.10} {
    85     91     Version 3.3.10 fixes several bugs that were introduced by the previous
    86     92     release.  Upgrading is recommended.
    87     93   }
    88     94   
    89         -newsitem {2007-Jan-4} {Version 3.3.9} {
    90         -  Version 3.3.9 fixes bugs that can lead to database corruption under
    91         -  obscure and difficult to reproduce circumstances.  See
    92         -  <a href="http://www.sqlite.org/cvstrac/wiki?p=DatabaseCorruption">
    93         -  DatabaseCorruption</a> in the
    94         -  <a href="http://www.sqlite.org/cvstrac/wiki">wiki</a> for details.
    95         -  This release also adds the new
    96         -  <a href="capi3ref.html#sqlite3_prepare_v2">sqlite3_prepare_v2()</a>
    97         -  API and includes important bug fixes in the command-line
    98         -  shell and enhancements to the query optimizer.  Upgrading is
    99         -  recommended.
   100         -}
   101         -
   102         -newsitem {2006-Oct-9} {Version 3.3.8} {
   103         -  Version 3.3.8 adds support for full-text search using the 
   104         -  <a href="http://www.sqlite.org/cvstrac/wiki?p=FtsOne">FTS1
   105         -  module.</a>  There are also minor bug fixes.  Upgrade only if
   106         -  you want to try out the new full-text search capabilities or if
   107         -  you are having problems with 3.3.7.
   108         -}
   109         -
   110     95   puts {
   111     96   <p align="right"><a href="oldnews.html">Old news...</a></p>
   112     97   </td></tr></table>
   113     98   }
   114         -footer {$Id: index.tcl,v 1.149 2007/01/27 13:38:26 drh Exp $}
           99  +footer {$Id: index.tcl,v 1.150 2007/02/13 02:03:24 drh Exp $}

Changes to www/lang.tcl.

     1      1   #
     2      2   # Run this Tcl script to generate the lang-*.html files.
     3      3   #
     4         -set rcsid {$Id: lang.tcl,v 1.121 2007/02/01 23:02:46 drh Exp $}
            4  +set rcsid {$Id: lang.tcl,v 1.122 2007/02/13 02:03:25 drh Exp $}
     5      5   source common.tcl
     6      6   
     7      7   if {[llength $argv]>0} {
     8      8     set outputdir [lindex $argv 0]
     9      9   } else {
    10     10     set outputdir ""
    11     11   }
................................................................................
  1267   1267   <td valign="top" align="right">coalesce(<i>X</i>,<i>Y</i>,...)</td>
  1268   1268   <td valign="top">Return a copy of the first non-NULL argument.  If
  1269   1269   all arguments are NULL then NULL is returned.  There must be at least 
  1270   1270   2 arguments.</td>
  1271   1271   </tr>
  1272   1272   
  1273   1273   <tr>
         1274  +<td valign="top" align="right">
  1274   1275   <a name="globFunc"></a>
  1275         -<td valign="top" align="right">glob(<i>X</i>,<i>Y</i>)</td>
         1276  +glob(<i>X</i>,<i>Y</i>)</td>
  1276   1277   <td valign="top">This function is used to implement the
  1277   1278   "<b>X GLOB Y</b>" syntax of SQLite.  The
  1278   1279   <a href="capi3ref.html#sqlite3_create_function">sqlite3_create_function()</a> 
  1279   1280   interface can
  1280   1281   be used to override this function and thereby change the operation
  1281   1282   of the <a href="#globFunc">GLOB</a> operator.</td>
  1282   1283   </tr>
................................................................................
  1285   1286   <td valign="top" align="right">ifnull(<i>X</i>,<i>Y</i>)</td>
  1286   1287   <td valign="top">Return a copy of the first non-NULL argument.  If
  1287   1288   both arguments are NULL then NULL is returned. This behaves the same as 
  1288   1289   <b>coalesce()</b> above.</td>
  1289   1290   </tr>
  1290   1291   
  1291   1292   <tr>
  1292         -<td valign="top" align="right">hex(<i>X</i>)</td>
         1293  +<td valign="top" align="right">
         1294  +<a name="hexFunc">
         1295  +hex(<i>X</i>)</td>
  1293   1296   <td valign="top">The argument is interpreted as a BLOB.  The result
  1294   1297   is a hexadecimal rendering of the content of that blob.</td>
  1295   1298   </tr>
  1296   1299   
  1297   1300   <tr>
  1298   1301   <td valign="top" align="right">last_insert_rowid()</td>
  1299   1302   <td valign="top">Return the ROWID of the last row insert from this
................................................................................
  1305   1308   <td valign="top" align="right">length(<i>X</i>)</td>
  1306   1309   <td valign="top">Return the string length of <i>X</i> in characters.
  1307   1310   If SQLite is configured to support UTF-8, then the number of UTF-8
  1308   1311   characters is returned, not the number of bytes.</td>
  1309   1312   </tr>
  1310   1313   
  1311   1314   <tr>
         1315  +<td valign="top" align="right">
  1312   1316   <a name="likeFunc"></a>
  1313         -<td valign="top" align="right">like(<i>X</i>,<i>Y</i> [,<i>Z</i>])</td>
         1317  +like(<i>X</i>,<i>Y</i> [,<i>Z</i>])</td>
  1314   1318   <td valign="top">
  1315   1319   This function is used to implement the "<b>X LIKE Y [ESCAPE Z]</b>"
  1316   1320   syntax of SQL. If the optional ESCAPE clause is present, then the
  1317   1321   user-function is invoked with three arguments. Otherwise, it is
  1318   1322   invoked with two arguments only. The 
  1319   1323   <a href="capi3ref.html#sqlite3_create_function">
  1320   1324   sqlite_create_function()</a> interface can be used to override this
................................................................................
  1382   1386   <tr>
  1383   1387   <td valign="top" align="right">random(*)</td>
  1384   1388   <td valign="top">Return a pseudo-random integer
  1385   1389   between -9223372036854775808 and +9223372036854775807.</td>
  1386   1390   </tr>
  1387   1391   
  1388   1392   <tr>
  1389         -<td valign="top" align="right">randomblob(<i>N</i>)</td>
         1393  +<td valign="top" align="right">
         1394  +<a name="randomblobFunc">
         1395  +randomblob(<i>N</i>)</td>
  1390   1396   <td valign="top">Return a <i>N</i>-byte blob containing pseudo-random bytes.
  1391   1397   <i>N</i> should be a postive integer.</td>
  1392   1398   </tr>
  1393   1399   
  1394   1400   <tr>
  1395   1401   <td valign="top" align="right">round(<i>X</i>)<br>round(<i>X</i>,<i>Y</i>)</td>
  1396   1402   <td valign="top">Round off the number <i>X</i> to <i>Y</i> digits to the

Changes to www/oldnews.tcl.

     5      5   proc newsitem {date title text} {
     6      6     puts "<h3>$date - $title</h3>"
     7      7     regsub -all "\n( *\n)+" $text "</p>\n\n<p>" txt
     8      8     puts "<p>$txt</p>"
     9      9     puts "<hr width=\"50%\">"
    10     10   }
    11     11   
           12  +
           13  +newsitem {2007-Jan-4} {Version 3.3.9} {
           14  +  Version 3.3.9 fixes bugs that can lead to database corruption under
           15  +  obscure and difficult to reproduce circumstances.  See
           16  +  <a href="http://www.sqlite.org/cvstrac/wiki?p=DatabaseCorruption">
           17  +  DatabaseCorruption</a> in the
           18  +  <a href="http://www.sqlite.org/cvstrac/wiki">wiki</a> for details.
           19  +  This release also adds the new
           20  +  <a href="capi3ref.html#sqlite3_prepare_v2">sqlite3_prepare_v2()</a>
           21  +  API and includes important bug fixes in the command-line
           22  +  shell and enhancements to the query optimizer.  Upgrading is
           23  +  recommended.
           24  +}
           25  +
           26  +newsitem {2006-Oct-9} {Version 3.3.8} {
           27  +  Version 3.3.8 adds support for full-text search using the 
           28  +  <a href="http://www.sqlite.org/cvstrac/wiki?p=FtsOne">FTS1
           29  +  module.</a>  There are also minor bug fixes.  Upgrade only if
           30  +  you want to try out the new full-text search capabilities or if
           31  +  you are having problems with 3.3.7.
           32  +}
    12     33   
    13     34   newsitem {2006-Aug-12} {Version 3.3.7} {
    14     35     Version 3.3.7 includes support for loadable extensions and virtual
    15     36     tables.  But both features are still considered "beta" and their
    16     37     APIs are subject to change in a future release.  This release is
    17     38     mostly to make available the minor bug fixes that have accumulated
    18     39     since 3.3.6.  Upgrading is not necessary.  Do so only if you encounter
................................................................................
   377    398     changes to both the C-language API and the underlying file format
   378    399     that will enable SQLite to better support internationalization.
   379    400     The first beta is schedule for release on 2004-July-01.
   380    401   
   381    402     Plans are to continue to support SQLite version 2.8 with
   382    403     bug fixes.  But all new development will occur in version 3.0.
   383    404   }
   384         -footer {$Id: oldnews.tcl,v 1.18 2007/01/22 13:06:03 drh Exp $}
          405  +footer {$Id: oldnews.tcl,v 1.19 2007/02/13 02:03:25 drh Exp $}