[pkgsrc/trunk]: pkgsrc/databases Changes 3.15.0:

[adam <adam%pkgsrc.org@localhost>]

details:   https://anonhg.NetBSD.org/pkgsrc/rev/7cd0fa19c6d5
branches:  trunk
changeset: 353882:7cd0fa19c6d5
user:      adam <adam%pkgsrc.org@localhost>
date:      Mon Oct 17 12:17:49 2016 +0000

description:
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.

diffstat:

 databases/sqlite3-docs/PLIST       |  17 ++++++++++++++++-
 databases/sqlite3-docs/distinfo    |  10 +++++-----
 databases/sqlite3-tcl/distinfo     |  10 +++++-----
 databases/sqlite3/Makefile.version |   6 +++---
 databases/sqlite3/distinfo         |  10 +++++-----
 5 files changed, 34 insertions(+), 19 deletions(-)

diffs (157 lines):

diff -r e8466eedf2e1 -r 7cd0fa19c6d5 databases/sqlite3-docs/PLIST
--- a/databases/sqlite3-docs/PLIST      Mon Oct 17 11:47:12 2016 +0000
+++ b/databases/sqlite3-docs/PLIST      Mon Oct 17 12:17:49 2016 +0000
@@ -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/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/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/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/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_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/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/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 -r e8466eedf2e1 -r 7cd0fa19c6d5 databases/sqlite3-docs/distinfo
--- a/databases/sqlite3-docs/distinfo   Mon Oct 17 11:47:12 2016 +0000
+++ b/databases/sqlite3-docs/distinfo   Mon Oct 17 12:17:49 2016 +0000
@@ -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 -r e8466eedf2e1 -r 7cd0fa19c6d5 databases/sqlite3-tcl/distinfo
--- a/databases/sqlite3-tcl/distinfo    Mon Oct 17 11:47:12 2016 +0000
+++ b/databases/sqlite3-tcl/distinfo    Mon Oct 17 12:17:49 2016 +0000
@@ -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 -r e8466eedf2e1 -r 7cd0fa19c6d5 databases/sqlite3/Makefile.version
--- a/databases/sqlite3/Makefile.version        Mon Oct 17 11:47:12 2016 +0000
+++ b/databases/sqlite3/Makefile.version        Mon Oct 17 12:17:49 2016 +0000
@@ -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 -r e8466eedf2e1 -r 7cd0fa19c6d5 databases/sqlite3/distinfo
--- a/databases/sqlite3/distinfo        Mon Oct 17 11:47:12 2016 +0000
+++ b/databases/sqlite3/distinfo        Mon Oct 17 12:17:49 2016 +0000
@@ -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