head	1.11;
access;
symbols
	pkgsrc-2026Q1:1.9.0.2
	pkgsrc-2026Q1-base:1.9
	pkgsrc-2025Q4:1.6.0.2
	pkgsrc-2025Q4-base:1.6
	pkgsrc-2025Q3:1.4.0.2
	pkgsrc-2025Q3-base:1.4
	pkgsrc-2025Q2:1.1.0.2
	pkgsrc-2025Q2-base:1.1;
locks; strict;
comment	@# @;


1.11
date	2026.05.06.06.13.10;	author adam;	state Exp;
branches;
next	1.10;
commitid	kNHkqgVIKen3AIEG;

1.10
date	2026.04.17.12.46.27;	author adam;	state Exp;
branches;
next	1.9;
commitid	UFqqAksNnaEKmjCG;

1.9
date	2026.03.15.09.36.08;	author adam;	state Exp;
branches;
next	1.8;
commitid	xDUpbbOyCQ89n3yG;

1.8
date	2026.03.12.20.29.22;	author wiz;	state Exp;
branches;
next	1.7;
commitid	DI3IImuHMkBr5JxG;

1.7
date	2026.01.15.07.41.35;	author wiz;	state Exp;
branches;
next	1.6;
commitid	rQaprWVwcdODDsqG;

1.6
date	2025.11.29.14.21.30;	author adam;	state Exp;
branches;
next	1.5;
commitid	0tdKkMF1KdrxmskG;

1.5
date	2025.11.06.16.13.25;	author adam;	state Exp;
branches;
next	1.4;
commitid	w927oFtwFhKLIvhG;

1.4
date	2025.08.02.14.06.56;	author adam;	state Exp;
branches;
next	1.3;
commitid	vGvRBlJwTqAH6a5G;

1.3
date	2025.07.24.15.56.22;	author schmonz;	state Exp;
branches;
next	1.2;
commitid	jc1wc2GU93l1014G;

1.2
date	2025.07.04.14.53.28;	author schmonz;	state Exp;
branches;
next	1.1;
commitid	zX0HrdORnB4qir1G;

1.1
date	2025.05.20.16.46.24;	author schmonz;	state Exp;
branches;
next	;
commitid	DZLSagkBRPmSmFVF;


desc
@@


1.11
log
@sqlite3: updated to 3.53.1

3.53.1 (2026-05-05):

Fixes for problems in 3.53.0 reported by users. See the check-in timeline for details.
@
text
@$NetBSD: distinfo,v 1.10 2026/04/17 12:46:27 adam Exp $

BLAKE2s (sqlite-src-3530100.zip) = a8dbae68168a3b76549c1083559d111a0ef9e6aaac46c224151ef91d2dcb24d4
SHA512 (sqlite-src-3530100.zip) = e6b429dbec2056e1e90557896940f46b0976b9c4a3cfa6890d23f690fcab4d7cff2f2dea3a3d2cfc5faf87d0d6feb318c70212ec101008416d106189c6bc0133
Size (sqlite-src-3530100.zip) = 14515734 bytes
@


1.10
log
@sqlite3: updated to 3.53.0

3.53.0

