Update to 3.5.6:

2008 Feb 6 (3.5.6)

   * Fix a bug ( ticket #2913) that prevented virtual tables from working
     in a LEFT JOIN. The problem was introduced into shortly before the
     3.5.5 release.
   * Bring the OS/2 porting layer up-to-date.
   * Add the new sqlite3_result_error_code() API and use it in the
     implementation of ATTACH so that proper error codes are returned when
     an ATTACH fails.

2008 Jan 31 (3.5.5)

   * Convert the underlying virtual machine to be a register-based machine
     rather than a stack-based machine. The only user-visible change is in
     the output of EXPLAIN.
   * Add the build-in RTRIM collating sequence.

2007 Dec 14 (3.5.4)

   * Fix a critical bug in UPDATE or DELETE that occurs when an OR REPLACE
     clause or a trigger causes rows in the same table to be deleted as
     side effects. (See ticket #2832.) The most likely result of this bug
     is a segmentation fault, though database corruption is a possibility.
   * Bring the processing of ORDER BY into compliance with the SQL standard
     for case where a result alias and a table column name are in conflict.
     Correct behavior is to prefer the result alias. Older versions of
     SQLite incorrectly picked the table column. (See ticket #2822.)
   * The VACUUM command preserves the setting of the legacy_file_format
     pragma. ( Ticket #2804.)
   * Productize and officially support the group_concat() SQL function.
   * Better optimization of some IN operator expressions.
   * Add the ability to change the auto_vacuum status of a database by
     setting the auto_vaccum pragma and VACUUMing the database.
   * Prefix search in FTS3 is much more efficient.
   * Relax the SQL statement length restriction in the CLI so that the
     ".dump" output of databases with very large BLOBs and strings can be
     played back to recreate the database.
   * Other small bug fixes and optimizations.

2007 Nov 27 (3.5.3)

   * Move website and documentation files out of the source tree into a
     separate CM system.
   * Fix a long-standing bug in INSERT INTO ... SELECT ... statements where
     the SELECT is compound.
   * Fix a long-standing bug in RAISE(IGNORE) as used in BEFORE triggers.
   * Fixed the operator precedence for the ~ operator.
   * On win32, do not return an error when attempting to delete a file that
     does not exist.
   * Allow collating sequence names to be quoted.
   * Modify the TCL interface to use sqlite3_prepare_v2().
   * Fix multiple bugs that can occur following a malloc() failure.
   * sqlite3_step() returns SQLITE_MISUSE instead of crashing when called
     with a NULL parameter.
   * FTS3 now uses the SQLite memory allocator exclusively. The FTS3
     amalgamation can now be appended to the SQLite amalgamation to
     generate a super-amalgamation containing both.
   * The DISTINCT keyword now will sometimes use an INDEX if an appropriate
     index is available and the optimizer thinks its use might be
     advantageous.

3 files changed, 10 insertions, 8 deletions

diff --git a/databases/sqlite3-tcl/Makefile b/databases/sqlite3-tcl/Makefile
index d17d26e8720..fdb2198eb6e 100644
--- a/databases/sqlite3-tcl/Makefile
+++ b/databases/sqlite3-tcl/Makefile
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile,v 1.6 2007/01/11 19:08:48 drochner Exp $
+# $NetBSD: Makefile,v 1.7 2008/03/04 10:46:55 wiz Exp $
 
 .include "../../databases/sqlite3/Makefile.common"
 
@@ -10,7 +10,7 @@ BUILD_TARGET=		libtclsqlite3.la
 INSTALL_TARGET=		tcl_install
 TEST_TARGET=		test
 
-BUILDLINK_API_DEPENDS.sqlite3+=	sqlite3>=3.2.7
+BUILDLINK_API_DEPENDS.sqlite3+=	sqlite3>=3.5.6
 
 .include "../../databases/sqlite3/buildlink3.mk"
 .include "../../lang/tcl/buildlink3.mk"
diff --git a/databases/sqlite3/Makefile.common b/databases/sqlite3/Makefile.common
index cc22695ea04..4c20319312d 100644
--- a/databases/sqlite3/Makefile.common
+++ b/databases/sqlite3/Makefile.common
@@ -1,6 +1,8 @@
-# $NetBSD: Makefile.common,v 1.17 2007/11/15 14:11:53 rillig Exp $
+# $NetBSD: Makefile.common,v 1.18 2008/03/04 10:46:55 wiz Exp $
 
-DISTNAME=	sqlite-3.5.2
+# used by databases/sqlite3-tcl/Makefile
+
+DISTNAME=	sqlite-3.5.6
 PKGNAME=	${DISTNAME:S/-/3-/}
 CATEGORIES=	databases
 MASTER_SITES=	http://www.hwaci.com/sw/sqlite/ \
diff --git a/databases/sqlite3/distinfo b/databases/sqlite3/distinfo
index be463811da3..8978bcc9f7c 100644
--- a/databases/sqlite3/distinfo
+++ b/databases/sqlite3/distinfo
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.15 2007/11/15 10:39:18 rillig Exp $
+$NetBSD: distinfo,v 1.16 2008/03/04 10:46:55 wiz Exp $
 
-SHA1 (sqlite-3.5.2.tar.gz) = e347b7040c0da586468811f78c3bc4111f33fc19
-RMD160 (sqlite-3.5.2.tar.gz) = fb5d8af8ab6c0c3b21493a114bdfec789319fc3f
-Size (sqlite-3.5.2.tar.gz) = 2487615 bytes
+SHA1 (sqlite-3.5.6.tar.gz) = e913e42445ce8ffc6fe534031c2d526468b901f7
+RMD160 (sqlite-3.5.6.tar.gz) = 602f49e6edcc7cc43d0972eabf8e937cd3a72888
+Size (sqlite-3.5.6.tar.gz) = 2543979 bytes
 SHA1 (patch-aa) = 0f6b1cd63810ce06874c781dfda2d3b1531d91da