From c6c82865a8a2a4ff59440f8344190f082fe239f2 Mon Sep 17 00:00:00 2001 From: wiz Date: Fri, 30 Sep 2005 12:17:39 +0000 Subject: Update to 3.2.7: 2005 September 24 (3.2.7) * GROUP BY now considers NULLs to be equal again, as it should * Now compiles on Solaris and OpenBSD and other Unix variants that lack the fdatasync() function * Now compiles on MSVC++6 again * Fix uninitialized variables causing malfunctions for various obscure queries * Correctly compute a LEFT OUTER JOINs that is constrained on the left table only 2005 September 17 (3.2.6) * Fix a bug that can cause database corruption if a VACUUM (or autovacuum) fails and is rolled back on a database that is larger than 1GiB * LIKE optiization now works for columns with COLLATE NOCASE * ORDER BY and GROUP BY now use bounded memory * Added support for COUNT(DISTINCT expr) * Change the way SUM() handles NULL values in order to comply with the SQL standard * Use fdatasync() instead of fsync() where possible in order to speed up commits slightly * Use of the CROSS keyword in a join turns off the table reordering optimization * Added the experimental and undocumented EXPLAIN QUERY PLAN capability * Use the unicode API in windows 2005 August 27 (3.2.5) * Fix a bug effecting DELETE and UPDATE statements that changed more than 40960 rows. * Change the makefile so that it no longer requires GNUmake extensions * Fix the --enable-threadsafe option on the configure script * Fix a code generator bug that occurs when the left-hand side of an IN operator is constant and the right-hand side is a SELECT statement * The PRAGMA synchronous=off statement now disables syncing of the master journal file in addition to the normal rollback journals 2005 August 24 (3.2.4) * Fix a bug introduced in the previous release that can cause a segfault while generating code for complex WHERE clauses. * Allow floating point literals to begin or end with a decimal point. 2005 August 21 (3.2.3) * Added support for the CAST operator * Tcl interface allows BLOB values to be transferred to user-defined functions * Added the "transaction" method to the Tcl interface * Allow the DEFAULT value of a column to call functions that have constant operands * Added the ANALYZE command for gathering statistics on indices and using those statistics when picking an index in the optimizer * Remove the limit (formerly 100) on the number of terms in the WHERE clause * The right-hand side of the IN operator can now be a list of expressions instead of just a list of constants * Rework the optimizer so that it is able to make better use of indices * The order of tables in a join is adjusted automatically to make better use of indices * The IN operator is now a candidate for optimization even if the left-hand side is not the left-most term of the index. Multiple IN operators can be used with the same index. * WHERE clause expressions using BETWEEN and OR are now candidates for optimization * Added the "case_sensitive_like" pragma and the SQLITE_CASE_SENSITIVE_LIKE compile-time option to set its default value to "on". * Use indices to help with GLOB expressions and LIKE expressions too when the case_sensitive_like pragma is enabled * Added support for grave-accent quoting for compatibility with MySQL * Improved test coverage --- databases/sqlite3-tcl/Makefile | 5 +++-- databases/sqlite3/Makefile.common | 4 ++-- databases/sqlite3/distinfo | 8 ++++---- 3 files changed, 9 insertions(+), 8 deletions(-) (limited to 'databases') diff --git a/databases/sqlite3-tcl/Makefile b/databases/sqlite3-tcl/Makefile index 52f8d0ef146..ae589d97535 100644 --- a/databases/sqlite3-tcl/Makefile +++ b/databases/sqlite3-tcl/Makefile @@ -1,4 +1,4 @@ -# $NetBSD: Makefile,v 1.1.1.1 2005/03/23 22:09:50 jmmv Exp $ +# $NetBSD: Makefile,v 1.2 2005/09/30 12:17:39 wiz Exp $ .include "../../databases/sqlite3/Makefile.common" @@ -8,8 +8,9 @@ CONFIGURE_ARGS+= --with-tcl=${BUILDLINK_PREFIX.tcl}/lib BUILD_TARGET= libtclsqlite3.la INSTALL_TARGET= tcl_install +TEST_TARGET= test -BUILDLINK_DEPENDS.sqlite3+= sqlite3>=3.1.3nb2 +BUILDLINK_DEPENDS.sqlite3+= sqlite3>=3.2.7 .include "../../databases/sqlite3/buildlink3.mk" .include "../../lang/tcl/buildlink3.mk" diff --git a/databases/sqlite3/Makefile.common b/databases/sqlite3/Makefile.common index bce07313492..f7ab274ee64 100644 --- a/databases/sqlite3/Makefile.common +++ b/databases/sqlite3/Makefile.common @@ -1,6 +1,6 @@ -# $NetBSD: Makefile.common,v 1.5 2005/07/06 18:13:07 drochner Exp $ +# $NetBSD: Makefile.common,v 1.6 2005/09/30 12:17:39 wiz Exp $ -DISTNAME= sqlite-3.2.2 +DISTNAME= sqlite-3.2.7 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 48390939539..84a5d3cb7ae 100644 --- a/databases/sqlite3/distinfo +++ b/databases/sqlite3/distinfo @@ -1,5 +1,5 @@ -$NetBSD: distinfo,v 1.5 2005/07/06 18:13:07 drochner Exp $ +$NetBSD: distinfo,v 1.6 2005/09/30 12:17:39 wiz Exp $ -SHA1 (sqlite-3.2.2.tar.gz) = 7c2d5941ccb54e761cb867ea9d0213dba6ed5eb4 -RMD160 (sqlite-3.2.2.tar.gz) = 7d0db91b70e863e383766d1f89ac9179ad3ba47f -Size (sqlite-3.2.2.tar.gz) = 1385618 bytes +SHA1 (sqlite-3.2.7.tar.gz) = 370095ce08b0f70754e034b2f07915c07f74ac11 +RMD160 (sqlite-3.2.7.tar.gz) = e321badace03b7d48112fc9ae1dca8c39c90a3d5 +Size (sqlite-3.2.7.tar.gz) = 1521075 bytes -- cgit v1.2.3