summaryrefslogtreecommitdiff
path: root/databases
diff options
context:
space:
mode:
authorwiz <wiz@pkgsrc.org>2007-06-07 19:49:10 +0000
committerwiz <wiz@pkgsrc.org>2007-06-07 19:49:10 +0000
commit53ac435ed7b9e33a8d1abc675dbab3c37f6dc917 (patch)
tree87aad75aa36f8b3492abc51c4051246939fe444c /databases
parentcc7676ec317d37242415c92256ed1303b8ef6b73 (diff)
downloadpkgsrc-53ac435ed7b9e33a8d1abc675dbab3c37f6dc917.tar.gz
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 (limited to 'databases')
-rw-r--r--databases/sqlite3/Makefile.common4
-rw-r--r--databases/sqlite3/distinfo11
-rw-r--r--databases/sqlite3/patches/patch-aa6
-rw-r--r--databases/sqlite3/patches/patch-ab40
4 files changed, 10 insertions, 51 deletions
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"