CVS commit: pkgsrc

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

Module Name:    pkgsrc
Committed By:   adam
Date:           Mon Jan  2 17:52:24 UTC 2017

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

Log Message:
SQLite Release 3.16.0 On 2017-01-02

Uses 9% fewer CPU cycles. (See the CPU performance measurement report for details on how the this performance increase was computed.)
Added experimental support for PRAGMA functions.
Added the SQLITE_DBCONFIG_NO_CKPT_ON_CLOSE option to sqlite3_db_config().
Enhance the date and time functions so that the 'unixepoch' modifier works for the full span of supported dates.
Changed the default configuration of the lookaside memory allocator from 500 slots of 128 bytes each into 125 slots of 512 bytes each.
Enhanced "WHERE x NOT NULL" partial indexes so that they are usable if the "x" column appears in a LIKE or GLOB operator.
Enhanced sqlite3_interrupt() so that it interrupts checkpoint operations that are in process.
Enhanced the LIKE and GLOB matching algorithm to be faster for cases when the pattern contains multiple wildcards.
Added the SQLITE_FCNTL_WIN32_GET_HANDLE file control opcode.
Added ".mode quote" to the command-line shell.
Added ".lint fkey-indexes" to the command-line shell.
Added the .imposter dot-command to the command-line shell.
Added the remember(V,PTR) SQL function as a loadable extension.
Rename the SQLITE_OMIT_BUILTIN_TEST compile-time option to SQLITE_UNTESTABLE to better reflect the implications of using it.

Bug Fixes:
Fix a long-standing bug in the query planner that caused incorrect results on a LEFT JOIN where the left-hand table is a subquery and the join constraint is a bare column name coming from the 
left-hand subquery. Ticket 2df0107b.
Correctly handle the integer literal -0x8000000000000000 in the query planner.


To generate a diff of this commit:
cvs rdiff -u -r1.112 -r1.113 pkgsrc/databases/sqlite3/Makefile
cvs rdiff -u -r1.25 -r1.26 pkgsrc/databases/sqlite3/Makefile.version
cvs rdiff -u -r1.128 -r1.129 pkgsrc/databases/sqlite3/distinfo
cvs rdiff -u -r1.62 -r1.63 pkgsrc/databases/sqlite3-docs/PLIST
cvs rdiff -u -r1.63 -r1.64 pkgsrc/databases/sqlite3-docs/distinfo
cvs rdiff -u -r1.83 -r1.84 pkgsrc/databases/sqlite3-tcl/Makefile
cvs rdiff -u -r1.76 -r1.77 pkgsrc/databases/sqlite3-tcl/distinfo
cvs rdiff -u -r1.5 -r1.6 pkgsrc/devel/lemon/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
diff -u pkgsrc/databases/sqlite3/Makefile:1.112 pkgsrc/databases/sqlite3/Makefile:1.113
--- pkgsrc/databases/sqlite3/Makefile:1.112     Mon Dec 12 16:17:53 2016
+++ pkgsrc/databases/sqlite3/Makefile   Mon Jan  2 17:52:23 2017
@@ -1,8 +1,7 @@
-# $NetBSD: Makefile,v 1.112 2016/12/12 16:17:53 wiz Exp $
+# $NetBSD: Makefile,v 1.113 2017/01/02 17:52:23 adam Exp $
 #
 # used by databases/sqlite3-tcl/Makefile
 
-PKGREVISION= 2
 .include "Makefile.common"
 
 PKGNAME=       sqlite3-${SQLITE3_VERSION}

Index: pkgsrc/databases/sqlite3/Makefile.version
diff -u pkgsrc/databases/sqlite3/Makefile.version:1.25 pkgsrc/databases/sqlite3/Makefile.version:1.26
--- pkgsrc/databases/sqlite3/Makefile.version:1.25      Tue Nov 29 08:46:48 2016
+++ pkgsrc/databases/sqlite3/Makefile.version   Mon Jan  2 17:52:23 2017
@@ -1,12 +1,12 @@
-# $NetBSD: Makefile.version,v 1.25 2016/11/29 08:46:48 adam Exp $
+# $NetBSD: Makefile.version,v 1.26 2017/01/02 17:52:23 adam Exp $
 #
 # used by databases/sqlite3/Makefile
 # used by databases/sqlite3-docs/Makefile
 # used by databases/sqlite3-tcl/Makefile
 # used by devel/lemon/Makefile
 
