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.

2 files changed, 21 insertions, 6 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