Mon Oct 3 12:27:52 2022 UTC ()
sqlite3: updated to 3.39.4

Changes in version 3.39.4 (2022-09-29):

Fix the build on Windows so that it works with -DSQLITE_OMIT_AUTOINIT
Fix a long-standing problem in the btree balancer that might, in rare cases, cause database corruption if the application uses an application-defined page cache.
Enhance SQLITE_DBCONFIG_DEFENSIVE so that it disallows CREATE TRIGGER statements if one or more of the statements in the body of the trigger write into shadow tables.
Fix a possible integer overflow in the size computation for a memory allocation in FTS3.
Fix a misuse of the sqlite3_set_auxdata() interface in the ICU Extension.


(adam)
diff -r1.94 -r1.95 pkgsrc/databases/sqlite3/Makefile.common
diff -r1.187 -r1.188 pkgsrc/databases/sqlite3/distinfo
diff -r1.117 -r1.118 pkgsrc/databases/sqlite3-docs/PLIST
diff -r1.120 -r1.121 pkgsrc/databases/sqlite3-docs/distinfo
diff -r1.132 -r1.133 pkgsrc/databases/sqlite3-tcl/distinfo
diff -r1.61 -r1.62 pkgsrc/devel/lemon/distinfo

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

--- pkgsrc/databases/sqlite3/Makefile.common 2022/09/06 18:59:11 1.94
+++ pkgsrc/databases/sqlite3/Makefile.common 2022/10/03 12:27:52 1.95
@@ -1,15 +1,15 @@ @@ -1,15 +1,15 @@
1# $NetBSD: Makefile.common,v 1.94 2022/09/06 18:59:11 adam Exp $ 1# $NetBSD: Makefile.common,v 1.95 2022/10/03 12:27:52 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= 3390300 8SQLITE3_DISTVERSION= 3390400
9SQLITE3_VERSION= 3.39.3 9SQLITE3_VERSION= 3.39.4
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.187 -r1.188 pkgsrc/databases/sqlite3/distinfo (expand / switch to unified diff)

--- pkgsrc/databases/sqlite3/distinfo 2022/09/06 18:59:11 1.187
+++ pkgsrc/databases/sqlite3/distinfo 2022/10/03 12:27:52 1.188
@@ -1,6 +1,6 @@ @@ -1,6 +1,6 @@
1$NetBSD: distinfo,v 1.187 2022/09/06 18:59:11 adam Exp $ 1$NetBSD: distinfo,v 1.188 2022/10/03 12:27:52 adam Exp $
2 2
3BLAKE2s (sqlite-autoconf-3390300.tar.gz) = 5707cc7b31f4b87fcee797ed569569cd781b93cad9749dace18104313ea95f31 3BLAKE2s (sqlite-autoconf-3390400.tar.gz) = efef4f594d97c8a4bd724c16f7ae7c9f295eb0a52193146753cb08392e5d5b97
4SHA512 (sqlite-autoconf-3390300.tar.gz) = f5f1f275ca7def6e1971d0152852468b89f2759d6fc2dda42b6e47646d65c7d8c454a9accd4ac900e171908114a9164c722314b90fb2ca422b99603158f9ce3e 4SHA512 (sqlite-autoconf-3390400.tar.gz) = cc1de214e69ef677cac3f6dd2000ccfcf4b672ab464a115d96f24707009a408630e762c3cda89741b728ab34c4d9f5b8f8b12e9b11448e8364642b4421c3393d
5Size (sqlite-autoconf-3390300.tar.gz) = 3064970 bytes 5Size (sqlite-autoconf-3390400.tar.gz) = 3065214 bytes
6SHA1 (patch-configure) = c0aa83bddc20d090b3cd2fd840ac69031f4396e4 6SHA1 (patch-configure) = c0aa83bddc20d090b3cd2fd840ac69031f4396e4

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

