CVS commit: pkgsrc

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

Module Name:    pkgsrc
Committed By:   adam
Date:           Fri Aug 25 06:48:00 UTC 2023

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

Log Message:
databases/sqlite3* devel/lemon: updated to 2.43.0

SQLite Release 3.43.0 On 2023-08-24

Add support for Contentless-Delete FTS5 Indexes. This is a variety of FTS5 full-text search index that omits storing the content that is being indexed while also allowing records to be deleted.
Enhancements to the date and time functions:
Added new time shift modifiers of the form ±YYYY-MM-DD HH:MM:SS.SSS.
Added the timediff() SQL function.
Added the octet_length(X) SQL function.
Added the sqlite3_stmt_explain() API.
Query planner enhancements:
Generalize the LEFT JOIN strength reduction optimization so that it works for RIGHT and FULL JOINs as well. Rename it to OUTER JOIN strength reduction.
Enhance the theorem prover in the OUTER JOIN strength reduction optimization so that it returns fewer false-negatives.
Enhancements to the decimal extension:
New function decimal_pow2(N) returns the N-th power of 2 for integer N between -20000 and +20000.
New function decimal_exp(X) works like decimal(X) except that it returns the result in exponential notation - with a "e+NN" at the end.
If X is a floating-point value, then the decimal(X) function now does a full expansion of that value into its exact decimal equivalent.
Performance enhancements to JSON processing results in a 2x performance improvement for some kinds of processing on large JSON strings.
New makefile target "verify-source" checks to ensure that there are no unintentional changes in the source tree. (Works for canonical source code only - not for precompiled amalgamation tarballs.)
Added the SQLITE_USE_SEH compile-time option that enables Structured Exception Handling on Windows while working with the memory-mapped shm file that is part of WAL mode processing. This option is 
enabled by default when building on Windows using Makefile.msc.
The VFS for unix now assumes that the nanosleep() system call is available unless compiled with -DHAVE_NANOSLEEP=0.


To generate a diff of this commit:
cvs rdiff -u -r1.101 -r1.102 pkgsrc/databases/sqlite3/Makefile.common
cvs rdiff -u -r1.194 -r1.195 pkgsrc/databases/sqlite3/distinfo
cvs rdiff -u -r1.124 -r1.125 pkgsrc/databases/sqlite3-docs/PLIST
cvs rdiff -u -r1.127 -r1.128 pkgsrc/databases/sqlite3-docs/distinfo
cvs rdiff -u -r1.139 -r1.140 pkgsrc/databases/sqlite3-tcl/distinfo
cvs rdiff -u -r1.68 -r1.69 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.common
diff -u pkgsrc/databases/sqlite3/Makefile.common:1.101 pkgsrc/databases/sqlite3/Makefile.common:1.102
--- pkgsrc/databases/sqlite3/Makefile.common:1.101      Wed May 17 12:29:57 2023
+++ pkgsrc/databases/sqlite3/Makefile.common    Fri Aug 25 06:48:00 2023
@@ -1,12 +1,12 @@
-# $NetBSD: Makefile.common,v 1.101 2023/05/17 12:29:57 adam Exp $
+# $NetBSD: Makefile.common,v 1.102 2023/08/25 06:48: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=   3420000
-SQLITE3_VERSION=       3.42.0
+SQLITE3_DISTVERSION=   3430000
+SQLITE3_VERSION=       3.43.0
 
 MASTER_SITES=  http://www.sqlite.org/2023/
 MASTER_SITES+= http://www.hwaci.com/sw/sqlite/2023/

Index: pkgsrc/databases/sqlite3/distinfo
diff -u pkgsrc/databases/sqlite3/distinfo:1.194 pkgsrc/databases/sqlite3/distinfo:1.195
--- pkgsrc/databases/sqlite3/distinfo:1.194     Wed May 17 12:29:57 2023
+++ pkgsrc/databases/sqlite3/distinfo   Fri Aug 25 06:48:00 2023
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.194 2023/05/17 12:29:57 adam Exp $
+$NetBSD: distinfo,v 1.195 2023/08/25 06:48:00 adam Exp $
 