Fix the WAL-reset database corruption bug.
Add the Query Result Formatter (QRF) library for formatting the results of SQL queries for human readability on a fixed-pitch font screen.
Add the format method to the TCL Interface so that QRF is accessible from TCL.
QRF is used for result formatting in the CLI, resulting in improved display capabilities.
New SQL language features:
Enhance ALTER TABLE to permit adding and removing NOT NULL and CHECK constraints.
The REINDEX EXPRESSIONS statement rebuilds expression indexes. (Useful to repair stale expression indexes.)
The body of TEMP triggers may now modify and/or query tables in the main schema.
Enhance VACUUM INTO so that if a URI filename is used as the target and that filename has a reserve=N query parameter with N between 0 and 255, then the reserve amount for the generated database copy is set to N.
New SQL functions:
json_array_insert()
jsonb_array_insert()
Renovations to the CLI:
Major enhancements to the .mode command.
Improved result formatting, due to the addition of the QRF extension. For example, numeric values are now right-justified by default in tabular output modes.
The default output mode for interactive CLI sessions now uses QRF to display query results in boxes formed using Unicode box-drawing characters, for improved legibility. Batch CLI sessions use the legacy output format for compatibility.
Bare (unquoted) semicolons at the end of dot-commands are silently ignored.  ← Potential incompatibility!
Fix the .testcase and .check commands so that they actually work, and use those commands in scripts that are part of the standard SQLite test suite included with the source tree.
Command-line arguments that match *.sql or *.txt and are the names of non-empty files are read and interpreted as scripts of SQL statements and/or dot-commands.
The argument to the ".timer" command can now be "once", to run the timer on only the next SQL statement.
The new "--timeout S" option to the ".progress" dot-command causes SQL statements to interrupt after S seconds.
The ".indexes" command was changed so that the PATTERN argument matches the name of the index, not the name of the table being indexed (thus making the PATTERN argument actually useful). And, several new options were added to ".indexes".
New C-language interfaces:
sqlite3_str_truncate()
sqlite3_str_free()
sqlite3_carray_bind_v2()
Add the SQLITE_PREPARE_FROM_DDL option to sqlite3_prepare_v3() which permits virtual table implementations to safely prepare SQL statements that are derived from the database schema.
Added the SQLITE_UTF8_ZT constant which can be used as the encoding parameter to sqlite3_result_text64() or sqlite3_bind_text64() to indicate that the value is UTF-8 encoded and zero terminated.
The SQLITE_LIMIT_PARSER_DEPTH option is added to sqlite3_limit().
The SQLITE_DBCONFIG_FP_DIGITS option is added to sqlite3_db_config(). See also item 9b below.
Query planner improvements:
Always use a sort-and-merge algorithm for EXCEPT, INTERSECT, and UNION, since this is almost always faster than using a hash table.
Improvements to join order selection in large multi-way joins on a star schema.
Enhance the EXISTS-to-JOIN optimization so that the inserted JOIN terms are not required to be on the inner-most loops, as long as all dependencies for the EXISTS-to-JOIN loops are in outer loops.
Enhance the omit-noop-join optimization so that it is able to omit a chain of joins that do not affect the output.
Allow queries that use "GROUP BY e1 ORDER BY e2" where e1 and e2 are identical apart from ASC/DESC sort-orders to be optimized using a single index.
Allow virtual tables to optimize DISTINCT in cases where the result-set of a query does not exactly match the ORDER BY clause.
Add new interfaces to the session extension that enable an application to add changes one at a time to the sqlite3_changegroup object:
sqlite3changegroup_change_begin()
sqlite3changegroup_change_blob()
sqlite3changegroup_change_double()
sqlite3changegroup_change_int64()
sqlite3changegroup_change_null()
sqlite3changegroup_change_text()
sqlite3changegroup_change_finish()
sqlite3changegroup_config()
Improvements to floating-point ↔ text conversions.
Reimplemented to improve performance.
Rounding is now done by default to 17 significant digits, instead of 15, as was the case for all prior versions. The sqlite3_db_config(SQLITE_DBCONFIG_FP_DIGITS) API (item 6g above) can change this, if desired.
Added the self-healing index feature to deal with the stale expression index problem.
Add the "-p|--port" option to sqlite3_rsync.
Discontinue support for Windows RT.
JavaScript/WASM
Add the "opfs-wl" VFS, functionally identical to the "opfs" VFS but using Web Locks for locking, which can promise fairer lock sharing than the "opfs" bespoke protocol can. "opfs-wl" requires Atomics.waitAsync(), so requires newer browsers than "opfs" does.
@
text
@d1 1
a1 1
$NetBSD: distinfo,v 1.9 2026/03/15 09:36:08 adam Exp $
d3 3
a5 3
BLAKE2s (sqlite-src-3530000.zip) = be0413cb2f3913e07b45ab6a6b8f795b80dd76d03f89985425e22a6200ef49b1
SHA512 (sqlite-src-3530000.zip) = f2a5990d8bafc2d2bb63b1a413bca6cb4b6bed1c7b84caf7ce7fe569ec22f1098f54c5e46080025b09ddb882f5ef1ae36baccaf7f5d53dfe7a242afdc74adcda
Size (sqlite-src-3530000.zip) = 14513779 bytes
@