--- pkgsrc/databases/sqlite3-docs/PLIST 2022/09/06 18:59:11 1.117
+++ pkgsrc/databases/sqlite3-docs/PLIST 2022/10/03 12:27:52 1.118
@@ -1,14 +1,14 @@ @@ -1,14 +1,14 @@
1@comment $NetBSD: PLIST,v 1.117 2022/09/06 18:59:11 adam Exp $ 1@comment $NetBSD: PLIST,v 1.118 2022/10/03 12:27:52 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
@@ -265,27 +265,26 @@ share/doc/sqlite3/doc_target_crossref.ht @@ -265,27 +265,26 @@ share/doc/sqlite3/doc_target_crossref.ht
265share/doc/sqlite3/doclist.html 265share/doc/sqlite3/doclist.html
266share/doc/sqlite3/docs.html 266share/doc/sqlite3/docs.html
267share/doc/sqlite3/download.html 267share/doc/sqlite3/download.html
268share/doc/sqlite3/eqp.html 268share/doc/sqlite3/eqp.html
269share/doc/sqlite3/errlog.html 269share/doc/sqlite3/errlog.html
270share/doc/sqlite3/expridx.html 270share/doc/sqlite3/expridx.html
271share/doc/sqlite3/famous.html 271share/doc/sqlite3/famous.html
272share/doc/sqlite3/faq.html 272share/doc/sqlite3/faq.html
273share/doc/sqlite3/fasterthanfs.html 273share/doc/sqlite3/fasterthanfs.html
274share/doc/sqlite3/favicon.ico 274share/doc/sqlite3/favicon.ico
275share/doc/sqlite3/features.html 275share/doc/sqlite3/features.html
276share/doc/sqlite3/fileformat.html 276share/doc/sqlite3/fileformat.html
277share/doc/sqlite3/fileformat2.html 277share/doc/sqlite3/fileformat2.html
278share/doc/sqlite3/fileio.html 
279share/doc/sqlite3/flextypegood.html 278share/doc/sqlite3/flextypegood.html
280share/doc/sqlite3/floatingpoint.html 279share/doc/sqlite3/floatingpoint.html
281share/doc/sqlite3/footprint.html 280share/doc/sqlite3/footprint.html
282share/doc/sqlite3/foreignkeys.html 281share/doc/sqlite3/foreignkeys.html
283share/doc/sqlite3/formatchng.html 282share/doc/sqlite3/formatchng.html
284share/doc/sqlite3/fts3.html 283share/doc/sqlite3/fts3.html
285share/doc/sqlite3/fts5.html 284share/doc/sqlite3/fts5.html
286share/doc/sqlite3/fullsql.html 285share/doc/sqlite3/fullsql.html
287share/doc/sqlite3/gencol.html 286share/doc/sqlite3/gencol.html
288share/doc/sqlite3/geopoly.html 287share/doc/sqlite3/geopoly.html
289share/doc/sqlite3/getthecode.html 288share/doc/sqlite3/getthecode.html
290share/doc/sqlite3/hirely.html 289share/doc/sqlite3/hirely.html
291share/doc/sqlite3/howitworks.html 290share/doc/sqlite3/howitworks.html
@@ -641,26 +640,27 @@ share/doc/sqlite3/releaselog/3_36_0.html @@ -641,26 +640,27 @@ share/doc/sqlite3/releaselog/3_36_0.html
641share/doc/sqlite3/releaselog/3_37_0.html 640share/doc/sqlite3/releaselog/3_37_0.html
642share/doc/sqlite3/releaselog/3_37_1.html 641share/doc/sqlite3/releaselog/3_37_1.html
643share/doc/sqlite3/releaselog/3_37_2.html 642share/doc/sqlite3/releaselog/3_37_2.html
644share/doc/sqlite3/releaselog/3_38_0.html 643share/doc/sqlite3/releaselog/3_38_0.html
645share/doc/sqlite3/releaselog/3_38_1.html 644share/doc/sqlite3/releaselog/3_38_1.html
646share/doc/sqlite3/releaselog/3_38_2.html 645share/doc/sqlite3/releaselog/3_38_2.html
647share/doc/sqlite3/releaselog/3_38_3.html 646share/doc/sqlite3/releaselog/3_38_3.html
648share/doc/sqlite3/releaselog/3_38_4.html 647share/doc/sqlite3/releaselog/3_38_4.html
649share/doc/sqlite3/releaselog/3_38_5.html 648share/doc/sqlite3/releaselog/3_38_5.html
650share/doc/sqlite3/releaselog/3_39_0.html 649share/doc/sqlite3/releaselog/3_39_0.html
651share/doc/sqlite3/releaselog/3_39_1.html 650share/doc/sqlite3/releaselog/3_39_1.html
652share/doc/sqlite3/releaselog/3_39_2.html 651share/doc/sqlite3/releaselog/3_39_2.html
653share/doc/sqlite3/releaselog/3_39_3.html 652share/doc/sqlite3/releaselog/3_39_3.html
 653share/doc/sqlite3/releaselog/3_39_4.html