-BLAKE2s (sqlite-autoconf-3420000.tar.gz) = 1b2bc59cf530020d633e37b80da52b50187ff969d082b2ac381abad062e9c010
-SHA512 (sqlite-autoconf-3420000.tar.gz) = f54a8993433b4787dde99b11754f26cb525389446f12c78100b47ed342933385c819621c5384387aec7be68aed92d729acb1e5391d3c786f4f9cf1c767a743bd
-Size (sqlite-autoconf-3420000.tar.gz) = 3148813 bytes
+BLAKE2s (sqlite-autoconf-3430000.tar.gz) = 81d027e5f866d8ba06bf3a0660599951f9341e8274c6b39fd4a5a743627cbd2e
+SHA512 (sqlite-autoconf-3430000.tar.gz) = 45996a8ccf49d72104ff938642ad9e1a427c08238579dbe2e5806e77728ffa85441c7ab865723c0c16742dd8246190306d800eb1285c145428b0739ad65d222e
+Size (sqlite-autoconf-3430000.tar.gz) = 3178199 bytes
 SHA1 (patch-configure) = c0aa83bddc20d090b3cd2fd840ac69031f4396e4

Index: pkgsrc/databases/sqlite3-docs/PLIST
diff -u pkgsrc/databases/sqlite3-docs/PLIST:1.124 pkgsrc/databases/sqlite3-docs/PLIST:1.125
--- pkgsrc/databases/sqlite3-docs/PLIST:1.124   Wed May 17 12:29:58 2023
+++ pkgsrc/databases/sqlite3-docs/PLIST Fri Aug 25 06:48:00 2023
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.124 2023/05/17 12:29:58 adam Exp $
+@comment $NetBSD: PLIST,v 1.125 2023/08/25 06:48:00 adam Exp $
 share/doc/sqlite3/34to35.html
 share/doc/sqlite3/35to36.html
 share/doc/sqlite3/about.html
@@ -181,6 +181,7 @@ share/doc/sqlite3/c3ref/status.html
 share/doc/sqlite3/c3ref/step.html
 share/doc/sqlite3/c3ref/stmt.html
 share/doc/sqlite3/c3ref/stmt_busy.html
+share/doc/sqlite3/c3ref/stmt_explain.html
 share/doc/sqlite3/c3ref/stmt_isexplain.html
 share/doc/sqlite3/c3ref/stmt_readonly.html
 share/doc/sqlite3/c3ref/stmt_scanstatus.html
@@ -340,7 +341,6 @@ share/doc/sqlite3/images/btreemodule_bal
 share/doc/sqlite3/images/btreemodule_balance_shallower.svg
 share/doc/sqlite3/images/btreemodule_delete1.svg
 share/doc/sqlite3/images/btreemodule_overview.svg
-share/doc/sqlite3/images/cc-diff.jpg
 share/doc/sqlite3/images/chart.wiki
 share/doc/sqlite3/images/chw.jpg
 share/doc/sqlite3/images/cpu-usage.jpg
@@ -682,6 +682,7 @@ share/doc/sqlite3/releaselog/3_41_0.html
 share/doc/sqlite3/releaselog/3_41_1.html
 share/doc/sqlite3/releaselog/3_41_2.html
 share/doc/sqlite3/releaselog/3_42_0.html
+share/doc/sqlite3/releaselog/3_43_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

Index: pkgsrc/databases/sqlite3-docs/distinfo
diff -u pkgsrc/databases/sqlite3-docs/distinfo:1.127 pkgsrc/databases/sqlite3-docs/distinfo:1.128
--- pkgsrc/databases/sqlite3-docs/distinfo:1.127        Wed May 17 12:29:58 2023
+++ pkgsrc/databases/sqlite3-docs/distinfo      Fri Aug 25 06:48:00 2023
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.127 2023/05/17 12:29:58 adam Exp $
+$NetBSD: distinfo,v 1.128 2023/08/25 06:48:00 adam Exp $
 
