Fri Mar 19 06:29:04 2021 UTC ()
sqlite3: updated to 3.35.2

Changes in version 3.35.2:

Fix a problem in the appendvfs.c extension that was introduced into version 3.35.0.
Ensure that date/time functions with no arguments (which generate responses that depend on the current time) are treated as non-deterministic functions. Ticket 2c6c8689fb5f3d2f
Fix a problem in the sqldiff utility program having to do with unusual whitespace characters in a virtual table definition.
Limit the new UNION ALL optimization described by item 8c in the 3.35.0 release so that it does not try to make too many new subqueries. See forum thread 140a67d3d2 for details.


(adam)
diff -r1.76 -r1.77 pkgsrc/databases/sqlite3/Makefile.common
diff -r1.166 -r1.167 pkgsrc/databases/sqlite3/distinfo
diff -r1.99 -r1.100 pkgsrc/databases/sqlite3-docs/PLIST
diff -r1.100 -r1.101 pkgsrc/databases/sqlite3-docs/distinfo
diff -r1.112 -r1.113 pkgsrc/databases/sqlite3-tcl/distinfo
diff -r1.41 -r1.42 pkgsrc/devel/lemon/distinfo

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

--- pkgsrc/databases/sqlite3/Makefile.common 2021/03/17 06:24:42 1.76
+++ pkgsrc/databases/sqlite3/Makefile.common 2021/03/19 06:29:03 1.77
@@ -1,15 +1,15 @@ @@ -1,15 +1,15 @@
1# $NetBSD: Makefile.common,v 1.76 2021/03/17 06:24:42 adam Exp $ 1# $NetBSD: Makefile.common,v 1.77 2021/03/19 06:29:03 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= 3350100 8SQLITE3_DISTVERSION= 3350200
9SQLITE3_VERSION= 3.35.1 9SQLITE3_VERSION= 3.35.2
10 10
11MASTER_SITES= http://www.sqlite.org/2021/ 11MASTER_SITES= http://www.sqlite.org/2021/
12MASTER_SITES+= http://www.hwaci.com/sw/sqlite/2021/ 12MASTER_SITES+= http://www.hwaci.com/sw/sqlite/2021/
13 13
14HOMEPAGE?= http://www.sqlite.org/ 14HOMEPAGE?= http://www.sqlite.org/
15LICENSE= public-domain 15LICENSE= public-domain

cvs diff -r1.166 -r1.167 pkgsrc/databases/sqlite3/distinfo (expand / switch to unified diff)

--- pkgsrc/databases/sqlite3/distinfo 2021/03/17 06:24:42 1.166
+++ pkgsrc/databases/sqlite3/distinfo 2021/03/19 06:29:03 1.167
@@ -1,7 +1,7 @@ @@ -1,7 +1,7 @@
1$NetBSD: distinfo,v 1.166 2021/03/17 06:24:42 adam Exp $ 1$NetBSD: distinfo,v 1.167 2021/03/19 06:29:03 adam Exp $
2 2
3SHA1 (sqlite-autoconf-3350100.tar.gz) = 37dcec2327c817ae3a5ad6cf4960e310ed448299 3SHA1 (sqlite-autoconf-3350200.tar.gz) = ba6994db6d4ffd2797b9340aeb4ad8bd616176f8
4RMD160 (sqlite-autoconf-3350100.tar.gz) = 404a3615aad36fa6f2a79143ca04d770efdc8f75 4RMD160 (sqlite-autoconf-3350200.tar.gz) = 394c3c2b7212a60e2c9bf1d46306b53be6e433fd
5SHA512 (sqlite-autoconf-3350100.tar.gz) = 1106e5d65eabaf3efc6edb83a2db512fef81f660b1160ec970e1a9456799e5f5ca2b96d6fdc660719506daf1931dbd68a6a2e3f74af704f2749fd8f385919c21 5SHA512 (sqlite-autoconf-3350200.tar.gz) = a755c8647028aee9f862533c5e14a9b8627f494b205962798715ed27010e8fda3074f0da005d8c89c560a86b7510a425bf886824cf2de3f2bf129e5d95eb7d1f
6Size (sqlite-autoconf-3350100.tar.gz) = 2955802 bytes 6Size (sqlite-autoconf-3350200.tar.gz) = 2955661 bytes
7SHA1 (patch-configure) = c0aa83bddc20d090b3cd2fd840ac69031f4396e4 7SHA1 (patch-configure) = c0aa83bddc20d090b3cd2fd840ac69031f4396e4

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

