CVS commit: pkgsrc/databases

["Adam Ciarcinski" <adam%netbsd.org@localhost>]

Module Name:    pkgsrc
Committed By:   adam
Date:           Mon Oct 17 12:17:50 UTC 2016

Modified Files:
        pkgsrc/databases/sqlite3: Makefile.version distinfo
        pkgsrc/databases/sqlite3-docs: PLIST distinfo
        pkgsrc/databases/sqlite3-tcl: distinfo

Log Message:
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.


To generate a diff of this commit:
cvs rdiff -u -r1.21 -r1.22 pkgsrc/databases/sqlite3/Makefile.version
cvs rdiff -u -r1.125 -r1.126 pkgsrc/databases/sqlite3/distinfo
cvs rdiff -u -r1.59 -r1.60 pkgsrc/databases/sqlite3-docs/PLIST
cvs rdiff -u -r1.60 -r1.61 pkgsrc/databases/sqlite3-docs/distinfo
cvs rdiff -u -r1.73 -r1.74 pkgsrc/databases/sqlite3-tcl/distinfo

Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.

Modified files:

Index: pkgsrc/databases/sqlite3/Makefile.version
diff -u pkgsrc/databases/sqlite3/Makefile.version:1.21 pkgsrc/databases/sqlite3/Makefile.version:1.22
--- pkgsrc/databases/sqlite3/Makefile.version:1.21      Tue Sep 13 10:48:24 2016
+++ pkgsrc/databases/sqlite3/Makefile.version   Mon Oct 17 12:17:49 2016
@@ -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/

Index: pkgsrc/databases/sqlite3/distinfo
diff -u pkgsrc/databases/sqlite3/distinfo:1.125 pkgsrc/databases/sqlite3/distinfo:1.126
--- pkgsrc/databases/sqlite3/distinfo:1.125     Tue Sep 13 10:48:24 2016
+++ pkgsrc/databases/sqlite3/distinfo   Mon Oct 17 12:17:49 2016
@@ -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

Index: pkgsrc/databases/sqlite3-docs/PLIST
diff -u pkgsrc/databases/sqlite3-docs/PLIST:1.59 pkgsrc/databases/sqlite3-docs/PLIST:1.60
--- pkgsrc/databases/sqlite3-docs/PLIST:1.59    Tue Sep 13 10:48:24 2016
+++ pkgsrc/databases/sqlite3-docs/PLIST Mon Oct 17 12:17:50 2016
@@ -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-s
 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.htm
 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

Index: pkgsrc/databases/sqlite3-docs/distinfo
diff -u pkgsrc/databases/sqlite3-docs/distinfo:1.60 pkgsrc/databases/sqlite3-docs/distinfo:1.61
--- pkgsrc/databases/sqlite3-docs/distinfo:1.60 Tue Sep 13 10:48:24 2016
+++ pkgsrc/databases/sqlite3-docs/distinfo      Mon Oct 17 12:17:50 2016
@@ -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

Index: pkgsrc/databases/sqlite3-tcl/distinfo
diff -u pkgsrc/databases/sqlite3-tcl/distinfo:1.73 pkgsrc/databases/sqlite3-tcl/distinfo:1.74
--- pkgsrc/databases/sqlite3-tcl/distinfo:1.73  Tue Sep 13 10:48:24 2016
+++ pkgsrc/databases/sqlite3-tcl/distinfo       Mon Oct 17 12:17:50 2016
@@ -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