sqlite3: updated to 3.40.0

SQLite Release 3.40.0

Add support for compiling SQLite to WASM and running it in web browsers. NB: The WASM build and its interfaces are considered "beta" and are subject to minor changes if the need arises. We anticipate finalizing the interface for the next release.
Add the recovery extension that might be able to recover some content from a corrupt database file.
Query planner enhancements:
Recognize covering indexes on tables with more than 63 columns where columns beyond the 63rd column are used in the query and/or are referenced by the index.
Extract the values of expressions contained within expression indexes where practical, rather than recomputing the expression.
The NOT NULL and IS NULL operators (and their equivalents) avoid loading the content of large strings and BLOB values from disk.
Avoid materializing a view on which a full scan is performed exactly once. Use and discard the rows of the view as they are computed.
Allow flattening of a subquery that is the right-hand operand of a LEFT JOIN in an aggregate query.
A new typedef named sqlite3_filename is added and used to represent the name of a database file. Various interfaces are modified to use the new typedef instead of "char*". This interface change should be fully backwards compatible, though it might cause (harmless) compiler warnings when rebuilding some legacy applications.
Add the sqlite3_value_encoding() interface.
Security enhancement: SQLITE_DBCONFIG_DEFENSIVE is augmented to prohibit changing the schema_version. The schema_version becomes read-only in defensive mode.
Enhancements to the PRAGMA integrity_check statement:
Columns in non-STRICT tables with TEXT affinity should not contain numeric values.
Columns in non-STRICT tables with NUMERIC affinity should not contain TEXT values that could be converted into numbers.
Verify that the rows of a WITHOUT ROWID table are in the correct order.
Enhance the VACUUM INTO statement so that it honors they PRAGMA synchronous setting.
Enhance the sqlite3_strglob() and sqlite3_strlike() APIs so that they are able to accept NULL pointers for their string parameters and still generate a sensible result.
Provide the new SQLITE_MAX_ALLOCATION_SIZE compile-time option for limiting the size of memory allocations.
Change the algorithm used by SQLite's built-in pseudo-random number generator (PRNG) from RC4 to Chacha20.
Allow two or more indexes to have the same name as long as they are all in separate schemas.
Miscellaneous performance optimizations result in about 1% fewer CPU cycles used on typical workloads.

7 files changed, 30 insertions, 25 deletions

diff --git a/databases/sqlite3-docs/PLIST b/databases/sqlite3-docs/PLIST
index 0575d7f1a14..e23506ac507 100644
--- a/databases/sqlite3-docs/PLIST
+++ b/databases/sqlite3-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.118 2022/10/03 12:27:52 adam Exp $
+@comment $NetBSD: PLIST,v 1.119 2022/11/17 06:20:44 adam Exp $
 share/doc/sqlite3/34to35.html
 share/doc/sqlite3/35to36.html
 share/doc/sqlite3/about.html
@@ -118,6 +118,7 @@ share/doc/sqlite3/c3ref/experimental.html
 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.html
 share/doc/sqlite3/c3ref/filename_database.html
 share/doc/sqlite3/c3ref/finalize.html
 share/doc/sqlite3/c3ref/free.html
@@ -468,6 +469,7 @@ share/doc/sqlite3/images/sqlite370.jpg
 share/doc/sqlite3/images/sqlite370_banner.gif
 share/doc/sqlite3/images/sqlitepie.jpg
 share/doc/sqlite3/images/src_logo.gif
+share/doc/sqlite3/images/sschart20221116.jpg
 share/doc/sqlite3/images/sw.gif
 share/doc/sqlite3/images/sw.png
 share/doc/sqlite3/images/table-ex1b2.gif
@@ -551,6 +553,7 @@ share/doc/sqlite3/queryplanner.html
 share/doc/sqlite3/quickstart.html
 share/doc/sqlite3/quirks.html
 share/doc/sqlite3/rbu.html
+share/doc/sqlite3/recovery.html
 share/doc/sqlite3/releaselog/3_0_0.html
 share/doc/sqlite3/releaselog/3_0_1.html
 share/doc/sqlite3/releaselog/3_0_2.html
@@ -669,6 +672,7 @@ share/doc/sqlite3/releaselog/3_3_6.html
 share/doc/sqlite3/releaselog/3_3_7.html
 share/doc/sqlite3/releaselog/3_3_8.html
 share/doc/sqlite3/releaselog/3_3_9.html
