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.

2 files changed, 7 insertions, 7 deletions

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