Wed Dec 28 22:26:07 2022 UTC ()
sqlite3: updated to 3.40.1

3.40.1 (2022-12-28):

Fix the --safe command-line option to the CLI such that it correctly disallows the use of SQL functions like writefile() that can cause harmful side-effects.
Fix a potential infinite loop in the memsys5 alternative memory allocator. This bug was introduced by a performance optimization in version 3.39.0.
Various other obscure fixes.


(adam)
diff -r1.148 -r1.149 pkgsrc/databases/sqlite3/Makefile
diff -r1.96 -r1.97 pkgsrc/databases/sqlite3/Makefile.common
diff -r1.189 -r1.190 pkgsrc/databases/sqlite3/distinfo
diff -r1.119 -r1.120 pkgsrc/databases/sqlite3-docs/PLIST
diff -r1.122 -r1.123 pkgsrc/databases/sqlite3-docs/distinfo
diff -r1.113 -r1.114 pkgsrc/databases/sqlite3-tcl/Makefile
diff -r1.134 -r1.135 pkgsrc/databases/sqlite3-tcl/distinfo
diff -r0 -r1.1 pkgsrc/databases/sqlite3-tcl/patches/patch-configure
diff -r1.63 -r1.64 pkgsrc/devel/lemon/distinfo

cvs diff -r1.148 -r1.149 pkgsrc/databases/sqlite3/Makefile (expand / switch to unified diff)

--- pkgsrc/databases/sqlite3/Makefile 2022/11/23 16:18:36 1.148
+++ pkgsrc/databases/sqlite3/Makefile 2022/12/28 22:26:06 1.149
@@ -1,16 +1,15 @@ @@ -1,16 +1,15 @@
1# $NetBSD: Makefile,v 1.148 2022/11/23 16:18:36 adam Exp $ 1# $NetBSD: Makefile,v 1.149 2022/12/28 22:26:06 adam Exp $
2 2
3PKGREVISION= 1 
4.include "Makefile.common" 3.include "Makefile.common"
5 4
6DISTNAME= sqlite-autoconf-${SQLITE3_DISTVERSION} 5DISTNAME= sqlite-autoconf-${SQLITE3_DISTVERSION}
7PKGNAME= sqlite3-${SQLITE3_VERSION} 6PKGNAME= sqlite3-${SQLITE3_VERSION}
8CATEGORIES= databases 7CATEGORIES= databases
9 8
10MAINTAINER= pkgsrc-users@NetBSD.org 9MAINTAINER= pkgsrc-users@NetBSD.org
11COMMENT= SQL Database Engine in a C Library 10COMMENT= SQL Database Engine in a C Library
12 11
13.include "options.mk" 12.include "options.mk"
14 13
15USE_LIBTOOL= yes 14USE_LIBTOOL= yes
16USE_TOOLS+= gmake 15USE_TOOLS+= gmake

cvs diff -r1.96 -r1.97 pkgsrc/databases/sqlite3/Makefile.common (expand / switch to unified diff)

--- pkgsrc/databases/sqlite3/Makefile.common 2022/11/17 06:20:44 1.96
+++ pkgsrc/databases/sqlite3/Makefile.common 2022/12/28 22:26:06 1.97
@@ -1,15 +1,15 @@ @@ -1,15 +1,15 @@
1# $NetBSD: Makefile.common,v 1.96 2022/11/17 06:20:44 adam Exp $ 1# $NetBSD: Makefile.common,v 1.97 2022/12/28 22:26:06 adam Exp $
2# 2#
3# used by databases/sqlite3/Makefile 3# used by databases/sqlite3/Makefile
4# used by databases/sqlite3-docs/Makefile 4# used by databases/sqlite3-docs/Makefile
5# used by databases/sqlite3-tcl/Makefile 5# used by databases/sqlite3-tcl/Makefile
6# used by devel/lemon/Makefile 6# used by devel/lemon/Makefile
7 7
8SQLITE3_DISTVERSION= 3400000 8SQLITE3_DISTVERSION= 3400100
9SQLITE3_VERSION= 3.40.0 9SQLITE3_VERSION= 3.40.1
10 10
11MASTER_SITES= http://www.sqlite.org/2022/ 11MASTER_SITES= http://www.sqlite.org/2022/
12MASTER_SITES+= http://www.hwaci.com/sw/sqlite/2022/ 12MASTER_SITES+= http://www.hwaci.com/sw/sqlite/2022/
13 13
14HOMEPAGE?= http://www.sqlite.org/ 14HOMEPAGE?= http://www.sqlite.org/
15LICENSE= public-domain 15LICENSE= public-domain

