CVS commit: pkgsrc

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

Module Name:    pkgsrc
Committed By:   adam
Date:           Sat Oct  5 08:03:56 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.30.0

SQLite Release 3.30.0

Add support for the FILTER clause on aggregate functions.
Add support for the NULLS FIRST and NULLS LAST syntax in ORDER BY clauses.
The index_info and index_xinfo pragmas are enhanced to provide information about the on-disk representation of WITHOUT ROWID tables.
Add the sqlite3_drop_modules() interface, allowing applications to disable automatically loaded virtual tables that they do not need.
Improvements to the .recover dot-command in the CLI so that it recovers more content from corrupt database files.
Enhance the RBU extension to support indexes on expressions.
Change the schema parser so that it will error out if any of the type, name, and tbl_name columns of the sqlite_master table have been corrupted and the database connection is not in writable_schema 
mode.
The PRAGMA function_list, PRAGMA module_list, and PRAGMA pragma_list commands are now enabled in all builds by default. Disable them using -DSQLITE_OMIT_INTROSPECTION_PRAGMAS.
Add the SQLITE_DBCONFIG_ENABLE_VIEW option for sqlite3_db_config().
Added the TCL Interface config method in order to be able to disable SQLITE_DBCONFIG_ENABLE_VIEW as well as control other sqlite3_db_config() options from TCL.
Added the SQLITE_DIRECTONLY flag for application-defined SQL functions to prevent those functions from being used inside triggers and views.
The legacy SQLITE_ENABLE_STAT3 compile-time option is now a no-op.


To generate a diff of this commit:
cvs rdiff -u -r1.63 -r1.64 pkgsrc/databases/sqlite3/Makefile.common
cvs rdiff -u -r1.152 -r1.153 pkgsrc/databases/sqlite3/distinfo
cvs rdiff -u -r1.86 -r1.87 pkgsrc/databases/sqlite3-docs/PLIST
cvs rdiff -u -r1.87 -r1.88 pkgsrc/databases/sqlite3-docs/distinfo
cvs rdiff -u -r1.99 -r1.100 pkgsrc/databases/sqlite3-tcl/distinfo
cvs rdiff -u -r1.28 -r1.29 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.63 pkgsrc/databases/sqlite3/Makefile.common:1.64
--- pkgsrc/databases/sqlite3/Makefile.common:1.63       Fri Jul 12 10:04:26 2019
+++ pkgsrc/databases/sqlite3/Makefile.common    Sat Oct  5 08:03:55 2019
@@ -1,12 +1,12 @@
-# $NetBSD: Makefile.common,v 1.63 2019/07/12 10:04:26 adam Exp $
+# $NetBSD: Makefile.common,v 1.64 2019/10/05 08:03:55 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=   3290000
-SQLITE3_VERSION=       3.29.0
+SQLITE3_DISTVERSION=   3300000
+SQLITE3_VERSION=       3.30.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.152 pkgsrc/databases/sqlite3/distinfo:1.153
--- pkgsrc/databases/sqlite3/distinfo:1.152     Fri Jul 12 10:04:26 2019
+++ pkgsrc/databases/sqlite3/distinfo   Sat Oct  5 08:03:55 2019
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.152 2019/07/12 10:04:26 adam Exp $
+$NetBSD: distinfo,v 1.153 2019/10/05 08:03:55 adam Exp $
 
-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 (sqlite-autoconf-3300000.tar.gz) = 785c0f6f00fe1871cb1dd97893267cb50db03b9b
+RMD160 (sqlite-autoconf-3300000.tar.gz) = a31b073fab598bda350d373adeca11c8778d886b
+SHA512 (sqlite-autoconf-3300000.tar.gz) = d1b0d4c6874e600f4e0f8c3eae8a5d754f8a25b3ab68b058ea657641acbae7e4f517d075dd103a87544ccf62a706990e3db909de18cf649ac5a1a459d123926a
+Size (sqlite-autoconf-3300000.tar.gz) = 2848866 bytes

Index: pkgsrc/databases/sqlite3-docs/PLIST
diff -u pkgsrc/databases/sqlite3-docs/PLIST:1.86 pkgsrc/databases/sqlite3-docs/PLIST:1.87
--- pkgsrc/databases/sqlite3-docs/PLIST:1.86    Fri Jul 12 10:04:27 2019
+++ pkgsrc/databases/sqlite3-docs/PLIST Sat Oct  5 08:03:55 2019
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.86 2019/07/12 10:04:27 adam Exp $
+@comment $NetBSD: PLIST,v 1.87 2019/10/05 08:03:55 adam Exp $
 share/doc/sqlite3/34to35.html
 share/doc/sqlite3/35to36.html
 share/doc/sqlite3/about.html
