Changes 3.7.10:

* The default schema format number is changed from 1 to 4. This means that,
  unless the PRAGMA legacy_file_format=ON statement is run, newly created
  database files will be unreadable by version of SQLite prior to 3.3.0
  (2006-01-10). It also means that the descending indices are enabled by
  default.
* The sqlite3_pcache_methods structure and the SQLITE_CONFIG_PCACHE and
  SQLITE_CONFIG_GETPCACHE configuration parameters are deprecated. They are
  replaced by a new sqlite3_pcache_methods2 structure and SQLITE_CONFIG_PCACHE2
  and SQLITE_CONFIG_GETPCACHE2 configuration parameters.
* Added the powersafe overwrite property to the VFS interface. Provide the
  SQLITE_IOCAP_POWERSAFE_OVERWRITE I/O capability, the
  SQLITE_POWERSAFE_OVERWRITE compile-time option, and the "psow=BOOLEAN" query
  parameter for URI filenames.
* Added the sqlite3_db_release_memory() interface and the shrink_memory pragma.
* Added the sqlite3_db_filename() interface.
* Added the sqlite3_stmt_busy() interface.
* Added the sqlite3_uri_boolean() and sqlite3_uri_int64() interfaces.
* If the argument to PRAGMA cache_size is negative N, that means to use
  approximately -1024*N bytes of memory for the page cache regardless of the
  page size.
* Enhanced the default memory allocator to make use of _msize() on windows,
  malloc_size() on Mac, and malloc_usable_size() on Linux.
* Enhanced the query planner to support index queries with range constraints on
  the rowid.
* Enhanced the query planner flattening logic to allow UNION ALL compounds to
  be promoted upwards to replace a simple wrapper SELECT even if the compounds
  are joins.
* Enhanced the query planner so that the xfer optimization can be used with
  INTEGER PRIMARY KEY ON CONFLICT as long as the destination table is initially
  empty.
* Enhanced the windows VFS so that all system calls can be overridden using the
  xSetSystemCall interface.
* Updated the "unix-dotfile" VFS to use locking directories with mkdir() and
  rmdir() instead of locking files with open() and unlink().
* Enhancements to the test_quota.c extension to support stdio-like interfaces
  with quotas.
* Change the unix VFS to be tolerant of read() system calls that return less
  then the full number of requested bytes.
* Change both unix and windows VFSes to report a sector size of 4096 instead of
  the old default of 512.
* In the TCL Interface, add the -uri option to the "sqlite3" TCL command used
  for creating new database connection objects.
* Added the SQLITE_TESTCTRL_EXPLAIN_STMT test-control option with the
  SQLITE_ENABLE_TREE_EXPLAIN compile-time option to enable the command-line
  shell to display ASCII-art parse trees of SQL statements that it processes,
  for debugging and analysis.
* Bug fix: Add an additional xSync when restarting a WAL in order to prevent an
  exceedingly unlikely but theoretically possible database corruption following
  power-loss.
* Bug fix: Change the VDBE so that all registers are initialized to Invalid
  instead of NULL.
* Bug fix: Fix problems that can result from 32-bit integer overflow.

7 files changed, 30 insertions, 24 deletions

diff --git a/databases/sqlite3-docs/Makefile b/databases/sqlite3-docs/Makefile
index cfab4f8f2ef..a8d8dcf8b79 100644
--- a/databases/sqlite3-docs/Makefile
+++ b/databases/sqlite3-docs/Makefile
@@ -1,7 +1,7 @@
-# $NetBSD: Makefile,v 1.6 2011/11/05 19:09:07 adam Exp $
+# $NetBSD: Makefile,v 1.7 2012/01/17 15:53:13 adam Exp $
 
-DISTNAME=	sqlite-doc-3070900
-PKGNAME=	sqlite3-docs-3.7.9
+DISTNAME=	sqlite-doc-3071000
+PKGNAME=	sqlite3-docs-3.7.10
 CATEGORIES=	databases
 MASTER_SITES=	http://www.hwaci.com/sw/sqlite/ \
 		http://www.sqlite.org/
diff --git a/databases/sqlite3-docs/PLIST b/databases/sqlite3-docs/PLIST
index 6ce5189c617..3b5e942d248 100644
--- a/databases/sqlite3-docs/PLIST
+++ b/databases/sqlite3-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.6 2011/11/05 19:09:07 adam Exp $
+@comment $NetBSD: PLIST,v 1.7 2012/01/17 15:53:13 adam Exp $
 share/doc/sqlite3/34to35.html
 share/doc/sqlite3/35to36.html
 share/doc/sqlite3/about.html
