CVS commit: pkgsrc

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

Module Name:    pkgsrc
Committed By:   adam
Date:           Wed Jan 17 08:24:19 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.45.0

SQLite Release 3.45.0 On 2024-01-15

Added the SQLITE_RESULT_SUBTYPE property for application-defined SQL functions. All application defined SQL functions that invokes sqlite3_result_subtype() must be registered with this new property. 
Failure to do so might cause the call to sqlite3_result_subtype() to behave as a no-op. Compile with -DSQLITE_STRICT_SUBTYPE=1 to cause an SQL error to be raised if a function that is not 
SQLITE_RESULT_SUBTYPE tries invokes sqlite3_result_subtype(). The use of -DSQLITE_STRICT_SUBTYPE=1 is a recommended compile-time option for every application that makes use of subtypes.
Enhancements to the JSON SQL functions:
All JSON functions are rewritten to use a new internal parse tree format called JSONB. The new parse-tree format is serializable and hence can be stored in the database to avoid unnecessary 
re-parsing whenever the JSON value is used.
New versions of JSON-generating functions generate binary JSONB instead of JSON text.
The json_valid() function adds an optional second argument that specifies what it means for the first argument to be "well-formed".
Add the FTS5 tokendata option to the FTS5 virtual table.
The SQLITE_DIRECT_OVERFLOW_READ optimization is now enabled by default. Disable it at compile-time using -DSQLITE_DIRECT_OVERFLOW_READ=0.
Query planner improvements:
Do not allow the transitive constraint optimization to trick the query planner into using a range constraint when a better equality constraint is available. (Forum post 2568d1f6e6.)
The query planner now does a better job of disregarding indexes that ANALYZE identifies as low-quality. (Forum post 6f0958b03b.)
Increase the default value for SQLITE_MAX_PAGE_COUNT from 1073741824 to 4294967294.
Enhancements to the CLI:
Improvements to the display of UTF-8 content on Windows
Automatically detect playback of ".dump" scripts and make appropriate changes to settings such as ".dbconfig defensive off" and ".dbconfig dqs_dll on".


To generate a diff of this commit:
cvs rdiff -u -r1.106 -r1.107 pkgsrc/databases/sqlite3/Makefile.common
cvs rdiff -u -r1.200 -r1.201 pkgsrc/databases/sqlite3/distinfo
cvs rdiff -u -r1.129 -r1.130 pkgsrc/databases/sqlite3-docs/PLIST
cvs rdiff -u -r1.132 -r1.133 pkgsrc/databases/sqlite3-docs/distinfo
cvs rdiff -u -r1.146 -r1.147 pkgsrc/databases/sqlite3-tcl/distinfo
cvs rdiff -u -r1.73 -r1.74 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.106 pkgsrc/databases/sqlite3/Makefile.common:1.107
--- pkgsrc/databases/sqlite3/Makefile.common:1.106      Sat Nov 25 21:07:38 2023
+++ pkgsrc/databases/sqlite3/Makefile.common    Wed Jan 17 08:24:18 2024
@@ -1,15 +1,15 @@
-# $NetBSD: Makefile.common,v 1.106 2023/11/25 21:07:38 adam Exp $
+# $NetBSD: Makefile.common,v 1.107 2024/01/17 08:24:18 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=   3440200
-SQLITE3_VERSION=       3.44.2
+SQLITE3_DISTVERSION=   3450000
+SQLITE3_VERSION=       3.45.0
 
-MASTER_SITES=  http://www.sqlite.org/2023/
-MASTER_SITES+= http://www.hwaci.com/sw/sqlite/2023/
+MASTER_SITES=  http://www.sqlite.org/2024/
+MASTER_SITES+= http://www.hwaci.com/sw/sqlite/2024/
 
 HOMEPAGE?=     http://www.sqlite.org/
 LICENSE=       public-domain

