[pkgsrc/trunk]: pkgsrc Changes 3.16.2:

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

details:   https://anonhg.NetBSD.org/pkgsrc/rev/e583de7fc665
branches:  trunk
changeset: 356895:e583de7fc665
user:      adam <adam%pkgsrc.org@localhost>
date:      Sat Jan 07 10:23:00 2017 +0000

description:
Changes 3.16.2:
Fix the REPLACE statement for WITHOUT ROWID tables that lack secondary indexes so that it works correctly with triggers and foreign keys. This was a new bug caused by performance optimizations added 
in version 3.16.0. Ticket 30027b613b4
Fix the sqlite3_value_text() interface so that it correctly translates content generated by zeroblob() into a string of all 0x00 characters. This is a long-standing issue discovered after the 3.16.1 
release by OSS-Fuzz
Fix the bytecode generator to deal with a subquery in the FROM clause that is itself a UNION ALL where one side of the UNION ALL is a view that contains an ORDER BY. This is a long-standing issue 
that was discovered after the release of 3.16.1. See ticket 190c2507.
Adjust the sqlite3_column_count() API so it more often returns the same values for PRAGMA statements as it did in prior releases, to minimize disruption to applications that might be using that 
interface in unexpected ways.

diffstat:

 databases/sqlite3-docs/PLIST       |   3 ++-
 databases/sqlite3-docs/distinfo    |  10 +++++-----
 databases/sqlite3-tcl/distinfo     |  10 +++++-----
 databases/sqlite3/Makefile.version |   6 +++---
 databases/sqlite3/distinfo         |  10 +++++-----
 devel/lemon/distinfo               |  10 +++++-----
 6 files changed, 25 insertions(+), 24 deletions(-)

diffs (97 lines):

diff -r 16c4fe5cce15 -r e583de7fc665 databases/sqlite3-docs/PLIST
--- a/databases/sqlite3-docs/PLIST      Sat Jan 07 06:37:56 2017 +0000
+++ b/databases/sqlite3-docs/PLIST      Sat Jan 07 10:23:00 2017 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.64 2017/01/05 17:49:54 adam Exp $
+@comment $NetBSD: PLIST,v 1.65 2017/01/07 10:23:00 adam Exp $
 share/doc/sqlite3/34to35.html
 share/doc/sqlite3/35to36.html
 share/doc/sqlite3/about.html
@@ -575,6 +575,7 @@
 share/doc/sqlite3/releaselog/3_15_2.html
 share/doc/sqlite3/releaselog/3_16_0.html
 share/doc/sqlite3/releaselog/3_16_1.html
+share/doc/sqlite3/releaselog/3_16_2.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
diff -r 16c4fe5cce15 -r e583de7fc665 databases/sqlite3-docs/distinfo
--- a/databases/sqlite3-docs/distinfo   Sat Jan 07 06:37:56 2017 +0000
+++ b/databases/sqlite3-docs/distinfo   Sat Jan 07 10:23:00 2017 +0000
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.65 2017/01/05 17:49:54 adam Exp $
+$NetBSD: distinfo,v 1.66 2017/01/07 10:23:00 adam Exp $
 
-SHA1 (sqlite-doc-3160100.zip) = cc8fe20f8788e87b847509c4501194dfdbb70d39
-RMD160 (sqlite-doc-3160100.zip) = 3016264a0a3104f822f0187d11a39f0ff6b8a374
-SHA512 (sqlite-doc-3160100.zip) = d5c70bf202f142fc3c67a49d45a4218c3e47ede23a934cd3b27c7b5cb873d5cff4ee2cc8f5e04c2f00d1b8f002219d09a1926ab84108f985d39ff0520b0a7054
-Size (sqlite-doc-3160100.zip) = 5517276 bytes
+SHA1 (sqlite-doc-3160200.zip) = c3424040e2368dd78cf9aac801de8d8988549439
+RMD160 (sqlite-doc-3160200.zip) = 2d3c201abfdcd7ec4902ee5a299d99f9946e4cb5
+SHA512 (sqlite-doc-3160200.zip) = b79d21074d1ab154e3b324fb2943f24321ad5cdbc6e2030f1d21940ae46538462af049e0e0cd7c6cf96dec2c59708eaf70aa4cb3c84ba1a0e87238ffcf31fca2
+Size (sqlite-doc-3160200.zip) = 5521023 bytes
diff -r 16c4fe5cce15 -r e583de7fc665 databases/sqlite3-tcl/distinfo
--- a/databases/sqlite3-tcl/distinfo    Sat Jan 07 06:37:56 2017 +0000
+++ b/databases/sqlite3-tcl/distinfo    Sat Jan 07 10:23:00 2017 +0000
@@ -1,7 +1,7 @@
-$NetBSD: distinfo,v 1.78 2017/01/05 17:49:54 adam Exp $
+$NetBSD: distinfo,v 1.79 2017/01/07 10:23:00 adam Exp $
 
