[pkgsrc/trunk]: pkgsrc sqlite3: updated to 3.38.1

[adam <adam%pkgsrc.org@localhost>]

details:   https://anonhg.NetBSD.org/pkgsrc/rev/f6a7f24d30ec
branches:  trunk
changeset: 375418:f6a7f24d30ec
user:      adam <adam%pkgsrc.org@localhost>
date:      Mon Mar 14 10:01:19 2022 +0000

description:
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.

diffstat:

 databases/sqlite3-docs/PLIST      |  3 ++-
 databases/sqlite3-docs/distinfo   |  8 ++++----
 databases/sqlite3-tcl/distinfo    |  8 ++++----
 databases/sqlite3/Makefile.common |  6 +++---
 databases/sqlite3/distinfo        |  8 ++++----
 devel/lemon/distinfo              |  8 ++++----
 6 files changed, 21 insertions(+), 20 deletions(-)

diffs (90 lines):

diff -r 7ba98880b2f5 -r f6a7f24d30ec databases/sqlite3-docs/PLIST
--- a/databases/sqlite3-docs/PLIST      Mon Mar 14 03:10:49 2022 +0000
+++ b/databases/sqlite3-docs/PLIST      Mon Mar 14 10:01:19 2022 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.108 2022/02/23 17:07:36 adam Exp $
+@comment $NetBSD: PLIST,v 1.109 2022/03/14 10:01:19 adam Exp $
 share/doc/sqlite3/34to35.html
 share/doc/sqlite3/35to36.html
 share/doc/sqlite3/about.html
@@ -642,6 +642,7 @@
 share/doc/sqlite3/releaselog/3_37_1.html
 share/doc/sqlite3/releaselog/3_37_2.html
 share/doc/sqlite3/releaselog/3_38_0.html
+share/doc/sqlite3/releaselog/3_38_1.html
 share/doc/sqlite3/releaselog/3_3_0.html
 share/doc/sqlite3/releaselog/3_3_1.html
 share/doc/sqlite3/releaselog/3_3_10.html
diff -r 7ba98880b2f5 -r f6a7f24d30ec databases/sqlite3-docs/distinfo
--- a/databases/sqlite3-docs/distinfo   Mon Mar 14 03:10:49 2022 +0000
+++ b/databases/sqlite3-docs/distinfo   Mon Mar 14 10:01:19 2022 +0000
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.111 2022/02/23 17:07:36 adam Exp $
+$NetBSD: distinfo,v 1.112 2022/03/14 10:01:19 adam Exp $
 
-BLAKE2s (sqlite-doc-3380000.zip) = 86d1732125b456fdfb4b86131ff4b2ac27aec58eef4a31044b2167ef24aaa9b7
-SHA512 (sqlite-doc-3380000.zip) = 8e1f77504a1057cd23a8a6c2a285d63c5df50ceaf6ab84054a6f5422286dd868bdb3d5bd9be180b7834caba2b65ca185ffff60455bb504df30801157b62a62ef
-Size (sqlite-doc-3380000.zip) = 10603776 bytes
+BLAKE2s (sqlite-doc-3380100.zip) = 17ee199d3aea6f4008ed3cf9278a7361ddf7eb5672367ca390cf838a38753628
+SHA512 (sqlite-doc-3380100.zip) = ccdfee3d07f2c43b6dda52a2240fd3e72ada38be5a644d097b23116e1b0c2e21f539bf56afbae30fc4275b9b4a954393f95b0a5272bcf18c98e1538d190ff6bc
+Size (sqlite-doc-3380100.zip) = 10615296 bytes
diff -r 7ba98880b2f5 -r f6a7f24d30ec databases/sqlite3-tcl/distinfo
--- a/databases/sqlite3-tcl/distinfo    Mon Mar 14 03:10:49 2022 +0000
+++ b/databases/sqlite3-tcl/distinfo    Mon Mar 14 10:01:19 2022 +0000
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.123 2022/02/23 17:07:37 adam Exp $
+$NetBSD: distinfo,v 1.124 2022/03/14 10:01:19 adam Exp $
 
-BLAKE2s (sqlite-autoconf-3380000.tar.gz) = 4fd427938f2d2e2436b5e7c8e8d7b143654a6a98e51a7099d526fdd0be71742c
-SHA512 (sqlite-autoconf-3380000.tar.gz) = 30577730e54ac4f83acfe0ff2fac9cb2ba6eb917907d7584f2b18ca852382f2f4ff596e1e1cd4ce41fe90ac271501ee97b5e508b7e5072cda713855aae562d28
-Size (sqlite-autoconf-3380000.tar.gz) = 3030934 bytes
+BLAKE2s (sqlite-autoconf-3380100.tar.gz) = 7a0b11133239900a328dc9089fa626ffc33f1d70092048dc3a456bafc5c952a1
+SHA512 (sqlite-autoconf-3380100.tar.gz) = 9ed4ac73f73f14227eb442eb5f7963b92e28cfdb6b88fa380b756740dd38eddc13c8315c78f453c6869bc45aeafdf4946ce133592c3b4a3fdd0861775ec833ec
+Size (sqlite-autoconf-3380100.tar.gz) = 3031923 bytes
 SHA1 (patch-Makefile.in) = 6cbbc33a5bc9c98b5aa128279f8e21e47406f537
