Fri Jul 22 07:05:56 2022 UTC ()
sqlite3: updated to 3.39.2

changes in version 3.39.2 (2022-07-21):

Fix a performance regression in the query planner associated with rearranging the order of FROM clause terms in the presences of a LEFT JOIN.
Apply fixes for CVE-2022-35737, Chromium bugs 1343348 and 1345947, forum post 3607259d3c, and other minor problems discovered by internal testing.


(adam)
diff -r1.92 -r1.93 pkgsrc/databases/sqlite3/Makefile.common
diff -r1.185 -r1.186 pkgsrc/databases/sqlite3/distinfo
diff -r1.115 -r1.116 pkgsrc/databases/sqlite3-docs/PLIST
diff -r1.118 -r1.119 pkgsrc/databases/sqlite3-docs/distinfo
diff -r1.130 -r1.131 pkgsrc/databases/sqlite3-tcl/distinfo
diff -r1.59 -r1.60 pkgsrc/devel/lemon/distinfo

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

--- pkgsrc/databases/sqlite3/Makefile.common 2022/07/14 08:05:51 1.92
+++ pkgsrc/databases/sqlite3/Makefile.common 2022/07/22 07:05:55 1.93
@@ -1,15 +1,15 @@ @@ -1,15 +1,15 @@
1# $NetBSD: Makefile.common,v 1.92 2022/07/14 08:05:51 adam Exp $ 1# $NetBSD: Makefile.common,v 1.93 2022/07/22 07:05:55 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= 3390100 8SQLITE3_DISTVERSION= 3390200
9SQLITE3_VERSION= 3.39.1 9SQLITE3_VERSION= 3.39.2
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.185 -r1.186 pkgsrc/databases/sqlite3/distinfo (expand / switch to unified diff)

--- pkgsrc/databases/sqlite3/distinfo 2022/07/14 08:05:51 1.185
+++ pkgsrc/databases/sqlite3/distinfo 2022/07/22 07:05:55 1.186
@@ -1,6 +1,6 @@ @@ -1,6 +1,6 @@
1$NetBSD: distinfo,v 1.185 2022/07/14 08:05:51 adam Exp $ 1$NetBSD: distinfo,v 1.186 2022/07/22 07:05:55 adam Exp $
2 2
3BLAKE2s (sqlite-autoconf-3390100.tar.gz) = 86505243e797200c8fa1ad3df4ff7880c58082b235aabc5c888dc1ac572071ab 3BLAKE2s (sqlite-autoconf-3390200.tar.gz) = 8b13cf674edda283e4184f6dcb46da7d656d68d3333e331edd03ab43fc7363df
4SHA512 (sqlite-autoconf-3390100.tar.gz) = 39e9b07e164770a9d61ab376f0dd84aba584396fdcf2b7b50461fbc1a889ea789f6248abc92e1b9345ac61fd062374a1a90233745525440b3aba0cef49ade996 4SHA512 (sqlite-autoconf-3390200.tar.gz) = c16b50ade3c182d5473014ac0a51e2bb8a5cfc46e532c2bda77ae4d530336e2b57aa4f12dccb6aa2148d60e9289305bf20842ac95dc52f2d31df8eb5f0599de6
5Size (sqlite-autoconf-3390100.tar.gz) = 3064607 bytes 5Size (sqlite-autoconf-3390200.tar.gz) = 3064438 bytes
6SHA1 (patch-configure) = c0aa83bddc20d090b3cd2fd840ac69031f4396e4 6SHA1 (patch-configure) = c0aa83bddc20d090b3cd2fd840ac69031f4396e4

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

