Fri Jun 25 21:21:31 2021 UTC ()
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.


(adam)
diff -r1.140 -r1.141 pkgsrc/databases/sqlite3/Makefile
diff -r1.80 -r1.81 pkgsrc/databases/sqlite3/Makefile.common
diff -r1.170 -r1.171 pkgsrc/databases/sqlite3/distinfo
diff -r1.103 -r1.104 pkgsrc/databases/sqlite3-docs/PLIST
diff -r1.104 -r1.105 pkgsrc/databases/sqlite3-docs/distinfo
diff -r1.106 -r1.107 pkgsrc/databases/sqlite3-tcl/Makefile
diff -r1.116 -r1.117 pkgsrc/databases/sqlite3-tcl/distinfo
diff -r1.45 -r1.46 pkgsrc/devel/lemon/distinfo
cvs diff -r1.140 -r1.141 pkgsrc/databases/sqlite3/Makefile (expand / switch to context diff)
--- pkgsrc/databases/sqlite3/Makefile 2021/04/21 11:40:15 1.140
+++ pkgsrc/databases/sqlite3/Makefile 2021/06/25 21:21:31 1.141
@@ -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}
cvs diff -r1.80 -r1.81 pkgsrc/databases/sqlite3/Makefile.common (expand / switch to context diff)
--- pkgsrc/databases/sqlite3/Makefile.common 2021/04/20 06:30:07 1.80
+++ pkgsrc/databases/sqlite3/Makefile.common 2021/06/25 21:21:31 1.81
@@ -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/
cvs diff -r1.170 -r1.171 pkgsrc/databases/sqlite3/distinfo (expand / switch to context diff)
--- pkgsrc/databases/sqlite3/distinfo 2021/04/20 06:30:07 1.170
+++ pkgsrc/databases/sqlite3/distinfo 2021/06/25 21:21:31 1.171
@@ -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
cvs diff -r1.103 -r1.104 pkgsrc/databases/sqlite3-docs/PLIST (expand / switch to context diff)
--- pkgsrc/databases/sqlite3-docs/PLIST 2021/04/20 06:30:07 1.103
+++ pkgsrc/databases/sqlite3-docs/PLIST 2021/06/25 21:21:31 1.104
@@ -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
cvs diff -r1.104 -r1.105 pkgsrc/databases/sqlite3-docs/distinfo (expand / switch to context diff)
--- pkgsrc/databases/sqlite3-docs/distinfo 2021/04/20 06:30:07 1.104
+++ pkgsrc/databases/sqlite3-docs/distinfo 2021/06/25 21:21:31 1.105
@@ -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
+SHA1 (sqlite-doc-3360000.zip) = d1d98e937d565c2f8fa585498d9fde463330d2be
-RMD160 (sqlite-doc-3350500.zip) = d73900ea392c3639795bc7401099935c1c1c032a
+RMD160 (sqlite-doc-3360000.zip) = ad61422978de7a234f469cf007362be534c9b177
-SHA512 (sqlite-doc-3350500.zip) = 2da5357623f4db7003f46ec7ea8bdd8a794ad6e1be9a25a8ebccfe5222da43eabc32d9d17acfd7766aa4cf1fd010e476a8087fab78ac6f6596c7c5b8a06de685
+SHA512 (sqlite-doc-3360000.zip) = c9b5628f823c322688e2fcce0effe7564dccaf8bcdbb3397ee09c433975bfb5fd63fd81830c5c6d573314e1e55d25cdf1b3842d798f7be63b9b88b32f6694add
-Size (sqlite-doc-3350500.zip) = 10205830 bytes
+Size (sqlite-doc-3360000.zip) = 12274411 bytes
cvs diff -r1.106 -r1.107 pkgsrc/databases/sqlite3-tcl/Makefile (expand / switch to context diff)
--- pkgsrc/databases/sqlite3-tcl/Makefile 2021/04/21 11:41:21 1.106
+++ pkgsrc/databases/sqlite3-tcl/Makefile 2021/06/25 21:21:31 1.107
@@ -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}
cvs diff -r1.116 -r1.117 pkgsrc/databases/sqlite3-tcl/distinfo (expand / switch to context diff)
--- pkgsrc/databases/sqlite3-tcl/distinfo 2021/04/20 06:30:07 1.116
+++ pkgsrc/databases/sqlite3-tcl/distinfo 2021/06/25 21:21:31 1.117
@@ -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
cvs diff -r1.45 -r1.46 pkgsrc/devel/lemon/distinfo (expand / switch to context diff)
--- pkgsrc/devel/lemon/distinfo 2021/04/20 06:30:07 1.45
+++ pkgsrc/devel/lemon/distinfo 2021/06/25 21:21:31 1.46
@@ -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
+SHA1 (sqlite-src-3360000.zip) = ff0ccd70809c63e6c6a961d40eae6b6af6b46136
-RMD160 (sqlite-src-3350500.zip) = 880d8578a7e55d6e1d05a48b9094dc1aff33c7b9
+RMD160 (sqlite-src-3360000.zip) = 45e24313d68f6f4552e8f508e6afa4aeac4b230a
-SHA512 (sqlite-src-3350500.zip) = f9afd11b3c42a8241f91e2ecafc3928e7391cc0f1fbee236b8122c2d3ca922d0c82d2605968b131351b6c5e38f983f8eed29b86c94cfa72799e2387b3b3db561
+SHA512 (sqlite-src-3360000.zip) = 4083f96265c59001d21dce4d0288ddc6ea80ae079cbce2144c0fc3200b1904fd0d665fc54b08978c6b818527580042cde025c03b73d20d0bc56ccbeb75a330c3
-Size (sqlite-src-3350500.zip) = 12819198 bytes
+Size (sqlite-src-3360000.zip) = 12985683 bytes