-SHA1 (sqlite-autoconf-3160100.tar.gz) = 77f8c59fec1575c5e05462dccac956f141677647
-RMD160 (sqlite-autoconf-3160100.tar.gz) = d9e7f39f0818ac9bd83d45b6aa6ab969e4057f18
-SHA512 (sqlite-autoconf-3160100.tar.gz) = 4c6efa1e16ff7e0450de9971b833ee9678e47e932ed933c378fe293f9ff4b851bd5353a14cd61abd947d3138eb79d38142e536ad7240b704a67a994e377d242b
-Size (sqlite-autoconf-3160100.tar.gz) = 2507441 bytes
+SHA1 (sqlite-autoconf-3160200.tar.gz) = 64ca578ad44a94115b1db0406740e14288f74bb8
+RMD160 (sqlite-autoconf-3160200.tar.gz) = 86b351cfa4321a857fe6987694e188655226951f
+SHA512 (sqlite-autoconf-3160200.tar.gz) = 83bdd588504f265bbe93fb98a33a292aff5618c14f94d521c8557efbb5f777e82dfbb2d186cbfd4c628ee9522b1fcb73857e24ca2318fa34af3a3f9540e72b9a
+Size (sqlite-autoconf-3160200.tar.gz) = 2508179 bytes
 SHA1 (patch-aa) = 4a12a16498d04e1031dc0802fda731b73e98a32d
diff -r 16c4fe5cce15 -r e583de7fc665 databases/sqlite3/Makefile.version
--- a/databases/sqlite3/Makefile.version        Sat Jan 07 06:37:56 2017 +0000
+++ b/databases/sqlite3/Makefile.version        Sat Jan 07 10:23:00 2017 +0000
@@ -1,12 +1,12 @@
-# $NetBSD: Makefile.version,v 1.27 2017/01/05 17:49:54 adam Exp $
+# $NetBSD: Makefile.version,v 1.28 2017/01/07 10:23:00 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=   3160100
-SQLITE3_VERSION=       3.16.1
+SQLITE3_DISTVERSION=   3160200
+SQLITE3_VERSION=       3.16.2
 
 MASTER_SITES=  http://www.hwaci.com/sw/sqlite/2017/ \
                http://www.sqlite.org/2017/
diff -r 16c4fe5cce15 -r e583de7fc665 databases/sqlite3/distinfo
--- a/databases/sqlite3/distinfo        Sat Jan 07 06:37:56 2017 +0000
+++ b/databases/sqlite3/distinfo        Sat Jan 07 10:23:00 2017 +0000
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.130 2017/01/05 17:49:54 adam Exp $
+$NetBSD: distinfo,v 1.131 2017/01/07 10:23:00 adam Exp $
 
-SHA1 (sqlite-autoconf-3160100.tar.gz) = 77f8c59fec1575c5e05462dccac956f141677647
-RMD160 (sqlite-autoconf-3160100.tar.gz) = d9e7f39f0818ac9bd83d45b6aa6ab969e4057f18
-SHA512 (sqlite-autoconf-3160100.tar.gz) = 4c6efa1e16ff7e0450de9971b833ee9678e47e932ed933c378fe293f9ff4b851bd5353a14cd61abd947d3138eb79d38142e536ad7240b704a67a994e377d242b
-Size (sqlite-autoconf-3160100.tar.gz) = 2507441 bytes
+SHA1 (sqlite-autoconf-3160200.tar.gz) = 64ca578ad44a94115b1db0406740e14288f74bb8
+RMD160 (sqlite-autoconf-3160200.tar.gz) = 86b351cfa4321a857fe6987694e188655226951f
+SHA512 (sqlite-autoconf-3160200.tar.gz) = 83bdd588504f265bbe93fb98a33a292aff5618c14f94d521c8557efbb5f777e82dfbb2d186cbfd4c628ee9522b1fcb73857e24ca2318fa34af3a3f9540e72b9a
+Size (sqlite-autoconf-3160200.tar.gz) = 2508179 bytes
diff -r 16c4fe5cce15 -r e583de7fc665 devel/lemon/distinfo
--- a/devel/lemon/distinfo      Sat Jan 07 06:37:56 2017 +0000
+++ b/devel/lemon/distinfo      Sat Jan 07 10:23:00 2017 +0000
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.6 2017/01/02 17:52:24 adam Exp $
+$NetBSD: distinfo,v 1.7 2017/01/07 10:23:00 adam Exp $
 
-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
+SHA1 (sqlite-src-3160200.zip) = fc216077093044e9161d9d27c68d0fba8ff19d3f
+RMD160 (sqlite-src-3160200.zip) = 0b704dbe2e26c3b6153ef2a8108d1b668fd419c0
+SHA512 (sqlite-src-3160200.zip) = db49551c09830cf4d8997f0a623deeed9f85db5f27e6ca9d8aa5812a23c1466bbcdf8bb56cf009511f72cafec8f09a305127123f54d90437b28770dac34a0897
+Size (sqlite-src-3160200.zip) = 10081950 bytes