Log message:
Note that sqlite3-diff includes this too.

Log message:
sqlite3: updated to 3.49.2

3.49.2 (2025-05-07):

Fix a bug in the NOT NULL optimization of version 3.40.0 (item 3c in the version \ 
3.40.0 change log) that can lead to a memory error if abused.
Fix the count-of-view optimization so that it does not give an incorrect answer \ 
for a DISTINCT query.
Fix a possible incorrect answer that can result if a UNIQUE constraint of a \ 
table contains the PRIMARY KEY column and that UNIQUE constraint is used by an \ 
IN operator.
Fix obscure problems with the generate_series() extension function.
Incremental improvements to the configure/make.

Log message:
sqlite3: fix Tiger build. Sequoia and NetBSD still package.

Log message:
*: recursive bump for icu 77 and libxml2 2.14

Log message:
sqlite3: Fixes for UnixWare 7.

Log message:
databases/sqlite3: Fix cross-build.

Conditional on USE_CROSS_COMPILE = yes, so no change to native build.
Didn't cross-build without this, so no need for revbump.

Log message:
sqlite3: Remove jimtcl dependency.

The sqlite3 autoconf distribution includes a bundled jimsh0 that is used to
bootstrap in the case of the host not providing a TCL implementation.  Simply
use that rather than depending on jimtcl, which is non-portable.

Fixes build on at least Solaris/illumos.  Tested on SmartOS, macOS, and NetBSD,
with macOS being of particular interest as it ships a native implementation of
tclsh so does not use the bootstrap version.

While here perform pkglint cleanup.  Bump PKGREVISION.

Log message:
databases/sqlite3: Temporarily disable zlib for now.

Since the update, pkg_add sqlite3 is newly broken on some platforms.
See comment for details.

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.

Log message:
databases/sqlite3: fix outdated configure option name