@@ -101,6 +101,7 @@ share/doc/sqlite3/c3ref/db_release_memor
 share/doc/sqlite3/c3ref/db_status.html
 share/doc/sqlite3/c3ref/declare_vtab.html
 share/doc/sqlite3/c3ref/deserialize.html
+share/doc/sqlite3/c3ref/drop_modules.html
 share/doc/sqlite3/c3ref/enable_load_extension.html
 share/doc/sqlite3/c3ref/enable_shared_cache.html
 share/doc/sqlite3/c3ref/errcode.html
@@ -454,6 +455,7 @@ share/doc/sqlite3/images/sqlitepie.jpg
 share/doc/sqlite3/images/src_logo.gif
 share/doc/sqlite3/images/sw.gif
 share/doc/sqlite3/images/sw.png
+share/doc/sqlite3/images/syntax/aggregate-function-invocation.gif
 share/doc/sqlite3/images/syntax/alter-table-stmt.gif
 share/doc/sqlite3/images/syntax/analyze-stmt.gif
 share/doc/sqlite3/images/syntax/attach-stmt.gif
@@ -482,6 +484,7 @@ share/doc/sqlite3/images/syntax/drop-tri
 share/doc/sqlite3/images/syntax/drop-view-stmt.gif
 share/doc/sqlite3/images/syntax/expr.gif
 share/doc/sqlite3/images/syntax/factored-select-stmt.gif
+share/doc/sqlite3/images/syntax/filter-clause.gif
 share/doc/sqlite3/images/syntax/filter.gif
 share/doc/sqlite3/images/syntax/foreign-key-clause.gif
 share/doc/sqlite3/images/syntax/frame-spec.gif
@@ -494,6 +497,7 @@ share/doc/sqlite3/images/syntax/join-ope
 share/doc/sqlite3/images/syntax/literal-value.gif
 share/doc/sqlite3/images/syntax/numeric-literal.gif
 share/doc/sqlite3/images/syntax/ordering-term.gif
+share/doc/sqlite3/images/syntax/over-clause.gif
 share/doc/sqlite3/images/syntax/pragma-stmt.gif
 share/doc/sqlite3/images/syntax/pragma-value.gif
 share/doc/sqlite3/images/syntax/qualified-table-name.gif
@@ -507,6 +511,7 @@ share/doc/sqlite3/images/syntax/savepoin
 share/doc/sqlite3/images/syntax/select-core.gif
 share/doc/sqlite3/images/syntax/select-stmt.gif
 share/doc/sqlite3/images/syntax/signed-number.gif
+share/doc/sqlite3/images/syntax/simple-function-invocation.gif
 share/doc/sqlite3/images/syntax/simple-select-stmt.gif
 share/doc/sqlite3/images/syntax/sql-stmt-list.gif
 share/doc/sqlite3/images/syntax/sql-stmt.gif
@@ -666,6 +671,7 @@ share/doc/sqlite3/releaselog/3_2_5.html
 share/doc/sqlite3/releaselog/3_2_6.html
 share/doc/sqlite3/releaselog/3_2_7.html
 share/doc/sqlite3/releaselog/3_2_8.html
+share/doc/sqlite3/releaselog/3_30_0.html
 share/doc/sqlite3/releaselog/3_3_0.html
 share/doc/sqlite3/releaselog/3_3_1.html
 share/doc/sqlite3/releaselog/3_3_10.html
@@ -864,6 +870,7 @@ share/doc/sqlite3/stmt.html
 share/doc/sqlite3/support.html
 share/doc/sqlite3/swarmvtab.html
 share/doc/sqlite3/syntax.html
+share/doc/sqlite3/syntax/aggregate-function-invocation.html
 share/doc/sqlite3/syntax/alter-table-stmt.html
 share/doc/sqlite3/syntax/analyze-stmt.html
 share/doc/sqlite3/syntax/attach-stmt.html
@@ -892,10 +899,9 @@ share/doc/sqlite3/syntax/drop-trigger-st
 share/doc/sqlite3/syntax/drop-view-stmt.html
 share/doc/sqlite3/syntax/expr.html
 share/doc/sqlite3/syntax/factored-select-stmt.html
-share/doc/sqlite3/syntax/filter.html
+share/doc/sqlite3/syntax/filter-clause.html
 share/doc/sqlite3/syntax/foreign-key-clause.html
 share/doc/sqlite3/syntax/frame-spec.html
-share/doc/sqlite3/syntax/function-invocation.html
 share/doc/sqlite3/syntax/indexed-column.html
 share/doc/sqlite3/syntax/insert-stmt.html
 share/doc/sqlite3/syntax/join-clause.html
@@ -904,6 +910,7 @@ share/doc/sqlite3/syntax/join-operator.h
 share/doc/sqlite3/syntax/literal-value.html
 share/doc/sqlite3/syntax/numeric-literal.html
 share/doc/sqlite3/syntax/ordering-term.html
