[pkgsrc/trunk]: pkgsrc sqlite3: updated to 3.29.0

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

details:   https://anonhg.NetBSD.org/pkgsrc/rev/73afcc7a2402
branches:  trunk
changeset: 336333:73afcc7a2402
user:      adam <adam%pkgsrc.org@localhost>
date:      Fri Jul 12 10:04:26 2019 +0000

description:
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

diffstat:

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

diffs (97 lines):

diff -r 42ef7be8c155 -r 73afcc7a2402 databases/sqlite3-docs/PLIST
--- a/databases/sqlite3-docs/PLIST      Fri Jul 12 09:33:39 2019 +0000
+++ b/databases/sqlite3-docs/PLIST      Fri Jul 12 10:04:26 2019 +0000
@@ -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_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 -r 42ef7be8c155 -r 73afcc7a2402 databases/sqlite3-docs/distinfo
--- a/databases/sqlite3-docs/distinfo   Fri Jul 12 09:33:39 2019 +0000
+++ b/databases/sqlite3-docs/distinfo   Fri Jul 12 10:04:26 2019 +0000
@@ -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 -r 42ef7be8c155 -r 73afcc7a2402 databases/sqlite3-tcl/distinfo
--- a/databases/sqlite3-tcl/distinfo    Fri Jul 12 09:33:39 2019 +0000
+++ b/databases/sqlite3-tcl/distinfo    Fri Jul 12 10:04:26 2019 +0000
@@ -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 -r 42ef7be8c155 -r 73afcc7a2402 databases/sqlite3/Makefile.common
--- a/databases/sqlite3/Makefile.common Fri Jul 12 09:33:39 2019 +0000
+++ b/databases/sqlite3/Makefile.common Fri Jul 12 10:04:26 2019 +0000
@@ -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 -r 42ef7be8c155 -r 73afcc7a2402 databases/sqlite3/distinfo
--- a/databases/sqlite3/distinfo        Fri Jul 12 09:33:39 2019 +0000
+++ b/databases/sqlite3/distinfo        Fri Jul 12 10:04:26 2019 +0000
@@ -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 -r 42ef7be8c155 -r 73afcc7a2402 devel/lemon/distinfo
--- a/devel/lemon/distinfo      Fri Jul 12 09:33:39 2019 +0000
+++ b/devel/lemon/distinfo      Fri Jul 12 10:04:26 2019 +0000
@@ -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