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

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

details:   https://anonhg.NetBSD.org/pkgsrc/rev/f6bf7175b031
branches:  trunk
changeset: 455021:f6bf7175b031
user:      adam <adam%pkgsrc.org@localhost>
date:      Fri Jun 25 21:21:31 2021 +0000

description:
sqlite3: updated to 3.36.0

SQLite Release 3.36.0 On 2021-06-18

Improvement to the EXPLAIN QUERY PLAN output to make it easier to understand.
Byte-order marks at the start of a token are skipped as if they were whitespace.
An error is raised on any attempt to access the rowid of a VIEW or subquery. Formerly, the rowid of a VIEW would be indeterminate and often would be NULL. The -DSQLITE_ALLOW_ROWID_IN_VIEW 
compile-time option is available to restore the legacy behavior for applications that need it.
The sqlite3_deserialize() and sqlite3_serialize() interfaces are now enabled by default. The -DSQLITE_ENABLE_DESERIALIZE compile-time option is no longer required. Instead, there is is a new 
-DSQLITE_OMIT_DESERIALIZE compile-time option to omit those interfaces.
The "memdb" VFS now allows the same in-memory database to be shared among multiple database connections in the same process as long as the database name begins with "/".
Back out the EXISTS-to-IN optimization (item 8b in the SQLite 3.35.0 change log) as it was found to slow down queries more often than speed them up.
Improve the constant-propagation optimization so that it works on non-join queries.
The REGEXP extension is now included in CLI builds.

diffstat:

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

diffs (153 lines):

diff -r 8fc76b972249 -r f6bf7175b031 databases/sqlite3-docs/PLIST
--- a/databases/sqlite3-docs/PLIST      Fri Jun 25 21:08:23 2021 +0000
+++ b/databases/sqlite3-docs/PLIST      Fri Jun 25 21:21:31 2021 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.103 2021/04/20 06:30:07 adam Exp $
+@comment $NetBSD: PLIST,v 1.104 2021/06/25 21:21:31 adam Exp $
 share/doc/sqlite3/34to35.html
 share/doc/sqlite3/35to36.html
 share/doc/sqlite3/about.html
@@ -152,7 +152,7 @@
 share/doc/sqlite3/c3ref/pcache_methods2.html
 share/doc/sqlite3/c3ref/pcache_page.html
 share/doc/sqlite3/c3ref/prepare.html
-share/doc/sqlite3/c3ref/preupdate_count.html
+share/doc/sqlite3/c3ref/preupdate_blobwrite.html
 share/doc/sqlite3/c3ref/profile.html
 share/doc/sqlite3/c3ref/progress_handler.html
 share/doc/sqlite3/c3ref/randomness.html
@@ -430,6 +430,7 @@
 share/doc/sqlite3/images/powered_by_sqlite.gif
 share/doc/sqlite3/images/private_branch.gif
 share/doc/sqlite3/images/qp/fqp1.gif
+share/doc/sqlite3/images/qp/fqp1.pikchr
 share/doc/sqlite3/images/qp/fruitobstate.gif
 share/doc/sqlite3/images/qp/fruitobstate0.gif
 share/doc/sqlite3/images/qp/fullscan.gif
@@ -453,6 +454,7 @@
 share/doc/sqlite3/images/qp/rowidlu.gif
 share/doc/sqlite3/images/qp/tab.gif
 share/doc/sqlite3/images/qp/tpchq8.gif
+share/doc/sqlite3/images/qp/tpchq8.pikchr
 share/doc/sqlite3/images/se.gif
 share/doc/sqlite3/images/se.png
 share/doc/sqlite3/images/shane1.jpg
@@ -628,6 +630,7 @@
 share/doc/sqlite3/releaselog/3_35_3.html
 share/doc/sqlite3/releaselog/3_35_4.html
 share/doc/sqlite3/releaselog/3_35_5.html
+share/doc/sqlite3/releaselog/3_36_0.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
@@ -802,6 +805,7 @@
 share/doc/sqlite3/session/sqlite3rebaser_rebase.html
 share/doc/sqlite3/session/sqlite3session_attach.html
 share/doc/sqlite3/session/sqlite3session_changeset.html
+share/doc/sqlite3/session/sqlite3session_changeset_size.html
 share/doc/sqlite3/session/sqlite3session_config.html
 share/doc/sqlite3/session/sqlite3session_create.html
 share/doc/sqlite3/session/sqlite3session_delete.html