--- pkgsrc/databases/sqlite3-docs/PLIST 2021/03/17 06:24:42 1.99
+++ pkgsrc/databases/sqlite3-docs/PLIST 2021/03/19 06:29:04 1.100
@@ -1,14 +1,14 @@ @@ -1,14 +1,14 @@
1@comment $NetBSD: PLIST,v 1.99 2021/03/17 06:24:42 adam Exp $ 1@comment $NetBSD: PLIST,v 1.100 2021/03/19 06:29:04 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
@@ -614,26 +614,27 @@ share/doc/sqlite3/releaselog/3_2_8.html @@ -614,26 +614,27 @@ share/doc/sqlite3/releaselog/3_2_8.html
614share/doc/sqlite3/releaselog/3_30_0.html 614share/doc/sqlite3/releaselog/3_30_0.html
615share/doc/sqlite3/releaselog/3_30_1.html 615share/doc/sqlite3/releaselog/3_30_1.html
616share/doc/sqlite3/releaselog/3_31_0.html 616share/doc/sqlite3/releaselog/3_31_0.html
617share/doc/sqlite3/releaselog/3_31_1.html 617share/doc/sqlite3/releaselog/3_31_1.html
618share/doc/sqlite3/releaselog/3_32_0.html 618share/doc/sqlite3/releaselog/3_32_0.html
619share/doc/sqlite3/releaselog/3_32_1.html 619share/doc/sqlite3/releaselog/3_32_1.html
620share/doc/sqlite3/releaselog/3_32_2.html 620share/doc/sqlite3/releaselog/3_32_2.html
621share/doc/sqlite3/releaselog/3_32_3.html 621share/doc/sqlite3/releaselog/3_32_3.html
622share/doc/sqlite3/releaselog/3_33_0.html 622share/doc/sqlite3/releaselog/3_33_0.html
623share/doc/sqlite3/releaselog/3_34_0.html 623share/doc/sqlite3/releaselog/3_34_0.html
624share/doc/sqlite3/releaselog/3_34_1.html 624share/doc/sqlite3/releaselog/3_34_1.html
625share/doc/sqlite3/releaselog/3_35_0.html 625share/doc/sqlite3/releaselog/3_35_0.html
626share/doc/sqlite3/releaselog/3_35_1.html 626share/doc/sqlite3/releaselog/3_35_1.html
 627share/doc/sqlite3/releaselog/3_35_2.html
627share/doc/sqlite3/releaselog/3_3_0.html 628share/doc/sqlite3/releaselog/3_3_0.html
628share/doc/sqlite3/releaselog/3_3_1.html 629share/doc/sqlite3/releaselog/3_3_1.html
629share/doc/sqlite3/releaselog/3_3_10.html 630share/doc/sqlite3/releaselog/3_3_10.html
630share/doc/sqlite3/releaselog/3_3_11.html 631share/doc/sqlite3/releaselog/3_3_11.html
631share/doc/sqlite3/releaselog/3_3_12.html 632share/doc/sqlite3/releaselog/3_3_12.html
632share/doc/sqlite3/releaselog/3_3_13.html 633share/doc/sqlite3/releaselog/3_3_13.html
633share/doc/sqlite3/releaselog/3_3_14.html 634share/doc/sqlite3/releaselog/3_3_14.html
634share/doc/sqlite3/releaselog/3_3_15.html 635share/doc/sqlite3/releaselog/3_3_15.html
635share/doc/sqlite3/releaselog/3_3_16.html 636share/doc/sqlite3/releaselog/3_3_16.html
636share/doc/sqlite3/releaselog/3_3_17.html 637share/doc/sqlite3/releaselog/3_3_17.html
637share/doc/sqlite3/releaselog/3_3_2.html 638share/doc/sqlite3/releaselog/3_3_2.html
638share/doc/sqlite3/releaselog/3_3_3.html 639share/doc/sqlite3/releaselog/3_3_3.html
639share/doc/sqlite3/releaselog/3_3_4.html 640share/doc/sqlite3/releaselog/3_3_4.html

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

