Subject: CVS commit: pkgsrc
From: Adam Ciarcinski
Date: 2025-03-30 08:18:07
Message id: 20250330061807.BC82DFBE1@cvs.NetBSD.org

Log Message:
sqlite3: updated to 3.49.1

Prior changes from version 3.49.0 (2025-02-06):

Enhancements to the query planner:
Improve the query-time index optimization so that it works on WITHOUT ROWID tables.
Better query plans for large star-query joins. This fixes three different \ 
performance regressions that were reported on the SQLite Forum.
When two or more queries have the same estimated cost, use the one with the \ 
fewer bytes per row.
Enhance the iif() SQL function so that it can accept any number of arguments \ 
greater than or equal to two.
Enhance the session extension so that it works on databases that make use of \ 
generated columns.
Omit the SQLITE_USE_STDIO_FOR_CONSOLE compile-time option which was not \ 
implemented correctly and never worked right. In its place add the \ 
SQLITE_USE_W32_FOR_CONSOLE_IO compile-time option. This option applies to \ 
command-line tools like the CLI only, not to the SQLite core. It causes Win32 \ 
APIs to be used for console I/O instead of stdio. This option affects Windows \ 
builds only.
Three new options to sqlite3_db_config(). All default to "on".
SQLITE_DBCONFIG_ENABLE_ATTACH_CREATE
SQLITE_DBCONFIG_ENABLE_ATTACH_WRITE
SQLITE_DBCONFIG_ENABLE_COMMENTS
Replace Autotools with Autosetup for the configure script used in the \ 
precompiled amalgamation tarball. The configure script for the canonical source \ 
code was changed to Autosetup in the previous (3.48.0) release. Only the main \ 
SQLite configure script in the amalgamation tarball is changed. The (deprecated) \ 
configuration script use by TEA subdirectory of the amalgamation tarball still \ 
relies on Autotools.
Various minor patches and fixes for problems seen in the 3.48.0 release.

Changes in this specific patch release, version 3.49.1 (2025-02-18):

Improve portability of makefiles and configure scripts.
Fix a bug in the concat_ws() function, introduced in version 3.44.0, that could \ 
lead to a memory error if the separator string is very large (hundreds of \ 
megabytes).
Enhanced the SQLITE_DBCONFIG_LOOKASIDE interface to make it more robust against \ 
misuse.

Files:
RevisionActionfile
1.164modifypkgsrc/databases/sqlite3/Makefile
1.117modifypkgsrc/databases/sqlite3/Makefile.common
1.7modifypkgsrc/databases/sqlite3/PLIST
1.211modifypkgsrc/databases/sqlite3/distinfo
1.10modifypkgsrc/databases/sqlite3/options.mk
1.140modifypkgsrc/databases/sqlite3-docs/PLIST
1.143modifypkgsrc/databases/sqlite3-docs/distinfo
1.157modifypkgsrc/databases/sqlite3-tcl/distinfo
1.84modifypkgsrc/devel/lemon/distinfo
1.5removepkgsrc/databases/sqlite3/patches/patch-configure