Changes 3.15.0:

Added support for row values.
Allow deterministic SQL functions in the WHERE clause of a partial index.
Added the "modeof=filename" URI parameter on the unix VFS
Added support for SQLITE_DBCONFIG_MAINDBNAME.
Added the ability to VACUUM an ATTACH-ed database.
Enhancements to the command-line shell:
Add the ".testcase" and ".check" dot-commands.
Added the --new option to the ".open" dot-command, causing any prior content in the database to be purged prior to opening.
Enhance the fts5vocab virtual table to handle "ORDER BY term" efficiently.
Miscellaneous micro-optimizations reduce CPU usage by more than 7% on common workloads. Most optimization in this release has been on the front-end (sqlite3_prepare_v2()).


Bug Fixes:

The multiply operator now correctly detects 64-bit integer overflow and promotes to floating point in all corner-cases.
Correct handling of columns with redundant unique indexes when those columns are used on the LHS of an IN operator.
Skip NULL entries on range queries in indexes on expressions.
Ensure that the AUTOINCREMENT counters in the sqlite_sequence table are initialized doing "Xfer Optimization" on "INSERT ... SELECT" statements.
Make sure the ORDER BY LIMIT optimization (from check-in 559733b09e) works with IN operators on INTEGER PRIMARY KEYs.

5 files changed, 34 insertions, 19 deletions

diff --git a/databases/sqlite3-docs/PLIST b/databases/sqlite3-docs/PLIST
index a06837aa6e8..801067a9526 100644
--- a/databases/sqlite3-docs/PLIST
+++ b/databases/sqlite3-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.59 2016/09/13 10:48:24 adam Exp $
+@comment $NetBSD: PLIST,v 1.60 2016/10/17 12:17:50 adam Exp $
 share/doc/sqlite3/34to35.html
 share/doc/sqlite3/35to36.html
 share/doc/sqlite3/about.html
@@ -214,6 +214,8 @@ share/doc/sqlite3/datatype3.html
 share/doc/sqlite3/datatypes.html
 share/doc/sqlite3/dbhash.html
 share/doc/sqlite3/dbstat.html
+share/doc/sqlite3/debugging.html
+share/doc/sqlite3/deterministic.html
 share/doc/sqlite3/dev.html
 share/doc/sqlite3/different.html
 share/doc/sqlite3/doc_backlink_crossref.html
@@ -238,7 +240,9 @@ share/doc/sqlite3/foreignkeys.html
 share/doc/sqlite3/formatchng.html
 share/doc/sqlite3/fts3.html
 share/doc/sqlite3/fts5.html
+share/doc/sqlite3/fullsql.html
 share/doc/sqlite3/getthecode.html
+share/doc/sqlite3/hirely.html
 share/doc/sqlite3/howtocompile.html
 share/doc/sqlite3/howtocorrupt.html
 share/doc/sqlite3/hp1.html
@@ -418,6 +422,7 @@ share/doc/sqlite3/images/syntax/attach-stmt.gif
 share/doc/sqlite3/images/syntax/begin-stmt.gif
 share/doc/sqlite3/images/syntax/column-constraint.gif
 share/doc/sqlite3/images/syntax/column-def.gif
+share/doc/sqlite3/images/syntax/column-name-list.gif
 share/doc/sqlite3/images/syntax/comment-syntax.gif
 share/doc/sqlite3/images/syntax/commit-stmt.gif
 share/doc/sqlite3/images/syntax/common-table-expression.gif
@@ -516,12 +521,14 @@ share/doc/sqlite3/lang_with.html
 share/doc/sqlite3/limits.html
 share/doc/sqlite3/loadext.html
 share/doc/sqlite3/lockingv3.html
+share/doc/sqlite3/lts.html
 share/doc/sqlite3/malloc.html
 share/doc/sqlite3/mingw.html
 share/doc/sqlite3/mmap.html
 share/doc/sqlite3/mostdeployed.html
 share/doc/sqlite3/news.html
 share/doc/sqlite3/not-found.html
+share/doc/sqlite3/np1queryprob.html
 share/doc/sqlite3/nulls.html
 share/doc/sqlite3/oldnews.html
 share/doc/sqlite3/omitted.html
