Changes 3.12.2:

Fix a backwards compatibility problem in version 3.12.0 and 3.12.1: Columns declared as "INTEGER" PRIMARY KEY (with quotes around the datatype keyword) where not being recognized as an INTEGER PRIMARY KEY, which resulted in an incompatible database file.
Fix a bug (present since version 3.9.0) that can cause the DELETE operation to miss rows if PRAGMA reverse_unordered_selects is turned on.
Fix a bug in the code generator that can causes incorrect results if two or more virtual tables are joined and the virtual table used in outer loop of the join has an IN operator constraint.
Correctly interpret negative "PRAGMA cache_size" values when determining the cache size used for sorting large amounts of data.

7 files changed, 22 insertions, 23 deletions

diff --git a/databases/sqlite3-docs/PLIST b/databases/sqlite3-docs/PLIST
index d5015760fea..89cb1d3fe30 100644
--- a/databases/sqlite3-docs/PLIST
+++ b/databases/sqlite3-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.54 2016/04/09 09:25:39 adam Exp $
+@comment $NetBSD: PLIST,v 1.55 2016/04/20 05:04:44 adam Exp $
 share/doc/sqlite3/34to35.html
 share/doc/sqlite3/35to36.html
 share/doc/sqlite3/about.html
@@ -546,6 +546,7 @@ share/doc/sqlite3/releaselog/3_11_0.html
 share/doc/sqlite3/releaselog/3_11_1.html
 share/doc/sqlite3/releaselog/3_12_0.html
 share/doc/sqlite3/releaselog/3_12_1.html
+share/doc/sqlite3/releaselog/3_12_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 c06a4c2e8bf..4f18379f529 100644
--- a/databases/sqlite3-docs/distinfo
+++ b/databases/sqlite3-docs/distinfo
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.55 2016/04/09 09:25:39 adam Exp $
+$NetBSD: distinfo,v 1.56 2016/04/20 05:04:44 adam Exp $
 
-SHA1 (sqlite-doc-3120100.zip) = 5adad476e52a031bfb1cbc9c1426a5fb77e453a3
-RMD160 (sqlite-doc-3120100.zip) = 49fea2965d7233abef41f3b3c87b009e47680d90
-SHA512 (sqlite-doc-3120100.zip) = d0117618d97744255248b9160816203147ba2afdb0bea5fe02d5e464541e09bc9147189317c6f849cc56059d6ae96e3e4b2a30cd8d0bc7b0e1ecacb573cfcdd4
-Size (sqlite-doc-3120100.zip) = 5410493 bytes
+SHA1 (sqlite-doc-3120200.zip) = e49eb277915d1f886a9ee4687a23ec67dc5fe3cb
+RMD160 (sqlite-doc-3120200.zip) = c3689f9f140a8a5b28dbefdf0a385dfc1f673877
+SHA512 (sqlite-doc-3120200.zip) = 4ded937565b2d9b63ae55495d4b536bc0056e0d9aa7119ee54ddea127c42ba7de17986db7b85c172043fab1112132cbc126a102b248770fca6cde9a8fda438ae
+Size (sqlite-doc-3120200.zip) = 5416790 bytes
diff --git a/databases/sqlite3-tcl/Makefile b/databases/sqlite3-tcl/Makefile
index 0c3ed4e7ab4..d8402236e9b 100644
--- a/databases/sqlite3-tcl/Makefile
+++ b/databases/sqlite3-tcl/Makefile
@@ -1,8 +1,7 @@
-# $NetBSD: Makefile,v 1.80 2016/04/11 19:01:46 ryoon Exp $
+# $NetBSD: Makefile,v 1.81 2016/04/20 05:04:44 adam Exp $
 
 DISTNAME=	sqlite-autoconf-${SQLITE3_DISTVERSION}
 PKGNAME=	sqlite3-tcl-${SQLITE3_VERSION}
-PKGREVISION=	1
 CATEGORIES=	databases
 
 MAINTAINER=	pkgsrc-users@NetBSD.org
diff --git a/databases/sqlite3-tcl/distinfo b/databases/sqlite3-tcl/distinfo
index 9793a9b7d20..2856fa4a580 100644
--- a/databases/sqlite3-tcl/distinfo
+++ b/databases/sqlite3-tcl/distinfo
@@ -1,7 +1,7 @@
-$NetBSD: distinfo,v 1.68 2016/04/09 09:25:39 adam Exp $
+$NetBSD: distinfo,v 1.69 2016/04/20 05:04:44 adam Exp $
 