Index: pkgsrc/databases/sqlite3/distinfo
diff -u pkgsrc/databases/sqlite3/distinfo:1.200 pkgsrc/databases/sqlite3/distinfo:1.201
--- pkgsrc/databases/sqlite3/distinfo:1.200     Sat Nov 25 21:07:38 2023
+++ pkgsrc/databases/sqlite3/distinfo   Wed Jan 17 08:24:18 2024
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.200 2023/11/25 21:07:38 adam Exp $
+$NetBSD: distinfo,v 1.201 2024/01/17 08:24:18 adam Exp $
 
-BLAKE2s (sqlite-autoconf-3440200.tar.gz) = 0c9565e28fb64d17d7b02d8821df12de34858eed1a0647c92c3e5ff10898d1d9
-SHA512 (sqlite-autoconf-3440200.tar.gz) = 59ad55df15eb84430f5286db2e5ceddd6ca1fc207a6343546a365c0c1baf20258e96c53d2ad48b50385608d03de09a692ae834cb78a39d1a48cb36a05722e402
-Size (sqlite-autoconf-3440200.tar.gz) = 3204841 bytes
+BLAKE2s (sqlite-autoconf-3450000.tar.gz) = eb87bf6e9b934006ce01ee97463ac6db34b5dc86b8da9c8cf0824104dc539c1e
+SHA512 (sqlite-autoconf-3450000.tar.gz) = 40ae9ba1dea234aacfecf44a6b1c0713c24348d8d475503c11f1d92ed2fffb54a765bbd0669f39aa09d20f42cbcfac4dedcf7e64f4421b8762eebfc66399aa9a
+Size (sqlite-autoconf-3450000.tar.gz) = 3231697 bytes
 SHA1 (patch-configure) = c0aa83bddc20d090b3cd2fd840ac69031f4396e4

Index: pkgsrc/databases/sqlite3-docs/PLIST
diff -u pkgsrc/databases/sqlite3-docs/PLIST:1.129 pkgsrc/databases/sqlite3-docs/PLIST:1.130
--- pkgsrc/databases/sqlite3-docs/PLIST:1.129   Sat Nov 25 21:07:38 2023
+++ pkgsrc/databases/sqlite3-docs/PLIST Wed Jan 17 08:24:19 2024
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.129 2023/11/25 21:07:38 adam Exp $
+@comment $NetBSD: PLIST,v 1.130 2024/01/17 08:24:19 adam Exp $
 share/doc/sqlite3/34to35.html
 share/doc/sqlite3/35to36.html
 share/doc/sqlite3/about.html
@@ -485,6 +485,7 @@ share/doc/sqlite3/intern-v-extern-blob.h
 share/doc/sqlite3/invalidutf.html
 share/doc/sqlite3/isolation.html
 share/doc/sqlite3/json1.html
+share/doc/sqlite3/jsonb.html
 share/doc/sqlite3/keyword_index.html
 share/doc/sqlite3/lang.html
 share/doc/sqlite3/lang_aggfunc.html
@@ -689,6 +690,7 @@ share/doc/sqlite3/releaselog/3_43_2.html
 share/doc/sqlite3/releaselog/3_44_0.html
 share/doc/sqlite3/releaselog/3_44_1.html
 share/doc/sqlite3/releaselog/3_44_2.html
+share/doc/sqlite3/releaselog/3_45_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

Index: pkgsrc/databases/sqlite3-docs/distinfo
diff -u pkgsrc/databases/sqlite3-docs/distinfo:1.132 pkgsrc/databases/sqlite3-docs/distinfo:1.133
--- pkgsrc/databases/sqlite3-docs/distinfo:1.132        Sat Nov 25 21:07:38 2023
+++ pkgsrc/databases/sqlite3-docs/distinfo      Wed Jan 17 08:24:19 2024
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.132 2023/11/25 21:07:38 adam Exp $
+$NetBSD: distinfo,v 1.133 2024/01/17 08:24:19 adam Exp $
 
