CVS commit: pkgsrc

To: pkgsrc-changes%NetBSD.org@localhost
Subject: CVS commit: pkgsrc
From: "Adam Ciarcinski" <adam%netbsd.org@localhost>
Date: Fri, 24 May 2024 04:48:54 +0000

Module Name:    pkgsrc
Committed By:   adam
Date:           Fri May 24 04:48:54 UTC 2024

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.46.0

SQLite Release 3.46.0 On 2024-05-23

Enhance PRAGMA optimize in multiple ways, to make it simpler to use:
PRAGMA optimize automatically implements a temporary analysis limit to prevent excess runtime on large databases.
Added the new 0x10000 bitmask option to check for updates on all tables.
Automatically re-analyze tables that do not have sqlite_stat1 entries.
Enhancements to the date and time functions:
The strftime() SQL function now supports %G, %g, %U, and %V.
New modifiers 'ceiling' and 'floor' control the algorithm used to resolve ambiguous dates when shifting a date by an integer number of months and/or years.
The 'utc' and 'localtime' modifiers are now no-ops if SQLite knows that the time is already in UTC or in the localtime, respectively.
Add support for underscore ("_") characters between digits in numeric literals.
Add the json_pretty() SQL function.
Query planner improvements:
The "VALUES-as-coroutine" optimization enables INSERT statements with thousands of rows in the VALUES clause to parse and run in about half the time and using about half as much memory.
Allow the use of an index for queries like "SELECT count(DISTINCT col) FROM ...", even if the index records are not smaller than the table records.
Improved recognition of cases where the value of an SQL function is constant because all its arguments are constant.
Enhance the WHERE-clause push-down optimization so that it is able to push down WHERE clause terms containing uncorrelated subqueries.
Allocate additional memory from the heap for the SQL parser stack if that stack overflows, rather than reporting a "parser stack overflow" error.
JSON changes:
Allow ASCII control characters within JSON5 string literals.
Fix the -> and ->> operators so that when the right-hand side operand is a string that looks like an integer it is still treated as a string, because that is what PostgreSQL does.
Allow large hexadecimal literals to be used as the DEFAULT value to a table column.


To generate a diff of this commit:
cvs rdiff -u -r1.110 -r1.111 pkgsrc/databases/sqlite3/Makefile.common
cvs rdiff -u -r1.204 -r1.205 pkgsrc/databases/sqlite3/distinfo
cvs rdiff -u -r1.133 -r1.134 pkgsrc/databases/sqlite3-docs/PLIST
cvs rdiff -u -r1.136 -r1.137 pkgsrc/databases/sqlite3-docs/distinfo
cvs rdiff -u -r1.150 -r1.151 pkgsrc/databases/sqlite3-tcl/distinfo
cvs rdiff -u -r1.77 -r1.78 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.110 pkgsrc/databases/sqlite3/Makefile.common:1.111
--- pkgsrc/databases/sqlite3/Makefile.common:1.110      Mon Apr 15 16:43:56 2024
+++ pkgsrc/databases/sqlite3/Makefile.common    Fri May 24 04:48:54 2024
@@ -1,12 +1,12 @@
-# $NetBSD: Makefile.common,v 1.110 2024/04/15 16:43:56 adam Exp $
+# $NetBSD: Makefile.common,v 1.111 2024/05/24 04:48:54 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=   3450300
-SQLITE3_VERSION=       3.45.3
+SQLITE3_DISTVERSION=   3460000
+SQLITE3_VERSION=       3.46.0
 
 MASTER_SITES=  http://www.sqlite.org/2024/
 MASTER_SITES+= http://www.hwaci.com/sw/sqlite/2024/

Index: pkgsrc/databases/sqlite3/distinfo
diff -u pkgsrc/databases/sqlite3/distinfo:1.204 pkgsrc/databases/sqlite3/distinfo:1.205
--- pkgsrc/databases/sqlite3/distinfo:1.204     Mon Apr 15 16:43:56 2024
+++ pkgsrc/databases/sqlite3/distinfo   Fri May 24 04:48:54 2024
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.204 2024/04/15 16:43:56 adam Exp $
+$NetBSD: distinfo,v 1.205 2024/05/24 04:48:54 adam Exp $
 
