Changes 3.7.9:

* If a search token (on the right-hand side of the MATCH operator) in FTS4
  begins with "^" then that token must be the first in its field of the
  document. ** Potentially Incompatible Change **
* Added options SQLITE_DBSTATUS_CACHE_HIT and SQLITE_DBSTATUS_CACHE_MISS to the
  sqlite3_db_status() interface.
* Removed support for SQLITE_ENABLE_STAT2, replacing it with the much more
  capable SQLITE_ENABLE_STAT3 option.
* Enhancements to the sqlite3_analyzer utility program, including the --pageinfo
  and --stats options and support for multiplexed databases.
* Enhance the sqlite3_data_count() interface so that it can be used to determine
  if SQLITE_DONE has been seen on the prepared statement.
* Added the SQLITE_FCNTL_OVERWRITE file-control by which the SQLite core
  indicates to the VFS that the current transaction will overwrite the entire
  database file.
* Increase the default lookaside memory allocator allocation size from 100 to
  128 bytes.
* Enhanced the query planner so that it can factor terms in and out of OR
  expressions in the WHERE clause in an effort to find better indices.
* Added the SQLITE_DIRECT_OVERFLOW_READ compile-time option, causing overflow
  pages to be read directly from the database file, bypassing the page cache.
* Remove limits on the magnitude of precision and width value in the format
  specifiers of the sqlite3_mprintf() family of string rendering routines.
* Fix a bug that prevent ALTER TABLE ... RENAME from working on some virtual
  tables in a database with a UTF16 encoding.
* Fix a bug in ASCII-to-float conversion that causes slow performance and
  incorrect results when converting numbers with ridiculously large exponents.
* Fix a bug that causes incorrect results in aggregate queries that use
  multiple aggregate functions whose arguments contain complicated expressions
  that differ only in the case of string literals contained within those
  expressions.
* Fix a bug that prevented the page_count and quick_check pragmas from working
  correctly if their names were capitalized.
* Fix a bug that caused VACUUM to fail if the count_changes pragma was engaged.
* Fix a bug in virtual table implementation that causes a crash if an FTS4
  table is dropped inside a transaction and a SAVEPOINT occurs afterwards.

3 files changed, 10 insertions, 31 deletions

diff --git a/databases/sqlite3-docs/Makefile b/databases/sqlite3-docs/Makefile
index ea53f2745a4..cfab4f8f2ef 100644
--- a/databases/sqlite3-docs/Makefile
+++ b/databases/sqlite3-docs/Makefile
@@ -1,7 +1,7 @@
-# $NetBSD: Makefile,v 1.5 2011/10/03 10:22:19 adam Exp $
+# $NetBSD: Makefile,v 1.6 2011/11/05 19:09:07 adam Exp $
 
-DISTNAME=	sqlite-doc-3070800
-PKGNAME=	sqlite3-docs-3.7.8
+DISTNAME=	sqlite-doc-3070900
+PKGNAME=	sqlite3-docs-3.7.9
 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 518bf7914e9..6ce5189c617 100644
--- a/databases/sqlite3-docs/PLIST
+++ b/databases/sqlite3-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.5 2011/10/03 10:22:19 adam Exp $
+@comment $NetBSD: PLIST,v 1.6 2011/11/05 19:09:07 adam Exp $
 share/doc/sqlite3/34to35.html
 share/doc/sqlite3/35to36.html
 share/doc/sqlite3/about.html
@@ -121,7 +121,6 @@ share/doc/sqlite3/c3ref/overload_function.html
 share/doc/sqlite3/c3ref/pcache.html
 share/doc/sqlite3/c3ref/pcache_methods.html
 share/doc/sqlite3/c3ref/prepare.html
-share/doc/sqlite3/c3ref/preupdate_count.html
 share/doc/sqlite3/c3ref/profile.html
 share/doc/sqlite3/c3ref/progress_handler.html
 share/doc/sqlite3/c3ref/randomness.html