cvs diff -r1.189 -r1.190 pkgsrc/databases/sqlite3/distinfo (expand / switch to unified diff)

--- pkgsrc/databases/sqlite3/distinfo 2022/11/17 06:20:44 1.189
+++ pkgsrc/databases/sqlite3/distinfo 2022/12/28 22:26:06 1.190
@@ -1,6 +1,6 @@ @@ -1,6 +1,6 @@
1$NetBSD: distinfo,v 1.189 2022/11/17 06:20:44 adam Exp $ 1$NetBSD: distinfo,v 1.190 2022/12/28 22:26:06 adam Exp $
2 2
3BLAKE2s (sqlite-autoconf-3400000.tar.gz) = 378945cc6da267e3c5652afe62731904acc6d4a2154c0b2fb08355a5cbdced00 3BLAKE2s (sqlite-autoconf-3400100.tar.gz) = f46e011624666d90fc246a1687b3014f20e4db6ca4bc0ccbb360d82f53f2a97e
4SHA512 (sqlite-autoconf-3400000.tar.gz) = 175271e620dd947df2ca63c3ea6cff80e16f8f808a3ea7f6700282768adc2d61ac375d42b2064c73eec849c67307ac5291fdadc3059861caa015ac3ac7a480e4 4SHA512 (sqlite-autoconf-3400100.tar.gz) = 50ff85b40b0017a73b52988843ec439358a8dde7d5d012a33ecfdaa67006697692f091a62d5f052f64e6fee84e27251864d331f63039a326ae4d5bf4a4dd5a91
5Size (sqlite-autoconf-3400000.tar.gz) = 3097756 bytes 5Size (sqlite-autoconf-3400100.tar.gz) = 3098662 bytes
6SHA1 (patch-configure) = c0aa83bddc20d090b3cd2fd840ac69031f4396e4 6SHA1 (patch-configure) = c0aa83bddc20d090b3cd2fd840ac69031f4396e4

cvs diff -r1.119 -r1.120 pkgsrc/databases/sqlite3-docs/PLIST (expand / switch to unified diff)