-SHA1 (sqlite-autoconf-3120100.tar.gz) = fa1f3dbf6e2e8c6d14125b2eceda5b2e16a19f1f
-RMD160 (sqlite-autoconf-3120100.tar.gz) = 3853c603a8fc712dd9e53dd9191487e02ff9607b
-SHA512 (sqlite-autoconf-3120100.tar.gz) = eb0b892bb6a1783df9b712d5f78c9f5fb5aa8ff1b1735fd2806e96b1c04e2a5f87b2e47469185195611a5cf6c446ec32935e9ae0b01734383a8fefc1bcaf5842
-Size (sqlite-autoconf-3120100.tar.gz) = 2374576 bytes
+SHA1 (sqlite-autoconf-3120200.tar.gz) = b43c2e7238e54c50b95fbbd85c48792f4f39af8c
+RMD160 (sqlite-autoconf-3120200.tar.gz) = 95906cd70cbf190f82820dd0b5cad57caffa0f6f
+SHA512 (sqlite-autoconf-3120200.tar.gz) = e56b8d5b8fb41d27437659db669259198663c266c0b3faf44ba9b130441550fb79bd040e6488f56280b33230d9cf4e51c7906f968ffdd36206354bfabc4b6eb4
+Size (sqlite-autoconf-3120200.tar.gz) = 2374804 bytes
 SHA1 (patch-aa) = 4a12a16498d04e1031dc0802fda731b73e98a32d
diff --git a/databases/sqlite3/Makefile b/databases/sqlite3/Makefile
index 631b469b72c..f70b6632d26 100644
--- a/databases/sqlite3/Makefile
+++ b/databases/sqlite3/Makefile
@@ -1,8 +1,7 @@
-# $NetBSD: Makefile,v 1.107 2016/04/11 19:01:34 ryoon Exp $
+# $NetBSD: Makefile,v 1.108 2016/04/20 05:04:44 adam Exp $
 
 DISTNAME=	sqlite-autoconf-${SQLITE3_DISTVERSION}
 PKGNAME=	sqlite3-${SQLITE3_VERSION}
-PKGREVISION=	1
 CATEGORIES=	databases
 
 MAINTAINER=	pkgsrc-users@NetBSD.org
diff --git a/databases/sqlite3/Makefile.version b/databases/sqlite3/Makefile.version
index e8f9abd9092..c40bb8f97a5 100644
--- a/databases/sqlite3/Makefile.version
+++ b/databases/sqlite3/Makefile.version
@@ -1,10 +1,10 @@
-# $NetBSD: Makefile.version,v 1.16 2016/04/09 09:25:39 adam Exp $
+# $NetBSD: Makefile.version,v 1.17 2016/04/20 05:04:44 adam Exp $
 # used by databases/sqlite3/Makefile
 # used by databases/sqlite3-docs/Makefile
 # used by databases/sqlite3-tcl/Makefile
 
-SQLITE3_DISTVERSION=	3120100
-SQLITE3_VERSION=	3.12.1
+SQLITE3_DISTVERSION=	3120200
+SQLITE3_VERSION=	3.12.2
 
 MASTER_SITES=	http://www.hwaci.com/sw/sqlite/2016/ \
 		http://www.sqlite.org/2016/
diff --git a/databases/sqlite3/distinfo b/databases/sqlite3/distinfo
index cc5454bf2a8..b0c8c49db72 100644
--- a/databases/sqlite3/distinfo
+++ b/databases/sqlite3/distinfo
@@ -1,7 +1,7 @@
-$NetBSD: distinfo,v 1.120 2016/04/09 09:25:39 adam Exp $
+$NetBSD: distinfo,v 1.121 2016/04/20 05:04:44 adam Exp $
 
-SHA1 (sqlite-autoconf-3120100.tar.gz) = fa1f3dbf6e2e8c6d14125b2eceda5b2e16a19f1f
-RMD160 (sqlite-autoconf-3120100.tar.gz) = 3853c603a8fc712dd9e53dd9191487e02ff9607b
-SHA512 (sqlite-autoconf-3120100.tar.gz) = eb0b892bb6a1783df9b712d5f78c9f5fb5aa8ff1b1735fd2806e96b1c04e2a5f87b2e47469185195611a5cf6c446ec32935e9ae0b01734383a8fefc1bcaf5842
-Size (sqlite-autoconf-3120100.tar.gz) = 2374576 bytes
+SHA1 (sqlite-autoconf-3120200.tar.gz) = b43c2e7238e54c50b95fbbd85c48792f4f39af8c
+RMD160 (sqlite-autoconf-3120200.tar.gz) = 95906cd70cbf190f82820dd0b5cad57caffa0f6f
+SHA512 (sqlite-autoconf-3120200.tar.gz) = e56b8d5b8fb41d27437659db669259198663c266c0b3faf44ba9b130441550fb79bd040e6488f56280b33230d9cf4e51c7906f968ffdd36206354bfabc4b6eb4
+Size (sqlite-autoconf-3120200.tar.gz) = 2374804 bytes
 SHA1 (patch-configure) = 833f6b824f03b3f12f51617fa2fc7b9d4a580b35