@@ -409,6 +408,7 @@ share/doc/sqlite3/images/table-ex1b2.gif
 share/doc/sqlite3/images/vfs1.gif
 share/doc/sqlite3/index.html
 share/doc/sqlite3/inmemorydb.html
+share/doc/sqlite3/intern-v-extern-blob.html
 share/doc/sqlite3/keyword_index.html
 share/doc/sqlite3/lang.html
 share/doc/sqlite3/lang_aggfunc.html
@@ -560,38 +560,17 @@ share/doc/sqlite3/releaselog/3_7_6_3.html
 share/doc/sqlite3/releaselog/3_7_7.html
 share/doc/sqlite3/releaselog/3_7_7_1.html
 share/doc/sqlite3/releaselog/3_7_8.html
+share/doc/sqlite3/releaselog/3_7_9.html
 share/doc/sqlite3/requirements.html
 share/doc/sqlite3/robots.txt
 share/doc/sqlite3/rtree.html
 share/doc/sqlite3/selfcontained.html
 share/doc/sqlite3/serverless.html
 share/doc/sqlite3/session.html
-share/doc/sqlite3/session/c_changeset_abort.html
-share/doc/sqlite3/session/c_changeset_conflict.html
-share/doc/sqlite3/session/changeset_iter.html
 share/doc/sqlite3/session/constlist.html
 share/doc/sqlite3/session/funclist.html
 share/doc/sqlite3/session/intro.html
 share/doc/sqlite3/session/objlist.html
-share/doc/sqlite3/session/session.html
-share/doc/sqlite3/session/sqlite3changeset_apply.html
-share/doc/sqlite3/session/sqlite3changeset_concat.html
-share/doc/sqlite3/session/sqlite3changeset_conflict.html
-share/doc/sqlite3/session/sqlite3changeset_finalize.html
-share/doc/sqlite3/session/sqlite3changeset_invert.html
-share/doc/sqlite3/session/sqlite3changeset_new.html
-share/doc/sqlite3/session/sqlite3changeset_next.html
-share/doc/sqlite3/session/sqlite3changeset_old.html
-share/doc/sqlite3/session/sqlite3changeset_op.html
-share/doc/sqlite3/session/sqlite3changeset_pk.html
-share/doc/sqlite3/session/sqlite3changeset_start.html
-share/doc/sqlite3/session/sqlite3session_attach.html
-share/doc/sqlite3/session/sqlite3session_changeset.html
-share/doc/sqlite3/session/sqlite3session_create.html
-share/doc/sqlite3/session/sqlite3session_delete.html
-share/doc/sqlite3/session/sqlite3session_enable.html
-share/doc/sqlite3/session/sqlite3session_indirect.html
-share/doc/sqlite3/session/sqlite3session_isempty.html
 share/doc/sqlite3/sharedcache.html
 share/doc/sqlite3/shortnames.html
 share/doc/sqlite3/sitemap.html
diff --git a/databases/sqlite3-docs/distinfo b/databases/sqlite3-docs/distinfo
index fae7df4d698..4276e45c085 100644
--- a/databases/sqlite3-docs/distinfo
+++ b/databases/sqlite3-docs/distinfo
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.5 2011/10/03 10:22:19 adam Exp $
+$NetBSD: distinfo,v 1.6 2011/11/05 19:09:07 adam Exp $
 
-SHA1 (sqlite-doc-3070800.zip) = e8fec8ca866289477ea4249c219e07bc301d96c6
-RMD160 (sqlite-doc-3070800.zip) = e4a858d78b3cad71e43a8bb73755e09290dccd38
-Size (sqlite-doc-3070800.zip) = 3395664 bytes
+SHA1 (sqlite-doc-3070900.zip) = 2d4a25f75cc6b7251f1b49b828f9fd1d699fc8a2
+RMD160 (sqlite-doc-3070900.zip) = 841495870094ab3314bfcecd82e182548fa483fe
+Size (sqlite-doc-3070900.zip) = 3332830 bytes