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

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

details:   https://anonhg.NetBSD.org/pkgsrc/rev/08c20fcd2760
branches:  trunk
changeset: 432532:08c20fcd2760
user:      adam <adam%pkgsrc.org@localhost>
date:      Sat May 23 07:38:00 2020 +0000

description:
sqlite3: updated to 3.32.0

SQLite Release 3.32.0:

Added support for approximate ANALYZE using the PRAGMA analysis_limit command.
Added the bytecode virtual table.
Add the checksum VFS shim to the set of run-time loadable extensions included in the source tree.
Added the iif() SQL function.
INSERT and UPDATE statements now always apply column affinity before computing CHECK constraints. This bug fix could, in theory, cause problems for legacy databases with unorthodox CHECK constraints 
the require the input type for an INSERT is different from the declared column type. See ticket 86ba67afafded936 for more information.
Added the sqlite3_create_filename(), sqlite3_free_filename(), and sqlite3_database_file_object() interfaces to better support of VFS shim implementations.
Increase the default upper bound on the number of parameters from 999 to 32766.
Added code for the UINT collating sequence as an optional loadable extension.
Enhancements to the CLI:
Add options to the .import command: --csv, --ascii, --skip
The .dump command now accepts multiple LIKE-pattern arguments and outputs the union of all matching tables.
Add the .oom command in debugging builds
Add the --bom option to the .excel, .output, and .once commands.
Enhance the .filectrl command to support the --schema option.
The UINT collating sequence extension is automatically loaded
The ESCAPE clause of a LIKE operator now overrides wildcard characters, so that the behavior now matches what PostgreSQL does.

diffstat:

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

diffs (221 lines):

diff -r 8b97e6f9b5f9 -r 08c20fcd2760 databases/sqlite3-docs/PLIST
--- a/databases/sqlite3-docs/PLIST      Sat May 23 07:35:56 2020 +0000
+++ b/databases/sqlite3-docs/PLIST      Sat May 23 07:38:00 2020 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.90 2020/01/29 08:33:12 adam Exp $
+@comment $NetBSD: PLIST,v 1.91 2020/05/23 07:38:01 adam Exp $
 share/doc/sqlite3/34to35.html
 share/doc/sqlite3/35to36.html
 share/doc/sqlite3/about.html
@@ -15,6 +15,7 @@
 share/doc/sqlite3/backup.html
 share/doc/sqlite3/bindptr.html
 share/doc/sqlite3/books.html
+share/doc/sqlite3/bytecodevtab.html
 share/doc/sqlite3/c3ref/aggregate_context.html
 share/doc/sqlite3/c3ref/aggregate_count.html
 share/doc/sqlite3/c3ref/api_routines.html
@@ -88,10 +89,12 @@
 share/doc/sqlite3/c3ref/context.html
 share/doc/sqlite3/c3ref/context_db_handle.html
 share/doc/sqlite3/c3ref/create_collation.html
+share/doc/sqlite3/c3ref/create_filename.html
 share/doc/sqlite3/c3ref/create_function.html
 share/doc/sqlite3/c3ref/create_module.html
 share/doc/sqlite3/c3ref/data_count.html
 share/doc/sqlite3/c3ref/data_directory.html
+share/doc/sqlite3/c3ref/database_file_object.html
 share/doc/sqlite3/c3ref/db_cacheflush.html
 share/doc/sqlite3/c3ref/db_config.html
 share/doc/sqlite3/c3ref/db_filename.html
@@ -221,6 +224,7 @@
 share/doc/sqlite3/changes.html
 share/doc/sqlite3/chronology.html
 share/doc/sqlite3/cintro.html
+share/doc/sqlite3/cksumvfs.html
 share/doc/sqlite3/cli.html
 share/doc/sqlite3/codeofconduct.html
 share/doc/sqlite3/codeofethics.html
@@ -236,6 +240,7 @@
 share/doc/sqlite3/crew.html
 share/doc/sqlite3/csv.html
 share/doc/sqlite3/custombuild.html
+share/doc/sqlite3/cves.html
 share/doc/sqlite3/cvstrac.css
 share/doc/sqlite3/datatype3.html
 share/doc/sqlite3/datatypes.html
@@ -244,7 +249,6 @@
 share/doc/sqlite3/dbstat.html
 share/doc/sqlite3/debugging.html
 share/doc/sqlite3/deterministic.html
