[pkgsrc/trunk]: pkgsrc/databases/sqlite3 Update to 3.3.17:

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

details:   https://anonhg.NetBSD.org/pkgsrc/rev/3c2fe2be2c12
branches:  trunk
changeset: 529557:3c2fe2be2c12
user:      wiz <wiz%pkgsrc.org@localhost>
date:      Thu Jun 07 19:49:10 2007 +0000

description:
Update to 3.3.17:

2007 April 25 (3.3.17)

* When the "write_version" value of the database
  header is larger than what the library understands,
  make the database read-only instead of unreadable.
* Other minor bug fixes

2007 April 18 (3.3.16)

* Fix a bug that caused VACUUM to fail if NULLs
  appeared in a UNIQUE column.
* Reinstate performance improvements that were added
  in 3.3.14 but regressed in 3.3.15.
* Fix problems with the handling of ORDER BY expressions
  on compound SELECT statements in subqueries.
* Fix a potential segfault when destroying locks on
  WinCE in a multi-threaded environment.
* Documentation updates.

2007 April 9 (3.3.15)

* Fix a bug introduced in 3.3.14 that caused a rollback
  of CREATE TEMP TABLE to leave the database connection
  wedged.
* Fix a bug that caused an extra NULL row to be
  returned when a descending query was interrupted by
  a change to the database.
* The FOR EACH STATEMENT clause on a trigger now
  causes a syntax error. It used to be silently ignored.
* Fix an obscure and relatively harmless problem that
  might have caused a resource leak following an I/O
  error.
* Many improvements to the test suite. Test coverage
  now exceeded 98%

2007 April 2 (3.3.14)

* Fix a bug in 3.3.13 that could cause a segfault
  when the IN operator is used one one term of a
  two-column index and the right-hand side of the IN
  operator contains a NULL.
* Added a new OS interface method for determining
  the sector size of underlying media: sqlite3OsSectorSize().
* A new algorithm for statements of the form INSERT
  INTO table1 SELECT * FROM table2 is faster and
  reduces fragmentation. VACUUM uses statements of
  this form and thus runs faster and defragments
  better.
* Performance enhancements through reductions in disk I/O:
* Do not read the last page of an overflow chain
  when deleting the row - just add that page to
  the freelist.
* Do not store pages being deleted in the rollback journal.
* Do not read in the (meaningless) content of
  pages extracted from the freelist.
* Do not flush the page cache (and thus avoiding
  a cache refill) unless another process changes
  the underlying database file.
* Truncate rather than delete the rollback
  journal when committing a transaction in
  exclusive access mode, or when committing the
  TEMP database.
* Added support for exclusive access mode using
  "PRAGMA locking_mode=EXCLUSIVE"
* Use heap space instead of stack space for large
  buffers in the pager - useful on embedded platforms
  with stack-space limitations.
* Add a makefile target "sqlite3.c" that builds an
  amalgamation containing the core SQLite library C
  code in a single file.
* Get the library working correctly when compiled
  with GCC option "-fstrict-aliasing".
* Removed the vestigal SQLITE_PROTOCOL error.
* Improvements to test coverage, other minor bugs
  fixed, memory leaks plugged, code refactored and/or
  recommented in places for easier reading.

diffstat:

 databases/sqlite3/Makefile.common  |   4 +-
 databases/sqlite3/distinfo         |  11 ++++-----
 databases/sqlite3/patches/patch-aa |   6 ++--
 databases/sqlite3/patches/patch-ab |  40 --------------------------------------
 4 files changed, 10 insertions(+), 51 deletions(-)

diffs (87 lines):

diff -r bfe28806a317 -r 3c2fe2be2c12 databases/sqlite3/Makefile.common
--- a/databases/sqlite3/Makefile.common Thu Jun 07 16:50:25 2007 +0000
+++ b/databases/sqlite3/Makefile.common Thu Jun 07 19:49:10 2007 +0000
@@ -1,6 +1,6 @@
-# $NetBSD: Makefile.common,v 1.11 2007/03/07 12:17:58 drochner Exp $
+# $NetBSD: Makefile.common,v 1.12 2007/06/07 19:49:10 wiz Exp $
 
-DISTNAME=      sqlite-3.3.13
+DISTNAME=      sqlite-3.3.17
 PKGNAME=       ${DISTNAME:S/-/3-/}
 CATEGORIES=    databases
 MASTER_SITES=  http://www.hwaci.com/sw/sqlite/ \