diff -r 8fc76b972249 -r f6bf7175b031 databases/sqlite3-docs/distinfo
--- a/databases/sqlite3-docs/distinfo   Fri Jun 25 21:08:23 2021 +0000
+++ b/databases/sqlite3-docs/distinfo   Fri Jun 25 21:21:31 2021 +0000
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.104 2021/04/20 06:30:07 adam Exp $
+$NetBSD: distinfo,v 1.105 2021/06/25 21:21:31 adam Exp $
 
-SHA1 (sqlite-doc-3350500.zip) = c973cdbbd171064260601fe7b65bbdd51a33337e
-RMD160 (sqlite-doc-3350500.zip) = d73900ea392c3639795bc7401099935c1c1c032a
-SHA512 (sqlite-doc-3350500.zip) = 2da5357623f4db7003f46ec7ea8bdd8a794ad6e1be9a25a8ebccfe5222da43eabc32d9d17acfd7766aa4cf1fd010e476a8087fab78ac6f6596c7c5b8a06de685
-Size (sqlite-doc-3350500.zip) = 10205830 bytes
+SHA1 (sqlite-doc-3360000.zip) = d1d98e937d565c2f8fa585498d9fde463330d2be
+RMD160 (sqlite-doc-3360000.zip) = ad61422978de7a234f469cf007362be534c9b177
+SHA512 (sqlite-doc-3360000.zip) = c9b5628f823c322688e2fcce0effe7564dccaf8bcdbb3397ee09c433975bfb5fd63fd81830c5c6d573314e1e55d25cdf1b3842d798f7be63b9b88b32f6694add
+Size (sqlite-doc-3360000.zip) = 12274411 bytes
diff -r 8fc76b972249 -r f6bf7175b031 databases/sqlite3-tcl/Makefile
--- a/databases/sqlite3-tcl/Makefile    Fri Jun 25 21:08:23 2021 +0000
+++ b/databases/sqlite3-tcl/Makefile    Fri Jun 25 21:21:31 2021 +0000
@@ -1,6 +1,5 @@
-# $NetBSD: Makefile,v 1.106 2021/04/21 11:41:21 adam Exp $
+# $NetBSD: Makefile,v 1.107 2021/06/25 21:21:31 adam Exp $
 
-PKGREVISION= 1
 .include "../../databases/sqlite3/Makefile.common"
 
 DISTNAME=      sqlite-autoconf-${SQLITE3_DISTVERSION}
diff -r 8fc76b972249 -r f6bf7175b031 databases/sqlite3-tcl/distinfo
--- a/databases/sqlite3-tcl/distinfo    Fri Jun 25 21:08:23 2021 +0000
+++ b/databases/sqlite3-tcl/distinfo    Fri Jun 25 21:21:31 2021 +0000
@@ -1,7 +1,7 @@
-$NetBSD: distinfo,v 1.116 2021/04/20 06:30:07 adam Exp $
+$NetBSD: distinfo,v 1.117 2021/06/25 21:21:31 adam Exp $
 
-SHA1 (sqlite-autoconf-3350500.tar.gz) = f6875472fc86c679400ede139d1dfc6937003abc
-RMD160 (sqlite-autoconf-3350500.tar.gz) = 2296997b18ab1b16a9371f039bd9f55e5e74fe82
-SHA512 (sqlite-autoconf-3350500.tar.gz) = 039af796f79fc4517be0bd5ba37886264d49da309e234ae6fccdb488ef0109ed2b917fc3e6c1fc7224dff4f736824c653aaf8f0a37550c5ebc14d035cb8ac737
-Size (sqlite-autoconf-3350500.tar.gz) = 2956627 bytes
+SHA1 (sqlite-autoconf-3360000.tar.gz) = a4bcf9e951bfb9745214241ba08476299fc2dc1e
+RMD160 (sqlite-autoconf-3360000.tar.gz) = ef34b98fbe1f3436fc0d1255ae2fa9a660011cb2
+SHA512 (sqlite-autoconf-3360000.tar.gz) = e59c57f421b4956c7759af528a2da929167e15179ab9d28267474683e2272f93c901203e5a648732f1a3d43e7be3ac4217c3cdd7adf108c378b9127b771a7cd0
+Size (sqlite-autoconf-3360000.tar.gz) = 2977080 bytes
 SHA1 (patch-Makefile.in) = 6cbbc33a5bc9c98b5aa128279f8e21e47406f537
diff -r 8fc76b972249 -r f6bf7175b031 databases/sqlite3/Makefile
--- a/databases/sqlite3/Makefile        Fri Jun 25 21:08:23 2021 +0000
+++ b/databases/sqlite3/Makefile        Fri Jun 25 21:21:31 2021 +0000
@@ -1,6 +1,5 @@
-# $NetBSD: Makefile,v 1.140 2021/04/21 11:40:15 adam Exp $
+# $NetBSD: Makefile,v 1.141 2021/06/25 21:21:31 adam Exp $
 
