CVS commit: pkgsrc

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

Module Name:    pkgsrc
Committed By:   adam
Date:           Wed Mar 11 10:56:03 UTC 2026

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:
sqlite3: updated to 3.52.0

3.52.0

Fix the WAL-reset database corruption bug.
Enhance ALTER TABLE to permit adding and removing NOT NULL and CHECK constraints.
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 built-in SQL functions: json_array_insert(), and 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 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.
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 8b 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.
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.
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.
Add the "-p|--port" option to sqlite3_rsync.
Discontinue support for Windows RT.


To generate a diff of this commit:
cvs rdiff -u -r1.127 -r1.128 pkgsrc/databases/sqlite3/Makefile.common
cvs rdiff -u -r1.219 -r1.220 pkgsrc/databases/sqlite3/distinfo
cvs rdiff -u -r1.147 -r1.148 pkgsrc/databases/sqlite3-docs/PLIST
cvs rdiff -u -r1.150 -r1.151 pkgsrc/databases/sqlite3-docs/distinfo
cvs rdiff -u -r1.164 -r1.165 pkgsrc/databases/sqlite3-tcl/distinfo
cvs rdiff -u -r1.91 -r1.92 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.127 pkgsrc/databases/sqlite3/Makefile.common:1.128
--- pkgsrc/databases/sqlite3/Makefile.common:1.127      Tue Feb 10 08:05:50 2026
+++ pkgsrc/databases/sqlite3/Makefile.common    Wed Mar 11 10:56:03 2026
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.127 2026/02/10 08:05:50 wiz Exp $
+# $NetBSD: Makefile.common,v 1.128 2026/03/11 10:56:03 adam Exp $
 #
 # used by databases/sqlite3/Makefile
 # used by databases/sqlite3-diff/Makefile -- please `bmake makesum` there
@@ -6,8 +6,8 @@
 # used by databases/sqlite3-tcl/Makefile
 # used by devel/lemon/Makefile
 
-SQLITE3_DISTVERSION=   3510200
-SQLITE3_VERSION=       3.51.2
+SQLITE3_DISTVERSION=   3520000
+SQLITE3_VERSION=       3.52.0
 
 MASTER_SITES=  https://www.sqlite.org/2026/
 

Index: pkgsrc/databases/sqlite3/distinfo
diff -u pkgsrc/databases/sqlite3/distinfo:1.219 pkgsrc/databases/sqlite3/distinfo:1.220
--- pkgsrc/databases/sqlite3/distinfo:1.219     Sat Jan 10 17:04:27 2026
+++ pkgsrc/databases/sqlite3/distinfo   Wed Mar 11 10:56:03 2026
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.219 2026/01/10 17:04:27 adam Exp $
+$NetBSD: distinfo,v 1.220 2026/03/11 10:56:03 adam Exp $
 
-BLAKE2s (sqlite-autoconf-3510200.tar.gz) = 7c1ca0bcd2b537605eafd580293f32ce7641d0994ae2af3dff72af460f214084
-SHA512 (sqlite-autoconf-3510200.tar.gz) = 0f59037e537543154711fdfa5707592658121e8b0973eb07396a9fb980e6c0c822717d0a787c564ebd6bf7383a3388f128fce6adbbf98b417909855d42ac8710
-Size (sqlite-autoconf-3510200.tar.gz) = 3208444 bytes
+BLAKE2s (sqlite-autoconf-3520000.tar.gz) = 80e69febf07ee42ac4bf90ce0d1ba5254788c8ed132ac0aba29557057131dd97
+SHA512 (sqlite-autoconf-3520000.tar.gz) = 2e0f5f4e1caa02bd947badbff171532b6368cbddbfc2091bad532c453dc3ff9f505bae663613884361b4d6eca9d4a87423538271efae1794e47fbf93b581d2fb
+Size (sqlite-autoconf-3520000.tar.gz) = 3258980 bytes
 SHA1 (patch-autosetup_proj.tcl) = b0e8241e57e82a1dadd721a64128f62e7409f600

Index: pkgsrc/databases/sqlite3-docs/PLIST
diff -u pkgsrc/databases/sqlite3-docs/PLIST:1.147 pkgsrc/databases/sqlite3-docs/PLIST:1.148
--- pkgsrc/databases/sqlite3-docs/PLIST:1.147   Sat Jan 10 17:04:27 2026
+++ pkgsrc/databases/sqlite3-docs/PLIST Wed Mar 11 10:56:03 2026
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.147 2026/01/10 17:04:27 adam Exp $
+@comment $NetBSD: PLIST,v 1.148 2026/03/11 10:56:03 adam Exp $
 share/doc/sqlite3/34to35.html
 share/doc/sqlite3/35to36.html
 share/doc/sqlite3/about.html
@@ -10,7 +10,6 @@ share/doc/sqlite3/appfileformat.html
 share/doc/sqlite3/appfunc.html
 share/doc/sqlite3/arch.html
 share/doc/sqlite3/assert.html
-share/doc/sqlite3/asyncvfs.html
 share/doc/sqlite3/atomiccommit.html
 share/doc/sqlite3/autoinc.html
 share/doc/sqlite3/backup.html
@@ -247,6 +246,7 @@ share/doc/sqlite3/chronology.html
 share/doc/sqlite3/cintro.html
 share/doc/sqlite3/cksumvfs.html
 share/doc/sqlite3/cli.html
+share/doc/sqlite3/climode.html
 share/doc/sqlite3/codeofconduct.html
 share/doc/sqlite3/codeofethics.html
 share/doc/sqlite3/compile.html
@@ -723,6 +723,7 @@ share/doc/sqlite3/releaselog/3_50_4.html
 share/doc/sqlite3/releaselog/3_51_0.html
 share/doc/sqlite3/releaselog/3_51_1.html
 share/doc/sqlite3/releaselog/3_51_2.html
