sqlite3: updated to 3.39.0

SQLite Release 3.39.0 On 2022-06-25

Add (long overdue) support for RIGHT and FULL OUTER JOIN.
Add new binary comparison operators IS NOT DISTINCT FROM and IS DISTINCT FROM that are equivalent to IS and IS NOT, respective, for compatibility with PostgreSQL and SQL standards.
Add a new return code (value "3") from the sqlite3_vtab_distinct() interface that indicates a query that has both DISTINCT and ORDER BY clauses.
Added the sqlite3_db_name() interface.
The unix os interface resolves all symbolic links in database filenames to create a canonical name for the database before the file is opened.
Defer materializing views until the materialization is actually needed, thus avoiding unnecessary work if the materialization turns out to never be used.
The HAVING clause of a SELECT statement is now allowed on any aggregate query, even queries that do not have a GROUP BY clause.
Many microoptimizations collectively reduce CPU cycles by about 2.3%.

7 files changed, 24 insertions, 23 deletions

diff --git a/databases/sqlite3-docs/PLIST b/databases/sqlite3-docs/PLIST
index 9bf09c64b94..37515b08089 100644
--- a/databases/sqlite3-docs/PLIST
+++ b/databases/sqlite3-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.113 2022/05/08 08:10:27 adam Exp $
+@comment $NetBSD: PLIST,v 1.114 2022/07/01 17:49:39 adam Exp $
 share/doc/sqlite3/34to35.html
 share/doc/sqlite3/35to36.html
 share/doc/sqlite3/about.html
@@ -102,6 +102,7 @@ share/doc/sqlite3/c3ref/db_config.html
 share/doc/sqlite3/c3ref/db_filename.html
 share/doc/sqlite3/c3ref/db_handle.html
 share/doc/sqlite3/c3ref/db_mutex.html
+share/doc/sqlite3/c3ref/db_name.html
 share/doc/sqlite3/c3ref/db_readonly.html
 share/doc/sqlite3/c3ref/db_release_memory.html
 share/doc/sqlite3/c3ref/db_status.html
@@ -387,7 +388,6 @@ share/doc/sqlite3/images/foreignlogos/dropbox.gif
 share/doc/sqlite3/images/foreignlogos/expensify.png
 share/doc/sqlite3/images/foreignlogos/fb.gif
 share/doc/sqlite3/images/foreignlogos/firefox.gif
-share/doc/sqlite3/images/foreignlogos/flame.gif
 share/doc/sqlite3/images/foreignlogos/ge.gif
 share/doc/sqlite3/images/foreignlogos/google.gif
 share/doc/sqlite3/images/foreignlogos/intuit.gif
@@ -647,6 +647,7 @@ share/doc/sqlite3/releaselog/3_38_2.html
 share/doc/sqlite3/releaselog/3_38_3.html
 share/doc/sqlite3/releaselog/3_38_4.html
 share/doc/sqlite3/releaselog/3_38_5.html
+share/doc/sqlite3/releaselog/3_39_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
diff --git a/databases/sqlite3-docs/distinfo b/databases/sqlite3-docs/distinfo
index 2b29f4548ce..d840389508b 100644
--- a/databases/sqlite3-docs/distinfo
+++ b/databases/sqlite3-docs/distinfo
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.116 2022/05/08 08:10:27 adam Exp $
+$NetBSD: distinfo,v 1.117 2022/07/01 17:49:39 adam Exp $
 
-BLAKE2s (sqlite-doc-3380500.zip) = b03fe71d84a85f9a7ff67e882b9ad875ac2e3c9cbe5c7757201382144fa9c616
-SHA512 (sqlite-doc-3380500.zip) = 1f8520e8b06cac97a3cd532d105be847b864d4d51ff2d8ab92c62b369e2e662aa477808e566e334a9103e31b84c119050b92ab6f0ef6d5d68db4d49bf2dd8182
-Size (sqlite-doc-3380500.zip) = 10640188 bytes
+BLAKE2s (sqlite-doc-3390000.zip) = b64e9bfeed81e0e311d55bb04d94f669b63ff6174f5c3882a9e753d2bf7004b7
+SHA512 (sqlite-doc-3390000.zip) = c9d86c15f743deca233eabd68edb7538e75d7c3bd49caeb6a2a2958e1fdb3a258d2a69964626fac13c7f402dae9f33fd5e3b479ef23c43f835efeaf84d6ba32c
+Size (sqlite-doc-3390000.zip) = 10666677 bytes
diff --git a/databases/sqlite3-tcl/Makefile b/databases/sqlite3-tcl/Makefile
index e17146dea24..06215406c16 100644
--- a/databases/sqlite3-tcl/Makefile
+++ b/databases/sqlite3-tcl/Makefile
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile,v 1.111 2022/04/27 17:12:17 adam Exp $
+# $NetBSD: Makefile,v 1.112 2022/07/01 17:49:39 adam Exp $
 
 .include "../../databases/sqlite3/Makefile.common"
 
@@ -21,7 +21,7 @@ BUILDLINK_API_DEPENDS.sqlite3+=	sqlite3>=3.6.10
 
 # avoid conflict with lang/tcl
 post-extract:
-	mv ${WRKSRC}/doc/sqlite3.n ${WRKSRC}/doc/sqlite3-tcl.n
+	${MV} ${WRKSRC}/doc/sqlite3.n ${WRKSRC}/doc/sqlite3-tcl.n
 
 .include "../../mk/bsd.prefs.mk"
 
