Received: by mail.netbsd.org (Postfix, from userid 605) id 503EC84EEB; Fri, 24 Feb 2023 08:34:41 +0000 (UTC) Received: from localhost (localhost [127.0.0.1]) by mail.netbsd.org (Postfix) with ESMTP id 821D784E99 for ; Fri, 24 Feb 2023 08:34:40 +0000 (UTC) X-Virus-Scanned: amavisd-new at netbsd.org Received: from mail.netbsd.org ([IPv6:::1]) by localhost (mail.netbsd.org [IPv6:::1]) (amavisd-new, port 10025) with ESMTP id K3atHAhaFBEK for ; Fri, 24 Feb 2023 08:34:39 +0000 (UTC) Received: from cvs.NetBSD.org (ivanova.netbsd.org [199.233.217.197]) by mail.netbsd.org (Postfix) with ESMTP id 06CEF84CE8 for ; Fri, 24 Feb 2023 08:34:39 +0000 (UTC) Received: by cvs.NetBSD.org (Postfix, from userid 500) id 0044CFA90; Fri, 24 Feb 2023 08:34:38 +0000 (UTC) Content-Transfer-Encoding: 7bit Content-Type: multipart/mixed; boundary="_----------=_167722767859350" MIME-Version: 1.0 Date: Fri, 24 Feb 2023 08:34:38 +0000 From: "Adam Ciarcinski" Subject: CVS commit: pkgsrc To: pkgsrc-changes@NetBSD.org Reply-To: adam@netbsd.org X-Mailer: log_accum Message-Id: <20230224083439.0044CFA90@cvs.NetBSD.org> Sender: pkgsrc-changes-owner@NetBSD.org List-Id: Precedence: bulk List-Unsubscribe: This is a multi-part message in MIME format. --_----------=_167722767859350 Content-Disposition: inline Content-Transfer-Encoding: 8bit Content-Type: text/plain; charset="US-ASCII" Module Name: pkgsrc Committed By: adam Date: Fri Feb 24 08:34:38 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 Removed Files: pkgsrc/databases/sqlite3-tcl/patches: patch-configure Log Message: sqlite3: updated to 3.41.0 SQLite Release 3.41.0 On 2023-02-21 Query planner improvements: Make use of indexed expressions within an aggregate query that includes a GROUP BY clause. The query planner has improved awareness of when an index is a covering index and adjusts predicted runtimes accordingly. The query planner is more aggressive about using co-routines rather than materializing subqueries and views. Queries against the built-in table-valued functions json_tree() and json_each() will now usually treat "ORDER BY rowid" as a no-op. Enhance the ability of the query planner to use indexed expressions even if the expression has been modified by the constant-propagation optimization. (See forum thread 0a539c7.) Add the built-in unhex() SQL function. Add the base64 and base85 application-defined functions as an extension and include that extension in the CLI. Add the sqlite3_stmt_scanstatus_v2() interface. (This interface is only available if SQLite is compiled using SQLITE_ENABLE_STMT_SCANSTATUS.) In-memory databases created using sqlite3_deserialize() now report their filename as an empty string, not as 'x'. Changes to the CLI: Add the new base64() and base85() SQL functions Enhanced EXPLAIN QUERY PLAN output using the new sqlite3_stmt_scanstatus_v2() interface when compiled using SQLITE_ENABLE_STMT_SCANSTATUS. The ".scanstats est" command provides query planner estimates in profiles. The continuation prompt indicates if the input is currently inside of a string literal, identifier literal, comment, trigger definition, etc. Enhance the --safe command-line option to disallow dangerous SQL functions. The double-quoted string misfeature is now disabled by default for CLI builds. Legacy use cases can reenable the misfeature at run-time using the ".dbconfig dqs_dml on" and ".dbconfig dqs_ddl on" commands. Enhance the PRAGMA integrity_check command so that it detects when text strings in a table are equivalent to but not byte-for-byte identical to the same strings in the index. Enhance the carray table-valued function so that it is able to bind an array of BLOB objects. Added the sqlite3_is_interrupted() interface. Long-running calls to sqlite3_prepare() and similar now invoke the progress handler callback and react to sqlite3_interrupt(). The sqlite3_vtab_in_first() and sqlite3_vtab_in_next() functions are enhanced so that they reliably detect if they are invoked on a parameter that was not selected for multi-value IN processing using sqlite3_vtab_in(). They return SQLITE_ERROR instead of SQLITE_MISUSE in this case. The parser now ignores excess parentheses around a subquery on the right-hand side of an IN operator, so that SQLite now works the same as PostgreSQL in this regard. Formerly, SQLite treated the subquery as an expression with an implied "LIMIT 1". Added the SQLITE_FCNTL_RESET_CACHE option to the sqlite3_file_control() API. Makefile improvements: The new makefile target "sqlite3r.c" builds an amalgamation that includes the recovery extension. New makefile targets "devtest" and "releasetest" for running a quick developmental test prior to doing a check-in and for doing a full release test, respectively. Miscellaneous performance enhancements. To generate a diff of this commit: cvs rdiff -u -r1.97 -r1.98 pkgsrc/databases/sqlite3/Makefile.common cvs rdiff -u -r1.190 -r1.191 pkgsrc/databases/sqlite3/distinfo cvs rdiff -u -r1.120 -r1.121 pkgsrc/databases/sqlite3-docs/PLIST cvs rdiff -u -r1.123 -r1.124 pkgsrc/databases/sqlite3-docs/distinfo cvs rdiff -u -r1.135 -r1.136 pkgsrc/databases/sqlite3-tcl/distinfo cvs rdiff -u -r1.1 -r0 pkgsrc/databases/sqlite3-tcl/patches/patch-configure cvs rdiff -u -r1.64 -r1.65 pkgsrc/devel/lemon/distinfo Please note that diffs are not public domain; they are subject to the copyright notices on the relevant files. --_----------=_167722767859350 Content-Disposition: inline Content-Length: 7533 Content-Transfer-Encoding: binary Content-Type: text/x-diff; charset=us-ascii Modified files: Index: pkgsrc/databases/sqlite3/Makefile.common diff -u pkgsrc/databases/sqlite3/Makefile.common:1.97 pkgsrc/databases/sqlite3/Makefile.common:1.98 --- pkgsrc/databases/sqlite3/Makefile.common:1.97 Wed Dec 28 22:26:06 2022 +++ pkgsrc/databases/sqlite3/Makefile.common Fri Feb 24 08:34:38 2023 @@ -1,15 +1,15 @@ -# $NetBSD: Makefile.common,v 1.97 2022/12/28 22:26:06 adam Exp $ +# $NetBSD: Makefile.common,v 1.98 2023/02/24 08:34:38 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= 3400100 -SQLITE3_VERSION= 3.40.1 +SQLITE3_DISTVERSION= 3410000 +SQLITE3_VERSION= 3.41.0 -MASTER_SITES= http://www.sqlite.org/2022/ -MASTER_SITES+= http://www.hwaci.com/sw/sqlite/2022/ +MASTER_SITES= http://www.sqlite.org/2023/ +MASTER_SITES+= http://www.hwaci.com/sw/sqlite/2023/ HOMEPAGE?= http://www.sqlite.org/ LICENSE= public-domain Index: pkgsrc/databases/sqlite3/distinfo diff -u pkgsrc/databases/sqlite3/distinfo:1.190 pkgsrc/databases/sqlite3/distinfo:1.191 --- pkgsrc/databases/sqlite3/distinfo:1.190 Wed Dec 28 22:26:06 2022 +++ pkgsrc/databases/sqlite3/distinfo Fri Feb 24 08:34:38 2023 @@ -1,6 +1,6 @@ -$NetBSD: distinfo,v 1.190 2022/12/28 22:26:06 adam Exp $ +$NetBSD: distinfo,v 1.191 2023/02/24 08:34:38 adam Exp $ -BLAKE2s (sqlite-autoconf-3400100.tar.gz) = f46e011624666d90fc246a1687b3014f20e4db6ca4bc0ccbb360d82f53f2a97e -SHA512 (sqlite-autoconf-3400100.tar.gz) = 50ff85b40b0017a73b52988843ec439358a8dde7d5d012a33ecfdaa67006697692f091a62d5f052f64e6fee84e27251864d331f63039a326ae4d5bf4a4dd5a91 -Size (sqlite-autoconf-3400100.tar.gz) = 3098662 bytes +BLAKE2s (sqlite-autoconf-3410000.tar.gz) = 63b08be2e4069c5ad7e5ab4b0866501b49f7c32cd28f8b8b6b70ba366f7cf502 +SHA512 (sqlite-autoconf-3410000.tar.gz) = a7c79d208358f61d3c9876ec143aee68de22512bd8c5e2bd8bdab62693055293f9d04d779075770e733dd611afdfe3662702d65ec2bb78672342292cd0133030 +Size (sqlite-autoconf-3410000.tar.gz) = 3124499 bytes SHA1 (patch-configure) = c0aa83bddc20d090b3cd2fd840ac69031f4396e4 Index: pkgsrc/databases/sqlite3-docs/PLIST diff -u pkgsrc/databases/sqlite3-docs/PLIST:1.120 pkgsrc/databases/sqlite3-docs/PLIST:1.121 --- pkgsrc/databases/sqlite3-docs/PLIST:1.120 Wed Dec 28 22:26:06 2022 +++ pkgsrc/databases/sqlite3-docs/PLIST Fri Feb 24 08:34:38 2023 @@ -1,4 +1,4 @@ -@comment $NetBSD: PLIST,v 1.120 2022/12/28 22:26:06 adam Exp $ +@comment $NetBSD: PLIST,v 1.121 2023/02/24 08:34:38 adam Exp $ share/doc/sqlite3/34to35.html share/doc/sqlite3/35to36.html share/doc/sqlite3/about.html @@ -59,6 +59,7 @@ share/doc/sqlite3/c3ref/c_lock_exclusive share/doc/sqlite3/c3ref/c_mutex_fast.html share/doc/sqlite3/c3ref/c_open_autoproxy.html share/doc/sqlite3/c3ref/c_prepare_normalize.html +share/doc/sqlite3/c3ref/c_scanstat_complex.html share/doc/sqlite3/c3ref/c_scanstat_est.html share/doc/sqlite3/c3ref/c_serialize_nocopy.html share/doc/sqlite3/c3ref/c_shm_exclusive.html @@ -208,6 +209,7 @@ share/doc/sqlite3/c3ref/user_data.html share/doc/sqlite3/c3ref/value.html share/doc/sqlite3/c3ref/value_blob.html share/doc/sqlite3/c3ref/value_dup.html +share/doc/sqlite3/c3ref/value_encoding.html share/doc/sqlite3/c3ref/value_subtype.html share/doc/sqlite3/c3ref/vfs.html share/doc/sqlite3/c3ref/vfs_find.html @@ -546,6 +548,7 @@ share/doc/sqlite3/pragma.html share/doc/sqlite3/pressrelease-20071212.html share/doc/sqlite3/printf.html share/doc/sqlite3/privatebranch.html +share/doc/sqlite3/profile.html share/doc/sqlite3/prosupport.html share/doc/sqlite3/psow.html share/doc/sqlite3/qmplan.html @@ -675,6 +678,7 @@ 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_40_1.html +share/doc/sqlite3/releaselog/3_41_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 @@ -935,7 +939,6 @@ share/doc/sqlite3/tempfiles.html share/doc/sqlite3/testing.html 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 Index: pkgsrc/databases/sqlite3-docs/distinfo diff -u pkgsrc/databases/sqlite3-docs/distinfo:1.123 pkgsrc/databases/sqlite3-docs/distinfo:1.124 --- pkgsrc/databases/sqlite3-docs/distinfo:1.123 Wed Dec 28 22:26:06 2022 +++ pkgsrc/databases/sqlite3-docs/distinfo Fri Feb 24 08:34:38 2023 @@ -1,5 +1,5 @@ -$NetBSD: distinfo,v 1.123 2022/12/28 22:26:06 adam Exp $ +$NetBSD: distinfo,v 1.124 2023/02/24 08:34:38 adam Exp $ -BLAKE2s (sqlite-doc-3400100.zip) = 0d9514b754281e4b23a1e7e6288942a0f1cb0cd8fd9472e4b26b99d4c5ab9638 -SHA512 (sqlite-doc-3400100.zip) = 1131b0a6304a4dd6287c85d38d1450fd2dd0e3377d88a263e3c4716415e0587750357f25486727b9433797da0331229682565e7a8a3986eba89cfcab550a2d41 -Size (sqlite-doc-3400100.zip) = 10934836 bytes +BLAKE2s (sqlite-doc-3410000.zip) = 146c6433509b6f60a224520cf38af5f60e5c3e7a5af013b1b7120ae4013cc685 +SHA512 (sqlite-doc-3410000.zip) = 6eff61b7a63ee8cd8c9460b50f6ab6c9bf8074a270e900fee8bf28c1602cc5da35b0c626a780e735f349f08310a924ba83cd1420f2767f8d12d0ee0455374109 +Size (sqlite-doc-3410000.zip) = 10979224 bytes Index: pkgsrc/databases/sqlite3-tcl/distinfo diff -u pkgsrc/databases/sqlite3-tcl/distinfo:1.135 pkgsrc/databases/sqlite3-tcl/distinfo:1.136 --- pkgsrc/databases/sqlite3-tcl/distinfo:1.135 Wed Dec 28 22:26:06 2022 +++ pkgsrc/databases/sqlite3-tcl/distinfo Fri Feb 24 08:34:38 2023 @@ -1,7 +1,6 @@ -$NetBSD: distinfo,v 1.135 2022/12/28 22:26:06 adam Exp $ +$NetBSD: distinfo,v 1.136 2023/02/24 08:34:38 adam Exp $ -BLAKE2s (sqlite-autoconf-3400100.tar.gz) = f46e011624666d90fc246a1687b3014f20e4db6ca4bc0ccbb360d82f53f2a97e -SHA512 (sqlite-autoconf-3400100.tar.gz) = 50ff85b40b0017a73b52988843ec439358a8dde7d5d012a33ecfdaa67006697692f091a62d5f052f64e6fee84e27251864d331f63039a326ae4d5bf4a4dd5a91 -Size (sqlite-autoconf-3400100.tar.gz) = 3098662 bytes +BLAKE2s (sqlite-autoconf-3410000.tar.gz) = 63b08be2e4069c5ad7e5ab4b0866501b49f7c32cd28f8b8b6b70ba366f7cf502 +SHA512 (sqlite-autoconf-3410000.tar.gz) = a7c79d208358f61d3c9876ec143aee68de22512bd8c5e2bd8bdab62693055293f9d04d779075770e733dd611afdfe3662702d65ec2bb78672342292cd0133030 +Size (sqlite-autoconf-3410000.tar.gz) = 3124499 bytes SHA1 (patch-Makefile.in) = 8f68039c9169bc69eb0da4bd0f910c7584aed2b5 -SHA1 (patch-configure) = a885e450adabd3cc300ee9da003b05670b02d049 Index: pkgsrc/devel/lemon/distinfo diff -u pkgsrc/devel/lemon/distinfo:1.64 pkgsrc/devel/lemon/distinfo:1.65 --- pkgsrc/devel/lemon/distinfo:1.64 Wed Dec 28 22:26:07 2022 +++ pkgsrc/devel/lemon/distinfo Fri Feb 24 08:34:38 2023 @@ -1,5 +1,5 @@ -$NetBSD: distinfo,v 1.64 2022/12/28 22:26:07 adam Exp $ +$NetBSD: distinfo,v 1.65 2023/02/24 08:34:38 adam Exp $ -BLAKE2s (sqlite-src-3400100.zip) = ca4e251fd76591fed11a5f6bda9663c72f7dea6c5713f980478a892f48be5353 -SHA512 (sqlite-src-3400100.zip) = 78f8c6396bf8da090671c6f4c41255e60788324fccdaad906c53610eb6e37705f4d25c7f84da3be00b511ddf9f2e0545901f33f5ae4b6e00b1ea9413af095299 -Size (sqlite-src-3400100.zip) = 13725560 bytes +BLAKE2s (sqlite-src-3410000.zip) = cf294b1a956cb24eaf096259b2e8e8533a8838f65d09ce92d547c4421eb40b27 +SHA512 (sqlite-src-3410000.zip) = 9c39202eb058e421035ffe4d5c9f74164a0ad4a928f6f01e4fa04af0e7efb64635ab5902220dbb37478c5c777170e4c49a171b36a0f908315e187a8f1aa2b5e8 +Size (sqlite-src-3410000.zip) = 13831104 bytes --_----------=_167722767859350--