-share/doc/sqlite3/dev.html
 share/doc/sqlite3/different.html
 share/doc/sqlite3/doc_backlink_crossref.html
 share/doc/sqlite3/doc_keyword_crossref.html
@@ -274,6 +278,7 @@
 share/doc/sqlite3/geopoly.html
 share/doc/sqlite3/getthecode.html
 share/doc/sqlite3/hirely.html
+share/doc/sqlite3/howitworks.html
 share/doc/sqlite3/howtocompile.html
 share/doc/sqlite3/howtocorrupt.html
 share/doc/sqlite3/hp1.html
@@ -539,7 +544,6 @@
 share/doc/sqlite3/json1.html
 share/doc/sqlite3/keyword_index.html
 share/doc/sqlite3/lang.html
-share/doc/sqlite3/lang_UPSERT.html
 share/doc/sqlite3/lang_aggfunc.html
 share/doc/sqlite3/lang_altertable.html
 share/doc/sqlite3/lang_analyze.html
@@ -571,6 +575,7 @@
 share/doc/sqlite3/lang_select.html
 share/doc/sqlite3/lang_transaction.html
 share/doc/sqlite3/lang_update.html
+share/doc/sqlite3/lang_upsert.html
 share/doc/sqlite3/lang_vacuum.html
 share/doc/sqlite3/lang_with.html
 share/doc/sqlite3/lemon.html
@@ -586,6 +591,7 @@
 share/doc/sqlite3/mostdeployed.html
 share/doc/sqlite3/news.html
 share/doc/sqlite3/np1queryprob.html
+share/doc/sqlite3/nulinstr.html
 share/doc/sqlite3/nulls.html
 share/doc/sqlite3/oldnews.html
 share/doc/sqlite3/omitted.html
@@ -678,6 +684,7 @@
 share/doc/sqlite3/releaselog/3_30_1.html
 share/doc/sqlite3/releaselog/3_31_0.html
 share/doc/sqlite3/releaselog/3_31_1.html
+share/doc/sqlite3/releaselog/3_32_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
@@ -952,6 +959,7 @@
 share/doc/sqlite3/threadsafe.html
 share/doc/sqlite3/toc.db
 share/doc/sqlite3/transactional.html
+share/doc/sqlite3/uintcseq.html
 share/doc/sqlite3/undoredo.html
 share/doc/sqlite3/unionvtab.html
 share/doc/sqlite3/unlock_notify.html
diff -r 8b97e6f9b5f9 -r 08c20fcd2760 databases/sqlite3-docs/distinfo
--- a/databases/sqlite3-docs/distinfo   Sat May 23 07:35:56 2020 +0000
+++ b/databases/sqlite3-docs/distinfo   Sat May 23 07:38:00 2020 +0000
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.91 2020/01/29 08:33:12 adam Exp $
+$NetBSD: distinfo,v 1.92 2020/05/23 07:38:01 adam Exp $
 
-SHA1 (sqlite-doc-3310100.zip) = 3b6241f788e568b6ae5a20b3630e67729860b2eb
-RMD160 (sqlite-doc-3310100.zip) = b19c26d9de2777299a0ec56aa3410c848163e89f
-SHA512 (sqlite-doc-3310100.zip) = 5572e2c2dac30c014ef9cd60a620b7a7bb610f91a47e2890c0641540d39b9d5ce0e914ee697583130317633918b7827e2612a7cbc024f5bd6aa22ad28a78b56b
-Size (sqlite-doc-3310100.zip) = 9600405 bytes
+SHA1 (sqlite-doc-3320000.zip) = d5fd884ed6e43d8e5e8d84735e52384e630b772a
+RMD160 (sqlite-doc-3320000.zip) = c75b0bc3e07a0b13eacbeb2da041a699a7d8a471
+SHA512 (sqlite-doc-3320000.zip) = 8733bad1e8dda2967e7fadaf1a541bea338d3a14dcc0ab7fe25525e422ea8d61eb21b07648d29fe8b30ace2891ec3150800ec50f3eff121280b47db1439e915c
+Size (sqlite-doc-3320000.zip) = 9718952 bytes
diff -r 8b97e6f9b5f9 -r 08c20fcd2760 databases/sqlite3-tcl/Makefile
--- a/databases/sqlite3-tcl/Makefile    Sat May 23 07:35:56 2020 +0000
+++ b/databases/sqlite3-tcl/Makefile    Sat May 23 07:38:00 2020 +0000
@@ -1,6 +1,5 @@
-# $NetBSD: Makefile,v 1.100 2020/04/12 08:28:27 adam Exp $
+# $NetBSD: Makefile,v 1.101 2020/05/23 07:38:01 adam Exp $
 
