Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Documentation updates in preparation for 3.4.0. (CVS 4064) |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
5232fd29d01d48d70b6d8f34ad5d0e2d |
User & Date: | drh 2007-06-15 12:16:31.000 |
Context
2007-06-15
| ||
12:41 | Clean up a variable in tkt2409.test that would cause subsequent tests to fail. (CVS 4065) (check-in: 0f944cb9fb user: drh tags: trunk) | |
12:16 | Documentation updates in preparation for 3.4.0. (CVS 4064) (check-in: 5232fd29d0 user: drh tags: trunk) | |
12:06 | Update the btree file format description in btreeInt.h. (CVS 4063) (check-in: 1ac160d3dc user: drh tags: trunk) | |
Changes
Changes to VERSION.
|
| | | 1 | 3.4.0 |
Changes to www/changes.tcl.
︙ | ︙ | |||
18 19 20 21 22 23 24 | proc chng {date desc} { if {[regexp {\(([0-9.]+)\)} $date all vers]} { set label [string map {. _} $vers] puts "<A NAME=\"version_$label\">" } puts "<DT><B>$date</B></DT>" | > > | > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > | 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 | proc chng {date desc} { if {[regexp {\(([0-9.]+)\)} $date all vers]} { set label [string map {. _} $vers] puts "<A NAME=\"version_$label\">" } puts "<DT><B>$date</B></DT>" regsub -all {[Tt]icket #(\d+)} $desc \ {<a href="http://www.sqlite.org/cvstrac/tktview?tn=\1">\0</a>} desc puts "<DD><P><UL>$desc</UL></P>" puts "</DD>" } chng {2007 June 15 (3.4.0)} { <li>Fix a bug that can lead to database corruption if an SQLITE_BUSY error occurs in the middle of an explicit transaction and that transaction is later committed. Ticket #2409. See the <a href="http://www.sqlite.org/cvstrac/wiki?p=CorruptionFollowingBusyError"> CorruptionFollowingBusyError</a> wiki page for details.</i> <li>Added explicit <a href="limits.html">upper bounds</a> on the sizes and quantities of things SQLite can process. This change might break some applications that use SQLite in the extreme, which is when the current release is 3.4.0 instead of 3.3.18.</li> <li>Added support for <a href="capi3ref.html#sqlite3_blob_open"> Incremental BLOB I/O</a>.</li> <li>Added the <a href="capi3ref.html#sqlite3_bind_zeroblob">zeroblob API</a> and the <a href="lang_expr.html#zeroblob">zeroblob()</a> SQL function.</li> <li>Added support for <a href="pragma.html#pragma_incremental_vacuum"> Incremntal Vacuum</a>.</li> <li>Added the SQLITE_MIXED_ENDIAN_64BIT_FLOAT compile-time option to suppport ARM7 processors with goofy endianness.</li> <li>Removed all instances of sprintf() and strcpy() from the core library.</li> <li>Added support for <a href="http://www.icu-project.org/"> International Components for Unicode (ICU)</a> to the full-text search extensions. </ul><p> <ul type="circle"> <li>In the windows OS driver, reacquire a SHARED lock if an attempt to acquire an EXCLUSIVE lock fails. Ticket #2354</li> <li>Fix the REPLACE() function so that it returns NULL if the second argument is an empty string. Ticket #2324.</li> <li>Document the hazards of type coversions in <a href="capi3ref.html#sqlite3_column_blob">sqlite3_column_blob()</a> and related APIs. Fix unnecessary type conversions. Ticket #2321.</li> <li>Internationalization of the TRIM() functin. Ticket #2323</li> <li>Use memmove() instead of memcpy() when moving between memory regions that might overlap. Ticket #2334</li> <li>Fix an optimizer bug involving subqueries in a compound SELECT that has both an ORDER BY and a LIMIT clause. Ticket #2339.</li> <li>Make sure the <a href="capi3ref.html#sqlite3_snprintf">sqlite3_snprintf() </a> interface does not zero-terminate the buffer if the buffer size is less than 1. Ticket #2341</li> <li>Fix the built-in printf logic so that it prints "NaN" not "Inf" for floating-point NaNs. Ticket #2345</li> <li>When converting BLOB to TEXT, use the text encoding of the main database. Ticket #2349</li> <li>Keep the full precision of integers (if possible) when casting to NUMERIC. Ticket #2364</li> <li>Fix a bug in the handling of UTF16 codepoint 0xE000</li> <li>Consider explicit collate clauses when matching WHERE constraints to indices in the query optimizer. Ticket #2391</li> <li>Fix the query optimizer to correctly handle constant expressions in the ON clause of a LEFT JOIN. Ticket #2403</li> <li>Fix the query optimizer to handle rowid comparisions to NULL correctly. Ticket #2404</li> <li>Fix many potental segfaults that could be caused by malicious SQL statements.</li> } chng {2007 April 25 (3.3.17)} { <li>When the "write_version" value of the database header is larger than what the library understands, make the database read-only instead of unreadable.</li> <li>Other minor bug fixes</li> |
︙ | ︙ |
Changes to www/index.tcl.
︙ | ︙ | |||
66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 | proc newsitem {date title text} { puts "<h3>$date - $title</h3>" regsub -all "\n( *\n)+" $text "</p>\n\n<p>" txt puts "<p>$txt</p>" puts "<hr width=\"50%\">" } newsitem {2007-Apr-25} {Version 3.3.17} { This version fixes a bug in the forwards-compatibility logic of SQLite that was causing a database to become unreadable when it should have been read-only. Upgrade from 3.3.16 only if you plan to deploy into a product that might need to be upgraded in the future. For day to day use, it probably does not matter. } newsitem {2007-Apr-18} {Version 3.3.16} { Performance improvements added in 3.3.14 but mistakenly turned off in 3.3.15 have been reinstated. A bug has been fixed that prevented VACUUM from running if a NULL value was in a UNIQUE column. } | > > > > > > > > > > > > > > > > > > < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < | | 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 | proc newsitem {date title text} { puts "<h3>$date - $title</h3>" regsub -all "\n( *\n)+" $text "</p>\n\n<p>" txt puts "<p>$txt</p>" puts "<hr width=\"50%\">" } newsitem {2007-Jun-15} {Version 3.4.0} { This release fixes a bug that can lead to database corruption. Upgrading is strongly recommended. If you must continue using an older version of SQLite, please at least read <a href="http://www.sqlite.org/cvstrac/wiki?p=CorruptionFollowingBusyError"> how to avoid the bug</a>. <p> This release also adds explicit <a href="limits.html">limits</a> on the sizes and quantities of things SQLite will handle. The new limits might causes minor problems for some existing applications that push the envelope, which is the reason that this release is 3.4.0 instead of 3.3.18. </p> There are also new features, including <a href="capi3ref.html#sqlite3_blob_open">incremental BLOB I/O</a> and <a href="pragma.html#pragma_incremental_vacuum">incremental vacuum</a>. See the <a href="changes.html">change log</a> for additional information. } newsitem {2007-Apr-25} {Version 3.3.17} { This version fixes a bug in the forwards-compatibility logic of SQLite that was causing a database to become unreadable when it should have been read-only. Upgrade from 3.3.16 only if you plan to deploy into a product that might need to be upgraded in the future. For day to day use, it probably does not matter. } newsitem {2007-Apr-18} {Version 3.3.16} { Performance improvements added in 3.3.14 but mistakenly turned off in 3.3.15 have been reinstated. A bug has been fixed that prevented VACUUM from running if a NULL value was in a UNIQUE column. } puts { <p align="right"><a href="oldnews.html">Old news...</a></p> </td></tr></table> } footer {$Id: index.tcl,v 1.156 2007/06/15 12:16:32 drh Exp $} |
Changes to www/lang.tcl.
1 2 3 | # # Run this Tcl script to generate the lang-*.html files. # | | | 1 2 3 4 5 6 7 8 9 10 11 | # # Run this Tcl script to generate the lang-*.html files. # set rcsid {$Id: lang.tcl,v 1.130 2007/06/15 12:16:32 drh Exp $} source common.tcl if {[llength $argv]>0} { set outputdir [lindex $argv 0] } else { set outputdir "" } |
︙ | ︙ | |||
1481 1482 1483 1484 1485 1486 1487 1488 1489 1490 1491 1492 1493 1494 | <tr> <td valign="top" align="right">upper(<i>X</i>)</td> <td valign="top">Return a copy of input string <i>X</i> converted to all upper-case letters. The implementation of this function uses the C library routine <b>toupper()</b> which means it may not work correctly on UTF-8 strings.</td> </tr> </table> <b>Date And Time Functions</b> <p>Date and time functions are documented in the <a href="http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions"> SQLite Wiki</a>.</p> | > > > > > > > > > > | 1481 1482 1483 1484 1485 1486 1487 1488 1489 1490 1491 1492 1493 1494 1495 1496 1497 1498 1499 1500 1501 1502 1503 1504 | <tr> <td valign="top" align="right">upper(<i>X</i>)</td> <td valign="top">Return a copy of input string <i>X</i> converted to all upper-case letters. The implementation of this function uses the C library routine <b>toupper()</b> which means it may not work correctly on UTF-8 strings.</td> </tr> <tr> <td valign="top" align="right">zeroblob(<i>N</i>)</td> <td valign="top"><a name="zeroblob"> Return a BLOB consisting of N bytes of 0x00. SQLite manages these zeroblobs very efficiently. Zeroblobs can be use to reserve space for a BLOB that is later written using <a href="capi3ref.html#sqlite3_blob_open">incremental BLOB I/O</a>.</td> </tr> </table> <b>Date And Time Functions</b> <p>Date and time functions are documented in the <a href="http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions"> SQLite Wiki</a>.</p> |
︙ | ︙ |
Changes to www/oldnews.tcl.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 | #!/usr/bin/tclsh source common.tcl header {SQLite Older News} proc newsitem {date title text} { puts "<h3>$date - $title</h3>" regsub -all "\n( *\n)+" $text "</p>\n\n<p>" txt puts "<p>$txt</p>" puts "<hr width=\"50%\">" } newsitem {2007-Jan-22} {Version 3.3.11} { Version 3.3.11 fixes for a few more problems in version 3.3.9 that version 3.3.10 failed to catch. Upgrading is recommended. } newsitem {2007-Jan-9} {Version 3.3.10} { | > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 | #!/usr/bin/tclsh source common.tcl header {SQLite Older News} proc newsitem {date title text} { puts "<h3>$date - $title</h3>" regsub -all "\n( *\n)+" $text "</p>\n\n<p>" txt puts "<p>$txt</p>" puts "<hr width=\"50%\">" } newsitem {2007-Apr-09} {Version 3.3.15} { An annoying bug introduced in 3.3.14 has been fixed. There are also many enhancements to the test suite. } newsitem {2007-Apr-02} {Version 3.3.14} { This version focuses on performance improvements. If you recompile <a href="http://www.sqlite.org/cvstrac/wiki?p=TheAmalgamation"> the amalgamation</a> using GCC option -O3 (the precompiled binaries use -O2) you may see performance improvements of 35% or more over version 3.3.13 depending on your workload. This version also adds support for <a href="pragma.html#pragma_locking_mode"> exclusive access mode</a>. } newsitem {2007-Feb-13} {Version 3.3.13} { This version fixes a subtle bug in the ORDER BY optimizer that can occur when using joins. There are also a few minor enhancements. Upgrading is recommended. } newsitem {2007-Jan-27} {Version 3.3.12} { The first published build of the previous version used the wrong set of source files. Consequently, many people downloaded a build that was labeled as "3.3.11" but was really 3.3.10. Version 3.3.12 is released to clear up the ambiguity. A couple more bugs have also been fixed and <a href="pragma.html#pragma_integrity_check"> PRAGMA integrity_check</a> has been enhanced. } newsitem {2007-Jan-22} {Version 3.3.11} { Version 3.3.11 fixes for a few more problems in version 3.3.9 that version 3.3.10 failed to catch. Upgrading is recommended. } newsitem {2007-Jan-9} {Version 3.3.10} { |
︙ | ︙ | |||
408 409 410 411 412 413 414 | changes to both the C-language API and the underlying file format that will enable SQLite to better support internationalization. The first beta is schedule for release on 2004-July-01. Plans are to continue to support SQLite version 2.8 with bug fixes. But all new development will occur in version 3.0. } | | | 439 440 441 442 443 444 445 446 | changes to both the C-language API and the underlying file format that will enable SQLite to better support internationalization. The first beta is schedule for release on 2004-July-01. Plans are to continue to support SQLite version 2.8 with bug fixes. But all new development will occur in version 3.0. } footer {$Id: oldnews.tcl,v 1.21 2007/06/15 12:16:32 drh Exp $} |