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

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

details:   https://anonhg.NetBSD.org/pkgsrc/rev/7b558fd46a03
branches:  trunk
changeset: 410087:7b558fd46a03
user:      adam <adam%pkgsrc.org@localhost>
date:      Sun Jan 26 09:05:19 2020 +0000

description:
sqlite3: updated to 3.31.0

SQLite Release 3.31.0:

Add support for generated columns.
Add the sqlite3_hard_heap_limit64() interface and the corresponding PRAGMA hard_heap_limit command.
Enhance the function_list pragma to show the number of arguments on each function, the type of function (scalar, aggregate, window), and the function property flags SQLITE_DETERMINISTIC, 
SQLITE_DIRECTONLY, SQLITE_INNOCUOUS, and/or SQLITE_SUBTYPE.
Add the aggregated mode feature to the DBSTAT virtual table.
Add the SQLITE_OPEN_NOFOLLOW option to sqlite3_open_v2() that prevents SQLite from opening symbolic links.
Added the "#-N" array notation for JSON function path arguments.
Added the SQLITE_DBCONFIG_TRUSTED_SCHEMA connection setting which is also controllable via the new trusted_schema pragma and at compile-time using the -DSQLITE_TRUSTED_SCHEMA compile-time option.
Added APIs sqlite3_filename_database(), sqlite3_filename_journal(), and sqlite3_filename_wal() which are useful for specialized extensions.
Add the sqlite3_uri_key() interface.
Upgraded the sqlite3_uri_parameter() function so that it works with the rollback journal or WAL filename in addition to the database filename.
Provide the ability to tag application-defined SQL functions with new properties SQLITE_INNOCUOUS or SQLITE_DIRECTONLY.
Add new verbs to sqlite3_vtab_config() so that the xConnect method of virtual tables can declare the virtual table as SQLITE_VTAB_INNOCUOUS or SQLITE_VTAB_DIRECTONLY.
Faster response to sqlite3_interrupt().
Added the uuid.c extension module implementing functions for processing RFC-4122 UUIDs.
The lookaside memory allocator is enhanced to support two separate memory pools with different sized allocations in each pool. This allows more memory allocations to be covered by lookaside while at 
the same time reducing the heap memory usage to 48KB per connection, down from 120KB.
The legacy_file_format pragma is deactivated. It is now a no-op. In its place, the SQLITE_DBCONFIG_LEGACY_FILE_FORMAT option to sqlite3_db_config() is provided. The legacy_file_format pragma is 
deactivated because (1) it is rarely useful and (2) it is incompatible with VACUUM in schemas that have tables with both generated columns and descending indexes.

diffstat:

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

diffs (141 lines):

diff -r c770927c6ad3 -r 7b558fd46a03 databases/sqlite3-docs/PLIST
--- a/databases/sqlite3-docs/PLIST      Sun Jan 26 07:27:40 2020 +0000
+++ b/databases/sqlite3-docs/PLIST      Sun Jan 26 09:05:19 2020 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.88 2019/10/11 15:37:09 adam Exp $
+@comment $NetBSD: PLIST,v 1.89 2020/01/26 09:05:19 adam Exp $
 share/doc/sqlite3/34to35.html
 share/doc/sqlite3/35to36.html
 share/doc/sqlite3/about.html
@@ -6,6 +6,7 @@
 share/doc/sqlite3/affcase1.html
 share/doc/sqlite3/amalgamation.html
 share/doc/sqlite3/appfileformat.html
+share/doc/sqlite3/appfunc.html
 share/doc/sqlite3/arch.html
 share/doc/sqlite3/assert.html
 share/doc/sqlite3/asyncvfs.html
@@ -111,12 +112,14 @@
 share/doc/sqlite3/c3ref/extended_result_codes.html
 share/doc/sqlite3/c3ref/file.html
 share/doc/sqlite3/c3ref/file_control.html
+share/doc/sqlite3/c3ref/filename_database.html
 share/doc/sqlite3/c3ref/finalize.html
 share/doc/sqlite3/c3ref/free.html
 share/doc/sqlite3/c3ref/free_table.html
 share/doc/sqlite3/c3ref/funclist.html
 share/doc/sqlite3/c3ref/get_autocommit.html
 share/doc/sqlite3/c3ref/get_auxdata.html
+share/doc/sqlite3/c3ref/hard_heap_limit64.html
 share/doc/sqlite3/c3ref/index_info.html
 share/doc/sqlite3/c3ref/initialize.html
 share/doc/sqlite3/c3ref/int64.html