654share/doc/sqlite3/releaselog/3_3_0.html 654share/doc/sqlite3/releaselog/3_3_0.html
655share/doc/sqlite3/releaselog/3_3_1.html 655share/doc/sqlite3/releaselog/3_3_1.html
656share/doc/sqlite3/releaselog/3_3_10.html 656share/doc/sqlite3/releaselog/3_3_10.html
657share/doc/sqlite3/releaselog/3_3_11.html 657share/doc/sqlite3/releaselog/3_3_11.html
658share/doc/sqlite3/releaselog/3_3_12.html 658share/doc/sqlite3/releaselog/3_3_12.html
659share/doc/sqlite3/releaselog/3_3_13.html 659share/doc/sqlite3/releaselog/3_3_13.html
660share/doc/sqlite3/releaselog/3_3_14.html 660share/doc/sqlite3/releaselog/3_3_14.html
661share/doc/sqlite3/releaselog/3_3_15.html 661share/doc/sqlite3/releaselog/3_3_15.html
662share/doc/sqlite3/releaselog/3_3_16.html 662share/doc/sqlite3/releaselog/3_3_16.html
663share/doc/sqlite3/releaselog/3_3_17.html 663share/doc/sqlite3/releaselog/3_3_17.html
664share/doc/sqlite3/releaselog/3_3_2.html 664share/doc/sqlite3/releaselog/3_3_2.html
665share/doc/sqlite3/releaselog/3_3_3.html 665share/doc/sqlite3/releaselog/3_3_3.html
666share/doc/sqlite3/releaselog/3_3_4.html 666share/doc/sqlite3/releaselog/3_3_4.html
@@ -836,27 +836,26 @@ share/doc/sqlite3/session/sqlite3session @@ -836,27 +836,26 @@ share/doc/sqlite3/session/sqlite3session
836share/doc/sqlite3/session/sqlite3session_memory_used.html 836share/doc/sqlite3/session/sqlite3session_memory_used.html
837share/doc/sqlite3/session/sqlite3session_patchset.html 837share/doc/sqlite3/session/sqlite3session_patchset.html
838share/doc/sqlite3/session/sqlite3session_table_filter.html 838share/doc/sqlite3/session/sqlite3session_table_filter.html
839share/doc/sqlite3/sessionintro.html 839share/doc/sqlite3/sessionintro.html
840share/doc/sqlite3/sharedcache.html 840share/doc/sqlite3/sharedcache.html
841share/doc/sqlite3/shortnames.html 841share/doc/sqlite3/shortnames.html
842share/doc/sqlite3/sitemap.html 842share/doc/sqlite3/sitemap.html
843share/doc/sqlite3/speed.html 843share/doc/sqlite3/speed.html
844share/doc/sqlite3/spellfix1.html 844share/doc/sqlite3/spellfix1.html
845share/doc/sqlite3/sqlanalyze.html 845share/doc/sqlite3/sqlanalyze.html
846share/doc/sqlite3/sqlar.html 846share/doc/sqlite3/sqlar.html
847share/doc/sqlite3/sqldiff.html 847share/doc/sqlite3/sqldiff.html
848share/doc/sqlite3/sqlite.css 848share/doc/sqlite3/sqlite.css
849share/doc/sqlite3/sqlite.css~ 
850share/doc/sqlite3/sqlite.html 849share/doc/sqlite3/sqlite.html
851share/doc/sqlite3/stmt.html 850share/doc/sqlite3/stmt.html
852share/doc/sqlite3/stricttables.html 851share/doc/sqlite3/stricttables.html
853share/doc/sqlite3/support.html 852share/doc/sqlite3/support.html
854share/doc/sqlite3/swarmvtab.html 853share/doc/sqlite3/swarmvtab.html
855share/doc/sqlite3/syntax.html 854share/doc/sqlite3/syntax.html
856share/doc/sqlite3/syntax/aggregate-function-invocation.html 855share/doc/sqlite3/syntax/aggregate-function-invocation.html
857share/doc/sqlite3/syntax/alter-table-stmt.html 856share/doc/sqlite3/syntax/alter-table-stmt.html
858share/doc/sqlite3/syntax/analyze-stmt.html 857share/doc/sqlite3/syntax/analyze-stmt.html
859share/doc/sqlite3/syntax/attach-stmt.html 858share/doc/sqlite3/syntax/attach-stmt.html
860share/doc/sqlite3/syntax/begin-stmt.html 859share/doc/sqlite3/syntax/begin-stmt.html
861share/doc/sqlite3/syntax/column-constraint.html 860share/doc/sqlite3/syntax/column-constraint.html
862share/doc/sqlite3/syntax/column-def.html 861share/doc/sqlite3/syntax/column-def.html

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