-SQLITE3_DISTVERSION=   3150200
-SQLITE3_VERSION=       3.15.2
+SQLITE3_DISTVERSION=   3160000
+SQLITE3_VERSION=       3.16.0
 
-MASTER_SITES=  http://www.hwaci.com/sw/sqlite/2016/ \
-               http://www.sqlite.org/2016/
+MASTER_SITES=  http://www.hwaci.com/sw/sqlite/2017/ \
+               http://www.sqlite.org/2017/

Index: pkgsrc/databases/sqlite3/distinfo
diff -u pkgsrc/databases/sqlite3/distinfo:1.128 pkgsrc/databases/sqlite3/distinfo:1.129
--- pkgsrc/databases/sqlite3/distinfo:1.128     Tue Nov 29 08:46:48 2016
+++ pkgsrc/databases/sqlite3/distinfo   Mon Jan  2 17:52:23 2017
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.128 2016/11/29 08:46:48 adam Exp $
+$NetBSD: distinfo,v 1.129 2017/01/02 17:52:23 adam Exp $
 
-SHA1 (sqlite-autoconf-3150200.tar.gz) = 31f52169bcfeef9efb61480d0950e928ad059552
-RMD160 (sqlite-autoconf-3150200.tar.gz) = d4472bdea8d4af9dcffa68305a88c21bbd9fad9f
-SHA512 (sqlite-autoconf-3150200.tar.gz) = 9620f03bbd14a15063378656567df544245f62255ed36cca683b3b92b6eb48e83c6ca09bbf904b916c1c7504b69f0332860923daabb25c94b2a46434e2dcb19d
-Size (sqlite-autoconf-3150200.tar.gz) = 2491735 bytes
+SHA1 (sqlite-autoconf-3160000.tar.gz) = 5150313c332b598a98be0c4bd5a04031a216ab13
+RMD160 (sqlite-autoconf-3160000.tar.gz) = 015864279cad35ca05740e53de6d703e1a549dc3
+SHA512 (sqlite-autoconf-3160000.tar.gz) = b1f6d5148e3e1238c838ff2eb9dd6f534f61dddda9f3b1275a608a1c3ddd2e8064ddffaf6e90d13dbf203bc7cc5f3f48191dd613a09fd1ba56567f8ccc253687
+Size (sqlite-autoconf-3160000.tar.gz) = 2506992 bytes

Index: pkgsrc/databases/sqlite3-docs/PLIST
diff -u pkgsrc/databases/sqlite3-docs/PLIST:1.62 pkgsrc/databases/sqlite3-docs/PLIST:1.63
--- pkgsrc/databases/sqlite3-docs/PLIST:1.62    Tue Dec 20 14:20:27 2016
+++ pkgsrc/databases/sqlite3-docs/PLIST Mon Jan  2 17:52:24 2017
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.62 2016/12/20 14:20:27 adam Exp $
+@comment $NetBSD: PLIST,v 1.63 2017/01/02 17:52:24 adam Exp $
 share/doc/sqlite3/34to35.html
 share/doc/sqlite3/35to36.html
 share/doc/sqlite3/about.html
@@ -152,6 +152,7 @@ share/doc/sqlite3/c3ref/snapshot_cmp.htm
 share/doc/sqlite3/c3ref/snapshot_free.html
 share/doc/sqlite3/c3ref/snapshot_get.html
 share/doc/sqlite3/c3ref/snapshot_open.html
+share/doc/sqlite3/c3ref/snapshot_recover.html
 share/doc/sqlite3/c3ref/soft_heap_limit.html
 share/doc/sqlite3/c3ref/soft_heap_limit64.html
 share/doc/sqlite3/c3ref/sqlite3.html
@@ -206,6 +207,7 @@ share/doc/sqlite3/consortium_agreement-2
 share/doc/sqlite3/copyright-release.html
 share/doc/sqlite3/copyright-release.pdf
 share/doc/sqlite3/copyright.html