-PKGREVISION= 1
 .include "../../databases/sqlite3/Makefile.common"
 
 DISTNAME=      sqlite-autoconf-${SQLITE3_DISTVERSION}
diff -r 8b97e6f9b5f9 -r 08c20fcd2760 databases/sqlite3-tcl/distinfo
--- a/databases/sqlite3-tcl/distinfo    Sat May 23 07:35:56 2020 +0000
+++ b/databases/sqlite3-tcl/distinfo    Sat May 23 07:38:00 2020 +0000
@@ -1,7 +1,7 @@
-$NetBSD: distinfo,v 1.103 2020/01/29 08:33:12 adam Exp $
+$NetBSD: distinfo,v 1.104 2020/05/23 07:38:01 adam Exp $
 
-SHA1 (sqlite-autoconf-3310100.tar.gz) = 0c30f5b22152a8166aa3bebb0f4bc1f3e9cc508b
-RMD160 (sqlite-autoconf-3310100.tar.gz) = da0b2c10c0a1132c91375a1d9b3a4e8909f9a1f3
-SHA512 (sqlite-autoconf-3310100.tar.gz) = d85250ba5f78f0c918880f663741709aba662192f04888b2324a0df17affdf5b8540e8428c6c7315119806e7adad758ea281c9b403c0ad94ac6a9bd1b93fd617
-Size (sqlite-autoconf-3310100.tar.gz) = 2887243 bytes
+SHA1 (sqlite-autoconf-3320000.tar.gz) = 3fe480c40c83a911ab4174625f14c434936d0b6c
+RMD160 (sqlite-autoconf-3320000.tar.gz) = 8ae701d8dc4ccd04b903edd85858d373d9adb155
+SHA512 (sqlite-autoconf-3320000.tar.gz) = bb0f73d63658c3e31daa7919ea621d1a8add8d430fe4385947555f0a334038750630eb1240f28d1709c69d45d12c1cc04ed081ecfe421c594ed29b6ac80b0a5f
+Size (sqlite-autoconf-3320000.tar.gz) = 2902505 bytes
 SHA1 (patch-Makefile.in) = 6cbbc33a5bc9c98b5aa128279f8e21e47406f537
diff -r 8b97e6f9b5f9 -r 08c20fcd2760 databases/sqlite3/Makefile
--- a/databases/sqlite3/Makefile        Sat May 23 07:35:56 2020 +0000
+++ b/databases/sqlite3/Makefile        Sat May 23 07:38:00 2020 +0000
@@ -1,6 +1,5 @@
-# $NetBSD: Makefile,v 1.133 2020/04/12 08:27:50 adam Exp $
+# $NetBSD: Makefile,v 1.134 2020/05/23 07:38:00 adam Exp $
 
-PKGREVISION= 1
 .include "Makefile.common"
 
 DISTNAME=      sqlite-autoconf-${SQLITE3_DISTVERSION}
diff -r 8b97e6f9b5f9 -r 08c20fcd2760 databases/sqlite3/Makefile.common
--- a/databases/sqlite3/Makefile.common Sat May 23 07:35:56 2020 +0000
+++ b/databases/sqlite3/Makefile.common Sat May 23 07:38:00 2020 +0000
@@ -1,12 +1,12 @@
-# $NetBSD: Makefile.common,v 1.67 2020/01/29 08:33:12 adam Exp $
+# $NetBSD: Makefile.common,v 1.68 2020/05/23 07:38:00 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=   3310100
-SQLITE3_VERSION=       3.31.1
+SQLITE3_DISTVERSION=   3320000
+SQLITE3_VERSION=       3.32.0
 
 MASTER_SITES=  http://www.sqlite.org/2020/
 MASTER_SITES+= http://www.hwaci.com/sw/sqlite/2020/