+share/doc/sqlite3/releaselog/3_40_0.html
 share/doc/sqlite3/releaselog/3_4_0.html
 share/doc/sqlite3/releaselog/3_4_1.html
 share/doc/sqlite3/releaselog/3_4_2.html
@@ -846,6 +850,7 @@ share/doc/sqlite3/sqlanalyze.html
 share/doc/sqlite3/sqlar.html
 share/doc/sqlite3/sqldiff.html
 share/doc/sqlite3/sqlite.css
+share/doc/sqlite3/sqlite.css~
 share/doc/sqlite3/sqlite.html
 share/doc/sqlite3/stmt.html
 share/doc/sqlite3/stricttables.html
diff --git a/databases/sqlite3-docs/distinfo b/databases/sqlite3-docs/distinfo
index 85275983396..c7a91fe46d5 100644
--- a/databases/sqlite3-docs/distinfo
+++ b/databases/sqlite3-docs/distinfo
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.121 2022/10/03 12:27:52 adam Exp $
+$NetBSD: distinfo,v 1.122 2022/11/17 06:20:44 adam Exp $
 
-BLAKE2s (sqlite-doc-3390400.zip) = ee8d991decabf8089b0dd80157930f33a9d38c8526c97da6faa17c1033a9939e
-SHA512 (sqlite-doc-3390400.zip) = 75d97b0f2f0d530b2e0ad505574af3bf657d82f0859bb5de7ee45c40a80351e933944845cedca56b579925a3d07505c6f4721f756f27862ffafdfc2caff539fb
-Size (sqlite-doc-3390400.zip) = 10853153 bytes
+BLAKE2s (sqlite-doc-3400000.zip) = 335f41408e24dc66874aeaf55bf6c7f5594b8afc0938c061c34a9f9f73d10d85
+SHA512 (sqlite-doc-3400000.zip) = 3557fe49e08fd24890da584f3fa7fb93d1e3317787f98a8ce1062dcac07733782026e50dfef7db72582739ddf0a77095cc4d3a81f3df097a69e85c672591bf7e
+Size (sqlite-doc-3400000.zip) = 10921883 bytes
diff --git a/databases/sqlite3-tcl/distinfo b/databases/sqlite3-tcl/distinfo
index 808b3420c79..9d05147502b 100644
--- a/databases/sqlite3-tcl/distinfo
+++ b/databases/sqlite3-tcl/distinfo
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.133 2022/10/03 12:27:52 adam Exp $
+$NetBSD: distinfo,v 1.134 2022/11/17 06:20:44 adam Exp $
 
-BLAKE2s (sqlite-autoconf-3390400.tar.gz) = efef4f594d97c8a4bd724c16f7ae7c9f295eb0a52193146753cb08392e5d5b97
-SHA512 (sqlite-autoconf-3390400.tar.gz) = cc1de214e69ef677cac3f6dd2000ccfcf4b672ab464a115d96f24707009a408630e762c3cda89741b728ab34c4d9f5b8f8b12e9b11448e8364642b4421c3393d
-Size (sqlite-autoconf-3390400.tar.gz) = 3065214 bytes
-SHA1 (patch-Makefile.in) = 6cbbc33a5bc9c98b5aa128279f8e21e47406f537
+BLAKE2s (sqlite-autoconf-3400000.tar.gz) = 378945cc6da267e3c5652afe62731904acc6d4a2154c0b2fb08355a5cbdced00
+SHA512 (sqlite-autoconf-3400000.tar.gz) = 175271e620dd947df2ca63c3ea6cff80e16f8f808a3ea7f6700282768adc2d61ac375d42b2064c73eec849c67307ac5291fdadc3059861caa015ac3ac7a480e4
+Size (sqlite-autoconf-3400000.tar.gz) = 3097756 bytes
+SHA1 (patch-Makefile.in) = 8f68039c9169bc69eb0da4bd0f910c7584aed2b5
diff --git a/databases/sqlite3-tcl/patches/patch-Makefile.in b/databases/sqlite3-tcl/patches/patch-Makefile.in
index 9f1008a72d0..85ae0ff0870 100644
--- a/databases/sqlite3-tcl/patches/patch-Makefile.in
+++ b/databases/sqlite3-tcl/patches/patch-Makefile.in
@@ -1,10 +1,10 @@
-$NetBSD: patch-Makefile.in,v 1.1 2017/06/10 19:14:00 adam Exp $
+$NetBSD: patch-Makefile.in,v 1.2 2022/11/17 06:20:44 adam Exp $
 
 Install into correct directory.
 
