Tue Mar 4 10:46:55 2008 UTC ()
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.


(wiz)
diff -r1.17 -r1.18 pkgsrc/databases/sqlite3/Makefile.common
diff -r1.15 -r1.16 pkgsrc/databases/sqlite3/distinfo
diff -r1.6 -r1.7 pkgsrc/databases/sqlite3-tcl/Makefile

cvs diff -r1.17 -r1.18 pkgsrc/databases/sqlite3/Makefile.common (expand / switch to unified diff)

--- pkgsrc/databases/sqlite3/Makefile.common 2007/11/15 14:11:53 1.17
+++ pkgsrc/databases/sqlite3/Makefile.common 2008/03/04 10:46:55 1.18
@@ -1,16 +1,18 @@ @@ -1,16 +1,18 @@
1# $NetBSD: Makefile.common,v 1.17 2007/11/15 14:11:53 rillig Exp $ 1# $NetBSD: Makefile.common,v 1.18 2008/03/04 10:46:55 wiz Exp $
2 2
3DISTNAME= sqlite-3.5.2 3# used by databases/sqlite3-tcl/Makefile
 4
 5DISTNAME= sqlite-3.5.6
4PKGNAME= ${DISTNAME:S/-/3-/} 6PKGNAME= ${DISTNAME:S/-/3-/}
5CATEGORIES= databases 7CATEGORIES= databases
6MASTER_SITES= http://www.hwaci.com/sw/sqlite/ \ 8MASTER_SITES= http://www.hwaci.com/sw/sqlite/ \
7 http://www.sqlite.org/ 9 http://www.sqlite.org/
8 10
9MAINTAINER= pkgsrc-users@NetBSD.org 11MAINTAINER= pkgsrc-users@NetBSD.org
10HOMEPAGE= http://www.sqlite.org/ 12HOMEPAGE= http://www.sqlite.org/
11COMMENT= SQL Database Engine in a C Library 13COMMENT= SQL Database Engine in a C Library
12 14
13DISTINFO_FILE= ${.CURDIR}/../../databases/sqlite3/distinfo 15DISTINFO_FILE= ${.CURDIR}/../../databases/sqlite3/distinfo
14PATCHDIR= ${.CURDIR}/../../databases/sqlite3/patches 16PATCHDIR= ${.CURDIR}/../../databases/sqlite3/patches
15 17
16GNU_CONFIGURE= yes 18GNU_CONFIGURE= yes

cvs diff -r1.15 -r1.16 pkgsrc/databases/sqlite3/distinfo (expand / switch to unified diff)

--- pkgsrc/databases/sqlite3/distinfo 2007/11/15 10:39:18 1.15
+++ pkgsrc/databases/sqlite3/distinfo 2008/03/04 10:46:55 1.16
@@ -1,6 +1,6 @@ @@ -1,6 +1,6 @@
1$NetBSD: distinfo,v 1.15 2007/11/15 10:39:18 rillig Exp $ 1$NetBSD: distinfo,v 1.16 2008/03/04 10:46:55 wiz Exp $
2 2
3SHA1 (sqlite-3.5.2.tar.gz) = e347b7040c0da586468811f78c3bc4111f33fc19 3SHA1 (sqlite-3.5.6.tar.gz) = e913e42445ce8ffc6fe534031c2d526468b901f7
4RMD160 (sqlite-3.5.2.tar.gz) = fb5d8af8ab6c0c3b21493a114bdfec789319fc3f 4RMD160 (sqlite-3.5.6.tar.gz) = 602f49e6edcc7cc43d0972eabf8e937cd3a72888
5Size (sqlite-3.5.2.tar.gz) = 2487615 bytes 5Size (sqlite-3.5.6.tar.gz) = 2543979 bytes
6SHA1 (patch-aa) = 0f6b1cd63810ce06874c781dfda2d3b1531d91da 6SHA1 (patch-aa) = 0f6b1cd63810ce06874c781dfda2d3b1531d91da

cvs diff -r1.6 -r1.7 pkgsrc/databases/sqlite3-tcl/Makefile (expand / switch to unified diff)

--- pkgsrc/databases/sqlite3-tcl/Makefile 2007/01/11 19:08:48 1.6
+++ pkgsrc/databases/sqlite3-tcl/Makefile 2008/03/04 10:46:55 1.7
@@ -1,18 +1,18 @@ @@ -1,18 +1,18 @@
1# $NetBSD: Makefile,v 1.6 2007/01/11 19:08:48 drochner Exp $ 1# $NetBSD: Makefile,v 1.7 2008/03/04 10:46:55 wiz Exp $
2 2
3.include "../../databases/sqlite3/Makefile.common" 3.include "../../databases/sqlite3/Makefile.common"
4 4
5PKGNAME:= ${PKGNAME:S/-/-tcl-/} 5PKGNAME:= ${PKGNAME:S/-/-tcl-/}
6 6
7CONFIGURE_ARGS+= --with-tcl=${BUILDLINK_PREFIX.tcl}/lib 7CONFIGURE_ARGS+= --with-tcl=${BUILDLINK_PREFIX.tcl}/lib
8 8
9BUILD_TARGET= libtclsqlite3.la 9BUILD_TARGET= libtclsqlite3.la
10INSTALL_TARGET= tcl_install 10INSTALL_TARGET= tcl_install
11TEST_TARGET= test 11TEST_TARGET= test
12 12
13BUILDLINK_API_DEPENDS.sqlite3+= sqlite3>=3.2.7 13BUILDLINK_API_DEPENDS.sqlite3+= sqlite3>=3.5.6
14 14
15.include "../../databases/sqlite3/buildlink3.mk" 15.include "../../databases/sqlite3/buildlink3.mk"
16.include "../../lang/tcl/buildlink3.mk" 16.include "../../lang/tcl/buildlink3.mk"
17.include "../../devel/readline/buildlink3.mk" 17.include "../../devel/readline/buildlink3.mk"
18.include "../../mk/bsd.pkg.mk" 18.include "../../mk/bsd.pkg.mk"