@@ -165,7 +168,6 @@
 share/doc/sqlite3/c3ref/snapshot_open.html
 share/doc/sqlite3/c3ref/snapshot_recover.html
 share/doc/sqlite3/c3ref/soft_heap_limit.html
-share/doc/sqlite3/c3ref/soft_heap_limit64.html
 share/doc/sqlite3/c3ref/sqlite3.html
 share/doc/sqlite3/c3ref/status.html
 share/doc/sqlite3/c3ref/step.html
@@ -268,6 +270,7 @@
 share/doc/sqlite3/fts3.html
 share/doc/sqlite3/fts5.html
 share/doc/sqlite3/fullsql.html
+share/doc/sqlite3/gencol.html
 share/doc/sqlite3/geopoly.html
 share/doc/sqlite3/getthecode.html
 share/doc/sqlite3/hirely.html
@@ -673,6 +676,7 @@
 share/doc/sqlite3/releaselog/3_2_8.html
 share/doc/sqlite3/releaselog/3_30_0.html
 share/doc/sqlite3/releaselog/3_30_1.html
+share/doc/sqlite3/releaselog/3_31_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
diff -r c770927c6ad3 -r 7b558fd46a03 databases/sqlite3-docs/distinfo
--- a/databases/sqlite3-docs/distinfo   Sun Jan 26 07:27:40 2020 +0000
+++ b/databases/sqlite3-docs/distinfo   Sun Jan 26 09:05:19 2020 +0000
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.89 2019/10/11 15:37:09 adam Exp $
+$NetBSD: distinfo,v 1.90 2020/01/26 09:05:19 adam Exp $
 
-SHA1 (sqlite-doc-3300100.zip) = 35b89685c2164a3d18ceeb23ab57f0e207894dad
-RMD160 (sqlite-doc-3300100.zip) = 6f6da3d3222789c566ee94c3a769f8549559f876
-SHA512 (sqlite-doc-3300100.zip) = 373e843015307071443a0db5fb930f9120718f6118cc2e21b506fdc8535fbe6996e9889e8b5809ffb91257addfe778bdf3412a81e11f6bced2c5e0330337d00d
-Size (sqlite-doc-3300100.zip) = 9485342 bytes
+SHA1 (sqlite-doc-3310000.zip) = 58a43ae9a9f7442b0e6031c887c57935d5c4bd90
+RMD160 (sqlite-doc-3310000.zip) = 1f29e4ddb3e9a5eca6bcf7188deb41f1b0611890
+SHA512 (sqlite-doc-3310000.zip) = 33e0aa57556181ca35dd0bedcd70e7d3dd1d63956444a04a8c73233158e5cbd9c63dd12e86bd0ae510621193a3ca397a289ae5556a39a1400cac4ec471422f9f
+Size (sqlite-doc-3310000.zip) = 9586441 bytes
diff -r c770927c6ad3 -r 7b558fd46a03 databases/sqlite3-tcl/distinfo
--- a/databases/sqlite3-tcl/distinfo    Sun Jan 26 07:27:40 2020 +0000
+++ b/databases/sqlite3-tcl/distinfo    Sun Jan 26 09:05:19 2020 +0000
@@ -1,7 +1,7 @@
-$NetBSD: distinfo,v 1.101 2019/10/11 15:37:09 adam Exp $
+$NetBSD: distinfo,v 1.102 2020/01/26 09:05:19 adam Exp $
 
-SHA1 (sqlite-autoconf-3300100.tar.gz) = 8383f29d53fa1d4383e4c8eb3e087f2ed940a9e0
-RMD160 (sqlite-autoconf-3300100.tar.gz) = 6c0f21a67051264ff26ba6c36619ee864dde58fc
-SHA512 (sqlite-autoconf-3300100.tar.gz) = 9ec0283c417fb0323b0e43550af2a49e9a63988e4212c27ea62cc9da3534caa6faf5bdc7e051b6772c4ce61560a433b3d3288b68e05e9ba8495f61a3bcebda3e
-Size (sqlite-autoconf-3300100.tar.gz) = 2848951 bytes
+SHA1 (sqlite-autoconf-3310000.tar.gz) = 8488afaa1cb452a1ac7ee4db1505eaef60341ab2
+RMD160 (sqlite-autoconf-3310000.tar.gz) = db0e430f78c9a6eec7c14aeb54197b62b1131a58
+SHA512 (sqlite-autoconf-3310000.tar.gz) = cfb618d4eedd8da19d106cbea473f3f7a332f2d794d0c089968573a83f8c2e38474f28b3ae2bda6567c4ac22aac29431154bef315192a16788cd065d35273ee3
+Size (sqlite-autoconf-3310000.tar.gz) = 2887038 bytes
 SHA1 (patch-Makefile.in) = 6cbbc33a5bc9c98b5aa128279f8e21e47406f537
