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.diff -r1.85 -r1.86 pkgsrc/databases/sqlite3/Makefile.common
(adam)
@@ -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 | |||
8 | SQLITE3_DISTVERSION= 3380000 | 8 | SQLITE3_DISTVERSION= 3380100 | |
9 | SQLITE3_VERSION= 3.38.0 | 9 | SQLITE3_VERSION= 3.38.1 | |
10 | 10 | |||
11 | MASTER_SITES= http://www.sqlite.org/2022/ | 11 | MASTER_SITES= http://www.sqlite.org/2022/ | |
12 | MASTER_SITES+= http://www.hwaci.com/sw/sqlite/2022/ | 12 | MASTER_SITES+= http://www.hwaci.com/sw/sqlite/2022/ | |
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.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 | |||
3 | BLAKE2s (sqlite-autoconf-3380000.tar.gz) = 4fd427938f2d2e2436b5e7c8e8d7b143654a6a98e51a7099d526fdd0be71742c | 3 | BLAKE2s (sqlite-autoconf-3380100.tar.gz) = 7a0b11133239900a328dc9089fa626ffc33f1d70092048dc3a456bafc5c952a1 | |
4 | SHA512 (sqlite-autoconf-3380000.tar.gz) = 30577730e54ac4f83acfe0ff2fac9cb2ba6eb917907d7584f2b18ca852382f2f4ff596e1e1cd4ce41fe90ac271501ee97b5e508b7e5072cda713855aae562d28 | 4 | SHA512 (sqlite-autoconf-3380100.tar.gz) = 9ed4ac73f73f14227eb442eb5f7963b92e28cfdb6b88fa380b756740dd38eddc13c8315c78f453c6869bc45aeafdf4946ce133592c3b4a3fdd0861775ec833ec | |
5 | Size (sqlite-autoconf-3380000.tar.gz) = 3030934 bytes | 5 | Size (sqlite-autoconf-3380100.tar.gz) = 3031923 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.108 2022/02/23 17:07:36 adam Exp $ | 1 | @comment $NetBSD: PLIST,v 1.109 2022/03/14 10:01:19 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 | |
@@ -632,26 +632,27 @@ share/doc/sqlite3/releaselog/3_33_0.html | @@ -632,26 +632,27 @@ share/doc/sqlite3/releaselog/3_33_0.html | |||
632 | share/doc/sqlite3/releaselog/3_34_0.html | 632 | share/doc/sqlite3/releaselog/3_34_0.html | |
633 | share/doc/sqlite3/releaselog/3_34_1.html | 633 | share/doc/sqlite3/releaselog/3_34_1.html | |
634 | share/doc/sqlite3/releaselog/3_35_0.html | 634 | share/doc/sqlite3/releaselog/3_35_0.html | |
635 | share/doc/sqlite3/releaselog/3_35_1.html | 635 | share/doc/sqlite3/releaselog/3_35_1.html | |
636 | share/doc/sqlite3/releaselog/3_35_2.html | 636 | share/doc/sqlite3/releaselog/3_35_2.html | |
637 | share/doc/sqlite3/releaselog/3_35_3.html | 637 | share/doc/sqlite3/releaselog/3_35_3.html | |
638 | share/doc/sqlite3/releaselog/3_35_4.html | 638 | share/doc/sqlite3/releaselog/3_35_4.html | |
639 | share/doc/sqlite3/releaselog/3_35_5.html | 639 | share/doc/sqlite3/releaselog/3_35_5.html | |
640 | share/doc/sqlite3/releaselog/3_36_0.html | 640 | share/doc/sqlite3/releaselog/3_36_0.html | |
641 | share/doc/sqlite3/releaselog/3_37_0.html | 641 | share/doc/sqlite3/releaselog/3_37_0.html | |
642 | share/doc/sqlite3/releaselog/3_37_1.html | 642 | share/doc/sqlite3/releaselog/3_37_1.html | |
643 | share/doc/sqlite3/releaselog/3_37_2.html | 643 | share/doc/sqlite3/releaselog/3_37_2.html | |
644 | share/doc/sqlite3/releaselog/3_38_0.html | 644 | share/doc/sqlite3/releaselog/3_38_0.html | |
645 | share/doc/sqlite3/releaselog/3_38_1.html | |||
645 | share/doc/sqlite3/releaselog/3_3_0.html | 646 | share/doc/sqlite3/releaselog/3_3_0.html | |
646 | share/doc/sqlite3/releaselog/3_3_1.html | 647 | share/doc/sqlite3/releaselog/3_3_1.html | |
647 | share/doc/sqlite3/releaselog/3_3_10.html | 648 | share/doc/sqlite3/releaselog/3_3_10.html | |
648 | share/doc/sqlite3/releaselog/3_3_11.html | 649 | share/doc/sqlite3/releaselog/3_3_11.html | |
649 | share/doc/sqlite3/releaselog/3_3_12.html | 650 | share/doc/sqlite3/releaselog/3_3_12.html | |
650 | share/doc/sqlite3/releaselog/3_3_13.html | 651 | share/doc/sqlite3/releaselog/3_3_13.html | |
651 | share/doc/sqlite3/releaselog/3_3_14.html | 652 | share/doc/sqlite3/releaselog/3_3_14.html | |
652 | share/doc/sqlite3/releaselog/3_3_15.html | 653 | share/doc/sqlite3/releaselog/3_3_15.html | |
653 | share/doc/sqlite3/releaselog/3_3_16.html | 654 | share/doc/sqlite3/releaselog/3_3_16.html | |
654 | share/doc/sqlite3/releaselog/3_3_17.html | 655 | share/doc/sqlite3/releaselog/3_3_17.html | |
655 | share/doc/sqlite3/releaselog/3_3_2.html | 656 | share/doc/sqlite3/releaselog/3_3_2.html | |
656 | share/doc/sqlite3/releaselog/3_3_3.html | 657 | share/doc/sqlite3/releaselog/3_3_3.html | |
657 | share/doc/sqlite3/releaselog/3_3_4.html | 658 | share/doc/sqlite3/releaselog/3_3_4.html |
@@ -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 | |||
3 | BLAKE2s (sqlite-doc-3380000.zip) = 86d1732125b456fdfb4b86131ff4b2ac27aec58eef4a31044b2167ef24aaa9b7 | 3 | BLAKE2s (sqlite-doc-3380100.zip) = 17ee199d3aea6f4008ed3cf9278a7361ddf7eb5672367ca390cf838a38753628 | |
4 | SHA512 (sqlite-doc-3380000.zip) = 8e1f77504a1057cd23a8a6c2a285d63c5df50ceaf6ab84054a6f5422286dd868bdb3d5bd9be180b7834caba2b65ca185ffff60455bb504df30801157b62a62ef | 4 | SHA512 (sqlite-doc-3380100.zip) = ccdfee3d07f2c43b6dda52a2240fd3e72ada38be5a644d097b23116e1b0c2e21f539bf56afbae30fc4275b9b4a954393f95b0a5272bcf18c98e1538d190ff6bc | |
5 | Size (sqlite-doc-3380000.zip) = 10603776 bytes | 5 | Size (sqlite-doc-3380100.zip) = 10615296 bytes |
@@ -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 | |||
3 | BLAKE2s (sqlite-autoconf-3380000.tar.gz) = 4fd427938f2d2e2436b5e7c8e8d7b143654a6a98e51a7099d526fdd0be71742c | 3 | BLAKE2s (sqlite-autoconf-3380100.tar.gz) = 7a0b11133239900a328dc9089fa626ffc33f1d70092048dc3a456bafc5c952a1 | |
4 | SHA512 (sqlite-autoconf-3380000.tar.gz) = 30577730e54ac4f83acfe0ff2fac9cb2ba6eb917907d7584f2b18ca852382f2f4ff596e1e1cd4ce41fe90ac271501ee97b5e508b7e5072cda713855aae562d28 | 4 | SHA512 (sqlite-autoconf-3380100.tar.gz) = 9ed4ac73f73f14227eb442eb5f7963b92e28cfdb6b88fa380b756740dd38eddc13c8315c78f453c6869bc45aeafdf4946ce133592c3b4a3fdd0861775ec833ec | |
5 | Size (sqlite-autoconf-3380000.tar.gz) = 3030934 bytes | 5 | Size (sqlite-autoconf-3380100.tar.gz) = 3031923 bytes | |
6 | SHA1 (patch-Makefile.in) = 6cbbc33a5bc9c98b5aa128279f8e21e47406f537 | 6 | SHA1 (patch-Makefile.in) = 6cbbc33a5bc9c98b5aa128279f8e21e47406f537 |
@@ -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 | |||
3 | BLAKE2s (sqlite-src-3380000.zip) = 1239ff74cd5245e1f5180438a595a0ee68b17c277b8877ca3b6acf87afc5da80 | 3 | BLAKE2s (sqlite-src-3380100.zip) = 0b84704fbcd57e90f00cd69b03aa08eec01904963ab5ecc33ea556f883e28496 | |
4 | SHA512 (sqlite-src-3380000.zip) = 9f4d3c406df5e6290f3f0b5e24b568723ab54bb085cb8cd7621ab42b0b8cd4f76e9784a4a29b42ea8cb0d1b7d759267c3cd980913d490d08e7172df05949131d | 4 | SHA512 (sqlite-src-3380100.zip) = df200916789c15e010a8e62dd8257833f34d4cf3496080a72fdc2330a530c193cda055e3c9ed39a404b87c8001c83a4b187491525ca95b5c5a1dbdd2f41cc222 | |
5 | Size (sqlite-src-3380000.zip) = 13236840 bytes | 5 | Size (sqlite-src-3380100.zip) = 13241298 bytes |