-BLAKE2s (sqlite-autoconf-3450300.tar.gz) = 71d26f767a08f8d4405feaaf06aecf6acedf3f9dcf2d3d9bbede465b0d254cc0
-SHA512 (sqlite-autoconf-3450300.tar.gz) = ab4bb99186ccf81d288bc5150dacd5f8a32561303fbc0c607c24b5bb5ad44e0974655cea57d05122c62e957329f5260d170d2a71cbcf818501af29903c99a391
-Size (sqlite-autoconf-3450300.tar.gz) = 3235957 bytes
+BLAKE2s (sqlite-autoconf-3460000.tar.gz) = b86a0af97649f4bae134d60c4cabb63b5692f6cd83c672400c84bdfd6f21ed8e
+SHA512 (sqlite-autoconf-3460000.tar.gz) = 631ffe4b39dffbafdcb8ac09a6a84cd7959505ecc588d8ad9278d0ff0c3ea467f87c11167e1b1a3f56d62178e679780e2be313ae3badae8ea056709d71bd4817
+Size (sqlite-autoconf-3460000.tar.gz) = 3265248 bytes
 SHA1 (patch-configure) = c0aa83bddc20d090b3cd2fd840ac69031f4396e4

Index: pkgsrc/databases/sqlite3-docs/PLIST
diff -u pkgsrc/databases/sqlite3-docs/PLIST:1.133 pkgsrc/databases/sqlite3-docs/PLIST:1.134
--- pkgsrc/databases/sqlite3-docs/PLIST:1.133   Mon Apr 15 16:43:57 2024
+++ pkgsrc/databases/sqlite3-docs/PLIST Fri May 24 04:48:54 2024
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.133 2024/04/15 16:43:57 adam Exp $
+@comment $NetBSD: PLIST,v 1.134 2024/05/24 04:48:54 adam Exp $
 share/doc/sqlite3/34to35.html
 share/doc/sqlite3/35to36.html
 share/doc/sqlite3/about.html
@@ -693,6 +693,7 @@ share/doc/sqlite3/releaselog/3_45_0.html
 share/doc/sqlite3/releaselog/3_45_1.html
 share/doc/sqlite3/releaselog/3_45_2.html
 share/doc/sqlite3/releaselog/3_45_3.html
+share/doc/sqlite3/releaselog/3_46_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
@@ -828,6 +829,7 @@ share/doc/sqlite3/session/objlist.html
 share/doc/sqlite3/session/rebaser.html
 share/doc/sqlite3/session/session.html
 share/doc/sqlite3/session/sqlite3changegroup_add.html
+share/doc/sqlite3/session/sqlite3changegroup_add_change.html
 share/doc/sqlite3/session/sqlite3changegroup_add_strm.html
 share/doc/sqlite3/session/sqlite3changegroup_delete.html
 share/doc/sqlite3/session/sqlite3changegroup_new.html
@@ -974,6 +976,7 @@ share/doc/sqlite3/vtablist.html
 share/doc/sqlite3/wal.html
 share/doc/sqlite3/walformat.html
 share/doc/sqlite3/whentouse.html
+share/doc/sqlite3/whybytecode.html
 share/doc/sqlite3/whyc.html
 share/doc/sqlite3/whynotgit.html
 share/doc/sqlite3/windowfunctions.html

Index: pkgsrc/databases/sqlite3-docs/distinfo
diff -u pkgsrc/databases/sqlite3-docs/distinfo:1.136 pkgsrc/databases/sqlite3-docs/distinfo:1.137
--- pkgsrc/databases/sqlite3-docs/distinfo:1.136        Mon Apr 15 16:43:57 2024
+++ pkgsrc/databases/sqlite3-docs/distinfo      Fri May 24 04:48:54 2024
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.136 2024/04/15 16:43:57 adam Exp $
+$NetBSD: distinfo,v 1.137 2024/05/24 04:48:54 adam Exp $
 
