Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
| 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: |
7799a0b63dd4ab6f422f138e5b423d6f |
| User & Date: | drh 2007-02-13 02:03:24 |
|
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 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 $}