Mon Mar 14 10:01:19 2022 UTC ()
sqlite3: updated to 3.38.1

3.38.1 (2022-03-12):

Fix problems with the new Bloom filter optimization that might cause some obscure queries to get an incorrect answer.
Fix the localtime modifier of the date and time functions so that it preserves fractional seconds.
Fix the sqlite_offset SQL function so that it works correctly even in corner cases such as when the argument is a virtual column or the column of a view.
Fix row value IN operator constraints on virtual tables so that they work correctly even if the virtual table implementation relies on bytecode to filter rows that do not satisfy the constraint.
Other minor fixes to assert() statements, test cases, and documentation.


(adam)
diff -r1.85 -r1.86 pkgsrc/databases/sqlite3/Makefile.common
diff -r1.178 -r1.179 pkgsrc/databases/sqlite3/distinfo
diff -r1.108 -r1.109 pkgsrc/databases/sqlite3-docs/PLIST
diff -r1.111 -r1.112 pkgsrc/databases/sqlite3-docs/distinfo
diff -r1.123 -r1.124 pkgsrc/databases/sqlite3-tcl/distinfo
diff -r1.52 -r1.53 pkgsrc/devel/lemon/distinfo

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

--- pkgsrc/databases/sqlite3/Makefile.common 2022/02/23 17:07:36 1.85
+++ pkgsrc/databases/sqlite3/Makefile.common 2022/03/14 10:01:19 1.86
@@ -1,15 +1,15 @@ @@ -1,15 +1,15 @@
1# $NetBSD: Makefile.common,v 1.85 2022/02/23 17:07:36 adam Exp $ 1# $NetBSD: Makefile.common,v 1.86 2022/03/14 10:01:19 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= 3380000 8SQLITE3_DISTVERSION= 3380100
9SQLITE3_VERSION= 3.38.0 9SQLITE3_VERSION= 3.38.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.178 -r1.179 pkgsrc/databases/sqlite3/distinfo (expand / switch to unified diff)

--- pkgsrc/databases/sqlite3/distinfo 2022/02/23 17:07:36 1.178
+++ pkgsrc/databases/sqlite3/distinfo 2022/03/14 10:01:19 1.179
@@ -1,6 +1,6 @@ @@ -1,6 +1,6 @@
1$NetBSD: distinfo,v 1.178 2022/02/23 17:07:36 adam Exp $ 1$NetBSD: distinfo,v 1.179 2022/03/14 10:01:19 adam Exp $
2 2
3BLAKE2s (sqlite-autoconf-3380000.tar.gz) = 4fd427938f2d2e2436b5e7c8e8d7b143654a6a98e51a7099d526fdd0be71742c 3BLAKE2s (sqlite-autoconf-3380100.tar.gz) = 7a0b11133239900a328dc9089fa626ffc33f1d70092048dc3a456bafc5c952a1
4SHA512 (sqlite-autoconf-3380000.tar.gz) = 30577730e54ac4f83acfe0ff2fac9cb2ba6eb917907d7584f2b18ca852382f2f4ff596e1e1cd4ce41fe90ac271501ee97b5e508b7e5072cda713855aae562d28 4SHA512 (sqlite-autoconf-3380100.tar.gz) = 9ed4ac73f73f14227eb442eb5f7963b92e28cfdb6b88fa380b756740dd38eddc13c8315c78f453c6869bc45aeafdf4946ce133592c3b4a3fdd0861775ec833ec
5Size (sqlite-autoconf-3380000.tar.gz) = 3030934 bytes 5Size (sqlite-autoconf-3380100.tar.gz) = 3031923 bytes
6SHA1 (patch-configure) = c0aa83bddc20d090b3cd2fd840ac69031f4396e4 6SHA1 (patch-configure) = c0aa83bddc20d090b3cd2fd840ac69031f4396e4

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