1.9
log
@sqlite3: updated/downgraded to 3.51.3

SQLite version 3.52.0 has been withdrawn because some of the new features found
in 3.52.0 are not 100% compatible with prior releases. Those new features and
their associated APIs need to be reworked before 3.52 is made available.

In place of 3.52.0, patch release 3.51.3 is now available. Patch release 3.51.3
fixes the WAL-reset bug as well as other minor problems that have come to light
since the 3.51.2 release.

3.51.3 (2026-03-13):

Fix the WAL-reset database corruption bug.
Other minor bug fixes.
@
text
@d1 1
a1 1
$NetBSD: distinfo,v 1.8 2026/03/12 20:29:22 wiz Exp $
d3 3
a5 3
BLAKE2s (sqlite-src-3510300.zip) = 3f3bf8ffbca2390f1b1f8359058e73756f10ce466a7b1b1131f094e052a421b9
SHA512 (sqlite-src-3510300.zip) = 2bf2d0fd824580a5f4d4312c1c350459fce9342de45ba33ba521f539ef455ce0afe35ea58aefc3f39f7a353f998f4b9b98ffafe56d65582ef6ae78c2ec503125
Size (sqlite-src-3510300.zip) = 14206164 bytes
@


1.8
log
@sqlite3-diff: regen for sqlite3 update
@
text
@d1 1
a1 1
$NetBSD: distinfo,v 1.7 2026/01/15 07:41:35 wiz Exp $
d3 3
a5 3
BLAKE2s (sqlite-src-3520000.zip) = 67c231e82b0d8eacaa32211742facd03e8d4b0430bb932befe2d81b708101423
SHA512 (sqlite-src-3520000.zip) = 178546508c78e2a271c5e72fb4e47af3860557c6692a6db79639f627d06e5222f52a9cbd7f522b8e7be81d899620419591ce7e1e66588b0f0c90e22de5598ca0
Size (sqlite-src-3520000.zip) = 14346407 bytes
@


1.7
log
@sqlite3-diff: regen distinfo after sqlite update
@
text
@d1 1
a1 1
$NetBSD: distinfo,v 1.6 2025/11/29 14:21:30 adam Exp $
d3 3
a5 3
BLAKE2s (sqlite-src-3510200.zip) = e78989e84a5125f41788476d404e0a0b1502b2fbbd2c5df53eb8debb841be6fa
SHA512 (sqlite-src-3510200.zip) = 89e1c76d6cae41f2ececb85af2e8bfd5cf60e8b9e3d8a48f98f3913513762bc8846f6b5c28e76cca12505ce670cdaf6ca95ecb2267b9527e47929fb928847605
Size (sqlite-src-3510200.zip) = 14202690 bytes
@


1.6
log
@sqlite3-diff: bump to 3.51.1
@
text
@d1 1
a1 1
$NetBSD: distinfo,v 1.5 2025/11/06 16:13:25 adam Exp $
d3 3
a5 3
BLAKE2s (sqlite-src-3510100.zip) = 92e2bc9f917b9a3258b0753ed49b23dfe1533ec95cae95f61e211e7b19ddf12e
SHA512 (sqlite-src-3510100.zip) = 43f4e50a2e0257bfb6c7694e7226d120ec122e3c8558ace547452d381f72a3484037e79d7e27db05ea6ad256012fd2f660b595591e127db4db7bf74301c9503f
Size (sqlite-src-3510100.zip) = 14200172 bytes
@