diff -r c770927c6ad3 -r 7b558fd46a03 databases/sqlite3/Makefile.common
--- a/databases/sqlite3/Makefile.common Sun Jan 26 07:27:40 2020 +0000
+++ b/databases/sqlite3/Makefile.common Sun Jan 26 09:05:19 2020 +0000
@@ -1,15 +1,15 @@
-# $NetBSD: Makefile.common,v 1.65 2019/10/11 15:37:09 adam Exp $
+# $NetBSD: Makefile.common,v 1.66 2020/01/26 09:05:19 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=   3300100
-SQLITE3_VERSION=       3.30.1
+SQLITE3_DISTVERSION=   3310000
+SQLITE3_VERSION=       3.31.0
 
-MASTER_SITES=  http://www.sqlite.org/2019/
-MASTER_SITES+= http://www.hwaci.com/sw/sqlite/2019/
+MASTER_SITES=  http://www.sqlite.org/2020/
+MASTER_SITES+= http://www.hwaci.com/sw/sqlite/2020/
 
 HOMEPAGE?=     http://www.sqlite.org/
 LICENSE=       public-domain
diff -r c770927c6ad3 -r 7b558fd46a03 databases/sqlite3/distinfo
--- a/databases/sqlite3/distinfo        Sun Jan 26 07:27:40 2020 +0000
+++ b/databases/sqlite3/distinfo        Sun Jan 26 09:05:19 2020 +0000
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.154 2019/10/11 15:37:09 adam Exp $
+$NetBSD: distinfo,v 1.155 2020/01/26 09:05:19 adam Exp $
 
-SHA1 (sqlite-autoconf-3300100.tar.gz) = 8383f29d53fa1d4383e4c8eb3e087f2ed940a9e0
-RMD160 (sqlite-autoconf-3300100.tar.gz) = 6c0f21a67051264ff26ba6c36619ee864dde58fc
-SHA512 (sqlite-autoconf-3300100.tar.gz) = 9ec0283c417fb0323b0e43550af2a49e9a63988e4212c27ea62cc9da3534caa6faf5bdc7e051b6772c4ce61560a433b3d3288b68e05e9ba8495f61a3bcebda3e
-Size (sqlite-autoconf-3300100.tar.gz) = 2848951 bytes
+SHA1 (sqlite-autoconf-3310000.tar.gz) = 8488afaa1cb452a1ac7ee4db1505eaef60341ab2
+RMD160 (sqlite-autoconf-3310000.tar.gz) = db0e430f78c9a6eec7c14aeb54197b62b1131a58
+SHA512 (sqlite-autoconf-3310000.tar.gz) = cfb618d4eedd8da19d106cbea473f3f7a332f2d794d0c089968573a83f8c2e38474f28b3ae2bda6567c4ac22aac29431154bef315192a16788cd065d35273ee3
+Size (sqlite-autoconf-3310000.tar.gz) = 2887038 bytes
diff -r c770927c6ad3 -r 7b558fd46a03 devel/lemon/distinfo
--- a/devel/lemon/distinfo      Sun Jan 26 07:27:40 2020 +0000
+++ b/devel/lemon/distinfo      Sun Jan 26 09:05:19 2020 +0000
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.30 2019/10/11 15:37:10 adam Exp $
+$NetBSD: distinfo,v 1.31 2020/01/26 09:05:19 adam Exp $
 
-SHA1 (sqlite-src-3300100.zip) = 3dec734206fab0cdceb421021964ff7e3fedf3b0
-RMD160 (sqlite-src-3300100.zip) = 911a567cc17df55e37c23fa91545bffb699bcf08
-SHA512 (sqlite-src-3300100.zip) = f40236d0bb25f3ea01a1192dace3b6732fb671fbdabb7cfa8d0cc2b99d21aef00ae380999fdee904501cb03304644cddfb2506951f36a2f6a83693f311c3c11d
-Size (sqlite-src-3300100.zip) = 12648162 bytes
+SHA1 (sqlite-src-3310000.zip) = 3860e314e87acb425ccaa280aeacd1ebec12a37a
+RMD160 (sqlite-src-3310000.zip) = fdc8e17edcbe51ffdf2a0dbe14bf9c26125e1708
+SHA512 (sqlite-src-3310000.zip) = 3c0f24857dbe41fb3fb36178c0858d44683a09f0096895cf02f6f0f678ce80b6c0f45d5a6c75ce466eeac5cd50b7e766c68e83cf28838164d08c74fc1743992a
+Size (sqlite-src-3310000.zip) = 12510000 bytes