From 60589cfcfec98859c8db75a0892c095b143f3ea6 Mon Sep 17 00:00:00 2001 From: drh Date: Tue, 13 Feb 2007 02:03:23 +0000 Subject: [PATCH] Changes in preparation for version 3.3.13. (CVS 3637) FossilOrigin-Name: 7799a0b63dd4ab6f422f138e5b423d6fb00529fb --- VERSION | 2 +- manifest | 20 ++++++++++---------- manifest.uuid | 2 +- www/changes.tcl | 20 ++++++++++++++++++++ www/index.tcl | 29 +++++++---------------------- www/lang.tcl | 16 +++++++++++----- www/oldnews.tcl | 23 ++++++++++++++++++++++- 7 files changed, 72 insertions(+), 40 deletions(-) diff --git a/VERSION b/VERSION index 4d541eb209..6c165c2846 100644 --- a/VERSION +++ b/VERSION @@ -1 +1 @@ -3.3.12 +3.3.13 diff --git a/manifest b/manifest index 17c94ed5a1..90bfbfb433 100644 --- a/manifest +++ b/manifest @@ -1,9 +1,9 @@ -C Explanation\sof\sthe\s"fragmentation"\sline\sis\sadded\sto\sthe\shelp\smessage\sat\nthe\send\sof\sthe\soutput\sof\ssqlite3_analyzer.\s(CVS\s3636) -D 2007-02-13T01:41:53 +C Changes\sin\spreparation\sfor\sversion\s3.3.13.\s(CVS\s3637) +D 2007-02-13T02:03:24 F Makefile.in 7fa74bf4359aa899da5586e394d17735f221315f F Makefile.linux-gcc 2d8574d1ba75f129aba2019f0b959db380a90935 F README 9c4e2d6706bdcc3efdd773ce752a8cdab4f90028 -F VERSION 6a9608ed1127dffbe0c612b89002a68ce182779d +F VERSION e31cc83750f9f93f8c53236f6618cb876fdd9d1a F aclocal.m4 a8df0ae21d1ac797fa7d7eaa1703412bc61b973f F addopcodes.awk 701697fae48376375ec8532c3d04e910cfeef352 F art/2005osaward.gif 0d1851b2a7c1c9d0ccce545f3e14bca42d7fd248 @@ -389,7 +389,7 @@ F www/autoinc.tcl b357f5ba954b046ee35392ce0f884a2fcfcdea06 F www/c_interface.tcl b51b08591554c16a0c3ef718364a508ac25abc7e F www/capi3.tcl 7a7cc225fe02eb7ab861a6019b08baa0014409e1 F www/capi3ref.tcl 9adb2d2313c3c5e9c6d6240c1d8f3d11dd533c59 -F www/changes.tcl 1dd3ded5a3a1b4f587c2bf913a5d4518220dd60f +F www/changes.tcl 62e0bb77ba7e291c2ceb3e06aff0580bb468b60b F www/common.tcl 14d121c28532ad20c3e349caa4db708b0b822083 F www/compile.tcl 276546d7eb445add5a867193bbd80f6919a6b084 F www/conflict.tcl cdd0f4b59b0ba6d61f67e6a38f3ae45853bacb30 @@ -408,13 +408,13 @@ F www/fileformat.tcl 900c95b9633abc3dcfc384d9ddd8eb4876793059 F www/formatchng.tcl bbb8af1ee494a71031acac4c8d8c51535f23b9df F www/fullscanb.gif f7c94cb227f060511f8909e10f570157263e9a25 F www/index-ex1-x-b.gif f9b1d85c3fa2435cf38b15970c7e3aa1edae23a3 -F www/index.tcl 7f67d421e4c1f48083c178bee460a27220f4fcc1 +F www/index.tcl 688cf1280232f4964d8d07fda65e166a4b2e16cc F www/indirect1b1.gif adfca361d2df59e34f9c5cac52a670c2bfc303a1 -F www/lang.tcl 65d0aa787aa55619dd7a8497306ea539f1201bf3 +F www/lang.tcl 5e7888c2d33ff521173ece39ddad53596700e2d9 F www/lockingv3.tcl f59b19d6c8920a931f096699d6faaf61c05db55f F www/mingw.tcl d96b451568c5d28545fefe0c80bee3431c73f69c F www/nulls.tcl ec35193f92485b87b90a994a01d0171b58823fcf -F www/oldnews.tcl 999cd52516da0eee571de7ea4ae76282dd6ec24a +F www/oldnews.tcl 32688aa238d455f080501201a25001cbf45f2bb0 F www/omitted.tcl ee6b46f83d513b2187869740da829a700e1a355e F www/opcode.tcl 5bd68059416b223515a680d410a9f7cb6736485f F www/optimizer.tcl d6812a10269bd0d7c488987aac0ad5036cace9dc @@ -432,7 +432,7 @@ F www/tclsqlite.tcl bb0d1357328a42b1993d78573e587c6dcbc964b9 F www/vdbe.tcl 87a31ace769f20d3627a64fa1fade7fed47b90d0 F www/version3.tcl 890248cf7b70e60c383b0e84d77d5132b3ead42b F www/whentouse.tcl 97e2b5cd296f7d8057e11f44427dea8a4c2db513 -P 82aed271a4a69e3dad6013b83cc7d492b7fed164 -R c7311865a9d75eb453f0b44118fce463 +P 31e5073c58f43b84d26218d70e6f6558c406803e +R fc066cde96130dfec06f20ce7f18d96c U drh -Z 02955294dcc6cffe6c0af5716910b9e0 +Z fd4ca1752cd0e86bf8e7a5383fb7c65d diff --git a/manifest.uuid b/manifest.uuid index a57b3b32ae..04c3af7be5 100644 --- a/manifest.uuid +++ b/manifest.uuid @@ -1 +1 @@ -31e5073c58f43b84d26218d70e6f6558c406803e \ No newline at end of file +7799a0b63dd4ab6f422f138e5b423d6fb00529fb \ No newline at end of file diff --git a/www/changes.tcl b/www/changes.tcl index 10636199db..e5add5dee5 100644 --- a/www/changes.tcl +++ b/www/changes.tcl @@ -25,6 +25,26 @@ proc chng {date desc} { puts "

" } +chng {2007 February 13 (3.3.13)} { +
  • Add a "fragmentation" measurement in the output of sqlite3_analyzer.
    • +
  • Add the COLLATE operator used to explicitly set the collating sequence +used by an expression. This feature is considered experimental pending +additional testing.
    • +
  • Allow up to 64 tables in a join - the old limit was 32.
    • +
  • Added two new experimental functions: +randomBlob() and +hex(). +Their intended use is to facilitate generating +UUIDs.
    • +
  • Fix a problem where +PRAGMA count_changes was +causing incorrect results for updates on tables with triggers
    • +
  • Fix a bug in the ORDER BY clause optimizer for joins where the +left-most table in the join is constrained by a UNIQUE index.
    • +
  • Fixed a bug in the "copy" method of the TCL interface.
    • +
  • Bug fixes in fts1 and fts2 modules.
    • +} + chng {2007 January 27 (3.3.12)} {
  • Fix another bug in the IS NULL optimization that was added in version 3.3.9.
    • diff --git a/www/index.tcl b/www/index.tcl index 196df1f8cd..afff6ba5d1 100644 --- a/www/index.tcl +++ b/www/index.tcl @@ -67,6 +67,12 @@ proc newsitem {date title text} { puts "
    " } +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 @@ -86,29 +92,8 @@ newsitem {2007-Jan-9} {Version 3.3.10} { release. Upgrading is recommended. } -newsitem {2007-Jan-4} {Version 3.3.9} { - Version 3.3.9 fixes bugs that can lead to database corruption under - obscure and difficult to reproduce circumstances. See - - DatabaseCorruption in the - wiki for details. - This release also adds the new - sqlite3_prepare_v2() - API and includes important bug fixes in the command-line - shell and enhancements to the query optimizer. Upgrading is - recommended. -} - -newsitem {2006-Oct-9} {Version 3.3.8} { - Version 3.3.8 adds support for full-text search using the - FTS1 - module. There are also minor bug fixes. Upgrade only if - you want to try out the new full-text search capabilities or if - you are having problems with 3.3.7. -} - puts {

    Old news...

    } -footer {$Id: index.tcl,v 1.149 2007/01/27 13:38:26 drh Exp $} +footer {$Id: index.tcl,v 1.150 2007/02/13 02:03:24 drh Exp $} diff --git a/www/lang.tcl b/www/lang.tcl index 83c6d062f0..a42b5cb094 100644 --- a/www/lang.tcl +++ b/www/lang.tcl @@ -1,7 +1,7 @@ # # Run this Tcl script to generate the lang-*.html files. # -set rcsid {$Id: lang.tcl,v 1.121 2007/02/01 23:02:46 drh Exp $} +set rcsid {$Id: lang.tcl,v 1.122 2007/02/13 02:03:25 drh Exp $} source common.tcl if {[llength $argv]>0} { @@ -1271,8 +1271,9 @@ all arguments are NULL then NULL is returned. There must be at least + -glob(X,Y) +glob(X,Y) This function is used to implement the "X GLOB Y" syntax of SQLite. The sqlite3_create_function() @@ -1289,7 +1290,9 @@ both arguments are NULL then NULL is returned. This behaves the same as -hex(X) + + +hex(X) The argument is interpreted as a BLOB. The result is a hexadecimal rendering of the content of that blob. @@ -1309,8 +1312,9 @@ characters is returned, not the number of bytes. + -like(X,Y [,Z]) +like(X,Y [,Z]) This function is used to implement the "X LIKE Y [ESCAPE Z]" syntax of SQL. If the optional ESCAPE clause is present, then the @@ -1386,7 +1390,9 @@ between -9223372036854775808 and +9223372036854775807. -randomblob(N) + + +randomblob(N) Return a N-byte blob containing pseudo-random bytes. N should be a postive integer. diff --git a/www/oldnews.tcl b/www/oldnews.tcl index 7836088752..6b40e943b8 100644 --- a/www/oldnews.tcl +++ b/www/oldnews.tcl @@ -10,6 +10,27 @@ proc newsitem {date title text} { } +newsitem {2007-Jan-4} {Version 3.3.9} { + Version 3.3.9 fixes bugs that can lead to database corruption under + obscure and difficult to reproduce circumstances. See + + DatabaseCorruption in the + wiki for details. + This release also adds the new + sqlite3_prepare_v2() + API and includes important bug fixes in the command-line + shell and enhancements to the query optimizer. Upgrading is + recommended. +} + +newsitem {2006-Oct-9} {Version 3.3.8} { + Version 3.3.8 adds support for full-text search using the + FTS1 + module. There are also minor bug fixes. Upgrade only if + you want to try out the new full-text search capabilities or if + you are having problems with 3.3.7. +} + newsitem {2006-Aug-12} {Version 3.3.7} { Version 3.3.7 includes support for loadable extensions and virtual tables. But both features are still considered "beta" and their @@ -381,4 +402,4 @@ newsitem {2004-Apr-23} {Work Begins On SQLite Version 3} { 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.18 2007/01/22 13:06:03 drh Exp $} +footer {$Id: oldnews.tcl,v 1.19 2007/02/13 02:03:25 drh Exp $} -- 2.47.2