-BLAKE2s (sqlite-doc-3450300.zip) = ed3cef0b24f2aa93a378f2a807971f1ccb0bb0907dcfd1d201d008825db8f979
-SHA512 (sqlite-doc-3450300.zip) = 8f865302137684c31c4f54d6cbe4ee82126394887930ec50501fb811023bc612878d2dc1c2317e960fe818a277b008a9835475e7a47822fc5ece5fe37aa61e31
-Size (sqlite-doc-3450300.zip) = 10759906 bytes
+BLAKE2s (sqlite-doc-3460000.zip) = 8b733173b6004d3094cbb537a1038f9702c3f8fa84b89252b03cc3e7f558d28c
+SHA512 (sqlite-doc-3460000.zip) = 22748bf113ff96320c90227ba104ff081bf1761550944afbc78b6768d6677b13982d7e759c5f67eb7ba7ed0dcbffee500bc39fc9929d28f86b2a269145fefebd
+Size (sqlite-doc-3460000.zip) = 10842823 bytes

Index: pkgsrc/databases/sqlite3-tcl/distinfo
diff -u pkgsrc/databases/sqlite3-tcl/distinfo:1.150 pkgsrc/databases/sqlite3-tcl/distinfo:1.151
--- pkgsrc/databases/sqlite3-tcl/distinfo:1.150 Mon Apr 15 16:43:57 2024
+++ pkgsrc/databases/sqlite3-tcl/distinfo       Fri May 24 04:48:54 2024
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.150 2024/04/15 16:43:57 adam Exp $
+$NetBSD: distinfo,v 1.151 2024/05/24 04:48:54 adam Exp $
 
-BLAKE2s (sqlite-autoconf-3450300.tar.gz) = 71d26f767a08f8d4405feaaf06aecf6acedf3f9dcf2d3d9bbede465b0d254cc0
-SHA512 (sqlite-autoconf-3450300.tar.gz) = ab4bb99186ccf81d288bc5150dacd5f8a32561303fbc0c607c24b5bb5ad44e0974655cea57d05122c62e957329f5260d170d2a71cbcf818501af29903c99a391
-Size (sqlite-autoconf-3450300.tar.gz) = 3235957 bytes
+BLAKE2s (sqlite-autoconf-3460000.tar.gz) = b86a0af97649f4bae134d60c4cabb63b5692f6cd83c672400c84bdfd6f21ed8e
+SHA512 (sqlite-autoconf-3460000.tar.gz) = 631ffe4b39dffbafdcb8ac09a6a84cd7959505ecc588d8ad9278d0ff0c3ea467f87c11167e1b1a3f56d62178e679780e2be313ae3badae8ea056709d71bd4817
+Size (sqlite-autoconf-3460000.tar.gz) = 3265248 bytes
 SHA1 (patch-Makefile.in) = 8f68039c9169bc69eb0da4bd0f910c7584aed2b5

Index: pkgsrc/devel/lemon/distinfo
diff -u pkgsrc/devel/lemon/distinfo:1.77 pkgsrc/devel/lemon/distinfo:1.78
--- pkgsrc/devel/lemon/distinfo:1.77    Mon Apr 15 16:43:57 2024
+++ pkgsrc/devel/lemon/distinfo Fri May 24 04:48:54 2024
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.77 2024/04/15 16:43:57 adam Exp $
+$NetBSD: distinfo,v 1.78 2024/05/24 04:48:54 adam Exp $
 
-BLAKE2s (sqlite-src-3450300.zip) = 19ad93aa02a5e8ce54af1fec4a902b7c450653f942ea61ec6a9e354609ba24b1
-SHA512 (sqlite-src-3450300.zip) = 8f44ffdefd2cf09e7edb7cd78d5416fe7b42e01fe4b4e4803ce9d34c7b1b2971ec170a908a94b4bb11737dd3888675c8ff101ff2b41c53b8db05b5954e947cc9
-Size (sqlite-src-3450300.zip) = 14160555 bytes
+BLAKE2s (sqlite-src-3460000.zip) = 3627bf75e3882b7192f2d376d879f48b652623534d641ab850d7c3fe72091341
+SHA512 (sqlite-src-3460000.zip) = 441c51943e77655652409965b831df5af8662b4c585134be7fcd9bb5755a495170f37bd6510a80c18c42de72dda23536b583e84e58f042d342dd9e4139ae3327
+Size (sqlite-src-3460000.zip) = 14275927 bytes

Prev by Date: CVS commit: pkgsrc/math/liblbfgs
Next by Date: CVS commit: pkgsrc/databases/py-apsw
Previous by Thread: CVS commit: pkgsrc/math/liblbfgs
Next by Thread: CVS commit: pkgsrc/databases/py-apsw
Indexes:

Home | Main Index | Thread Index | Old Index