-BLAKE2s (sqlite-doc-3420000.zip) = e5c603f21dfaa122deeae1f0c56a5c6d73d1eddd4ca0bbaea2727bb321b403c2
-SHA512 (sqlite-doc-3420000.zip) = d675ee2897323d468816bc713594c4e94cb5c15270b4f991758e2c82e2891ad724c5790f29b76bc9e5d6b3be04e95aee371c57ceb2d855c1057b4af62a5af162
-Size (sqlite-doc-3420000.zip) = 10665938 bytes
+BLAKE2s (sqlite-doc-3430000.zip) = 679bc74cbde749b34905ff27491d483817d2b89db80adbfc58cb0d12e7099588
+SHA512 (sqlite-doc-3430000.zip) = 393c759e86a2fd6a7bbdc820c78289b84f984acd83879d7385c8627c73060562d376d66a9464887fdbccdea395025db677aa4c6f37aa32e99048fcde3561ae06
+Size (sqlite-doc-3430000.zip) = 10663888 bytes

Index: pkgsrc/databases/sqlite3-tcl/distinfo
diff -u pkgsrc/databases/sqlite3-tcl/distinfo:1.139 pkgsrc/databases/sqlite3-tcl/distinfo:1.140
--- pkgsrc/databases/sqlite3-tcl/distinfo:1.139 Wed May 17 12:29:58 2023
+++ pkgsrc/databases/sqlite3-tcl/distinfo       Fri Aug 25 06:48:00 2023
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.139 2023/05/17 12:29:58 adam Exp $
+$NetBSD: distinfo,v 1.140 2023/08/25 06:48:00 adam Exp $
 
-BLAKE2s (sqlite-autoconf-3420000.tar.gz) = 1b2bc59cf530020d633e37b80da52b50187ff969d082b2ac381abad062e9c010
-SHA512 (sqlite-autoconf-3420000.tar.gz) = f54a8993433b4787dde99b11754f26cb525389446f12c78100b47ed342933385c819621c5384387aec7be68aed92d729acb1e5391d3c786f4f9cf1c767a743bd
-Size (sqlite-autoconf-3420000.tar.gz) = 3148813 bytes
+BLAKE2s (sqlite-autoconf-3430000.tar.gz) = 81d027e5f866d8ba06bf3a0660599951f9341e8274c6b39fd4a5a743627cbd2e
+SHA512 (sqlite-autoconf-3430000.tar.gz) = 45996a8ccf49d72104ff938642ad9e1a427c08238579dbe2e5806e77728ffa85441c7ab865723c0c16742dd8246190306d800eb1285c145428b0739ad65d222e
+Size (sqlite-autoconf-3430000.tar.gz) = 3178199 bytes
 SHA1 (patch-Makefile.in) = 8f68039c9169bc69eb0da4bd0f910c7584aed2b5

Index: pkgsrc/devel/lemon/distinfo
diff -u pkgsrc/devel/lemon/distinfo:1.68 pkgsrc/devel/lemon/distinfo:1.69
--- pkgsrc/devel/lemon/distinfo:1.68    Wed May 17 12:29:58 2023
+++ pkgsrc/devel/lemon/distinfo Fri Aug 25 06:48:00 2023
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.68 2023/05/17 12:29:58 adam Exp $
+$NetBSD: distinfo,v 1.69 2023/08/25 06:48:00 adam Exp $
 
-BLAKE2s (sqlite-src-3420000.zip) = 7f792dae1014897bbd84444887f33a95a86ad2b1095dc31c5d35d3315e84f6fe
-SHA512 (sqlite-src-3420000.zip) = 509b7aa292870c927ef137469028e5e07ca74907414c5b295360cb10b377a42de7469d3afe79f8d9947d486ef74d676679c7f2d3b1caaeb8c949f27201180def
-Size (sqlite-src-3420000.zip) = 13910252 bytes
+BLAKE2s (sqlite-src-3430000.zip) = b8ee615c3206ce5538be51dbfab320e0a4555f08a7ce89ee083b505334eb7503
+SHA512 (sqlite-src-3430000.zip) = 56a16980bf10ba0d312ada183cabaa4123faf4ed531749d70349ca55ca11cc8a6733f473b2247f6cc0e500523f1b598ffee31efb81e07879c523957f0e3efa90
+Size (sqlite-src-3430000.zip) = 13927457 bytes