--- pkgsrc/databases/sqlite3-docs/PLIST 2022/02/23 17:07:36 1.108
+++ pkgsrc/databases/sqlite3-docs/PLIST 2022/03/14 10:01:19 1.109
@@ -1,14 +1,14 @@ @@ -1,14 +1,14 @@
1@comment $NetBSD: PLIST,v 1.108 2022/02/23 17:07:36 adam Exp $ 1@comment $NetBSD: PLIST,v 1.109 2022/03/14 10:01:19 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
@@ -632,26 +632,27 @@ share/doc/sqlite3/releaselog/3_33_0.html @@ -632,26 +632,27 @@ share/doc/sqlite3/releaselog/3_33_0.html
632share/doc/sqlite3/releaselog/3_34_0.html 632share/doc/sqlite3/releaselog/3_34_0.html
633share/doc/sqlite3/releaselog/3_34_1.html 633share/doc/sqlite3/releaselog/3_34_1.html
634share/doc/sqlite3/releaselog/3_35_0.html 634share/doc/sqlite3/releaselog/3_35_0.html
635share/doc/sqlite3/releaselog/3_35_1.html 635share/doc/sqlite3/releaselog/3_35_1.html
636share/doc/sqlite3/releaselog/3_35_2.html 636share/doc/sqlite3/releaselog/3_35_2.html
637share/doc/sqlite3/releaselog/3_35_3.html 637share/doc/sqlite3/releaselog/3_35_3.html
638share/doc/sqlite3/releaselog/3_35_4.html 638share/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_3_0.html 646share/doc/sqlite3/releaselog/3_3_0.html
646share/doc/sqlite3/releaselog/3_3_1.html 647share/doc/sqlite3/releaselog/3_3_1.html
647share/doc/sqlite3/releaselog/3_3_10.html 648share/doc/sqlite3/releaselog/3_3_10.html
648share/doc/sqlite3/releaselog/3_3_11.html 649share/doc/sqlite3/releaselog/3_3_11.html
649share/doc/sqlite3/releaselog/3_3_12.html 650share/doc/sqlite3/releaselog/3_3_12.html
650share/doc/sqlite3/releaselog/3_3_13.html 651share/doc/sqlite3/releaselog/3_3_13.html
651share/doc/sqlite3/releaselog/3_3_14.html 652share/doc/sqlite3/releaselog/3_3_14.html
652share/doc/sqlite3/releaselog/3_3_15.html 653share/doc/sqlite3/releaselog/3_3_15.html
653share/doc/sqlite3/releaselog/3_3_16.html 654share/doc/sqlite3/releaselog/3_3_16.html
654share/doc/sqlite3/releaselog/3_3_17.html 655share/doc/sqlite3/releaselog/3_3_17.html
655share/doc/sqlite3/releaselog/3_3_2.html 656share/doc/sqlite3/releaselog/3_3_2.html
656share/doc/sqlite3/releaselog/3_3_3.html 657share/doc/sqlite3/releaselog/3_3_3.html
657share/doc/sqlite3/releaselog/3_3_4.html 658share/doc/sqlite3/releaselog/3_3_4.html

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

--- pkgsrc/databases/sqlite3-docs/distinfo 2022/02/23 17:07:36 1.111
+++ pkgsrc/databases/sqlite3-docs/distinfo 2022/03/14 10:01:19 1.112
@@ -1,5 +1,5 @@ @@ -1,5 +1,5 @@
1$NetBSD: distinfo,v 1.111 2022/02/23 17:07:36 adam Exp $ 1$NetBSD: distinfo,v 1.112 2022/03/14 10:01:19 adam Exp $
2 2
3BLAKE2s (sqlite-doc-3380000.zip) = 86d1732125b456fdfb4b86131ff4b2ac27aec58eef4a31044b2167ef24aaa9b7 3BLAKE2s (sqlite-doc-3380100.zip) = 17ee199d3aea6f4008ed3cf9278a7361ddf7eb5672367ca390cf838a38753628
4SHA512 (sqlite-doc-3380000.zip) = 8e1f77504a1057cd23a8a6c2a285d63c5df50ceaf6ab84054a6f5422286dd868bdb3d5bd9be180b7834caba2b65ca185ffff60455bb504df30801157b62a62ef 4SHA512 (sqlite-doc-3380100.zip) = ccdfee3d07f2c43b6dda52a2240fd3e72ada38be5a644d097b23116e1b0c2e21f539bf56afbae30fc4275b9b4a954393f95b0a5272bcf18c98e1538d190ff6bc
5Size (sqlite-doc-3380000.zip) = 10603776 bytes 5Size (sqlite-doc-3380100.zip) = 10615296 bytes

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