---- Makefile.in.orig	2014-03-10 13:47:51.000000000 +0000
+--- Makefile.in.orig	2022-11-16 13:42:39.000000000 +0000
 +++ Makefile.in
-@@ -81,7 +81,7 @@ DESTDIR		=
+@@ -83,7 +83,7 @@ DESTDIR		=
  
  PKG_DIR		= $(PACKAGE_NAME)$(PACKAGE_VERSION)
  pkgdatadir	= $(datadir)/$(PKG_DIR)
@@ -12,4 +12,4 @@ Install into correct directory.
 +pkglibdir	= $(libdir)/sqlite3
  pkgincludedir	= $(includedir)/$(PKG_DIR)
  
- top_builddir	= .
+ top_builddir	= @abs_top_builddir@
diff --git a/databases/sqlite3/Makefile.common b/databases/sqlite3/Makefile.common
index 9aa4bc179df..d719deb2bbe 100644
--- a/databases/sqlite3/Makefile.common
+++ b/databases/sqlite3/Makefile.common
@@ -1,12 +1,12 @@
-# $NetBSD: Makefile.common,v 1.95 2022/10/03 12:27:52 adam Exp $
+# $NetBSD: Makefile.common,v 1.96 2022/11/17 06:20:44 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=	3390400
-SQLITE3_VERSION=	3.39.4
+SQLITE3_DISTVERSION=	3400000
+SQLITE3_VERSION=	3.40.0
 
 MASTER_SITES=	http://www.sqlite.org/2022/
 MASTER_SITES+=	http://www.hwaci.com/sw/sqlite/2022/
diff --git a/databases/sqlite3/distinfo b/databases/sqlite3/distinfo
index c72037e696f..72075ac1d32 100644
--- a/databases/sqlite3/distinfo
+++ b/databases/sqlite3/distinfo
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.188 2022/10/03 12:27:52 adam Exp $
+$NetBSD: distinfo,v 1.189 2022/11/17 06:20:44 adam Exp $
 
-BLAKE2s (sqlite-autoconf-3390400.tar.gz) = efef4f594d97c8a4bd724c16f7ae7c9f295eb0a52193146753cb08392e5d5b97
-SHA512 (sqlite-autoconf-3390400.tar.gz) = cc1de214e69ef677cac3f6dd2000ccfcf4b672ab464a115d96f24707009a408630e762c3cda89741b728ab34c4d9f5b8f8b12e9b11448e8364642b4421c3393d
-Size (sqlite-autoconf-3390400.tar.gz) = 3065214 bytes
+BLAKE2s (sqlite-autoconf-3400000.tar.gz) = 378945cc6da267e3c5652afe62731904acc6d4a2154c0b2fb08355a5cbdced00
+SHA512 (sqlite-autoconf-3400000.tar.gz) = 175271e620dd947df2ca63c3ea6cff80e16f8f808a3ea7f6700282768adc2d61ac375d42b2064c73eec849c67307ac5291fdadc3059861caa015ac3ac7a480e4
+Size (sqlite-autoconf-3400000.tar.gz) = 3097756 bytes
 SHA1 (patch-configure) = c0aa83bddc20d090b3cd2fd840ac69031f4396e4
diff --git a/devel/lemon/distinfo b/devel/lemon/distinfo
index 50f8768a73e..1c7e3785546 100644
--- a/devel/lemon/distinfo
+++ b/devel/lemon/distinfo
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.62 2022/10/03 12:27:52 adam Exp $
+$NetBSD: distinfo,v 1.63 2022/11/17 06:20:44 adam Exp $
 
-BLAKE2s (sqlite-src-3390400.zip) = 58782c11d2e04d06f8ed91c5ae61bf2099cb9f812373f761c8cf697c5f584063
-SHA512 (sqlite-src-3390400.zip) = 0acb8afc87f911c91ec555cc97af5b77b6b0e80cc8672711ddd87c651d9e11b697c9669ff9ba2b58da12b972bb46acdf8b8fe35993950f10735b4036501b73bb
-Size (sqlite-src-3390400.zip) = 13405169 bytes
+BLAKE2s (sqlite-src-3400000.zip) = 6fcf2d0a0046143a892cef16c3c5d4986aa93febebbf4fcae207e9069a94a038
+SHA512 (sqlite-src-3400000.zip) = c3bb3829f99c663f3381f4c610e401173f133fe944558b70da7521cc44116d048e4e1651993feb128b0f3814381aa4fa93f48ba3e277abca3442af805159287d
+Size (sqlite-src-3400000.zip) = 13723231 bytes