Changes 3.8.9:

Add VxWorks-7 as an officially supported and tested platform.
Added the sqlite3_status64() interface.
Fix memory size tracking so that it works even if SQLite uses more than 2GiB of memory.
Added the PRAGMA index_xinfo command.
Fix a potential 32-bit integer overflow problem in the sqlite3_blob_read() and sqlite3_blob_write() interfaces.
Ensure that prepared statements automatically reset on extended error codes of SQLITE_BUSY and SQLITE_LOCKED even when compiled using SQLITE_OMIT_AUTORESET.
Correct miscounts in the sqlite3_analyzer.exe utility related to WITHOUT ROWID tables.
Added the ".dbinfo" command to the command-line shell.
Improve the performance of fts3/4 queries that use the OR operator and at least one auxiliary fts function.
Fix a bug in the fts3 snippet() function causing it to omit leading separator characters from snippets that begin with the first token in a column.

7 files changed, 28 insertions, 24 deletions

diff --git a/databases/sqlite3-docs/Makefile b/databases/sqlite3-docs/Makefile
index b5be69b0870..5660eec3000 100644
--- a/databases/sqlite3-docs/Makefile
+++ b/databases/sqlite3-docs/Makefile
@@ -1,7 +1,7 @@
-# $NetBSD: Makefile,v 1.40 2015/03/02 13:34:16 adam Exp $
+# $NetBSD: Makefile,v 1.41 2015/04/11 12:42:06 adam Exp $
 
-DISTNAME=	sqlite-doc-3080803
-PKGNAME=	sqlite3-docs-3.8.8.3
+DISTNAME=	sqlite-doc-3080900
+PKGNAME=	sqlite3-docs-3.8.9
 CATEGORIES=	databases
 MASTER_SITES=	http://www.hwaci.com/sw/sqlite/2015/ \
 		http://www.sqlite.org/2015/
diff --git a/databases/sqlite3-docs/PLIST b/databases/sqlite3-docs/PLIST
index 5b79335a0c2..3b72cbc12b0 100644
--- a/databases/sqlite3-docs/PLIST
+++ b/databases/sqlite3-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.38 2015/03/02 13:34:16 adam Exp $
+@comment $NetBSD: PLIST,v 1.39 2015/04/11 12:42:06 adam Exp $
 share/doc/sqlite3/34to35.html
 share/doc/sqlite3/35to36.html
 share/doc/sqlite3/about.html
@@ -216,6 +216,7 @@ share/doc/sqlite3/footprint.html
 share/doc/sqlite3/foreignkeys.html
 share/doc/sqlite3/formatchng.html
 share/doc/sqlite3/fts3.html
+share/doc/sqlite3/fts5.html
 share/doc/sqlite3/getthecode.html
 share/doc/sqlite3/howtocompile.html
 share/doc/sqlite3/howtocorrupt.html
@@ -334,6 +335,10 @@ share/doc/sqlite3/images/fts3_interior_node.png
 share/doc/sqlite3/images/fts3_interior_node.svg
 share/doc/sqlite3/images/fts3_leaf_node.png
 share/doc/sqlite3/images/fts3_leaf_node.svg
+share/doc/sqlite3/images/fts5_formula.odf
+share/doc/sqlite3/images/fts5_formula1.png
+share/doc/sqlite3/images/fts5_formula2.png
+share/doc/sqlite3/images/fts5_formula3.png
 share/doc/sqlite3/images/fullscanb.gif
 share/doc/sqlite3/images/harmony.gif
 share/doc/sqlite3/images/index-ex1-x-b.gif
@@ -639,6 +644,7 @@ share/doc/sqlite3/releaselog/3_8_8.html
 share/doc/sqlite3/releaselog/3_8_8_1.html
 share/doc/sqlite3/releaselog/3_8_8_2.html
 share/doc/sqlite3/releaselog/3_8_8_3.html
+share/doc/sqlite3/releaselog/3_8_9.html
 share/doc/sqlite3/releaselog/current.html
 share/doc/sqlite3/requirements.html
 share/doc/sqlite3/rescode.html
diff --git a/databases/sqlite3-docs/distinfo b/databases/sqlite3-docs/distinfo
index a1fe6506450..631c47b2429 100644
--- a/databases/sqlite3-docs/distinfo
+++ b/databases/sqlite3-docs/distinfo
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.38 2015/03/02 13:34:16 adam Exp $
+$NetBSD: distinfo,v 1.39 2015/04/11 12:42:06 adam Exp $
 
