sqlite3: updated to 3.29.0

SQLite Release 3.29.0:
Added the SQLITE_DBCONFIG_DQS_DML and SQLITE_DBCONFIG_DQS_DDL actions to sqlite3_db_config() for activating and deactivating the double-quoted string literal misfeature. Both default to "on" for legacy compatibility, but developers are encouraged to turn them "off", perhaps using the -DSQLITE_DQS=0 compile-time option.
-DSQLITE_DQS=0 is now a recommended compile-time option.

Improvements to the query planner:
Improved optimization of AND and OR operators when one or the other operand is a constant.
Enhancements to the LIKE optimization for cases when the left-hand side column has numeric affinity.
Added the "sqlite_dbdata" virtual table for extracting raw low-level content from an SQLite database, even a database that is corrupt.

Enhancements to the CLI:
Add the ".recover" command which tries to recover as much content as possible from a corrupt database file.
Add the ".filectrl" command useful for testing.
Add the long-standing ".testctrl" command to the ".help" menu.
Added the ".dbconfig" command

6 files changed, 25 insertions, 24 deletions

diff --git a/databases/sqlite3-docs/PLIST b/databases/sqlite3-docs/PLIST
index f1e1e6aa667..a2680e4dfd8 100644
--- a/databases/sqlite3-docs/PLIST
+++ b/databases/sqlite3-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.85 2019/04/18 10:10:03 adam Exp $
+@comment $NetBSD: PLIST,v 1.86 2019/07/12 10:04:27 adam Exp $
 share/doc/sqlite3/34to35.html
 share/doc/sqlite3/35to36.html
 share/doc/sqlite3/about.html
@@ -656,6 +656,7 @@ share/doc/sqlite3/releaselog/3_27_0.html
 share/doc/sqlite3/releaselog/3_27_1.html
 share/doc/sqlite3/releaselog/3_27_2.html
 share/doc/sqlite3/releaselog/3_28_0.html
+share/doc/sqlite3/releaselog/3_29_0.html
 share/doc/sqlite3/releaselog/3_2_0.html
 share/doc/sqlite3/releaselog/3_2_1.html
 share/doc/sqlite3/releaselog/3_2_2.html
diff --git a/databases/sqlite3-docs/distinfo b/databases/sqlite3-docs/distinfo
index b71d91c3238..bec7e188d36 100644
--- a/databases/sqlite3-docs/distinfo
+++ b/databases/sqlite3-docs/distinfo
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.86 2019/04/18 10:10:03 adam Exp $
+$NetBSD: distinfo,v 1.87 2019/07/12 10:04:27 adam Exp $
 
-SHA1 (sqlite-doc-3280000.zip) = f3242cf186a4e194e7d1a5e00384dd4aa66ec16b
-RMD160 (sqlite-doc-3280000.zip) = b495c4795641f9583b5b061ba7351274197689db
-SHA512 (sqlite-doc-3280000.zip) = 83e23dff00614d31d501c66c29d8d4aa780b38859242b58937243235d185fe3db2f9f3c1accf9bf2df0b457a6e32612a00e82f503a8665aad4f19602e2b36396
-Size (sqlite-doc-3280000.zip) = 9421770 bytes
+SHA1 (sqlite-doc-3290000.zip) = b0f697c557b415cb1d67acb61b40fbad0b012cad
+RMD160 (sqlite-doc-3290000.zip) = fd65542f02ef60217f1857202786114c439e2435
+SHA512 (sqlite-doc-3290000.zip) = ca856cf250e395d9c7e9817337adb5a16b1d96a20548a4010f5137188d35bb9d49a4a6da47bf2a696deffa68d2976dbb35a036adce19b8320e0e286876ac094f
+Size (sqlite-doc-3290000.zip) = 9415641 bytes
diff --git a/databases/sqlite3-tcl/distinfo b/databases/sqlite3-tcl/distinfo
index 4b3c99f548a..8f4f3c33756 100644
--- a/databases/sqlite3-tcl/distinfo
+++ b/databases/sqlite3-tcl/distinfo
@@ -1,7 +1,7 @@
-$NetBSD: distinfo,v 1.98 2019/04/18 10:10:03 adam Exp $
+$NetBSD: distinfo,v 1.99 2019/07/12 10:04:27 adam Exp $
 