--- pkgsrc/databases/sqlite3-docs/PLIST 2022/11/17 06:20:44 1.119
+++ pkgsrc/databases/sqlite3-docs/PLIST 2022/12/28 22:26:06 1.120
@@ -1,14 +1,14 @@ @@ -1,14 +1,14 @@
1@comment $NetBSD: PLIST,v 1.119 2022/11/17 06:20:44 adam Exp $ 1@comment $NetBSD: PLIST,v 1.120 2022/12/28 22:26:06 adam Exp $
2share/doc/sqlite3/34to35.html 2share/doc/sqlite3/34to35.html
3share/doc/sqlite3/35to36.html 3share/doc/sqlite3/35to36.html
4share/doc/sqlite3/about.html 4share/doc/sqlite3/about.html
5share/doc/sqlite3/aff_short.html 5share/doc/sqlite3/aff_short.html
6share/doc/sqlite3/affcase1.html 6share/doc/sqlite3/affcase1.html
7share/doc/sqlite3/amalgamation.html 7share/doc/sqlite3/amalgamation.html
8share/doc/sqlite3/appfileformat.html 8share/doc/sqlite3/appfileformat.html
9share/doc/sqlite3/appfunc.html 9share/doc/sqlite3/appfunc.html
10share/doc/sqlite3/arch.html 10share/doc/sqlite3/arch.html
11share/doc/sqlite3/assert.html 11share/doc/sqlite3/assert.html
12share/doc/sqlite3/asyncvfs.html 12share/doc/sqlite3/asyncvfs.html
13share/doc/sqlite3/atomiccommit.html 13share/doc/sqlite3/atomiccommit.html
14share/doc/sqlite3/autoinc.html 14share/doc/sqlite3/autoinc.html
@@ -329,26 +329,27 @@ share/doc/sqlite3/images/books/haldar2.j @@ -329,26 +329,27 @@ share/doc/sqlite3/images/books/haldar2.j
329share/doc/sqlite3/images/books/kreibich.gif 329share/doc/sqlite3/images/books/kreibich.gif
330share/doc/sqlite3/images/books/newman.jpg 330share/doc/sqlite3/images/books/newman.jpg
331share/doc/sqlite3/images/books/nishizawa2.jpg 331share/doc/sqlite3/images/books/nishizawa2.jpg
332share/doc/sqlite3/images/books/owens.jpg 332share/doc/sqlite3/images/books/owens.jpg
333share/doc/sqlite3/images/books/sanderson2018.jpg 333share/doc/sqlite3/images/books/sanderson2018.jpg
334share/doc/sqlite3/images/books/symbiansql.jpg 334share/doc/sqlite3/images/books/symbiansql.jpg
335share/doc/sqlite3/images/books/vanderLans.jpg 335share/doc/sqlite3/images/books/vanderLans.jpg
336share/doc/sqlite3/images/btreemodule_balance_deeper.svg 336share/doc/sqlite3/images/btreemodule_balance_deeper.svg
337share/doc/sqlite3/images/btreemodule_balance_quick.svg 337share/doc/sqlite3/images/btreemodule_balance_quick.svg
338share/doc/sqlite3/images/btreemodule_balance_shallower.svg 338share/doc/sqlite3/images/btreemodule_balance_shallower.svg
339share/doc/sqlite3/images/btreemodule_delete1.svg 339share/doc/sqlite3/images/btreemodule_delete1.svg
340share/doc/sqlite3/images/btreemodule_overview.svg 340share/doc/sqlite3/images/btreemodule_overview.svg
341share/doc/sqlite3/images/cc-diff.jpg 341share/doc/sqlite3/images/cc-diff.jpg
 342share/doc/sqlite3/images/chart.wiki