-SHA1 (sqlite-doc-3080803.zip) = 27c2cada8e663f694c0469bcae09eb0d8c55dd7c
-RMD160 (sqlite-doc-3080803.zip) = 3eae7234ce9f3df40a65b2b17b8ecb73600e630e
-Size (sqlite-doc-3080803.zip) = 4972781 bytes
+SHA1 (sqlite-doc-3080900.zip) = c677b73a0be5419427a01431d24d718ec4cde6a9
+RMD160 (sqlite-doc-3080900.zip) = 0567148dc603a5b633dea7b756c0edcf671d3857
+Size (sqlite-doc-3080900.zip) = 5025367 bytes
diff --git a/databases/sqlite3-tcl/Makefile b/databases/sqlite3-tcl/Makefile
index aa08c33be29..d091421c34c 100644
--- a/databases/sqlite3-tcl/Makefile
+++ b/databases/sqlite3-tcl/Makefile
@@ -1,8 +1,7 @@
-# $NetBSD: Makefile,v 1.72 2015/04/06 08:17:24 adam Exp $
+# $NetBSD: Makefile,v 1.73 2015/04/11 12:42:06 adam Exp $
 
-DISTNAME=	sqlite-autoconf-3080803
-PKGNAME=	sqlite3-tcl-3.8.8.3
-PKGREVISION=	1
+DISTNAME=	sqlite-autoconf-3080900
+PKGNAME=	sqlite3-tcl-3.8.9
 CATEGORIES=	databases
 MASTER_SITES=	http://www.hwaci.com/sw/sqlite/2015/ \
 		http://www.sqlite.org/2015/
diff --git a/databases/sqlite3-tcl/distinfo b/databases/sqlite3-tcl/distinfo
index 18a3b7c490d..d8e090f2772 100644
--- a/databases/sqlite3-tcl/distinfo
+++ b/databases/sqlite3-tcl/distinfo
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.51 2015/03/02 13:34:16 adam Exp $
+$NetBSD: distinfo,v 1.52 2015/04/11 12:42:06 adam Exp $
 
-SHA1 (sqlite-autoconf-3080803.tar.gz) = 2fe3f6226a2a08a2e814b97cd53e36bb3c597112
-RMD160 (sqlite-autoconf-3080803.tar.gz) = 9063dd4ae39745dfe44d99f514ec084ee4442685
-Size (sqlite-autoconf-3080803.tar.gz) = 2021112 bytes
+SHA1 (sqlite-autoconf-3080900.tar.gz) = db70dee268700b312cbaa5b3e5cf8454e1c8b7b9
+RMD160 (sqlite-autoconf-3080900.tar.gz) = b89b63ccf07a5b55976643a41e6d7481c1ed284d
+Size (sqlite-autoconf-3080900.tar.gz) = 2037200 bytes
 SHA1 (patch-aa) = 4a12a16498d04e1031dc0802fda731b73e98a32d
diff --git a/databases/sqlite3/Makefile b/databases/sqlite3/Makefile
index f5ec77f5930..f14a19be539 100644
--- a/databases/sqlite3/Makefile
+++ b/databases/sqlite3/Makefile
@@ -1,8 +1,7 @@
-# $NetBSD: Makefile,v 1.93 2015/04/06 08:17:14 adam Exp $
+# $NetBSD: Makefile,v 1.94 2015/04/11 12:42:06 adam Exp $
 
-DISTNAME=	sqlite-autoconf-3080803
-PKGNAME=	sqlite3-3.8.8.3
-PKGREVISION=	1
+DISTNAME=	sqlite-autoconf-3080900
+PKGNAME=	sqlite3-3.8.9
 CATEGORIES=	databases
 MASTER_SITES=	http://www.hwaci.com/sw/sqlite/2015/ \
 		http://www.sqlite.org/2015/
diff --git a/databases/sqlite3/distinfo b/databases/sqlite3/distinfo
index a134707f0c8..5546cbcc960 100644
--- a/databases/sqlite3/distinfo
+++ b/databases/sqlite3/distinfo
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.101 2015/03/02 13:34:16 adam Exp $
+$NetBSD: distinfo,v 1.102 2015/04/11 12:42:06 adam Exp $
 
-SHA1 (sqlite-autoconf-3080803.tar.gz) = 2fe3f6226a2a08a2e814b97cd53e36bb3c597112
-RMD160 (sqlite-autoconf-3080803.tar.gz) = 9063dd4ae39745dfe44d99f514ec084ee4442685
-Size (sqlite-autoconf-3080803.tar.gz) = 2021112 bytes
+SHA1 (sqlite-autoconf-3080900.tar.gz) = db70dee268700b312cbaa5b3e5cf8454e1c8b7b9
+RMD160 (sqlite-autoconf-3080900.tar.gz) = b89b63ccf07a5b55976643a41e6d7481c1ed284d
+Size (sqlite-autoconf-3080900.tar.gz) = 2037200 bytes