CVS commit: pkgsrc

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

Module Name:    pkgsrc
Committed By:   adam
Date:           Sat May 23 07:38:01 UTC 2020

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

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


To generate a diff of this commit:
cvs rdiff -u -r1.133 -r1.134 pkgsrc/databases/sqlite3/Makefile
cvs rdiff -u -r1.67 -r1.68 pkgsrc/databases/sqlite3/Makefile.common
cvs rdiff -u -r1.156 -r1.157 pkgsrc/databases/sqlite3/distinfo
cvs rdiff -u -r1.90 -r1.91 pkgsrc/databases/sqlite3-docs/PLIST
cvs rdiff -u -r1.91 -r1.92 pkgsrc/databases/sqlite3-docs/distinfo
cvs rdiff -u -r1.100 -r1.101 pkgsrc/databases/sqlite3-tcl/Makefile
cvs rdiff -u -r1.103 -r1.104 pkgsrc/databases/sqlite3-tcl/distinfo
cvs rdiff -u -r1.8 -r1.9 pkgsrc/devel/lemon/Makefile
cvs rdiff -u -r1.32 -r1.33 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
diff -u pkgsrc/databases/sqlite3/Makefile:1.133 pkgsrc/databases/sqlite3/Makefile:1.134
--- pkgsrc/databases/sqlite3/Makefile:1.133     Sun Apr 12 08:27:50 2020
+++ pkgsrc/databases/sqlite3/Makefile   Sat May 23 07:38:00 2020
@@ -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}

Index: pkgsrc/databases/sqlite3/Makefile.common
diff -u pkgsrc/databases/sqlite3/Makefile.common:1.67 pkgsrc/databases/sqlite3/Makefile.common:1.68
--- pkgsrc/databases/sqlite3/Makefile.common:1.67       Wed Jan 29 08:33:12 2020
+++ pkgsrc/databases/sqlite3/Makefile.common    Sat May 23 07:38:00 2020
@@ -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/

Index: pkgsrc/databases/sqlite3/distinfo
diff -u pkgsrc/databases/sqlite3/distinfo:1.156 pkgsrc/databases/sqlite3/distinfo:1.157
--- pkgsrc/databases/sqlite3/distinfo:1.156     Wed Jan 29 08:33:12 2020
+++ pkgsrc/databases/sqlite3/distinfo   Sat May 23 07:38:00 2020
@@ -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

Index: pkgsrc/databases/sqlite3-docs/PLIST
diff -u pkgsrc/databases/sqlite3-docs/PLIST:1.90 pkgsrc/databases/sqlite3-docs/PLIST:1.91
--- pkgsrc/databases/sqlite3-docs/PLIST:1.90    Wed Jan 29 08:33:12 2020
+++ pkgsrc/databases/sqlite3-docs/PLIST Sat May 23 07:38:01 2020
@@ -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/autoinc.html
 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/constlist.html
 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/carray.html
 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/cpu.html
 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/dbpage.html
 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/gencol.html
 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/isolation.html
 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_savepoint.html
 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/mmap.html
 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_0.html
 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/th3.html
 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

Index: pkgsrc/databases/sqlite3-docs/distinfo
diff -u pkgsrc/databases/sqlite3-docs/distinfo:1.91 pkgsrc/databases/sqlite3-docs/distinfo:1.92
--- pkgsrc/databases/sqlite3-docs/distinfo:1.91 Wed Jan 29 08:33:12 2020
+++ pkgsrc/databases/sqlite3-docs/distinfo      Sat May 23 07:38:01 2020
@@ -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

Index: pkgsrc/databases/sqlite3-tcl/Makefile
diff -u pkgsrc/databases/sqlite3-tcl/Makefile:1.100 pkgsrc/databases/sqlite3-tcl/Makefile:1.101
--- pkgsrc/databases/sqlite3-tcl/Makefile:1.100 Sun Apr 12 08:28:27 2020
+++ pkgsrc/databases/sqlite3-tcl/Makefile       Sat May 23 07:38:01 2020
@@ -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}

Index: pkgsrc/databases/sqlite3-tcl/distinfo
diff -u pkgsrc/databases/sqlite3-tcl/distinfo:1.103 pkgsrc/databases/sqlite3-tcl/distinfo:1.104
--- pkgsrc/databases/sqlite3-tcl/distinfo:1.103 Wed Jan 29 08:33:12 2020
+++ pkgsrc/databases/sqlite3-tcl/distinfo       Sat May 23 07:38:01 2020
@@ -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

Index: pkgsrc/devel/lemon/Makefile
diff -u pkgsrc/devel/lemon/Makefile:1.8 pkgsrc/devel/lemon/Makefile:1.9
--- pkgsrc/devel/lemon/Makefile:1.8     Sat Apr 25 17:34:37 2020
+++ pkgsrc/devel/lemon/Makefile Sat May 23 07:38:01 2020
@@ -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 @@ LEMON_VERSION=        1.0
 # - 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

Index: pkgsrc/devel/lemon/distinfo
diff -u pkgsrc/devel/lemon/distinfo:1.32 pkgsrc/devel/lemon/distinfo:1.33
--- pkgsrc/devel/lemon/distinfo:1.32    Wed Jan 29 08:33:12 2020
+++ pkgsrc/devel/lemon/distinfo Sat May 23 07:38:01 2020
@@ -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