@@ -560,6 +567,7 @@ share/doc/sqlite3/releaselog/3_13_0.html
 share/doc/sqlite3/releaselog/3_14.html
 share/doc/sqlite3/releaselog/3_14_1.html
 share/doc/sqlite3/releaselog/3_14_2.html
+share/doc/sqlite3/releaselog/3_15_0.html
 share/doc/sqlite3/releaselog/3_1_0.html
 share/doc/sqlite3/releaselog/3_1_1.html
 share/doc/sqlite3/releaselog/3_1_2.html
@@ -703,20 +711,26 @@ share/doc/sqlite3/requirements.html
 share/doc/sqlite3/rescode.html
 share/doc/sqlite3/robots.txt
 share/doc/sqlite3/rowidtable.html
+share/doc/sqlite3/rowvalue.html
 share/doc/sqlite3/rtree.html
 share/doc/sqlite3/selfcontained.html
+share/doc/sqlite3/series.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/changegroup.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/sqlite3changegroup_add.html
 share/doc/sqlite3/session/sqlite3changegroup_add_strm.html
+share/doc/sqlite3/session/sqlite3changegroup_delete.html
 share/doc/sqlite3/session/sqlite3changegroup_new.html
+share/doc/sqlite3/session/sqlite3changegroup_output.html
 share/doc/sqlite3/session/sqlite3changeset_apply.html
 share/doc/sqlite3/session/sqlite3changeset_concat.html
 share/doc/sqlite3/session/sqlite3changeset_conflict.html
@@ -757,6 +771,7 @@ share/doc/sqlite3/syntax/attach-stmt.html
 share/doc/sqlite3/syntax/begin-stmt.html
 share/doc/sqlite3/syntax/column-constraint.html
 share/doc/sqlite3/syntax/column-def.html
+share/doc/sqlite3/syntax/column-name-list.html
 share/doc/sqlite3/syntax/comment-syntax.html
 share/doc/sqlite3/syntax/commit-stmt.html
 share/doc/sqlite3/syntax/common-table-expression.html
diff --git a/databases/sqlite3-docs/distinfo b/databases/sqlite3-docs/distinfo
index 4fc0a0eecd6..63b2f572740 100644
--- a/databases/sqlite3-docs/distinfo
+++ b/databases/sqlite3-docs/distinfo
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.60 2016/09/13 10:48:24 adam Exp $
+$NetBSD: distinfo,v 1.61 2016/10/17 12:17:50 adam Exp $
 
-SHA1 (sqlite-doc-3140200.zip) = ed4248ebfd30a20ce9bddc8e27677ce63382a952
-RMD160 (sqlite-doc-3140200.zip) = f51ea4035fbec4f663f39e80681bd6843bd62080
-SHA512 (sqlite-doc-3140200.zip) = 4acd9818cc864332cbc57c9533d45c26d62f5c62ab9dff3f0fb1bb98530fe974f83699ccc0b098b14bcbfd718a2aa6b4d3b7c2ca880e4097d9b0833b8d902069
-Size (sqlite-doc-3140200.zip) = 5386739 bytes
+SHA1 (sqlite-doc-3150000.zip) = 0a0537702edefeff71355ee54ccced88d5035198
+RMD160 (sqlite-doc-3150000.zip) = e4fb62bf5e1009673e6faa3ee50f7b7c17ba6b9e
+SHA512 (sqlite-doc-3150000.zip) = 68938bb07b9144a847bddcced93e949a23eaaaa941dc0080f5468ca25a1023b97f351749cc9b3f7c3cb836d0c4fba6482f29d7381ae3b50b8fa93bd078696610
+Size (sqlite-doc-3150000.zip) = 5456115 bytes
diff --git a/databases/sqlite3-tcl/distinfo b/databases/sqlite3-tcl/distinfo
index bbccf1123ff..5e40a3bcb97 100644
--- a/databases/sqlite3-tcl/distinfo
+++ b/databases/sqlite3-tcl/distinfo
@@ -1,7 +1,7 @@
-$NetBSD: distinfo,v 1.73 2016/09/13 10:48:24 adam Exp $
+$NetBSD: distinfo,v 1.74 2016/10/17 12:17:50 adam Exp $
 
