From 53ac435ed7b9e33a8d1abc675dbab3c37f6dc917 Mon Sep 17 00:00:00 2001 From: wiz Date: Thu, 7 Jun 2007 19:49:10 +0000 Subject: 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. --- 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(-) delete mode 100644 databases/sqlite3/patches/patch-ab (limited to 'databases') diff --git a/databases/sqlite3/Makefile.common b/databases/sqlite3/Makefile.common index 745ed466adf..0bc0e5ef1d3 100644 --- a/databases/sqlite3/Makefile.common +++ b/databases/sqlite3/Makefile.common @@ -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 --git a/databases/sqlite3/distinfo b/databases/sqlite3/distinfo index f417d772d17..80c6a4e9a6d 100644 --- a/databases/sqlite3/distinfo +++ b/databases/sqlite3/distinfo @@ -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 --git a/databases/sqlite3/patches/patch-aa b/databases/sqlite3/patches/patch-aa index 46844160b9e..39a8187849e 100644 --- a/databases/sqlite3/patches/patch-aa +++ b/databases/sqlite3/patches/patch-aa @@ -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 --git a/databases/sqlite3/patches/patch-ab b/databases/sqlite3/patches/patch-ab deleted file mode 100644 index 9e175df6584..00000000000 --- a/databases/sqlite3/patches/patch-ab +++ /dev/null @@ -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" -- cgit v1.2.3