342share/doc/sqlite3/images/chw.jpg 343share/doc/sqlite3/images/chw.jpg
343share/doc/sqlite3/images/cpu-usage.jpg 344share/doc/sqlite3/images/cpu-usage.jpg
344share/doc/sqlite3/images/dan1.jpg 345share/doc/sqlite3/images/dan1.jpg
345share/doc/sqlite3/images/direct1b.gif 346share/doc/sqlite3/images/direct1b.gif
346share/doc/sqlite3/images/drh1.jpg 347share/doc/sqlite3/images/drh1.jpg
347share/doc/sqlite3/images/faster-read-blobapi.jpg 348share/doc/sqlite3/images/faster-read-blobapi.jpg
348share/doc/sqlite3/images/faster-read-mmap.jpg 349share/doc/sqlite3/images/faster-read-mmap.jpg
349share/doc/sqlite3/images/faster-read-sql.jpg 350share/doc/sqlite3/images/faster-read-sql.jpg
350share/doc/sqlite3/images/faster-write-safe.jpg 351share/doc/sqlite3/images/faster-write-safe.jpg
351share/doc/sqlite3/images/faster-write-unsafe.jpg 352share/doc/sqlite3/images/faster-write-unsafe.jpg
352share/doc/sqlite3/images/fileformat/db_connection.gif 353share/doc/sqlite3/images/fileformat/db_connection.gif
353share/doc/sqlite3/images/fileformat/examplepop.gif 354share/doc/sqlite3/images/fileformat/examplepop.gif
354share/doc/sqlite3/images/fileformat/fileio_diagrams.odg 355share/doc/sqlite3/images/fileformat/fileio_diagrams.odg
@@ -663,26 +664,27 @@ share/doc/sqlite3/releaselog/3_3_13.html @@ -663,26 +664,27 @@ share/doc/sqlite3/releaselog/3_3_13.html
663share/doc/sqlite3/releaselog/3_3_14.html 664share/doc/sqlite3/releaselog/3_3_14.html
664share/doc/sqlite3/releaselog/3_3_15.html 665share/doc/sqlite3/releaselog/3_3_15.html
665share/doc/sqlite3/releaselog/3_3_16.html 666share/doc/sqlite3/releaselog/3_3_16.html
666share/doc/sqlite3/releaselog/3_3_17.html 667share/doc/sqlite3/releaselog/3_3_17.html
667share/doc/sqlite3/releaselog/3_3_2.html 668share/doc/sqlite3/releaselog/3_3_2.html
668share/doc/sqlite3/releaselog/3_3_3.html 669share/doc/sqlite3/releaselog/3_3_3.html
669share/doc/sqlite3/releaselog/3_3_4.html 670share/doc/sqlite3/releaselog/3_3_4.html
670share/doc/sqlite3/releaselog/3_3_5.html 671share/doc/sqlite3/releaselog/3_3_5.html
671share/doc/sqlite3/releaselog/3_3_6.html 672share/doc/sqlite3/releaselog/3_3_6.html
672share/doc/sqlite3/releaselog/3_3_7.html 673share/doc/sqlite3/releaselog/3_3_7.html
673share/doc/sqlite3/releaselog/3_3_8.html 674share/doc/sqlite3/releaselog/3_3_8.html
674share/doc/sqlite3/releaselog/3_3_9.html 675share/doc/sqlite3/releaselog/3_3_9.html
675share/doc/sqlite3/releaselog/3_40_0.html 676share/doc/sqlite3/releaselog/3_40_0.html
 677share/doc/sqlite3/releaselog/3_40_1.html
676share/doc/sqlite3/releaselog/3_4_0.html 678share/doc/sqlite3/releaselog/3_4_0.html
677share/doc/sqlite3/releaselog/3_4_1.html 679share/doc/sqlite3/releaselog/3_4_1.html
678share/doc/sqlite3/releaselog/3_4_2.html 680share/doc/sqlite3/releaselog/3_4_2.html
679share/doc/sqlite3/releaselog/3_5_0.html 681share/doc/sqlite3/releaselog/3_5_0.html
680share/doc/sqlite3/releaselog/3_5_1.html 682share/doc/sqlite3/releaselog/3_5_1.html
681share/doc/sqlite3/releaselog/3_5_2.html 683share/doc/sqlite3/releaselog/3_5_2.html
682share/doc/sqlite3/releaselog/3_5_3.html 684share/doc/sqlite3/releaselog/3_5_3.html
683share/doc/sqlite3/releaselog/3_5_4.html 685share/doc/sqlite3/releaselog/3_5_4.html
684share/doc/sqlite3/releaselog/3_5_5.html 686share/doc/sqlite3/releaselog/3_5_5.html
685share/doc/sqlite3/releaselog/3_5_6.html 687share/doc/sqlite3/releaselog/3_5_6.html
686share/doc/sqlite3/releaselog/3_5_7.html 688share/doc/sqlite3/releaselog/3_5_7.html
687share/doc/sqlite3/releaselog/3_5_8.html 689share/doc/sqlite3/releaselog/3_5_8.html
688share/doc/sqlite3/releaselog/3_5_9.html 690share/doc/sqlite3/releaselog/3_5_9.html

cvs diff -r1.122 -r1.123 pkgsrc/databases/sqlite3-docs/distinfo (expand / switch to unified diff)

