CVS commit: pkgsrc

["Adam Ciarcinski" <adam%netbsd.org@localhost>]

Module Name:    pkgsrc
Committed By:   adam
Date:           Fri Jul 12 10:04:27 UTC 2019

Modified Files:
        pkgsrc/databases/sqlite3: Makefile.common distinfo
        pkgsrc/databases/sqlite3-docs: PLIST distinfo
        pkgsrc/databases/sqlite3-tcl: distinfo
        pkgsrc/devel/lemon: distinfo

Log Message:
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


To generate a diff of this commit:
cvs rdiff -u -r1.62 -r1.63 pkgsrc/databases/sqlite3/Makefile.common
cvs rdiff -u -r1.151 -r1.152 pkgsrc/databases/sqlite3/distinfo
cvs rdiff -u -r1.85 -r1.86 pkgsrc/databases/sqlite3-docs/PLIST
cvs rdiff -u -r1.86 -r1.87 pkgsrc/databases/sqlite3-docs/distinfo
cvs rdiff -u -r1.98 -r1.99 pkgsrc/databases/sqlite3-tcl/distinfo
cvs rdiff -u -r1.27 -r1.28 pkgsrc/devel/lemon/distinfo

Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.

Modified files:

Index: pkgsrc/databases/sqlite3/Makefile.common
diff -u pkgsrc/databases/sqlite3/Makefile.common:1.62 pkgsrc/databases/sqlite3/Makefile.common:1.63
--- pkgsrc/databases/sqlite3/Makefile.common:1.62       Thu Apr 18 10:10:03 2019
+++ pkgsrc/databases/sqlite3/Makefile.common    Fri Jul 12 10:04:26 2019
@@ -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/

Index: pkgsrc/databases/sqlite3/distinfo
diff -u pkgsrc/databases/sqlite3/distinfo:1.151 pkgsrc/databases/sqlite3/distinfo:1.152
--- pkgsrc/databases/sqlite3/distinfo:1.151     Thu Apr 18 10:10:03 2019
+++ pkgsrc/databases/sqlite3/distinfo   Fri Jul 12 10:04:26 2019
@@ -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

Index: pkgsrc/databases/sqlite3-docs/PLIST
diff -u pkgsrc/databases/sqlite3-docs/PLIST:1.85 pkgsrc/databases/sqlite3-docs/PLIST:1.86
--- pkgsrc/databases/sqlite3-docs/PLIST:1.85    Thu Apr 18 10:10:03 2019
+++ pkgsrc/databases/sqlite3-docs/PLIST Fri Jul 12 10:04:27 2019
@@ -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

Index: pkgsrc/databases/sqlite3-docs/distinfo
diff -u pkgsrc/databases/sqlite3-docs/distinfo:1.86 pkgsrc/databases/sqlite3-docs/distinfo:1.87
--- pkgsrc/databases/sqlite3-docs/distinfo:1.86 Thu Apr 18 10:10:03 2019
+++ pkgsrc/databases/sqlite3-docs/distinfo      Fri Jul 12 10:04:27 2019
@@ -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

Index: pkgsrc/databases/sqlite3-tcl/distinfo
diff -u pkgsrc/databases/sqlite3-tcl/distinfo:1.98 pkgsrc/databases/sqlite3-tcl/distinfo:1.99
--- pkgsrc/databases/sqlite3-tcl/distinfo:1.98  Thu Apr 18 10:10:03 2019
+++ pkgsrc/databases/sqlite3-tcl/distinfo       Fri Jul 12 10:04:27 2019
@@ -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

Index: pkgsrc/devel/lemon/distinfo
diff -u pkgsrc/devel/lemon/distinfo:1.27 pkgsrc/devel/lemon/distinfo:1.28
--- pkgsrc/devel/lemon/distinfo:1.27    Thu Apr 18 10:10:03 2019
+++ pkgsrc/devel/lemon/distinfo Fri Jul 12 10:04:27 2019
@@ -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