sqlite3: updated to 3.45.2 version 3.45.2 (2024-03-12): Fix an error in UPSERT, introduced by enhancement 3a in version 3.35.0 (2021-03-12), that could cause an index to get out-of-sync with its table. Forum thread 919c6579c8. Reduce the scope of the NOT NULL strength reduction optimization that was added as item 8e in version 3.35.0 (2021-03-12). The optimization was being attempted in some contexts where it did not work, resulting in incorrect query results. Forum thread 440f2a2f17. Other trifling corrections and compiler warning fixes that have come up since the previous patch release. See the timeline for details.diff -r1.108 -r1.109 pkgsrc/databases/sqlite3/Makefile.common
(adam)
@@ -1,15 +1,15 @@ | @@ -1,15 +1,15 @@ | |||
1 | # $NetBSD: Makefile.common,v 1.108 2024/01/30 20:13:21 adam Exp $ | 1 | # $NetBSD: Makefile.common,v 1.109 2024/03/14 08:07:10 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 | |||
8 | SQLITE3_DISTVERSION= 3450100 | 8 | SQLITE3_DISTVERSION= 3450200 | |
9 | SQLITE3_VERSION= 3.45.1 | 9 | SQLITE3_VERSION= 3.45.2 | |
10 | 10 | |||
11 | MASTER_SITES= http://www.sqlite.org/2024/ | 11 | MASTER_SITES= http://www.sqlite.org/2024/ | |
12 | MASTER_SITES+= http://www.hwaci.com/sw/sqlite/2024/ | 12 | MASTER_SITES+= http://www.hwaci.com/sw/sqlite/2024/ | |
13 | 13 | |||
14 | HOMEPAGE?= http://www.sqlite.org/ | 14 | HOMEPAGE?= http://www.sqlite.org/ | |
15 | LICENSE= public-domain | 15 | LICENSE= public-domain |
@@ -1,6 +1,6 @@ | @@ -1,6 +1,6 @@ | |||
1 | $NetBSD: distinfo,v 1.202 2024/01/30 20:13:21 adam Exp $ | 1 | $NetBSD: distinfo,v 1.203 2024/03/14 08:07:10 adam Exp $ | |
2 | 2 | |||
3 | BLAKE2s (sqlite-autoconf-3450100.tar.gz) = 30fb7ef9966c86e7ec7fd309a0ad7a441f3510ddedf74e86f6e794de09cc722d | 3 | BLAKE2s (sqlite-autoconf-3450200.tar.gz) = c3f5369f2a96b70b17d5f2e75cb9ab444a9e72c380d52e77c11457ea738fa549 | |
4 | SHA512 (sqlite-autoconf-3450100.tar.gz) = c6bd4eaa67cada28528d1ac31aec1662c0a11048247a1bb148c1842fb0252934e2096843b56fea94bfb96c4eaaa598ec70ac31f2a5e910388f24f152b9fc4211 | 4 | SHA512 (sqlite-autoconf-3450200.tar.gz) = 7a15feab6319d8718b0ec3fc2077f50e87bbbe0deb5689c3318d5283bbdd72e16f2b2fa8fcf9b1331d8eaffa75c479db044a3c452d1ec09744648a3930505eff | |
5 | Size (sqlite-autoconf-3450100.tar.gz) = 3232682 bytes | 5 | Size (sqlite-autoconf-3450200.tar.gz) = 3234010 bytes | |
6 | SHA1 (patch-configure) = c0aa83bddc20d090b3cd2fd840ac69031f4396e4 | 6 | SHA1 (patch-configure) = c0aa83bddc20d090b3cd2fd840ac69031f4396e4 |
@@ -1,14 +1,14 @@ | @@ -1,14 +1,14 @@ | |||
1 | @comment $NetBSD: PLIST,v 1.131 2024/01/30 20:13:21 adam Exp $ | 1 | @comment $NetBSD: PLIST,v 1.132 2024/03/14 08:07:10 adam Exp $ | |
2 | share/doc/sqlite3/34to35.html | 2 | share/doc/sqlite3/34to35.html | |
3 | share/doc/sqlite3/35to36.html | 3 | share/doc/sqlite3/35to36.html | |
4 | share/doc/sqlite3/about.html | 4 | share/doc/sqlite3/about.html | |
5 | share/doc/sqlite3/aff_short.html | 5 | share/doc/sqlite3/aff_short.html | |
6 | share/doc/sqlite3/affcase1.html | 6 | share/doc/sqlite3/affcase1.html | |
7 | share/doc/sqlite3/amalgamation.html | 7 | share/doc/sqlite3/amalgamation.html | |
8 | share/doc/sqlite3/appfileformat.html | 8 | share/doc/sqlite3/appfileformat.html | |
9 | share/doc/sqlite3/appfunc.html | 9 | share/doc/sqlite3/appfunc.html | |
10 | share/doc/sqlite3/arch.html | 10 | share/doc/sqlite3/arch.html | |
11 | share/doc/sqlite3/assert.html | 11 | share/doc/sqlite3/assert.html | |
12 | share/doc/sqlite3/asyncvfs.html | 12 | share/doc/sqlite3/asyncvfs.html | |
13 | share/doc/sqlite3/atomiccommit.html | 13 | share/doc/sqlite3/atomiccommit.html | |
14 | share/doc/sqlite3/autoinc.html | 14 | share/doc/sqlite3/autoinc.html | |
@@ -681,26 +681,27 @@ share/doc/sqlite3/releaselog/3_40_0.html | @@ -681,26 +681,27 @@ share/doc/sqlite3/releaselog/3_40_0.html | |||
681 | share/doc/sqlite3/releaselog/3_40_1.html | 681 | share/doc/sqlite3/releaselog/3_40_1.html | |
682 | share/doc/sqlite3/releaselog/3_41_0.html | 682 | share/doc/sqlite3/releaselog/3_41_0.html | |
683 | share/doc/sqlite3/releaselog/3_41_1.html | 683 | share/doc/sqlite3/releaselog/3_41_1.html | |
684 | share/doc/sqlite3/releaselog/3_41_2.html | 684 | share/doc/sqlite3/releaselog/3_41_2.html | |
685 | share/doc/sqlite3/releaselog/3_42_0.html | 685 | share/doc/sqlite3/releaselog/3_42_0.html | |
686 | share/doc/sqlite3/releaselog/3_43_0.html | 686 | share/doc/sqlite3/releaselog/3_43_0.html | |
687 | share/doc/sqlite3/releaselog/3_43_1.html | 687 | share/doc/sqlite3/releaselog/3_43_1.html | |
688 | share/doc/sqlite3/releaselog/3_43_2.html | 688 | share/doc/sqlite3/releaselog/3_43_2.html | |
689 | share/doc/sqlite3/releaselog/3_44_0.html | 689 | share/doc/sqlite3/releaselog/3_44_0.html | |
690 | share/doc/sqlite3/releaselog/3_44_1.html | 690 | share/doc/sqlite3/releaselog/3_44_1.html | |
691 | share/doc/sqlite3/releaselog/3_44_2.html | 691 | share/doc/sqlite3/releaselog/3_44_2.html | |
692 | share/doc/sqlite3/releaselog/3_45_0.html | 692 | share/doc/sqlite3/releaselog/3_45_0.html | |
693 | share/doc/sqlite3/releaselog/3_45_1.html | 693 | share/doc/sqlite3/releaselog/3_45_1.html | |
694 | share/doc/sqlite3/releaselog/3_45_2.html | |||
694 | share/doc/sqlite3/releaselog/3_4_0.html | 695 | share/doc/sqlite3/releaselog/3_4_0.html | |
695 | share/doc/sqlite3/releaselog/3_4_1.html | 696 | share/doc/sqlite3/releaselog/3_4_1.html | |
696 | share/doc/sqlite3/releaselog/3_4_2.html | 697 | share/doc/sqlite3/releaselog/3_4_2.html | |
697 | share/doc/sqlite3/releaselog/3_5_0.html | 698 | share/doc/sqlite3/releaselog/3_5_0.html | |
698 | share/doc/sqlite3/releaselog/3_5_1.html | 699 | share/doc/sqlite3/releaselog/3_5_1.html | |
699 | share/doc/sqlite3/releaselog/3_5_2.html | 700 | share/doc/sqlite3/releaselog/3_5_2.html | |
700 | share/doc/sqlite3/releaselog/3_5_3.html | 701 | share/doc/sqlite3/releaselog/3_5_3.html | |
701 | share/doc/sqlite3/releaselog/3_5_4.html | 702 | share/doc/sqlite3/releaselog/3_5_4.html | |
702 | share/doc/sqlite3/releaselog/3_5_5.html | 703 | share/doc/sqlite3/releaselog/3_5_5.html | |
703 | share/doc/sqlite3/releaselog/3_5_6.html | 704 | share/doc/sqlite3/releaselog/3_5_6.html | |
704 | share/doc/sqlite3/releaselog/3_5_7.html | 705 | share/doc/sqlite3/releaselog/3_5_7.html | |
705 | share/doc/sqlite3/releaselog/3_5_8.html | 706 | share/doc/sqlite3/releaselog/3_5_8.html | |
706 | share/doc/sqlite3/releaselog/3_5_9.html | 707 | share/doc/sqlite3/releaselog/3_5_9.html |
@@ -1,5 +1,5 @@ | @@ -1,5 +1,5 @@ | |||
1 | $NetBSD: distinfo,v 1.134 2024/01/30 20:13:21 adam Exp $ | 1 | $NetBSD: distinfo,v 1.135 2024/03/14 08:07:10 adam Exp $ | |
2 | 2 | |||
3 | BLAKE2s (sqlite-doc-3450100.zip) = 12f9c654025740a673a71b64771c50e6fcf2d05fcdf766f3d94f64e7932b92e4 | 3 | BLAKE2s (sqlite-doc-3450200.zip) = c8ff0b24b98acc56c9f13c0231259ee44ead06663ae9e5e0f64fbfb7a710ff2b | |
4 | SHA512 (sqlite-doc-3450100.zip) = dc036737973a29ea2b6cb4fe7ab4468f449e21eed34a773600570ed2e57ed4d195286c75afec91ab76ac55e25a0cc82e73c3b3119a9c8e7b5918bae8a1a3c8c0 | 4 | SHA512 (sqlite-doc-3450200.zip) = 5e80255b0030dd6dfc0f93a1d6863a35dc319c6567300ac5f4e16d15c322f0b3fc2681cae7d27de0d23bf6731069d0060b9edddf3d7e0b105c538beab53979dc | |
5 | Size (sqlite-doc-3450100.zip) = 10746925 bytes | 5 | Size (sqlite-doc-3450200.zip) = 10755940 bytes |
@@ -1,6 +1,6 @@ | @@ -1,6 +1,6 @@ | |||
1 | $NetBSD: distinfo,v 1.148 2024/01/30 20:13:21 adam Exp $ | 1 | $NetBSD: distinfo,v 1.149 2024/03/14 08:07:10 adam Exp $ | |
2 | 2 | |||
3 | BLAKE2s (sqlite-autoconf-3450100.tar.gz) = 30fb7ef9966c86e7ec7fd309a0ad7a441f3510ddedf74e86f6e794de09cc722d | 3 | BLAKE2s (sqlite-autoconf-3450200.tar.gz) = c3f5369f2a96b70b17d5f2e75cb9ab444a9e72c380d52e77c11457ea738fa549 | |
4 | SHA512 (sqlite-autoconf-3450100.tar.gz) = c6bd4eaa67cada28528d1ac31aec1662c0a11048247a1bb148c1842fb0252934e2096843b56fea94bfb96c4eaaa598ec70ac31f2a5e910388f24f152b9fc4211 | 4 | SHA512 (sqlite-autoconf-3450200.tar.gz) = 7a15feab6319d8718b0ec3fc2077f50e87bbbe0deb5689c3318d5283bbdd72e16f2b2fa8fcf9b1331d8eaffa75c479db044a3c452d1ec09744648a3930505eff | |
5 | Size (sqlite-autoconf-3450100.tar.gz) = 3232682 bytes | 5 | Size (sqlite-autoconf-3450200.tar.gz) = 3234010 bytes | |
6 | SHA1 (patch-Makefile.in) = 8f68039c9169bc69eb0da4bd0f910c7584aed2b5 | 6 | SHA1 (patch-Makefile.in) = 8f68039c9169bc69eb0da4bd0f910c7584aed2b5 |
@@ -1,5 +1,5 @@ | @@ -1,5 +1,5 @@ | |||
1 | $NetBSD: distinfo,v 1.75 2024/01/30 20:13:21 adam Exp $ | 1 | $NetBSD: distinfo,v 1.76 2024/03/14 08:07:10 adam Exp $ | |
2 | 2 | |||
3 | BLAKE2s (sqlite-src-3450100.zip) = ef79f3661a6acc63800b167d4077477d8165df53d78de119c9c49272c1613f75 | 3 | BLAKE2s (sqlite-src-3450200.zip) = 832d5823d49b1d586b5d981d62d4ddf801cd402a3fe210a5ef99ea1123bf93a0 | |
4 | SHA512 (sqlite-src-3450100.zip) = 475de1c473d2d828038a2afb98d74d52b5e0fd06a5bfc8516e44084ed38b1438310172905fd4fe0a64a736d699095ed286dfdee059ceeb50dfb9bb49131e2005 | 4 | SHA512 (sqlite-src-3450200.zip) = b6e875ab4ed24cd564330e50a87f35aae43c382f88ca86c2eedf5308c7fab683c1880c0053408e864b0cec1feb7ae81aca8a91979a3ee3975f26037a7983011a | |
5 | Size (sqlite-src-3450100.zip) = 14152147 bytes | 5 | Size (sqlite-src-3450200.zip) = 14156848 bytes |