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.diff -r1.17 -r1.18 pkgsrc/databases/sqlite3/Makefile.common
(wiz)
@@ -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 | |||
3 | DISTNAME= sqlite-3.5.2 | 3 | # used by databases/sqlite3-tcl/Makefile | |
4 | ||||
5 | DISTNAME= sqlite-3.5.6 | |||
4 | PKGNAME= ${DISTNAME:S/-/3-/} | 6 | PKGNAME= ${DISTNAME:S/-/3-/} | |
5 | CATEGORIES= databases | 7 | CATEGORIES= databases | |
6 | MASTER_SITES= http://www.hwaci.com/sw/sqlite/ \ | 8 | MASTER_SITES= http://www.hwaci.com/sw/sqlite/ \ | |
7 | http://www.sqlite.org/ | 9 | http://www.sqlite.org/ | |
8 | 10 | |||
9 | MAINTAINER= pkgsrc-users@NetBSD.org | 11 | MAINTAINER= pkgsrc-users@NetBSD.org | |
10 | HOMEPAGE= http://www.sqlite.org/ | 12 | HOMEPAGE= http://www.sqlite.org/ | |
11 | COMMENT= SQL Database Engine in a C Library | 13 | COMMENT= SQL Database Engine in a C Library | |
12 | 14 | |||
13 | DISTINFO_FILE= ${.CURDIR}/../../databases/sqlite3/distinfo | 15 | DISTINFO_FILE= ${.CURDIR}/../../databases/sqlite3/distinfo | |
14 | PATCHDIR= ${.CURDIR}/../../databases/sqlite3/patches | 16 | PATCHDIR= ${.CURDIR}/../../databases/sqlite3/patches | |
15 | 17 | |||
16 | GNU_CONFIGURE= yes | 18 | GNU_CONFIGURE= yes |
@@ -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 | |||
3 | SHA1 (sqlite-3.5.2.tar.gz) = e347b7040c0da586468811f78c3bc4111f33fc19 | 3 | SHA1 (sqlite-3.5.6.tar.gz) = e913e42445ce8ffc6fe534031c2d526468b901f7 | |
4 | RMD160 (sqlite-3.5.2.tar.gz) = fb5d8af8ab6c0c3b21493a114bdfec789319fc3f | 4 | RMD160 (sqlite-3.5.6.tar.gz) = 602f49e6edcc7cc43d0972eabf8e937cd3a72888 | |
5 | Size (sqlite-3.5.2.tar.gz) = 2487615 bytes | 5 | Size (sqlite-3.5.6.tar.gz) = 2543979 bytes | |
6 | SHA1 (patch-aa) = 0f6b1cd63810ce06874c781dfda2d3b1531d91da | 6 | SHA1 (patch-aa) = 0f6b1cd63810ce06874c781dfda2d3b1531d91da |
@@ -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 | |||
5 | PKGNAME:= ${PKGNAME:S/-/-tcl-/} | 5 | PKGNAME:= ${PKGNAME:S/-/-tcl-/} | |
6 | 6 | |||
7 | CONFIGURE_ARGS+= --with-tcl=${BUILDLINK_PREFIX.tcl}/lib | 7 | CONFIGURE_ARGS+= --with-tcl=${BUILDLINK_PREFIX.tcl}/lib | |
8 | 8 | |||
9 | BUILD_TARGET= libtclsqlite3.la | 9 | BUILD_TARGET= libtclsqlite3.la | |
10 | INSTALL_TARGET= tcl_install | 10 | INSTALL_TARGET= tcl_install | |
11 | TEST_TARGET= test | 11 | TEST_TARGET= test | |
12 | 12 | |||
13 | BUILDLINK_API_DEPENDS.sqlite3+= sqlite3>=3.2.7 | 13 | BUILDLINK_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" |