diff -r bfe28806a317 -r 3c2fe2be2c12 databases/sqlite3/distinfo
--- a/databases/sqlite3/distinfo        Thu Jun 07 16:50:25 2007 +0000
+++ b/databases/sqlite3/distinfo        Thu Jun 07 19:49:10 2007 +0000
@@ -1,7 +1,6 @@
-$NetBSD: distinfo,v 1.10 2007/03/07 12:17:58 drochner Exp $
+$NetBSD: distinfo,v 1.11 2007/06/07 19:49:10 wiz Exp $
 
-SHA1 (sqlite-3.3.13.tar.gz) = 405d3f042d64d9ecbb42fff6d4c0dae4a1eeeda2
-RMD160 (sqlite-3.3.13.tar.gz) = 5ed0c1248db4681349ee89a851fe200ea855fbcd
-Size (sqlite-3.3.13.tar.gz) = 2054971 bytes
-SHA1 (patch-aa) = 1362f7b554c91b495371de80170a9d1746e0fcd6
-SHA1 (patch-ab) = cf0748571cfb2b47a1032ca5f26e3b3cd4cf86da
+SHA1 (sqlite-3.3.17.tar.gz) = 6c968e3c608be4ab137577411869abdeffb0c3f7
+RMD160 (sqlite-3.3.17.tar.gz) = a948306fc45f7baa8cb241a6cf7e4a57c9c6468c
+Size (sqlite-3.3.17.tar.gz) = 2111281 bytes
+SHA1 (patch-aa) = 0f6b1cd63810ce06874c781dfda2d3b1531d91da
diff -r bfe28806a317 -r 3c2fe2be2c12 databases/sqlite3/patches/patch-aa
--- a/databases/sqlite3/patches/patch-aa        Thu Jun 07 16:50:25 2007 +0000
+++ b/databases/sqlite3/patches/patch-aa        Thu Jun 07 19:49:10 2007 +0000
@@ -1,8 +1,8 @@
-$NetBSD: patch-aa,v 1.1 2006/11/18 23:56:18 wiz Exp $
+$NetBSD: patch-aa,v 1.2 2007/06/07 19:49:11 wiz Exp $
 
---- configure.orig     2006-10-03 12:42:27.000000000 +0000
+--- configure.orig     2007-03-29 18:39:30.000000000 +0000
 +++ configure
-@@ -19700,7 +19700,7 @@ if test "$TARGET_EXEEXT" = ".exe"; then
+@@ -19170,7 +19170,7 @@ if test "$TARGET_EXEEXT" = ".exe"; then
      OS_WIN=0
      OS_OS2=1
      TARGET_CFLAGS="$TARGET_CFLAGS -DOS_OS2=1"
diff -r bfe28806a317 -r 3c2fe2be2c12 databases/sqlite3/patches/patch-ab
--- a/databases/sqlite3/patches/patch-ab        Thu Jun 07 16:50:25 2007 +0000
+++ /dev/null   Thu Jan 01 00:00:00 1970 +0000
@@ -1,40 +0,0 @@
-$NetBSD: patch-ab,v 1.1 2007/01/11 19:08:48 drochner Exp $
-
---- test/corrupt2.test.orig    2007-01-11 15:51:25.000000000 +0100
-+++ test/corrupt2.test
-@@ -33,7 +33,7 @@ do_test corrupt2-1.2 {
-   file delete -force corrupt.db
-   file delete -force corrupt.db-journal
-   copy_file test.db corrupt.db
--  set f [open corrupt.db a]
-+  set f [open corrupt.db r+]
-   seek $f 8 start
-   puts $f blah
-   close $f
-@@ -51,7 +51,7 @@ do_test corrupt2-1.3 {
-   file delete -force corrupt.db
-   file delete -force corrupt.db-journal
-   copy_file test.db corrupt.db
--  set f [open corrupt.db a]
-+  set f [open corrupt.db r+]
-   fconfigure $f -encoding binary
-   seek $f 16 start
-   puts -nonewline $f "\x00\xFF"
-@@ -70,7 +70,7 @@ do_test corrupt2-1.4 {
-   file delete -force corrupt.db
-   file delete -force corrupt.db-journal
-   copy_file test.db corrupt.db
--  set f [open corrupt.db a]
-+  set f [open corrupt.db r+]
-   fconfigure $f -encoding binary
-   seek $f 101 start
-   puts -nonewline $f "\xFF\xFF"
-@@ -89,7 +89,7 @@ do_test corrupt2-1.5 {
-   file delete -force corrupt.db
-   file delete -force corrupt.db-journal
-   copy_file test.db corrupt.db
--  set f [open corrupt.db a]
-+  set f [open corrupt.db r+]
-   fconfigure $f -encoding binary
-   seek $f 101 start
-   puts -nonewline $f "\x00\xC8"