--- pkgsrc/databases/sqlite3-tcl/distinfo 2022/02/23 17:07:37 1.123
+++ pkgsrc/databases/sqlite3-tcl/distinfo 2022/03/14 10:01:19 1.124
@@ -1,6 +1,6 @@ @@ -1,6 +1,6 @@
1$NetBSD: distinfo,v 1.123 2022/02/23 17:07:37 adam Exp $ 1$NetBSD: distinfo,v 1.124 2022/03/14 10:01:19 adam Exp $
2 2
3BLAKE2s (sqlite-autoconf-3380000.tar.gz) = 4fd427938f2d2e2436b5e7c8e8d7b143654a6a98e51a7099d526fdd0be71742c 3BLAKE2s (sqlite-autoconf-3380100.tar.gz) = 7a0b11133239900a328dc9089fa626ffc33f1d70092048dc3a456bafc5c952a1
4SHA512 (sqlite-autoconf-3380000.tar.gz) = 30577730e54ac4f83acfe0ff2fac9cb2ba6eb917907d7584f2b18ca852382f2f4ff596e1e1cd4ce41fe90ac271501ee97b5e508b7e5072cda713855aae562d28 4SHA512 (sqlite-autoconf-3380100.tar.gz) = 9ed4ac73f73f14227eb442eb5f7963b92e28cfdb6b88fa380b756740dd38eddc13c8315c78f453c6869bc45aeafdf4946ce133592c3b4a3fdd0861775ec833ec
5Size (sqlite-autoconf-3380000.tar.gz) = 3030934 bytes 5Size (sqlite-autoconf-3380100.tar.gz) = 3031923 bytes
6SHA1 (patch-Makefile.in) = 6cbbc33a5bc9c98b5aa128279f8e21e47406f537 6SHA1 (patch-Makefile.in) = 6cbbc33a5bc9c98b5aa128279f8e21e47406f537

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

--- pkgsrc/devel/lemon/distinfo 2022/02/23 17:07:37 1.52
+++ pkgsrc/devel/lemon/distinfo 2022/03/14 10:01:19 1.53
@@ -1,5 +1,5 @@ @@ -1,5 +1,5 @@
1$NetBSD: distinfo,v 1.52 2022/02/23 17:07:37 adam Exp $ 1$NetBSD: distinfo,v 1.53 2022/03/14 10:01:19 adam Exp $
2 2
3BLAKE2s (sqlite-src-3380000.zip) = 1239ff74cd5245e1f5180438a595a0ee68b17c277b8877ca3b6acf87afc5da80 3BLAKE2s (sqlite-src-3380100.zip) = 0b84704fbcd57e90f00cd69b03aa08eec01904963ab5ecc33ea556f883e28496
4SHA512 (sqlite-src-3380000.zip) = 9f4d3c406df5e6290f3f0b5e24b568723ab54bb085cb8cd7621ab42b0b8cd4f76e9784a4a29b42ea8cb0d1b7d759267c3cd980913d490d08e7172df05949131d 4SHA512 (sqlite-src-3380100.zip) = df200916789c15e010a8e62dd8257833f34d4cf3496080a72fdc2330a530c193cda055e3c9ed39a404b87c8001c83a4b187491525ca95b5c5a1dbdd2f41cc222
5Size (sqlite-src-3380000.zip) = 13236840 bytes 5Size (sqlite-src-3380100.zip) = 13241298 bytes