--- pkgsrc/databases/sqlite3-docs/distinfo 2022/11/17 06:20:44 1.122
+++ pkgsrc/databases/sqlite3-docs/distinfo 2022/12/28 22:26:06 1.123
@@ -1,5 +1,5 @@ @@ -1,5 +1,5 @@
1$NetBSD: distinfo,v 1.122 2022/11/17 06:20:44 adam Exp $ 1$NetBSD: distinfo,v 1.123 2022/12/28 22:26:06 adam Exp $
2 2
3BLAKE2s (sqlite-doc-3400000.zip) = 335f41408e24dc66874aeaf55bf6c7f5594b8afc0938c061c34a9f9f73d10d85 3BLAKE2s (sqlite-doc-3400100.zip) = 0d9514b754281e4b23a1e7e6288942a0f1cb0cd8fd9472e4b26b99d4c5ab9638
4SHA512 (sqlite-doc-3400000.zip) = 3557fe49e08fd24890da584f3fa7fb93d1e3317787f98a8ce1062dcac07733782026e50dfef7db72582739ddf0a77095cc4d3a81f3df097a69e85c672591bf7e 4SHA512 (sqlite-doc-3400100.zip) = 1131b0a6304a4dd6287c85d38d1450fd2dd0e3377d88a263e3c4716415e0587750357f25486727b9433797da0331229682565e7a8a3986eba89cfcab550a2d41
5Size (sqlite-doc-3400000.zip) = 10921883 bytes 5Size (sqlite-doc-3400100.zip) = 10934836 bytes

cvs diff -r1.113 -r1.114 pkgsrc/databases/sqlite3-tcl/Makefile (expand / switch to unified diff)

--- pkgsrc/databases/sqlite3-tcl/Makefile 2022/11/23 16:19:44 1.113
+++ pkgsrc/databases/sqlite3-tcl/Makefile 2022/12/28 22:26:06 1.114
@@ -1,16 +1,15 @@ @@ -1,16 +1,15 @@
1# $NetBSD: Makefile,v 1.113 2022/11/23 16:19:44 adam Exp $ 1# $NetBSD: Makefile,v 1.114 2022/12/28 22:26:06 adam Exp $
2 2
3PKGREVISION= 1 
4.include "../../databases/sqlite3/Makefile.common" 3.include "../../databases/sqlite3/Makefile.common"
5 4
6DISTNAME= sqlite-autoconf-${SQLITE3_DISTVERSION} 5DISTNAME= sqlite-autoconf-${SQLITE3_DISTVERSION}
7PKGNAME= sqlite3-tcl-${SQLITE3_VERSION} 6PKGNAME= sqlite3-tcl-${SQLITE3_VERSION}
8CATEGORIES= databases 7CATEGORIES= databases
9 8
10MAINTAINER= pkgsrc-users@NetBSD.org 9MAINTAINER= pkgsrc-users@NetBSD.org
11COMMENT= SQL Database Engine in a C Library (TCL extension) 10COMMENT= SQL Database Engine in a C Library (TCL extension)
12 11
13WRKSRC= ${WRKDIR}/${DISTNAME}/tea 12WRKSRC= ${WRKDIR}/${DISTNAME}/tea
14 13
15USE_TOOLS+= gmake 14USE_TOOLS+= gmake
16GNU_CONFIGURE= yes 15GNU_CONFIGURE= yes

cvs diff -r1.134 -r1.135 pkgsrc/databases/sqlite3-tcl/distinfo (expand / switch to unified diff)