-PKGREVISION= 1
 .include "Makefile.common"
 
 DISTNAME=      sqlite-autoconf-${SQLITE3_DISTVERSION}
diff -r 8fc76b972249 -r f6bf7175b031 databases/sqlite3/Makefile.common
--- a/databases/sqlite3/Makefile.common Fri Jun 25 21:08:23 2021 +0000
+++ b/databases/sqlite3/Makefile.common Fri Jun 25 21:21:31 2021 +0000
@@ -1,12 +1,12 @@
-# $NetBSD: Makefile.common,v 1.80 2021/04/20 06:30:07 adam Exp $
+# $NetBSD: Makefile.common,v 1.81 2021/06/25 21:21:31 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=   3350500
-SQLITE3_VERSION=       3.35.5
+SQLITE3_DISTVERSION=   3360000
+SQLITE3_VERSION=       3.36.0
 
 MASTER_SITES=  http://www.sqlite.org/2021/
 MASTER_SITES+= http://www.hwaci.com/sw/sqlite/2021/
diff -r 8fc76b972249 -r f6bf7175b031 databases/sqlite3/distinfo
--- a/databases/sqlite3/distinfo        Fri Jun 25 21:08:23 2021 +0000
+++ b/databases/sqlite3/distinfo        Fri Jun 25 21:21:31 2021 +0000
@@ -1,7 +1,7 @@
-$NetBSD: distinfo,v 1.170 2021/04/20 06:30:07 adam Exp $
+$NetBSD: distinfo,v 1.171 2021/06/25 21:21:31 adam Exp $
 
-SHA1 (sqlite-autoconf-3350500.tar.gz) = f6875472fc86c679400ede139d1dfc6937003abc
-RMD160 (sqlite-autoconf-3350500.tar.gz) = 2296997b18ab1b16a9371f039bd9f55e5e74fe82
-SHA512 (sqlite-autoconf-3350500.tar.gz) = 039af796f79fc4517be0bd5ba37886264d49da309e234ae6fccdb488ef0109ed2b917fc3e6c1fc7224dff4f736824c653aaf8f0a37550c5ebc14d035cb8ac737
-Size (sqlite-autoconf-3350500.tar.gz) = 2956627 bytes
+SHA1 (sqlite-autoconf-3360000.tar.gz) = a4bcf9e951bfb9745214241ba08476299fc2dc1e
+RMD160 (sqlite-autoconf-3360000.tar.gz) = ef34b98fbe1f3436fc0d1255ae2fa9a660011cb2
+SHA512 (sqlite-autoconf-3360000.tar.gz) = e59c57f421b4956c7759af528a2da929167e15179ab9d28267474683e2272f93c901203e5a648732f1a3d43e7be3ac4217c3cdd7adf108c378b9127b771a7cd0
+Size (sqlite-autoconf-3360000.tar.gz) = 2977080 bytes
 SHA1 (patch-configure) = c0aa83bddc20d090b3cd2fd840ac69031f4396e4
diff -r 8fc76b972249 -r f6bf7175b031 devel/lemon/distinfo
--- a/devel/lemon/distinfo      Fri Jun 25 21:08:23 2021 +0000
+++ b/devel/lemon/distinfo      Fri Jun 25 21:21:31 2021 +0000
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.45 2021/04/20 06:30:07 adam Exp $
+$NetBSD: distinfo,v 1.46 2021/06/25 21:21:31 adam Exp $
 
-SHA1 (sqlite-src-3350500.zip) = 3f5685eb64803c99fe92d5425c4688a57fef033e
-RMD160 (sqlite-src-3350500.zip) = 880d8578a7e55d6e1d05a48b9094dc1aff33c7b9
-SHA512 (sqlite-src-3350500.zip) = f9afd11b3c42a8241f91e2ecafc3928e7391cc0f1fbee236b8122c2d3ca922d0c82d2605968b131351b6c5e38f983f8eed29b86c94cfa72799e2387b3b3db561
-Size (sqlite-src-3350500.zip) = 12819198 bytes
+SHA1 (sqlite-src-3360000.zip) = ff0ccd70809c63e6c6a961d40eae6b6af6b46136
+RMD160 (sqlite-src-3360000.zip) = 45e24313d68f6f4552e8f508e6afa4aeac4b230a
+SHA512 (sqlite-src-3360000.zip) = 4083f96265c59001d21dce4d0288ddc6ea80ae079cbce2144c0fc3200b1904fd0d665fc54b08978c6b818527580042cde025c03b73d20d0bc56ccbeb75a330c3
+Size (sqlite-src-3360000.zip) = 12985683 bytes