--- pkgsrc/databases/sqlite3-docs/PLIST 2022/07/14 08:05:51 1.115
+++ pkgsrc/databases/sqlite3-docs/PLIST 2022/07/22 07:05:55 1.116
@@ -1,14 +1,14 @@ @@ -1,14 +1,14 @@
1@comment $NetBSD: PLIST,v 1.115 2022/07/14 08:05:51 adam Exp $ 1@comment $NetBSD: PLIST,v 1.116 2022/07/22 07:05:55 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
@@ -639,26 +639,27 @@ share/doc/sqlite3/releaselog/3_35_4.html @@ -639,26 +639,27 @@ share/doc/sqlite3/releaselog/3_35_4.html
639share/doc/sqlite3/releaselog/3_35_5.html 639share/doc/sqlite3/releaselog/3_35_5.html
640share/doc/sqlite3/releaselog/3_36_0.html 640share/doc/sqlite3/releaselog/3_36_0.html
641share/doc/sqlite3/releaselog/3_37_0.html 641share/doc/sqlite3/releaselog/3_37_0.html
642share/doc/sqlite3/releaselog/3_37_1.html 642share/doc/sqlite3/releaselog/3_37_1.html
643share/doc/sqlite3/releaselog/3_37_2.html 643share/doc/sqlite3/releaselog/3_37_2.html
644share/doc/sqlite3/releaselog/3_38_0.html 644share/doc/sqlite3/releaselog/3_38_0.html
645share/doc/sqlite3/releaselog/3_38_1.html 645share/doc/sqlite3/releaselog/3_38_1.html
646share/doc/sqlite3/releaselog/3_38_2.html 646share/doc/sqlite3/releaselog/3_38_2.html
647share/doc/sqlite3/releaselog/3_38_3.html 647share/doc/sqlite3/releaselog/3_38_3.html
648share/doc/sqlite3/releaselog/3_38_4.html 648share/doc/sqlite3/releaselog/3_38_4.html
649share/doc/sqlite3/releaselog/3_38_5.html 649share/doc/sqlite3/releaselog/3_38_5.html
650share/doc/sqlite3/releaselog/3_39_0.html 650share/doc/sqlite3/releaselog/3_39_0.html
651share/doc/sqlite3/releaselog/3_39_1.html 651share/doc/sqlite3/releaselog/3_39_1.html
 652share/doc/sqlite3/releaselog/3_39_2.html
652share/doc/sqlite3/releaselog/3_3_0.html 653share/doc/sqlite3/releaselog/3_3_0.html
653share/doc/sqlite3/releaselog/3_3_1.html 654share/doc/sqlite3/releaselog/3_3_1.html
654share/doc/sqlite3/releaselog/3_3_10.html 655share/doc/sqlite3/releaselog/3_3_10.html
655share/doc/sqlite3/releaselog/3_3_11.html 656share/doc/sqlite3/releaselog/3_3_11.html
656share/doc/sqlite3/releaselog/3_3_12.html 657share/doc/sqlite3/releaselog/3_3_12.html
657share/doc/sqlite3/releaselog/3_3_13.html 658share/doc/sqlite3/releaselog/3_3_13.html
658share/doc/sqlite3/releaselog/3_3_14.html 659share/doc/sqlite3/releaselog/3_3_14.html
659share/doc/sqlite3/releaselog/3_3_15.html 660share/doc/sqlite3/releaselog/3_3_15.html
660share/doc/sqlite3/releaselog/3_3_16.html 661share/doc/sqlite3/releaselog/3_3_16.html
661share/doc/sqlite3/releaselog/3_3_17.html 662share/doc/sqlite3/releaselog/3_3_17.html
662share/doc/sqlite3/releaselog/3_3_2.html 663share/doc/sqlite3/releaselog/3_3_2.html
663share/doc/sqlite3/releaselog/3_3_3.html 664share/doc/sqlite3/releaselog/3_3_3.html
664share/doc/sqlite3/releaselog/3_3_4.html 665share/doc/sqlite3/releaselog/3_3_4.html

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