-SHA1 (sqlite-autoconf-3280000.tar.gz) = 01b9d8fc77085e144dddc87456c9783e53d09a53
-RMD160 (sqlite-autoconf-3280000.tar.gz) = b4e13e4b6ae0678a3813e6c07c4df6596d2e6683
-SHA512 (sqlite-autoconf-3280000.tar.gz) = e800c0d9e6c8c01ccf1d714c6c4da4b98e9610c4c06557dda6393d0792a8ae09788703d4a74dcb21844c49b3629ff7ed95a4a86ff79872aafd2b49c672c7a570
-Size (sqlite-autoconf-3280000.tar.gz) = 2810415 bytes
+SHA1 (sqlite-autoconf-3290000.tar.gz) = 053d8237eb9741b0e297073810668c2611a8e38e
+RMD160 (sqlite-autoconf-3290000.tar.gz) = 2c976f4ee1a71c6600f829e04cd8be1712ff2420
+SHA512 (sqlite-autoconf-3290000.tar.gz) = 85dcaa72cc2476c628e801d4ce46cf10ed8997f56cb0334062df5553f18c29d607883a1049bf75258204f2f53a29a02a01f014dcca383b05dfac1e2123778024
+Size (sqlite-autoconf-3290000.tar.gz) = 2833613 bytes
 SHA1 (patch-Makefile.in) = 6cbbc33a5bc9c98b5aa128279f8e21e47406f537
diff --git a/databases/sqlite3/Makefile.common b/databases/sqlite3/Makefile.common
index 6cfeb5b5f74..4a290979880 100644
--- a/databases/sqlite3/Makefile.common
+++ b/databases/sqlite3/Makefile.common
@@ -1,12 +1,12 @@
-# $NetBSD: Makefile.common,v 1.62 2019/04/18 10:10:03 adam Exp $
+# $NetBSD: Makefile.common,v 1.63 2019/07/12 10:04:26 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=	3280000
-SQLITE3_VERSION=	3.28.0
+SQLITE3_DISTVERSION=	3290000
+SQLITE3_VERSION=	3.29.0
 
 MASTER_SITES=	http://www.sqlite.org/2019/
 MASTER_SITES+=	http://www.hwaci.com/sw/sqlite/2019/
diff --git a/databases/sqlite3/distinfo b/databases/sqlite3/distinfo
index 5367d727abf..d28fc09c1dd 100644
--- a/databases/sqlite3/distinfo
+++ b/databases/sqlite3/distinfo
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.151 2019/04/18 10:10:03 adam Exp $
+$NetBSD: distinfo,v 1.152 2019/07/12 10:04:26 adam Exp $
 
-SHA1 (sqlite-autoconf-3280000.tar.gz) = 01b9d8fc77085e144dddc87456c9783e53d09a53
-RMD160 (sqlite-autoconf-3280000.tar.gz) = b4e13e4b6ae0678a3813e6c07c4df6596d2e6683
-SHA512 (sqlite-autoconf-3280000.tar.gz) = e800c0d9e6c8c01ccf1d714c6c4da4b98e9610c4c06557dda6393d0792a8ae09788703d4a74dcb21844c49b3629ff7ed95a4a86ff79872aafd2b49c672c7a570
-Size (sqlite-autoconf-3280000.tar.gz) = 2810415 bytes
+SHA1 (sqlite-autoconf-3290000.tar.gz) = 053d8237eb9741b0e297073810668c2611a8e38e
+RMD160 (sqlite-autoconf-3290000.tar.gz) = 2c976f4ee1a71c6600f829e04cd8be1712ff2420
+SHA512 (sqlite-autoconf-3290000.tar.gz) = 85dcaa72cc2476c628e801d4ce46cf10ed8997f56cb0334062df5553f18c29d607883a1049bf75258204f2f53a29a02a01f014dcca383b05dfac1e2123778024
+Size (sqlite-autoconf-3290000.tar.gz) = 2833613 bytes
diff --git a/devel/lemon/distinfo b/devel/lemon/distinfo
index 085968f1020..4cb7b5b6add 100644
--- a/devel/lemon/distinfo
+++ b/devel/lemon/distinfo
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.27 2019/04/18 10:10:03 adam Exp $
+$NetBSD: distinfo,v 1.28 2019/07/12 10:04:27 adam Exp $
 
-SHA1 (sqlite-src-3280000.zip) = 21c391f177ac39750e5a8ac61d07550bf6befb4a
-RMD160 (sqlite-src-3280000.zip) = 73241e9eb7a3938453e822e4af7ac71099c12f27
-SHA512 (sqlite-src-3280000.zip) = 49c35c65fa686a2326e13218db583c54fa5fe8f48f0caddd11a942601803b3023f7d32ffbab16641e0d72dc9ed288ad26eaa7226c865ac54e1f181859125651f
-Size (sqlite-src-3280000.zip) = 12477204 bytes
+SHA1 (sqlite-src-3290000.zip) = e8862aa46fb70e25c8006a1fe519067a1fa9e618
+RMD160 (sqlite-src-3290000.zip) = bff9c9e661f232f07196f94907e6102084d880d3
+SHA512 (sqlite-src-3290000.zip) = 575398fbe20c6471ee2abcbde170b8d48efbb3cb2716a65f42f05c52429a45d14e8046e50c59bbf75bfe2d8f151c34abd50b440c50af571f19e19f3290b230df
+Size (sqlite-src-3290000.zip) = 12557725 bytes