diff --git a/databases/sqlite3-tcl/distinfo b/databases/sqlite3-tcl/distinfo
index f221dc9a600..c42f7bf4b27 100644
--- a/databases/sqlite3-tcl/distinfo
+++ b/databases/sqlite3-tcl/distinfo
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.128 2022/05/08 08:10:27 adam Exp $
+$NetBSD: distinfo,v 1.129 2022/07/01 17:49:39 adam Exp $
 
-BLAKE2s (sqlite-autoconf-3380500.tar.gz) = f3f2c62f0fb90c29f4e4377c270dc9ddee62a2337c38144f035e66d4286e9538
-SHA512 (sqlite-autoconf-3380500.tar.gz) = 6f515a7782bfb5414702721fc78ada5bf388f4bf8b3e3c2ec269df33a2e372859f682d028c30084e89847705c7050ea80790d51fbcc4decea8fbb0a35b89c0b3
-Size (sqlite-autoconf-3380500.tar.gz) = 3033164 bytes
+BLAKE2s (sqlite-autoconf-3390000.tar.gz) = 351b0005ca8e75ee6f5dd10584a59b9f5b888548033139ffcb7b523cd7874949
+SHA512 (sqlite-autoconf-3390000.tar.gz) = cc6e4d9a8e821f1feae2bc69d1eb212723624e67197defbf86b7b7f1e2e80e473798964bf3863fbce728800b262851b967c7b7de008e6ccf2707e671ebb27398
+Size (sqlite-autoconf-3390000.tar.gz) = 3064015 bytes
 SHA1 (patch-Makefile.in) = 6cbbc33a5bc9c98b5aa128279f8e21e47406f537
diff --git a/databases/sqlite3/Makefile.common b/databases/sqlite3/Makefile.common
index 8172ec662ac..430f31e092d 100644
--- a/databases/sqlite3/Makefile.common
+++ b/databases/sqlite3/Makefile.common
@@ -1,12 +1,12 @@
-# $NetBSD: Makefile.common,v 1.90 2022/05/08 08:10:26 adam Exp $
+# $NetBSD: Makefile.common,v 1.91 2022/07/01 17:49:39 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=	3380500
-SQLITE3_VERSION=	3.38.5
+SQLITE3_DISTVERSION=	3390000
+SQLITE3_VERSION=	3.39.0
 
 MASTER_SITES=	http://www.sqlite.org/2022/
 MASTER_SITES+=	http://www.hwaci.com/sw/sqlite/2022/
diff --git a/databases/sqlite3/distinfo b/databases/sqlite3/distinfo
index fc859f01563..92791c86abd 100644
--- a/databases/sqlite3/distinfo
+++ b/databases/sqlite3/distinfo
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.183 2022/05/08 08:10:26 adam Exp $
+$NetBSD: distinfo,v 1.184 2022/07/01 17:49:39 adam Exp $
 
-BLAKE2s (sqlite-autoconf-3380500.tar.gz) = f3f2c62f0fb90c29f4e4377c270dc9ddee62a2337c38144f035e66d4286e9538
-SHA512 (sqlite-autoconf-3380500.tar.gz) = 6f515a7782bfb5414702721fc78ada5bf388f4bf8b3e3c2ec269df33a2e372859f682d028c30084e89847705c7050ea80790d51fbcc4decea8fbb0a35b89c0b3
-Size (sqlite-autoconf-3380500.tar.gz) = 3033164 bytes
+BLAKE2s (sqlite-autoconf-3390000.tar.gz) = 351b0005ca8e75ee6f5dd10584a59b9f5b888548033139ffcb7b523cd7874949
+SHA512 (sqlite-autoconf-3390000.tar.gz) = cc6e4d9a8e821f1feae2bc69d1eb212723624e67197defbf86b7b7f1e2e80e473798964bf3863fbce728800b262851b967c7b7de008e6ccf2707e671ebb27398
+Size (sqlite-autoconf-3390000.tar.gz) = 3064015 bytes
 SHA1 (patch-configure) = c0aa83bddc20d090b3cd2fd840ac69031f4396e4
diff --git a/devel/lemon/distinfo b/devel/lemon/distinfo
index b1a1a5bf169..98e4b6bc9c3 100644
--- a/devel/lemon/distinfo
+++ b/devel/lemon/distinfo
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.57 2022/05/08 08:10:27 adam Exp $
+$NetBSD: distinfo,v 1.58 2022/07/01 17:49:39 adam Exp $
 
-BLAKE2s (sqlite-src-3380500.zip) = f7a41a5fce2814618120f90786ef36c04106001226323e304f82b106bdcdd52a
-SHA512 (sqlite-src-3380500.zip) = d91f060165354ff4b32a72627c16b6d2310d478768794a49eef57229d7199d83f951444fdc0725acf8d2565ef61a9c7921e9c965f429b018b6fd23d129b6e630
-Size (sqlite-src-3380500.zip) = 13245057 bytes
+BLAKE2s (sqlite-src-3390000.zip) = 916beff22ea23b60972287e0b0e89a6e8430aaada6091bbde5ae601972609de3
+SHA512 (sqlite-src-3390000.zip) = 65409f78bf9f1f02739749c3ac151153fd78af07822be7d532a6aeb5d742463e0dde51702ce737780dc65c526802996da7569032b76a0527f6aa784f89c0cca2
+Size (sqlite-src-3390000.zip) = 13400405 bytes