-BLAKE2s (sqlite-doc-3440200.zip) = 147e8264e026cf73e9ec94958cecddcb5d7ee3a154c68aabbe3ff800d43cfd11
-SHA512 (sqlite-doc-3440200.zip) = a7c92af0d3a61a2450511cfb507785c7ab64c21c6dbcf5a8bdef509d25a6b3ca35ce93a25ca827497c27abca77d11b794fbbc783e4d8e131981bf1d4b29f83e8
-Size (sqlite-doc-3440200.zip) = 10704552 bytes
+BLAKE2s (sqlite-doc-3450000.zip) = c56c0ff4c50681a1c527611b315c208da3e325c1d766d2ccdee3ac1339263c2c
+SHA512 (sqlite-doc-3450000.zip) = a92b7967c77a1f3e923099051bd88a58591e17bdf891f1533fa9e81b483fc05b6c4c7a66fb9399c3a76abf3c446bb02a93fd11a9e5c9b3171a58f65698217b68
+Size (sqlite-doc-3450000.zip) = 10760211 bytes

Index: pkgsrc/databases/sqlite3-tcl/distinfo
diff -u pkgsrc/databases/sqlite3-tcl/distinfo:1.146 pkgsrc/databases/sqlite3-tcl/distinfo:1.147
--- pkgsrc/databases/sqlite3-tcl/distinfo:1.146 Sat Nov 25 21:07:39 2023
+++ pkgsrc/databases/sqlite3-tcl/distinfo       Wed Jan 17 08:24:19 2024
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.146 2023/11/25 21:07:39 adam Exp $
+$NetBSD: distinfo,v 1.147 2024/01/17 08:24:19 adam Exp $
 
-BLAKE2s (sqlite-autoconf-3440200.tar.gz) = 0c9565e28fb64d17d7b02d8821df12de34858eed1a0647c92c3e5ff10898d1d9
-SHA512 (sqlite-autoconf-3440200.tar.gz) = 59ad55df15eb84430f5286db2e5ceddd6ca1fc207a6343546a365c0c1baf20258e96c53d2ad48b50385608d03de09a692ae834cb78a39d1a48cb36a05722e402
-Size (sqlite-autoconf-3440200.tar.gz) = 3204841 bytes
+BLAKE2s (sqlite-autoconf-3450000.tar.gz) = eb87bf6e9b934006ce01ee97463ac6db34b5dc86b8da9c8cf0824104dc539c1e
+SHA512 (sqlite-autoconf-3450000.tar.gz) = 40ae9ba1dea234aacfecf44a6b1c0713c24348d8d475503c11f1d92ed2fffb54a765bbd0669f39aa09d20f42cbcfac4dedcf7e64f4421b8762eebfc66399aa9a
+Size (sqlite-autoconf-3450000.tar.gz) = 3231697 bytes
 SHA1 (patch-Makefile.in) = 8f68039c9169bc69eb0da4bd0f910c7584aed2b5

Index: pkgsrc/devel/lemon/distinfo
diff -u pkgsrc/devel/lemon/distinfo:1.73 pkgsrc/devel/lemon/distinfo:1.74
--- pkgsrc/devel/lemon/distinfo:1.73    Sat Nov 25 21:07:39 2023
+++ pkgsrc/devel/lemon/distinfo Wed Jan 17 08:24:19 2024
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.73 2023/11/25 21:07:39 adam Exp $
+$NetBSD: distinfo,v 1.74 2024/01/17 08:24:19 adam Exp $
 
-BLAKE2s (sqlite-src-3440200.zip) = 49fb2e3ed4283fde2db20c41e5d945f2b57425612a30444ecbdacaf76701a9d3
-SHA512 (sqlite-src-3440200.zip) = 5c1fed9c399dad75735a1b4451f8f6be474b07652d74500649e60474691923f56156ef6d5bce51b58367c1676371f1184e32584fe9ac4d5dd0c4776fa6f1d9a3
-Size (sqlite-src-3440200.zip) = 14070781 bytes
+BLAKE2s (sqlite-src-3450000.zip) = 51d5cfd05a3cd98f3d8ecc63f922b479b7ec32d4796011fb990b1162a5d60d53
+SHA512 (sqlite-src-3450000.zip) = ae5152bf00d6fa69dad3e41eb07052277481c48e0c63da1081767f3c76ce026615e96760355b6e75d689588059c106add5e9066e6dcbab60e36996ec76ef2874
+Size (sqlite-src-3450000.zip) = 14148978 bytes