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.

6 files changed, 25 insertions, 24 deletions

diff --git a/databases/sqlite3-docs/PLIST b/databases/sqlite3-docs/PLIST
index 19f33afedaa..be6411b2174 100644
--- a/databases/sqlite3-docs/PLIST
+++ b/databases/sqlite3-docs/PLIST
@@ -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_1.html
 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 --git a/databases/sqlite3-docs/distinfo b/databases/sqlite3-docs/distinfo
index 85bb675448d..5055d713f58 100644
--- a/databases/sqlite3-docs/distinfo
+++ b/databases/sqlite3-docs/distinfo
@@ -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 --git a/databases/sqlite3-tcl/distinfo b/databases/sqlite3-tcl/distinfo
index 7bf6b5ba57f..be14e63e3c8 100644
--- a/databases/sqlite3-tcl/distinfo
+++ b/databases/sqlite3-tcl/distinfo
@@ -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 --git a/databases/sqlite3/Makefile.version b/databases/sqlite3/Makefile.version
index 2ad095c50b6..098b85021ac 100644
--- a/databases/sqlite3/Makefile.version
+++ b/databases/sqlite3/Makefile.version
@@ -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 --git a/databases/sqlite3/distinfo b/databases/sqlite3/distinfo
index 4005a64343e..5c831cbc917 100644
--- a/databases/sqlite3/distinfo
+++ b/databases/sqlite3/distinfo
@@ -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 --git a/devel/lemon/distinfo b/devel/lemon/distinfo
index 871a7e0af28..7268d1d05e0 100644
--- a/devel/lemon/distinfo
+++ b/devel/lemon/distinfo
@@ -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