@@ -77,8 +77,10 @@ share/doc/sqlite3/c3ref/create_function.html
 share/doc/sqlite3/c3ref/create_module.html
 share/doc/sqlite3/c3ref/data_count.html
 share/doc/sqlite3/c3ref/db_config.html
+share/doc/sqlite3/c3ref/db_filename.html
 share/doc/sqlite3/c3ref/db_handle.html
 share/doc/sqlite3/c3ref/db_mutex.html
+share/doc/sqlite3/c3ref/db_release_memory.html
 share/doc/sqlite3/c3ref/db_status.html
 share/doc/sqlite3/c3ref/declare_vtab.html
 share/doc/sqlite3/c3ref/enable_load_extension.html
@@ -119,7 +121,8 @@ share/doc/sqlite3/c3ref/objlist.html
 share/doc/sqlite3/c3ref/open.html
 share/doc/sqlite3/c3ref/overload_function.html
 share/doc/sqlite3/c3ref/pcache.html
-share/doc/sqlite3/c3ref/pcache_methods.html
+share/doc/sqlite3/c3ref/pcache_methods2.html
+share/doc/sqlite3/c3ref/pcache_page.html
 share/doc/sqlite3/c3ref/prepare.html
 share/doc/sqlite3/c3ref/profile.html
 share/doc/sqlite3/c3ref/progress_handler.html
@@ -137,6 +140,7 @@ share/doc/sqlite3/c3ref/sqlite3.html
 share/doc/sqlite3/c3ref/status.html
 share/doc/sqlite3/c3ref/step.html
 share/doc/sqlite3/c3ref/stmt.html
+share/doc/sqlite3/c3ref/stmt_busy.html
 share/doc/sqlite3/c3ref/stmt_readonly.html
 share/doc/sqlite3/c3ref/stmt_status.html
 share/doc/sqlite3/c3ref/strnicmp.html
@@ -147,7 +151,7 @@ share/doc/sqlite3/c3ref/threadsafe.html
 share/doc/sqlite3/c3ref/total_changes.html
 share/doc/sqlite3/c3ref/unlock_notify.html
 share/doc/sqlite3/c3ref/update_hook.html
-share/doc/sqlite3/c3ref/uri_parameter.html
+share/doc/sqlite3/c3ref/uri_boolean.html
 share/doc/sqlite3/c3ref/user_data.html
 share/doc/sqlite3/c3ref/value.html
 share/doc/sqlite3/c3ref/value_blob.html
@@ -458,6 +462,7 @@ share/doc/sqlite3/optoverview.html
 share/doc/sqlite3/pragma.html
 share/doc/sqlite3/pressrelease-20071212.html
 share/doc/sqlite3/privatebranch.html
+share/doc/sqlite3/psow.html
 share/doc/sqlite3/queryplanner.html
 share/doc/sqlite3/quickstart.html
 share/doc/sqlite3/releaselog/3_0_0.html
@@ -549,6 +554,7 @@ share/doc/sqlite3/releaselog/3_6_9.html
 share/doc/sqlite3/releaselog/3_7_0.html
 share/doc/sqlite3/releaselog/3_7_0_1.html
 share/doc/sqlite3/releaselog/3_7_1.html
+share/doc/sqlite3/releaselog/3_7_10.html
 share/doc/sqlite3/releaselog/3_7_2.html
 share/doc/sqlite3/releaselog/3_7_3.html
 share/doc/sqlite3/releaselog/3_7_4.html
diff --git a/databases/sqlite3-docs/distinfo b/databases/sqlite3-docs/distinfo
index 4276e45c085..7e2b45d4ee5 100644
--- a/databases/sqlite3-docs/distinfo
+++ b/databases/sqlite3-docs/distinfo
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.6 2011/11/05 19:09:07 adam Exp $
+$NetBSD: distinfo,v 1.7 2012/01/17 15:53:13 adam Exp $
 