+share/doc/sqlite3/syntax/over-clause.html
 share/doc/sqlite3/syntax/pragma-stmt.html
 share/doc/sqlite3/syntax/pragma-value.html
 share/doc/sqlite3/syntax/qualified-table-name.html
@@ -917,6 +924,7 @@ share/doc/sqlite3/syntax/savepoint-stmt.
 share/doc/sqlite3/syntax/select-core.html
 share/doc/sqlite3/syntax/select-stmt.html
 share/doc/sqlite3/syntax/signed-number.html
+share/doc/sqlite3/syntax/simple-function-invocation.html
 share/doc/sqlite3/syntax/simple-select-stmt.html
 share/doc/sqlite3/syntax/sql-stmt-list.html
 share/doc/sqlite3/syntax/sql-stmt.html

Index: pkgsrc/databases/sqlite3-docs/distinfo
diff -u pkgsrc/databases/sqlite3-docs/distinfo:1.87 pkgsrc/databases/sqlite3-docs/distinfo:1.88
--- pkgsrc/databases/sqlite3-docs/distinfo:1.87 Fri Jul 12 10:04:27 2019
+++ pkgsrc/databases/sqlite3-docs/distinfo      Sat Oct  5 08:03:55 2019
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.87 2019/07/12 10:04:27 adam Exp $
+$NetBSD: distinfo,v 1.88 2019/10/05 08:03:55 adam Exp $
 
-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
+SHA1 (sqlite-doc-3300000.zip) = 828cf2af20ef4b216620bdc7c86ac1073a7400bf
+RMD160 (sqlite-doc-3300000.zip) = 7d5249619263f83d0c5c9982c5041c8205aa9c88
+SHA512 (sqlite-doc-3300000.zip) = 11bc9910fa0b4740b19bb6c533a329f29520f68951e6e24c9957cd2ac3dc6708640d6e535a8be5af173eb0b273ab3bdee6f81724d5b5560054fccddf7d454f78
+Size (sqlite-doc-3300000.zip) = 9484386 bytes

Index: pkgsrc/databases/sqlite3-tcl/distinfo
diff -u pkgsrc/databases/sqlite3-tcl/distinfo:1.99 pkgsrc/databases/sqlite3-tcl/distinfo:1.100
--- pkgsrc/databases/sqlite3-tcl/distinfo:1.99  Fri Jul 12 10:04:27 2019
+++ pkgsrc/databases/sqlite3-tcl/distinfo       Sat Oct  5 08:03:55 2019
@@ -1,7 +1,7 @@
-$NetBSD: distinfo,v 1.99 2019/07/12 10:04:27 adam Exp $
+$NetBSD: distinfo,v 1.100 2019/10/05 08:03:55 adam Exp $
 
-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 (sqlite-autoconf-3300000.tar.gz) = 785c0f6f00fe1871cb1dd97893267cb50db03b9b
+RMD160 (sqlite-autoconf-3300000.tar.gz) = a31b073fab598bda350d373adeca11c8778d886b
+SHA512 (sqlite-autoconf-3300000.tar.gz) = d1b0d4c6874e600f4e0f8c3eae8a5d754f8a25b3ab68b058ea657641acbae7e4f517d075dd103a87544ccf62a706990e3db909de18cf649ac5a1a459d123926a
+Size (sqlite-autoconf-3300000.tar.gz) = 2848866 bytes
 SHA1 (patch-Makefile.in) = 6cbbc33a5bc9c98b5aa128279f8e21e47406f537

Index: pkgsrc/devel/lemon/distinfo
diff -u pkgsrc/devel/lemon/distinfo:1.28 pkgsrc/devel/lemon/distinfo:1.29
--- pkgsrc/devel/lemon/distinfo:1.28    Fri Jul 12 10:04:27 2019
+++ pkgsrc/devel/lemon/distinfo Sat Oct  5 08:03:56 2019
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.28 2019/07/12 10:04:27 adam Exp $
+$NetBSD: distinfo,v 1.29 2019/10/05 08:03:56 adam Exp $
 
-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
+SHA1 (sqlite-src-3300000.zip) = e07542078e2252d620a65152aa33fb0c6fa6f8a9
+RMD160 (sqlite-src-3300000.zip) = 065e8ff6b0d91f0afcbe8a6560d39ab363341797
+SHA512 (sqlite-src-3300000.zip) = 43dbe38eae0b14ecba962e418a7a717ef5a0b7aa8610a973daea3f538564fea9440c0053dccabbf1f6652ced180bf44de1a122609564fe357f0f8c7a34078dd7
+Size (sqlite-src-3300000.zip) = 12647593 bytes