--- pkgsrc/databases/sqlite3-docs/distinfo 2022/07/14 08:05:51 1.118
+++ pkgsrc/databases/sqlite3-docs/distinfo 2022/07/22 07:05:55 1.119
@@ -1,5 +1,5 @@ @@ -1,5 +1,5 @@
1$NetBSD: distinfo,v 1.118 2022/07/14 08:05:51 adam Exp $ 1$NetBSD: distinfo,v 1.119 2022/07/22 07:05:55 adam Exp $
2 2
3BLAKE2s (sqlite-doc-3390100.zip) = c162d02333c6a357fa0ad1d4dc54158604dddd7936b54ef30429899fdd3d29eb 3BLAKE2s (sqlite-doc-3390200.zip) = 53e730649d6dac34d41f6097c41d155cfa5f05d3b42e7e9c52b8ed68c3a2341b
4SHA512 (sqlite-doc-3390100.zip) = 81295ec49a4f22e38d4a459858c04731fdfc41e4fea307cdcf5443f30595fda7e268e85880dcc2d9d96e0bf3ccce96c6e5be692eb466258c196c89ed172635ac 4SHA512 (sqlite-doc-3390200.zip) = 54b9e632244b95ebf35fcaa5ce9c02381601eb442eec2ec2a809a7fe24d2cfed751581bb82fd243aaede2c935864da39fd1f1685e762826dd76fc754c7f79c0b
5Size (sqlite-doc-3390100.zip) = 10675104 bytes 5Size (sqlite-doc-3390200.zip) = 10683207 bytes

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

--- pkgsrc/databases/sqlite3-tcl/distinfo 2022/07/14 08:05:51 1.130
+++ pkgsrc/databases/sqlite3-tcl/distinfo 2022/07/22 07:05:55 1.131
@@ -1,6 +1,6 @@ @@ -1,6 +1,6 @@
1$NetBSD: distinfo,v 1.130 2022/07/14 08:05:51 adam Exp $ 1$NetBSD: distinfo,v 1.131 2022/07/22 07:05:55 adam Exp $
2 2
3BLAKE2s (sqlite-autoconf-3390100.tar.gz) = 86505243e797200c8fa1ad3df4ff7880c58082b235aabc5c888dc1ac572071ab 3BLAKE2s (sqlite-autoconf-3390200.tar.gz) = 8b13cf674edda283e4184f6dcb46da7d656d68d3333e331edd03ab43fc7363df
4SHA512 (sqlite-autoconf-3390100.tar.gz) = 39e9b07e164770a9d61ab376f0dd84aba584396fdcf2b7b50461fbc1a889ea789f6248abc92e1b9345ac61fd062374a1a90233745525440b3aba0cef49ade996 4SHA512 (sqlite-autoconf-3390200.tar.gz) = c16b50ade3c182d5473014ac0a51e2bb8a5cfc46e532c2bda77ae4d530336e2b57aa4f12dccb6aa2148d60e9289305bf20842ac95dc52f2d31df8eb5f0599de6
5Size (sqlite-autoconf-3390100.tar.gz) = 3064607 bytes 5Size (sqlite-autoconf-3390200.tar.gz) = 3064438 bytes
6SHA1 (patch-Makefile.in) = 6cbbc33a5bc9c98b5aa128279f8e21e47406f537 6SHA1 (patch-Makefile.in) = 6cbbc33a5bc9c98b5aa128279f8e21e47406f537

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

--- pkgsrc/devel/lemon/distinfo 2022/07/14 08:05:51 1.59
+++ pkgsrc/devel/lemon/distinfo 2022/07/22 07:05:55 1.60
@@ -1,5 +1,5 @@ @@ -1,5 +1,5 @@
1$NetBSD: distinfo,v 1.59 2022/07/14 08:05:51 adam Exp $ 1$NetBSD: distinfo,v 1.60 2022/07/22 07:05:55 adam Exp $
2 2
3BLAKE2s (sqlite-src-3390100.zip) = cb76fc7a55baddefce8b86260a434b7cd2caf985808ee1152c7a9db43125d9a2 3BLAKE2s (sqlite-src-3390200.zip) = c7b94da2980ebbe64d96ccfbbc65ce94fe9965ff12fa4092cccd68505e27a3ac
4SHA512 (sqlite-src-3390100.zip) = 2a4b6605e8925aed803ef6b62b9eb84e384325f9a81a800b07e0f4e63ce31f66881687ccf3cdc3c5ee89b8fb38cc8d8e2883b8feb5ae538800d99fa93a0b8de1 4SHA512 (sqlite-src-3390200.zip) = a838386a48654391590ea0e1cb355d29f6f93033c3e582df7c63139adaf5119dd5a1550e913dbad0d3eafb0bfa03c4fc6dc48a334d9c45ffb8a7205a528b38f1
5Size (sqlite-src-3390100.zip) = 13401695 bytes 5Size (sqlite-src-3390200.zip) = 13403722 bytes