-SHA1 (sqlite-autoconf-3140200.tar.gz) = 5d3a6bccd9154963641960db61df901a4e0b3ca0
-RMD160 (sqlite-autoconf-3140200.tar.gz) = 5a35fe94bda3876da1beb89bb19cb1a8bd6d235c
-SHA512 (sqlite-autoconf-3140200.tar.gz) = 02c5ca3073e29307f842af3305793dd6251d2ac43ce3f37b5b9402d6582a6bda56a41f82b130d03997ebb3cc109d6ab7baa9a946c03e74ae5158426bc154fd70
-Size (sqlite-autoconf-3140200.tar.gz) = 2472940 bytes
+SHA1 (sqlite-autoconf-3150000.tar.gz) = b34cb4ee9710368598c62df0222f5c24dfc9c860
+RMD160 (sqlite-autoconf-3150000.tar.gz) = 7d45f1c23059b44e2a2cf8149af21d23a2032c1e
+SHA512 (sqlite-autoconf-3150000.tar.gz) = d441a8654d72a203df898de4ae38526df0659d358942f21973d4c356a56105afa288e26f538a7cfb1bfe2a51bcd70ab281ce5d24c6f19c43b53ee9aa044e6e5e
+Size (sqlite-autoconf-3150000.tar.gz) = 2490473 bytes
 SHA1 (patch-aa) = 4a12a16498d04e1031dc0802fda731b73e98a32d
diff --git a/databases/sqlite3/Makefile.version b/databases/sqlite3/Makefile.version
index 1707fb6a5b5..88850e38c9c 100644
--- a/databases/sqlite3/Makefile.version
+++ b/databases/sqlite3/Makefile.version
@@ -1,10 +1,10 @@
-# $NetBSD: Makefile.version,v 1.21 2016/09/13 10:48:24 adam Exp $
+# $NetBSD: Makefile.version,v 1.22 2016/10/17 12:17:49 adam Exp $
 # used by databases/sqlite3/Makefile
 # used by databases/sqlite3-docs/Makefile
 # used by databases/sqlite3-tcl/Makefile
 
-SQLITE3_DISTVERSION=	3140200
-SQLITE3_VERSION=	3.14.2
+SQLITE3_DISTVERSION=	3150000
+SQLITE3_VERSION=	3.15.0
 
 MASTER_SITES=	http://www.hwaci.com/sw/sqlite/2016/ \
 		http://www.sqlite.org/2016/
diff --git a/databases/sqlite3/distinfo b/databases/sqlite3/distinfo
index 194030101ff..52bf0c0b68b 100644
--- a/databases/sqlite3/distinfo
+++ b/databases/sqlite3/distinfo
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.125 2016/09/13 10:48:24 adam Exp $
+$NetBSD: distinfo,v 1.126 2016/10/17 12:17:49 adam Exp $
 
-SHA1 (sqlite-autoconf-3140200.tar.gz) = 5d3a6bccd9154963641960db61df901a4e0b3ca0
-RMD160 (sqlite-autoconf-3140200.tar.gz) = 5a35fe94bda3876da1beb89bb19cb1a8bd6d235c
-SHA512 (sqlite-autoconf-3140200.tar.gz) = 02c5ca3073e29307f842af3305793dd6251d2ac43ce3f37b5b9402d6582a6bda56a41f82b130d03997ebb3cc109d6ab7baa9a946c03e74ae5158426bc154fd70
-Size (sqlite-autoconf-3140200.tar.gz) = 2472940 bytes
+SHA1 (sqlite-autoconf-3150000.tar.gz) = b34cb4ee9710368598c62df0222f5c24dfc9c860
+RMD160 (sqlite-autoconf-3150000.tar.gz) = 7d45f1c23059b44e2a2cf8149af21d23a2032c1e
+SHA512 (sqlite-autoconf-3150000.tar.gz) = d441a8654d72a203df898de4ae38526df0659d358942f21973d4c356a56105afa288e26f538a7cfb1bfe2a51bcd70ab281ce5d24c6f19c43b53ee9aa044e6e5e
+Size (sqlite-autoconf-3150000.tar.gz) = 2490473 bytes