+share/doc/sqlite3/cpu.html
 share/doc/sqlite3/crew.html
 share/doc/sqlite3/csv.html
 share/doc/sqlite3/custombuild.html
@@ -295,6 +297,7 @@ share/doc/sqlite3/images/btreemodule_bal
 share/doc/sqlite3/images/btreemodule_delete1.svg
 share/doc/sqlite3/images/btreemodule_overview.svg
 share/doc/sqlite3/images/chw.jpg
+share/doc/sqlite3/images/cpu-usage.jpg
 share/doc/sqlite3/images/dan1.jpg
 share/doc/sqlite3/images/direct1b.gif
 share/doc/sqlite3/images/drh1.jpg
@@ -478,6 +481,7 @@ share/doc/sqlite3/images/syntax/vacuum-s
 share/doc/sqlite3/images/syntax/with-clause.gif
 share/doc/sqlite3/images/table-ex1b2.gif
 share/doc/sqlite3/images/vfs1.gif
+share/doc/sqlite3/imposter.html
 share/doc/sqlite3/index.html
 share/doc/sqlite3/inmemorydb.html
 share/doc/sqlite3/intern-v-extern-blob.html
@@ -527,7 +531,6 @@ 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
@@ -570,6 +573,7 @@ share/doc/sqlite3/releaselog/3_14_2.html
 share/doc/sqlite3/releaselog/3_15_0.html
 share/doc/sqlite3/releaselog/3_15_1.html
 share/doc/sqlite3/releaselog/3_15_2.html
+share/doc/sqlite3/releaselog/3_16_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

Index: pkgsrc/databases/sqlite3-docs/distinfo
diff -u pkgsrc/databases/sqlite3-docs/distinfo:1.63 pkgsrc/databases/sqlite3-docs/distinfo:1.64
--- pkgsrc/databases/sqlite3-docs/distinfo:1.63 Tue Dec 20 14:20:27 2016
+++ pkgsrc/databases/sqlite3-docs/distinfo      Mon Jan  2 17:52:24 2017
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.63 2016/12/20 14:20:27 adam Exp $
+$NetBSD: distinfo,v 1.64 2017/01/02 17:52:24 adam Exp $
 
-SHA1 (sqlite-doc-3150200.zip) = 7f60ca500384f3de8e548d80fb48cb58b9ce0b1a
-RMD160 (sqlite-doc-3150200.zip) = 407128774e4e657a73304dfd5bbf93f3848e1093
-SHA512 (sqlite-doc-3150200.zip) = c0fd3325c4d73c86a07abe126a317e4b3acbf5dfe88c0e70de5a9b54dace8b1ca1469fe559a5d0fc1781586581abe51a4350a96f6498d02db1dfce4470cf0496
-Size (sqlite-doc-3150200.zip) = 5464066 bytes
+SHA1 (sqlite-doc-3160000.zip) = 6588aea01865be2cfcd326b693193dda5a618b7b
+RMD160 (sqlite-doc-3160000.zip) = 4c70c187cb0c1bbd2624676d9e30d5e66445ced6
+SHA512 (sqlite-doc-3160000.zip) = 9ca5394b6949cb0cdafe480d95c0509f29a2defb35fc7a1dbb6db212225d5ebf789a6b4519d03676a067c89a95453486dc5dba0d127610f7b806dc2cc530299a
+Size (sqlite-doc-3160000.zip) = 5513426 bytes

Index: pkgsrc/databases/sqlite3-tcl/Makefile
diff -u pkgsrc/databases/sqlite3-tcl/Makefile:1.83 pkgsrc/databases/sqlite3-tcl/Makefile:1.84
--- pkgsrc/databases/sqlite3-tcl/Makefile:1.83  Sun Dec  4 05:17:22 2016
+++ pkgsrc/databases/sqlite3-tcl/Makefile       Mon Jan  2 17:52:24 2017
@@ -1,6 +1,5 @@
-# $NetBSD: Makefile,v 1.83 2016/12/04 05:17:22 ryoon Exp $
+# $NetBSD: Makefile,v 1.84 2017/01/02 17:52:24 adam Exp $
 