+share/doc/sqlite3/releaselog/3_52_0.html
 share/doc/sqlite3/releaselog/3_5_0.html
 share/doc/sqlite3/releaselog/3_5_1.html
 share/doc/sqlite3/releaselog/3_5_2.html
@@ -979,6 +980,7 @@ share/doc/sqlite3/syntax/window-defn.htm
 share/doc/sqlite3/syntax/window-function-invocation.html
 share/doc/sqlite3/syntax/with-clause.html
 share/doc/sqlite3/syntaxdiagrams.html
+share/doc/sqlite3/tcljson.html
 share/doc/sqlite3/tclsqlite.html
 share/doc/sqlite3/tempfiles.html
 share/doc/sqlite3/testing.html

Index: pkgsrc/databases/sqlite3-docs/distinfo
diff -u pkgsrc/databases/sqlite3-docs/distinfo:1.150 pkgsrc/databases/sqlite3-docs/distinfo:1.151
--- pkgsrc/databases/sqlite3-docs/distinfo:1.150        Sat Jan 10 17:04:27 2026
+++ pkgsrc/databases/sqlite3-docs/distinfo      Wed Mar 11 10:56:03 2026
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.150 2026/01/10 17:04:27 adam Exp $
+$NetBSD: distinfo,v 1.151 2026/03/11 10:56:03 adam Exp $
 
-BLAKE2s (sqlite-doc-3510200.zip) = e3685b35b86ba0537d37e37466bf21382ed66f766b2321ead893044b21c78d85
-SHA512 (sqlite-doc-3510200.zip) = 7f6151f61748c6b9c081be5b52755f963a913009864e667cadd014744d14009f28e8ff61e940e971f9db69144106a51e87e88c25a12d5b157decc58178e63d59
-Size (sqlite-doc-3510200.zip) = 11620595 bytes
+BLAKE2s (sqlite-doc-3520000.zip) = 9aeadecad32bd2d442a717bd68d188e130ab54e0f3e70f0609cc0bad7d2f24ab
+SHA512 (sqlite-doc-3520000.zip) = ea4041ad1274dba0fd4a57b65f646ef3cf7a89bad81c12adbccff70d84b7659d01b1f2d5be6a7ee6e84470c133fac3db867c33c6686eb6822c71d68e797d8e21
+Size (sqlite-doc-3520000.zip) = 11732964 bytes

Index: pkgsrc/databases/sqlite3-tcl/distinfo
diff -u pkgsrc/databases/sqlite3-tcl/distinfo:1.164 pkgsrc/databases/sqlite3-tcl/distinfo:1.165
--- pkgsrc/databases/sqlite3-tcl/distinfo:1.164 Sat Jan 10 17:04:27 2026
+++ pkgsrc/databases/sqlite3-tcl/distinfo       Wed Mar 11 10:56:03 2026
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.164 2026/01/10 17:04:27 adam Exp $
+$NetBSD: distinfo,v 1.165 2026/03/11 10:56:03 adam Exp $
 
-BLAKE2s (sqlite-autoconf-3510200.tar.gz) = 7c1ca0bcd2b537605eafd580293f32ce7641d0994ae2af3dff72af460f214084
-SHA512 (sqlite-autoconf-3510200.tar.gz) = 0f59037e537543154711fdfa5707592658121e8b0973eb07396a9fb980e6c0c822717d0a787c564ebd6bf7383a3388f128fce6adbbf98b417909855d42ac8710
-Size (sqlite-autoconf-3510200.tar.gz) = 3208444 bytes
+BLAKE2s (sqlite-autoconf-3520000.tar.gz) = 80e69febf07ee42ac4bf90ce0d1ba5254788c8ed132ac0aba29557057131dd97
+SHA512 (sqlite-autoconf-3520000.tar.gz) = 2e0f5f4e1caa02bd947badbff171532b6368cbddbfc2091bad532c453dc3ff9f505bae663613884361b4d6eca9d4a87423538271efae1794e47fbf93b581d2fb
+Size (sqlite-autoconf-3520000.tar.gz) = 3258980 bytes

Index: pkgsrc/devel/lemon/distinfo
diff -u pkgsrc/devel/lemon/distinfo:1.91 pkgsrc/devel/lemon/distinfo:1.92
--- pkgsrc/devel/lemon/distinfo:1.91    Sat Jan 10 17:04:27 2026
+++ pkgsrc/devel/lemon/distinfo Wed Mar 11 10:56:03 2026
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.91 2026/01/10 17:04:27 adam Exp $
+$NetBSD: distinfo,v 1.92 2026/03/11 10:56:03 adam Exp $
 
-BLAKE2s (sqlite-src-3510200.zip) = e78989e84a5125f41788476d404e0a0b1502b2fbbd2c5df53eb8debb841be6fa
-SHA512 (sqlite-src-3510200.zip) = 89e1c76d6cae41f2ececb85af2e8bfd5cf60e8b9e3d8a48f98f3913513762bc8846f6b5c28e76cca12505ce670cdaf6ca95ecb2267b9527e47929fb928847605
-Size (sqlite-src-3510200.zip) = 14202690 bytes
+BLAKE2s (sqlite-src-3520000.zip) = 67c231e82b0d8eacaa32211742facd03e8d4b0430bb932befe2d81b708101423
+SHA512 (sqlite-src-3520000.zip) = 178546508c78e2a271c5e72fb4e47af3860557c6692a6db79639f627d06e5222f52a9cbd7f522b8e7be81d899620419591ce7e1e66588b0f0c90e22de5598ca0
+Size (sqlite-src-3520000.zip) = 14346407 bytes