1.5
log
@Add missing patches and distinfo
@
text
@d1 1
a1 1
$NetBSD: distinfo,v 1.4 2025/08/02 14:06:56 adam Exp $
d3 3
a5 3
BLAKE2s (sqlite-src-3510000.zip) = 2f478bca3d5683f338ee72be32bdd702b4bbed085b32bc9ddd055c52a8cc7b50
SHA512 (sqlite-src-3510000.zip) = 49f84c79030b2bd9141d1a6834201858493e782363a48b73dc7b7f46bd1d3dd1849dbe859671f84a1d5ef923568e00231be4c1ff4d611bbe0b0f8b69820f30d5
Size (sqlite-src-3510000.zip) = 14193571 bytes
@


1.4
log
@sqlite3-diff: update distinfo
@
text
@d1 1
a1 1
$NetBSD: distinfo,v 1.3 2025/07/24 15:56:22 schmonz Exp $
d3 3
a5 3
BLAKE2s (sqlite-src-3500400.zip) = 60a51a910fc0d7ab8d9f2a9c68d33de79bb7b7c6630caa34653f23669be149f1
SHA512 (sqlite-src-3500400.zip) = 003b03ddc4dd9618b48370e2aaf339c12c3384963f142f1f97110d6ed74f45aa7477477f53bc8b24b6d9f473b899ecb5d13889f52b8cd4fbdce2e6e5fa24502f
Size (sqlite-src-3500400.zip) = 14393367 bytes
@


1.3
log
@sqlite3-diff: update checksums to current version.
@
text
@d1 1
a1 1
$NetBSD: distinfo,v 1.2 2025/07/04 14:53:28 schmonz Exp $
d3 3
a5 3
BLAKE2s (sqlite-src-3500300.zip) = 8426aec9c768c5c4db1ed004cf719799df84aa4fcdba8dbb8a0428519b937ce4
SHA512 (sqlite-src-3500300.zip) = b09293191341df781353d1f76e7280b806e79ec79857e6ab881e4a0a2311ae8d524c2a918f1beeb007b487cc5615ad5c5ca96e2657c1e9853b2e727f637bcb5f
Size (sqlite-src-3500300.zip) = 14393097 bytes
@


1.2
log
@sqlite3-diff: regen distinfo after sqlite3 update.
@
text
@d1 1
a1 1
$NetBSD: distinfo,v 1.1 2025/05/20 16:46:24 schmonz Exp $
d3 3
a5 3
BLAKE2s (sqlite-src-3500200.zip) = a01f558e178109b676ca9fb0809b4ff0518d1e61ede6160ae6145ef734c16269
SHA512 (sqlite-src-3500200.zip) = 827c78b2bfd823626cdae6a88fff882cbd90430babfab6c6fd224cf05c8764b43499184a4f07293fb00bfcbbaedfec958d1afbfe4431ea9b24b189c561213e7d
Size (sqlite-src-3500200.zip) = 14392422 bytes
@


1.1
log
@Add sqlite3-diff: Display content differences between SQLite databases

sqldiff is a command-line utility program that displays content
differences between SQLite databases. The usual output is an SQL script
that will transform the source database into the destination database.

The sqldiff utility works by finding rows in the source and destination
that are logical "pairs". The default behavior is to treat two rows as
pairs if they are in tables with the same name and they have the same
rowid, or in the case of a WITHOUT ROWID table if they have the same
PRIMARY KEY. Any differences in the content of paired rows are output as
UPDATEs. Rows in the source database that could not be paired are output
as DELETEs. Rows in the destination database that could not be paired
are output as INSERTs.
@
text
@d1 1
a1 1
$NetBSD$
d3 3
a5 3
BLAKE2s (sqlite-src-3490200.zip) = ff6662bea8f3eec66a72cefe46f011f81fb9ea6780ff389ebf4f186f0186c382
SHA512 (sqlite-src-3490200.zip) = d07600391df9fd635b1d43cff208021450a18cedad67221e239b0ed86ef287f2f31c040ac413c8a69123615f01658b68f26b6e70a71da39be3ead372a13c8bdc
Size (sqlite-src-3490200.zip) = 14377708 bytes
@