CVS commit: pkgsrc

["Adam Ciarcinski" <adam%netbsd.org@localhost>]

Module Name:    pkgsrc
Committed By:   adam
Date:           Fri Jun 25 21:21:31 UTC 2021

Modified Files:
        pkgsrc/databases/sqlite3: Makefile Makefile.common distinfo
        pkgsrc/databases/sqlite3-docs: PLIST distinfo
        pkgsrc/databases/sqlite3-tcl: Makefile distinfo
        pkgsrc/devel/lemon: distinfo

Log Message:
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.


To generate a diff of this commit:
cvs rdiff -u -r1.140 -r1.141 pkgsrc/databases/sqlite3/Makefile
cvs rdiff -u -r1.80 -r1.81 pkgsrc/databases/sqlite3/Makefile.common
cvs rdiff -u -r1.170 -r1.171 pkgsrc/databases/sqlite3/distinfo
cvs rdiff -u -r1.103 -r1.104 pkgsrc/databases/sqlite3-docs/PLIST
cvs rdiff -u -r1.104 -r1.105 pkgsrc/databases/sqlite3-docs/distinfo
cvs rdiff -u -r1.106 -r1.107 pkgsrc/databases/sqlite3-tcl/Makefile
cvs rdiff -u -r1.116 -r1.117 pkgsrc/databases/sqlite3-tcl/distinfo
cvs rdiff -u -r1.45 -r1.46 pkgsrc/devel/lemon/distinfo

Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.

Modified files:

Index: pkgsrc/databases/sqlite3/Makefile
diff -u pkgsrc/databases/sqlite3/Makefile:1.140 pkgsrc/databases/sqlite3/Makefile:1.141
--- pkgsrc/databases/sqlite3/Makefile:1.140     Wed Apr 21 11:40:15 2021
+++ pkgsrc/databases/sqlite3/Makefile   Fri Jun 25 21:21:31 2021
@@ -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}

Index: pkgsrc/databases/sqlite3/Makefile.common
diff -u pkgsrc/databases/sqlite3/Makefile.common:1.80 pkgsrc/databases/sqlite3/Makefile.common:1.81
--- pkgsrc/databases/sqlite3/Makefile.common:1.80       Tue Apr 20 06:30:07 2021
+++ pkgsrc/databases/sqlite3/Makefile.common    Fri Jun 25 21:21:31 2021
@@ -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/

Index: pkgsrc/databases/sqlite3/distinfo
diff -u pkgsrc/databases/sqlite3/distinfo:1.170 pkgsrc/databases/sqlite3/distinfo:1.171
--- pkgsrc/databases/sqlite3/distinfo:1.170     Tue Apr 20 06:30:07 2021
+++ pkgsrc/databases/sqlite3/distinfo   Fri Jun 25 21:21:31 2021
@@ -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

Index: pkgsrc/databases/sqlite3-docs/PLIST
diff -u pkgsrc/databases/sqlite3-docs/PLIST:1.103 pkgsrc/databases/sqlite3-docs/PLIST:1.104
--- pkgsrc/databases/sqlite3-docs/PLIST:1.103   Tue Apr 20 06:30:07 2021
+++ pkgsrc/databases/sqlite3-docs/PLIST Fri Jun 25 21:21:31 2021
@@ -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.html
 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/nw.png
 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/partial-sort
 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_2.html
 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
 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

Index: pkgsrc/databases/sqlite3-docs/distinfo
diff -u pkgsrc/databases/sqlite3-docs/distinfo:1.104 pkgsrc/databases/sqlite3-docs/distinfo:1.105
--- pkgsrc/databases/sqlite3-docs/distinfo:1.104        Tue Apr 20 06:30:07 2021
+++ pkgsrc/databases/sqlite3-docs/distinfo      Fri Jun 25 21:21:31 2021
@@ -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

Index: pkgsrc/databases/sqlite3-tcl/Makefile
diff -u pkgsrc/databases/sqlite3-tcl/Makefile:1.106 pkgsrc/databases/sqlite3-tcl/Makefile:1.107
--- pkgsrc/databases/sqlite3-tcl/Makefile:1.106 Wed Apr 21 11:41:21 2021
+++ pkgsrc/databases/sqlite3-tcl/Makefile       Fri Jun 25 21:21:31 2021
@@ -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}

Index: pkgsrc/databases/sqlite3-tcl/distinfo
diff -u pkgsrc/databases/sqlite3-tcl/distinfo:1.116 pkgsrc/databases/sqlite3-tcl/distinfo:1.117
--- pkgsrc/databases/sqlite3-tcl/distinfo:1.116 Tue Apr 20 06:30:07 2021
+++ pkgsrc/databases/sqlite3-tcl/distinfo       Fri Jun 25 21:21:31 2021
@@ -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

Index: pkgsrc/devel/lemon/distinfo
diff -u pkgsrc/devel/lemon/distinfo:1.45 pkgsrc/devel/lemon/distinfo:1.46
--- pkgsrc/devel/lemon/distinfo:1.45    Tue Apr 20 06:30:07 2021
+++ pkgsrc/devel/lemon/distinfo Fri Jun 25 21:21:31 2021
@@ -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