-PKGREVISION= 1
 .include "../../databases/sqlite3/Makefile.common"
 
 PKGNAME=       sqlite3-tcl-${SQLITE3_VERSION}

Index: pkgsrc/databases/sqlite3-tcl/distinfo
diff -u pkgsrc/databases/sqlite3-tcl/distinfo:1.76 pkgsrc/databases/sqlite3-tcl/distinfo:1.77
--- pkgsrc/databases/sqlite3-tcl/distinfo:1.76  Tue Dec 20 14:20:27 2016
+++ pkgsrc/databases/sqlite3-tcl/distinfo       Mon Jan  2 17:52:24 2017
@@ -1,7 +1,7 @@
-$NetBSD: distinfo,v 1.76 2016/12/20 14:20:27 adam Exp $
+$NetBSD: distinfo,v 1.77 2017/01/02 17:52:24 adam Exp $
 
-SHA1 (sqlite-autoconf-3150200.tar.gz) = 31f52169bcfeef9efb61480d0950e928ad059552
-RMD160 (sqlite-autoconf-3150200.tar.gz) = d4472bdea8d4af9dcffa68305a88c21bbd9fad9f
-SHA512 (sqlite-autoconf-3150200.tar.gz) = 9620f03bbd14a15063378656567df544245f62255ed36cca683b3b92b6eb48e83c6ca09bbf904b916c1c7504b69f0332860923daabb25c94b2a46434e2dcb19d
-Size (sqlite-autoconf-3150200.tar.gz) = 2491735 bytes
+SHA1 (sqlite-autoconf-3160000.tar.gz) = 5150313c332b598a98be0c4bd5a04031a216ab13
+RMD160 (sqlite-autoconf-3160000.tar.gz) = 015864279cad35ca05740e53de6d703e1a549dc3
+SHA512 (sqlite-autoconf-3160000.tar.gz) = b1f6d5148e3e1238c838ff2eb9dd6f534f61dddda9f3b1275a608a1c3ddd2e8064ddffaf6e90d13dbf203bc7cc5f3f48191dd613a09fd1ba56567f8ccc253687
+Size (sqlite-autoconf-3160000.tar.gz) = 2506992 bytes
 SHA1 (patch-aa) = 4a12a16498d04e1031dc0802fda731b73e98a32d

Index: pkgsrc/devel/lemon/distinfo
diff -u pkgsrc/devel/lemon/distinfo:1.5 pkgsrc/devel/lemon/distinfo:1.6
--- pkgsrc/devel/lemon/distinfo:1.5     Tue Nov 29 08:46:48 2016
+++ pkgsrc/devel/lemon/distinfo Mon Jan  2 17:52:24 2017
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.5 2016/11/29 08:46:48 adam Exp $
+$NetBSD: distinfo,v 1.6 2017/01/02 17:52:24 adam Exp $
 
-SHA1 (sqlite-src-3150200.zip) = 4b7c86c0c2780321d524ca69073fc6bb7c29c108
-RMD160 (sqlite-src-3150200.zip) = 958ddac3da081ad1415c6278a491405ff8396cc6
-SHA512 (sqlite-src-3150200.zip) = 9ee97b2822853bb2dbf4ceaf011864e1afeb1deef7a668f2f31d5a6d1a9aab4a7127c6d54b4fa7288b21c8e849989bf24c53ea6de483103f9158d07dfb8ca85a
-Size (sqlite-src-3150200.zip) = 9635796 bytes
+SHA1 (sqlite-src-3160000.zip) = 1256fb4d810d23082ed2150cbfc3fa98245cd05b
+RMD160 (sqlite-src-3160000.zip) = 00f4a9fd26fca31d2b8ac8891e25370919f25b0b
+SHA512 (sqlite-src-3160000.zip) = a070787b09ed5d17004622ec6c332fb6d7b6b660f698b810d6c0af1ca3f99f88d27f1e4bd742ec0d13ba3a443db853c4b46de267640ee218564622c90ed8ed5e
+Size (sqlite-src-3160000.zip) = 10077752 bytes