[pkgsrc/trunk]: pkgsrc/databases Update to 3.2.7:

[wiz <wiz%pkgsrc.org@localhost>]

details:   https://anonhg.NetBSD.org/pkgsrc/rev/6a2c8e26a9fe
branches:  trunk
changeset: 499962:6a2c8e26a9fe
user:      wiz <wiz%pkgsrc.org@localhost>
date:      Fri Sep 30 12:17:39 2005 +0000

description:
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

diffstat:

 databases/sqlite3-tcl/Makefile    |  5 +++--
 databases/sqlite3/Makefile.common |  4 ++--
 databases/sqlite3/distinfo        |  8 ++++----
 3 files changed, 9 insertions(+), 8 deletions(-)

diffs (45 lines):

diff -r d64a627eec3c -r 6a2c8e26a9fe databases/sqlite3-tcl/Makefile
--- a/databases/sqlite3-tcl/Makefile    Fri Sep 30 12:10:44 2005 +0000
+++ b/databases/sqlite3-tcl/Makefile    Fri Sep 30 12:17:39 2005 +0000
@@ -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 @@
 
 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 -r d64a627eec3c -r 6a2c8e26a9fe databases/sqlite3/Makefile.common
--- a/databases/sqlite3/Makefile.common Fri Sep 30 12:10:44 2005 +0000
+++ b/databases/sqlite3/Makefile.common Fri Sep 30 12:17:39 2005 +0000
@@ -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 -r d64a627eec3c -r 6a2c8e26a9fe databases/sqlite3/distinfo
--- a/databases/sqlite3/distinfo        Fri Sep 30 12:10:44 2005 +0000
+++ b/databases/sqlite3/distinfo        Fri Sep 30 12:17:39 2005 +0000
@@ -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