--- pkgsrc/databases/sqlite3-tcl/distinfo 2022/11/17 06:20:44 1.134
+++ pkgsrc/databases/sqlite3-tcl/distinfo 2022/12/28 22:26:06 1.135
@@ -1,6 +1,7 @@ @@ -1,6 +1,7 @@
1$NetBSD: distinfo,v 1.134 2022/11/17 06:20:44 adam Exp $ 1$NetBSD: distinfo,v 1.135 2022/12/28 22:26:06 adam Exp $
2 2
3BLAKE2s (sqlite-autoconf-3400000.tar.gz) = 378945cc6da267e3c5652afe62731904acc6d4a2154c0b2fb08355a5cbdced00 3BLAKE2s (sqlite-autoconf-3400100.tar.gz) = f46e011624666d90fc246a1687b3014f20e4db6ca4bc0ccbb360d82f53f2a97e
4SHA512 (sqlite-autoconf-3400000.tar.gz) = 175271e620dd947df2ca63c3ea6cff80e16f8f808a3ea7f6700282768adc2d61ac375d42b2064c73eec849c67307ac5291fdadc3059861caa015ac3ac7a480e4 4SHA512 (sqlite-autoconf-3400100.tar.gz) = 50ff85b40b0017a73b52988843ec439358a8dde7d5d012a33ecfdaa67006697692f091a62d5f052f64e6fee84e27251864d331f63039a326ae4d5bf4a4dd5a91
5Size (sqlite-autoconf-3400000.tar.gz) = 3097756 bytes 5Size (sqlite-autoconf-3400100.tar.gz) = 3098662 bytes
6SHA1 (patch-Makefile.in) = 8f68039c9169bc69eb0da4bd0f910c7584aed2b5 6SHA1 (patch-Makefile.in) = 8f68039c9169bc69eb0da4bd0f910c7584aed2b5
 7SHA1 (patch-configure) = a885e450adabd3cc300ee9da003b05670b02d049

File Added: pkgsrc/databases/sqlite3-tcl/patches/Attic/patch-configure
$NetBSD: patch-configure,v 1.1 2022/12/28 22:26:07 adam Exp $

Fix package version.

--- configure.orig	2022-12-28 19:21:25.000000000 +0000
+++ configure
@@ -608,8 +608,8 @@ MAKEFLAGS=
 # Identity of this package.
 PACKAGE_NAME='sqlite'
 PACKAGE_TARNAME='sqlite'
-PACKAGE_VERSION='3.40.0'
-PACKAGE_STRING='sqlite 3.40.0'
+PACKAGE_VERSION='3.40.1'
+PACKAGE_STRING='sqlite 3.40.1'
 PACKAGE_BUGREPORT=''
 PACKAGE_URL=''
 

cvs diff -r1.63 -r1.64 pkgsrc/devel/lemon/distinfo (expand / switch to unified diff)

--- pkgsrc/devel/lemon/distinfo 2022/11/17 06:20:44 1.63
+++ pkgsrc/devel/lemon/distinfo 2022/12/28 22:26:07 1.64
@@ -1,5 +1,5 @@ @@ -1,5 +1,5 @@
1$NetBSD: distinfo,v 1.63 2022/11/17 06:20:44 adam Exp $ 1$NetBSD: distinfo,v 1.64 2022/12/28 22:26:07 adam Exp $
2 2
3BLAKE2s (sqlite-src-3400000.zip) = 6fcf2d0a0046143a892cef16c3c5d4986aa93febebbf4fcae207e9069a94a038 3BLAKE2s (sqlite-src-3400100.zip) = ca4e251fd76591fed11a5f6bda9663c72f7dea6c5713f980478a892f48be5353
4SHA512 (sqlite-src-3400000.zip) = c3bb3829f99c663f3381f4c610e401173f133fe944558b70da7521cc44116d048e4e1651993feb128b0f3814381aa4fa93f48ba3e277abca3442af805159287d 4SHA512 (sqlite-src-3400100.zip) = 78f8c6396bf8da090671c6f4c41255e60788324fccdaad906c53610eb6e37705f4d25c7f84da3be00b511ddf9f2e0545901f33f5ae4b6e00b1ea9413af095299
5Size (sqlite-src-3400000.zip) = 13723231 bytes 5Size (sqlite-src-3400100.zip) = 13725560 bytes