diff -r 8b97e6f9b5f9 -r 08c20fcd2760 databases/sqlite3/distinfo
--- a/databases/sqlite3/distinfo        Sat May 23 07:35:56 2020 +0000
+++ b/databases/sqlite3/distinfo        Sat May 23 07:38:00 2020 +0000
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.156 2020/01/29 08:33:12 adam Exp $
+$NetBSD: distinfo,v 1.157 2020/05/23 07:38:00 adam Exp $
 
-SHA1 (sqlite-autoconf-3310100.tar.gz) = 0c30f5b22152a8166aa3bebb0f4bc1f3e9cc508b
-RMD160 (sqlite-autoconf-3310100.tar.gz) = da0b2c10c0a1132c91375a1d9b3a4e8909f9a1f3
-SHA512 (sqlite-autoconf-3310100.tar.gz) = d85250ba5f78f0c918880f663741709aba662192f04888b2324a0df17affdf5b8540e8428c6c7315119806e7adad758ea281c9b403c0ad94ac6a9bd1b93fd617
-Size (sqlite-autoconf-3310100.tar.gz) = 2887243 bytes
+SHA1 (sqlite-autoconf-3320000.tar.gz) = 3fe480c40c83a911ab4174625f14c434936d0b6c
+RMD160 (sqlite-autoconf-3320000.tar.gz) = 8ae701d8dc4ccd04b903edd85858d373d9adb155
+SHA512 (sqlite-autoconf-3320000.tar.gz) = bb0f73d63658c3e31daa7919ea621d1a8add8d430fe4385947555f0a334038750630eb1240f28d1709c69d45d12c1cc04ed081ecfe421c594ed29b6ac80b0a5f
+Size (sqlite-autoconf-3320000.tar.gz) = 2902505 bytes
diff -r 8b97e6f9b5f9 -r 08c20fcd2760 devel/lemon/Makefile
--- a/devel/lemon/Makefile      Sat May 23 07:35:56 2020 +0000
+++ b/devel/lemon/Makefile      Sat May 23 07:38:00 2020 +0000
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile,v 1.8 2020/04/25 17:34:37 rillig Exp $
+# $NetBSD: Makefile,v 1.9 2020/05/23 07:38:01 adam Exp $
 
 .include "../../databases/sqlite3/Makefile.common"
 
@@ -12,7 +12,6 @@
 # - reflect reality and make it human readable without checking the sources
 
 PKGNAME=       lemon-${LEMON_VERSION}.${SQLITE3_VERSION}
-PKGREVISION=   1
 DISTNAME=      sqlite-src-${SQLITE3_DISTVERSION}
 CATEGORIES=    devel
 EXTRACT_SUFX=  .zip
diff -r 8b97e6f9b5f9 -r 08c20fcd2760 devel/lemon/distinfo
--- a/devel/lemon/distinfo      Sat May 23 07:35:56 2020 +0000
+++ b/devel/lemon/distinfo      Sat May 23 07:38:00 2020 +0000
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.32 2020/01/29 08:33:12 adam Exp $
+$NetBSD: distinfo,v 1.33 2020/05/23 07:38:01 adam Exp $
 
-SHA1 (sqlite-src-3310100.zip) = b75b19eede97a65d78eba627cb92c93c203f1e03
-RMD160 (sqlite-src-3310100.zip) = 7df3beae307ec6a0cc3ada50728db0b5e18c1325
-SHA512 (sqlite-src-3310100.zip) = af92a00877bcd90372d6f83a27fea12b4fe8d1155b223a6bccbccc31bb8e3d2269cd9e68f329bc55f70d1068ccbf220ff5abccea6f593fd7a3a4bdd732d1cdbe
-Size (sqlite-src-3310100.zip) = 12510166 bytes
+SHA1 (sqlite-src-3320000.zip) = 97e70225834db399796690c4cc876a5bf9aa883b
+RMD160 (sqlite-src-3320000.zip) = 95a06e058f5e7bff6effb16bb2bf0bc094efb292
+SHA512 (sqlite-src-3320000.zip) = ea915648bc7c364da9ad153c758e36b8cd4cc678958a5449824282844bc45963bd3602d30f731e4865f30c17a3249474127b911992cb13f46be35d646d288c29
+Size (sqlite-src-3320000.zip) = 12525021 bytes