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.

1 files changed, 4 insertions, 2 deletions

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/ \