diff -r 7ba98880b2f5 -r f6a7f24d30ec databases/sqlite3/Makefile.common
--- a/databases/sqlite3/Makefile.common Mon Mar 14 03:10:49 2022 +0000
+++ b/databases/sqlite3/Makefile.common Mon Mar 14 10:01:19 2022 +0000
@@ -1,12 +1,12 @@
-# $NetBSD: Makefile.common,v 1.85 2022/02/23 17:07:36 adam Exp $
+# $NetBSD: Makefile.common,v 1.86 2022/03/14 10:01:19 adam Exp $
 #
 # used by databases/sqlite3/Makefile
 # used by databases/sqlite3-docs/Makefile
 # used by databases/sqlite3-tcl/Makefile
 # used by devel/lemon/Makefile
 
-SQLITE3_DISTVERSION=   3380000
-SQLITE3_VERSION=       3.38.0
+SQLITE3_DISTVERSION=   3380100
+SQLITE3_VERSION=       3.38.1
 
 MASTER_SITES=  http://www.sqlite.org/2022/
 MASTER_SITES+= http://www.hwaci.com/sw/sqlite/2022/
diff -r 7ba98880b2f5 -r f6a7f24d30ec databases/sqlite3/distinfo
--- a/databases/sqlite3/distinfo        Mon Mar 14 03:10:49 2022 +0000
+++ b/databases/sqlite3/distinfo        Mon Mar 14 10:01:19 2022 +0000
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.178 2022/02/23 17:07:36 adam Exp $
+$NetBSD: distinfo,v 1.179 2022/03/14 10:01:19 adam Exp $
 
-BLAKE2s (sqlite-autoconf-3380000.tar.gz) = 4fd427938f2d2e2436b5e7c8e8d7b143654a6a98e51a7099d526fdd0be71742c
-SHA512 (sqlite-autoconf-3380000.tar.gz) = 30577730e54ac4f83acfe0ff2fac9cb2ba6eb917907d7584f2b18ca852382f2f4ff596e1e1cd4ce41fe90ac271501ee97b5e508b7e5072cda713855aae562d28
-Size (sqlite-autoconf-3380000.tar.gz) = 3030934 bytes
+BLAKE2s (sqlite-autoconf-3380100.tar.gz) = 7a0b11133239900a328dc9089fa626ffc33f1d70092048dc3a456bafc5c952a1
+SHA512 (sqlite-autoconf-3380100.tar.gz) = 9ed4ac73f73f14227eb442eb5f7963b92e28cfdb6b88fa380b756740dd38eddc13c8315c78f453c6869bc45aeafdf4946ce133592c3b4a3fdd0861775ec833ec
+Size (sqlite-autoconf-3380100.tar.gz) = 3031923 bytes
 SHA1 (patch-configure) = c0aa83bddc20d090b3cd2fd840ac69031f4396e4
diff -r 7ba98880b2f5 -r f6a7f24d30ec devel/lemon/distinfo
--- a/devel/lemon/distinfo      Mon Mar 14 03:10:49 2022 +0000
+++ b/devel/lemon/distinfo      Mon Mar 14 10:01:19 2022 +0000
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.52 2022/02/23 17:07:37 adam Exp $
+$NetBSD: distinfo,v 1.53 2022/03/14 10:01:19 adam Exp $
 
-BLAKE2s (sqlite-src-3380000.zip) = 1239ff74cd5245e1f5180438a595a0ee68b17c277b8877ca3b6acf87afc5da80
-SHA512 (sqlite-src-3380000.zip) = 9f4d3c406df5e6290f3f0b5e24b568723ab54bb085cb8cd7621ab42b0b8cd4f76e9784a4a29b42ea8cb0d1b7d759267c3cd980913d490d08e7172df05949131d
-Size (sqlite-src-3380000.zip) = 13236840 bytes
+BLAKE2s (sqlite-src-3380100.zip) = 0b84704fbcd57e90f00cd69b03aa08eec01904963ab5ecc33ea556f883e28496
+SHA512 (sqlite-src-3380100.zip) = df200916789c15e010a8e62dd8257833f34d4cf3496080a72fdc2330a530c193cda055e3c9ed39a404b87c8001c83a4b187491525ca95b5c5a1dbdd2f41cc222
+Size (sqlite-src-3380100.zip) = 13241298 bytes