-SHA1 (sqlite-doc-3070900.zip) = 2d4a25f75cc6b7251f1b49b828f9fd1d699fc8a2
-RMD160 (sqlite-doc-3070900.zip) = 841495870094ab3314bfcecd82e182548fa483fe
-Size (sqlite-doc-3070900.zip) = 3332830 bytes
+SHA1 (sqlite-doc-3071000.zip) = 9957b9f2e955d82b2484cb44cc6fb4a53313d085
+RMD160 (sqlite-doc-3071000.zip) = 6a75f7c10a8421a99e28c5430ab4f0a0ac09e6d6
+Size (sqlite-doc-3071000.zip) = 3630343 bytes
diff --git a/databases/sqlite3-tcl/Makefile b/databases/sqlite3-tcl/Makefile
index 307740af3fb..c0402cf9d4e 100644
--- a/databases/sqlite3-tcl/Makefile
+++ b/databases/sqlite3-tcl/Makefile
@@ -1,7 +1,7 @@
-# $NetBSD: Makefile,v 1.29 2011/11/05 19:09:07 adam Exp $
+# $NetBSD: Makefile,v 1.30 2012/01/17 15:53:13 adam Exp $
 
-DISTNAME=	sqlite-autoconf-3070900
-PKGNAME=	sqlite3-tcl-3.7.9
+DISTNAME=	sqlite-autoconf-3071000
+PKGNAME=	sqlite3-tcl-3.7.10
 CATEGORIES=	databases
 MASTER_SITES=	http://www.hwaci.com/sw/sqlite/ \
 		http://www.sqlite.org/
diff --git a/databases/sqlite3-tcl/distinfo b/databases/sqlite3-tcl/distinfo
index bebacc884c7..e6d25173f23 100644
--- a/databases/sqlite3-tcl/distinfo
+++ b/databases/sqlite3-tcl/distinfo
@@ -1,7 +1,7 @@
-$NetBSD: distinfo,v 1.18 2011/11/05 19:09:07 adam Exp $
+$NetBSD: distinfo,v 1.19 2012/01/17 15:53:13 adam Exp $
 
-SHA1 (sqlite-autoconf-3070900.tar.gz) = a9da98a4bde4d9dae5c29a969455d11a03600e11
-RMD160 (sqlite-autoconf-3070900.tar.gz) = 03ec092aeb7cc5453935f6c8ae00558d472b710a
-Size (sqlite-autoconf-3070900.tar.gz) = 1783755 bytes
+SHA1 (sqlite-autoconf-3071000.tar.gz) = 0442d5a1bff50153039951b09db649864d8af0bb
+RMD160 (sqlite-autoconf-3071000.tar.gz) = 8932a5cd4b596632c63af30cbd94c2b6c9d45377
+Size (sqlite-autoconf-3071000.tar.gz) = 1801640 bytes
 SHA1 (patch-aa) = d4d0424eec39ede995c2c408dcf51876072d3fea
 SHA1 (patch-ab) = 64a4352b9a8ed0518784837e390541cd4e1bc9aa
diff --git a/databases/sqlite3/Makefile b/databases/sqlite3/Makefile
index 14b6653f7cc..ea3ef21817a 100644
--- a/databases/sqlite3/Makefile
+++ b/databases/sqlite3/Makefile
@@ -1,7 +1,7 @@
-# $NetBSD: Makefile,v 1.47 2011/11/05 19:09:07 adam Exp $
+# $NetBSD: Makefile,v 1.48 2012/01/17 15:53:13 adam Exp $
 
-DISTNAME=	sqlite-autoconf-3070900
-PKGNAME=	sqlite3-3.7.9
+DISTNAME=	sqlite-autoconf-3071000
+PKGNAME=	sqlite3-3.7.10
 CATEGORIES=	databases
 MASTER_SITES=	http://www.hwaci.com/sw/sqlite/ \
 		http://www.sqlite.org/
diff --git a/databases/sqlite3/distinfo b/databases/sqlite3/distinfo
index 53d2141d593..cde82776b08 100644
--- a/databases/sqlite3/distinfo
+++ b/databases/sqlite3/distinfo
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.65 2011/11/05 19:09:07 adam Exp $
+$NetBSD: distinfo,v 1.66 2012/01/17 15:53:13 adam Exp $
 
-SHA1 (sqlite-autoconf-3070900.tar.gz) = a9da98a4bde4d9dae5c29a969455d11a03600e11
-RMD160 (sqlite-autoconf-3070900.tar.gz) = 03ec092aeb7cc5453935f6c8ae00558d472b710a
-Size (sqlite-autoconf-3070900.tar.gz) = 1783755 bytes
+SHA1 (sqlite-autoconf-3071000.tar.gz) = 0442d5a1bff50153039951b09db649864d8af0bb
+RMD160 (sqlite-autoconf-3071000.tar.gz) = 8932a5cd4b596632c63af30cbd94c2b6c9d45377
+Size (sqlite-autoconf-3071000.tar.gz) = 1801640 bytes