--- pkgsrc/databases/sqlite3-docs/distinfo 2022/09/06 18:59:11 1.120
+++ pkgsrc/databases/sqlite3-docs/distinfo 2022/10/03 12:27:52 1.121
@@ -1,5 +1,5 @@ @@ -1,5 +1,5 @@
1$NetBSD: distinfo,v 1.120 2022/09/06 18:59:11 adam Exp $ 1$NetBSD: distinfo,v 1.121 2022/10/03 12:27:52 adam Exp $
2 2
3BLAKE2s (sqlite-doc-3390300.zip) = 79443f36f46a20dbdbf3bd0d78ed41049adaf6367d67b31297a89a8592efd5d1 3BLAKE2s (sqlite-doc-3390400.zip) = ee8d991decabf8089b0dd80157930f33a9d38c8526c97da6faa17c1033a9939e
4SHA512 (sqlite-doc-3390300.zip) = edab798f777bec097a20798a71c8ea01e4c59034da1f696ce1574a57719edd252a0004a268866e338803dd4c46980754ed1b5ddd05a5fc01b59397b6fda172ae 4SHA512 (sqlite-doc-3390400.zip) = 75d97b0f2f0d530b2e0ad505574af3bf657d82f0859bb5de7ee45c40a80351e933944845cedca56b579925a3d07505c6f4721f756f27862ffafdfc2caff539fb
5Size (sqlite-doc-3390300.zip) = 10312031 bytes 5Size (sqlite-doc-3390400.zip) = 10853153 bytes

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

--- pkgsrc/databases/sqlite3-tcl/distinfo 2022/09/06 18:59:11 1.132
+++ pkgsrc/databases/sqlite3-tcl/distinfo 2022/10/03 12:27:52 1.133
@@ -1,6 +1,6 @@ @@ -1,6 +1,6 @@
1$NetBSD: distinfo,v 1.132 2022/09/06 18:59:11 adam Exp $ 1$NetBSD: distinfo,v 1.133 2022/10/03 12:27:52 adam Exp $
2 2
3BLAKE2s (sqlite-autoconf-3390300.tar.gz) = 5707cc7b31f4b87fcee797ed569569cd781b93cad9749dace18104313ea95f31 3BLAKE2s (sqlite-autoconf-3390400.tar.gz) = efef4f594d97c8a4bd724c16f7ae7c9f295eb0a52193146753cb08392e5d5b97
4SHA512 (sqlite-autoconf-3390300.tar.gz) = f5f1f275ca7def6e1971d0152852468b89f2759d6fc2dda42b6e47646d65c7d8c454a9accd4ac900e171908114a9164c722314b90fb2ca422b99603158f9ce3e 4SHA512 (sqlite-autoconf-3390400.tar.gz) = cc1de214e69ef677cac3f6dd2000ccfcf4b672ab464a115d96f24707009a408630e762c3cda89741b728ab34c4d9f5b8f8b12e9b11448e8364642b4421c3393d
5Size (sqlite-autoconf-3390300.tar.gz) = 3064970 bytes 5Size (sqlite-autoconf-3390400.tar.gz) = 3065214 bytes
6SHA1 (patch-Makefile.in) = 6cbbc33a5bc9c98b5aa128279f8e21e47406f537 6SHA1 (patch-Makefile.in) = 6cbbc33a5bc9c98b5aa128279f8e21e47406f537

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

--- pkgsrc/devel/lemon/distinfo 2022/09/06 18:59:11 1.61
+++ pkgsrc/devel/lemon/distinfo 2022/10/03 12:27:52 1.62
@@ -1,5 +1,5 @@ @@ -1,5 +1,5 @@
1$NetBSD: distinfo,v 1.61 2022/09/06 18:59:11 adam Exp $ 1$NetBSD: distinfo,v 1.62 2022/10/03 12:27:52 adam Exp $
2 2
3BLAKE2s (sqlite-src-3390300.zip) = 7ecc27cf10eb9812623084e990411684221b751d7fd9facfd9a9ccc580139793 3BLAKE2s (sqlite-src-3390400.zip) = 58782c11d2e04d06f8ed91c5ae61bf2099cb9f812373f761c8cf697c5f584063
4SHA512 (sqlite-src-3390300.zip) = 19827a3dc0b57046b3d50e9538dfcf2e0453a04b2d8ccfee94effa3eee1b1a56837740ecef0e6ee4ec0a94d7185fae9f4a5e158291468acbbcead5335196e776 4SHA512 (sqlite-src-3390400.zip) = 0acb8afc87f911c91ec555cc97af5b77b6b0e80cc8672711ddd87c651d9e11b697c9669ff9ba2b58da12b972bb46acdf8b8fe35993950f10735b4036501b73bb
5Size (sqlite-src-3390300.zip) = 13404886 bytes 5Size (sqlite-src-3390400.zip) = 13405169 bytes