--- pkgsrc/databases/sqlite3-docs/distinfo 2021/03/17 06:24:42 1.100
+++ pkgsrc/databases/sqlite3-docs/distinfo 2021/03/19 06:29:04 1.101
@@ -1,6 +1,6 @@ @@ -1,6 +1,6 @@
1$NetBSD: distinfo,v 1.100 2021/03/17 06:24:42 adam Exp $ 1$NetBSD: distinfo,v 1.101 2021/03/19 06:29:04 adam Exp $
2 2
3SHA1 (sqlite-doc-3350100.zip) = 0560563568606b7f9ef4c31e6db0434b488b488b 3SHA1 (sqlite-doc-3350200.zip) = 3eccd32a15eb373b17ccdd07f91e14d21c7a11e8
4RMD160 (sqlite-doc-3350100.zip) = 2655e30d94d7a8ca18abba94ab84c6c7bfa4286d 4RMD160 (sqlite-doc-3350200.zip) = 5c711e25c5ecfa6acb792677f61ae27bc7b4e078
5SHA512 (sqlite-doc-3350100.zip) = 4843d8186f4cc98fc9ad5459a1b987d4512e72ceeeb985372c22d44f35856e33ee41ab0fa4372c273cfa4730f9461dc3f359ba50f26e53a0c7abd87e70cdfe86 5SHA512 (sqlite-doc-3350200.zip) = 7ef973b804d059cf00c759a0ae001b7714df0472398e7cd55e34f59222df816a36511cefd15fa99abf67dec4291ee6babbc12bd87855194608ff556a5c1182ae
6Size (sqlite-doc-3350100.zip) = 10175402 bytes 6Size (sqlite-doc-3350200.zip) = 10182547 bytes

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

--- pkgsrc/databases/sqlite3-tcl/distinfo 2021/03/17 06:24:43 1.112
+++ pkgsrc/databases/sqlite3-tcl/distinfo 2021/03/19 06:29:04 1.113
@@ -1,7 +1,7 @@ @@ -1,7 +1,7 @@
1$NetBSD: distinfo,v 1.112 2021/03/17 06:24:43 adam Exp $ 1$NetBSD: distinfo,v 1.113 2021/03/19 06:29:04 adam Exp $
2 2
3SHA1 (sqlite-autoconf-3350100.tar.gz) = 37dcec2327c817ae3a5ad6cf4960e310ed448299 3SHA1 (sqlite-autoconf-3350200.tar.gz) = ba6994db6d4ffd2797b9340aeb4ad8bd616176f8
4RMD160 (sqlite-autoconf-3350100.tar.gz) = 404a3615aad36fa6f2a79143ca04d770efdc8f75 4RMD160 (sqlite-autoconf-3350200.tar.gz) = 394c3c2b7212a60e2c9bf1d46306b53be6e433fd
5SHA512 (sqlite-autoconf-3350100.tar.gz) = 1106e5d65eabaf3efc6edb83a2db512fef81f660b1160ec970e1a9456799e5f5ca2b96d6fdc660719506daf1931dbd68a6a2e3f74af704f2749fd8f385919c21 5SHA512 (sqlite-autoconf-3350200.tar.gz) = a755c8647028aee9f862533c5e14a9b8627f494b205962798715ed27010e8fda3074f0da005d8c89c560a86b7510a425bf886824cf2de3f2bf129e5d95eb7d1f
6Size (sqlite-autoconf-3350100.tar.gz) = 2955802 bytes 6Size (sqlite-autoconf-3350200.tar.gz) = 2955661 bytes
7SHA1 (patch-Makefile.in) = 6cbbc33a5bc9c98b5aa128279f8e21e47406f537 7SHA1 (patch-Makefile.in) = 6cbbc33a5bc9c98b5aa128279f8e21e47406f537

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

--- pkgsrc/devel/lemon/distinfo 2021/03/17 06:24:43 1.41
+++ pkgsrc/devel/lemon/distinfo 2021/03/19 06:29:04 1.42
@@ -1,6 +1,6 @@ @@ -1,6 +1,6 @@
1$NetBSD: distinfo,v 1.41 2021/03/17 06:24:43 adam Exp $ 1$NetBSD: distinfo,v 1.42 2021/03/19 06:29:04 adam Exp $
2 2
3SHA1 (sqlite-src-3350100.zip) = 85f1763852b97457dfb0199946d8a4832ba511e0 3SHA1 (sqlite-src-3350200.zip) = 4b1f70ce7a35f7f4e1c0962f90139f6b1edacf88
4RMD160 (sqlite-src-3350100.zip) = dec58a979b81b6ac6ea7c791ff7e4d94c316cd52 4RMD160 (sqlite-src-3350200.zip) = e8601f0a35bc9052b3c56a240b1466eb0327ab29
5SHA512 (sqlite-src-3350100.zip) = 004bcca9c2ae883b05d8f15c8bf28a12fd2fdf9527d1560d137f8e2570c153d14ea5405c500d0e79966a3881a516df4d9ed07be751712f1584df411e86c60977 5SHA512 (sqlite-src-3350200.zip) = d5382bf31d812bc51533d28a583c78d3f389b1ecbe1f9f30cc755059f2867f832c0529e9f97b090be5c5bc855c45611b220b8c29b5648c451490566a70cc5122
6Size (sqlite-src-3350100.zip) = 12814875 bytes 6Size (sqlite-src-3350200.zip) = 12815298 bytes