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

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

details:   https://anonhg.NetBSD.org/pkgsrc/rev/f64c84f6b1e1
branches:  trunk
changeset: 388329:f64c84f6b1e1
user:      adam <adam%pkgsrc.org@localhost>
date:      Thu Nov 17 06:20:44 2022 +0000

description:
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.

diffstat:

 databases/sqlite3-docs/PLIST                    |   7 ++++++-
 databases/sqlite3-docs/distinfo                 |   8 ++++----
 databases/sqlite3-tcl/distinfo                  |  10 +++++-----
 databases/sqlite3-tcl/patches/patch-Makefile.in |   8 ++++----
 databases/sqlite3/Makefile.common               |   6 +++---
 databases/sqlite3/distinfo                      |   8 ++++----
 devel/lemon/distinfo                            |   8 ++++----
 7 files changed, 30 insertions(+), 25 deletions(-)

diffs (146 lines):

diff -r 7b34e35cdbbf -r f64c84f6b1e1 databases/sqlite3-docs/PLIST
--- a/databases/sqlite3-docs/PLIST      Thu Nov 17 05:59:19 2022 +0000
+++ b/databases/sqlite3-docs/PLIST      Thu Nov 17 06:20:44 2022 +0000
@@ -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/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_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/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_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/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 -r 7b34e35cdbbf -r f64c84f6b1e1 databases/sqlite3-docs/distinfo
--- a/databases/sqlite3-docs/distinfo   Thu Nov 17 05:59:19 2022 +0000
+++ b/databases/sqlite3-docs/distinfo   Thu Nov 17 06:20:44 2022 +0000
@@ -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 -r 7b34e35cdbbf -r f64c84f6b1e1 databases/sqlite3-tcl/distinfo
--- a/databases/sqlite3-tcl/distinfo    Thu Nov 17 05:59:19 2022 +0000
+++ b/databases/sqlite3-tcl/distinfo    Thu Nov 17 06:20:44 2022 +0000
@@ -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 -r 7b34e35cdbbf -r f64c84f6b1e1 databases/sqlite3-tcl/patches/patch-Makefile.in
--- a/databases/sqlite3-tcl/patches/patch-Makefile.in   Thu Nov 17 05:59:19 2022 +0000
+++ b/databases/sqlite3-tcl/patches/patch-Makefile.in   Thu Nov 17 06:20:44 2022 +0000
@@ -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 @@
 +pkglibdir     = $(libdir)/sqlite3
  pkgincludedir = $(includedir)/$(PKG_DIR)
  
- top_builddir  = .
+ top_builddir  = @abs_top_builddir@
diff -r 7b34e35cdbbf -r f64c84f6b1e1 databases/sqlite3/Makefile.common
--- a/databases/sqlite3/Makefile.common Thu Nov 17 05:59:19 2022 +0000
+++ b/databases/sqlite3/Makefile.common Thu Nov 17 06:20:44 2022 +0000
@@ -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 -r 7b34e35cdbbf -r f64c84f6b1e1 databases/sqlite3/distinfo
--- a/databases/sqlite3/distinfo        Thu Nov 17 05:59:19 2022 +0000
+++ b/databases/sqlite3/distinfo        Thu Nov 17 06:20:44 2022 +0000
@@ -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 -r 7b34e35cdbbf -r f64c84f6b1e1 devel/lemon/distinfo
--- a/devel/lemon/distinfo      Thu Nov 17 05:59:19 2022 +0000
+++ b/devel/lemon/distinfo      Thu Nov 17 06:20:44 2022 +0000
@@ -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