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

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

details:   https://anonhg.NetBSD.org/pkgsrc/rev/dbeb28f7c446
branches:  trunk
changeset: 381184:dbeb28f7c446
user:      adam <adam%pkgsrc.org@localhost>
date:      Fri Jul 01 17:49:39 2022 +0000

description:
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%.

diffstat:

 databases/sqlite3-docs/PLIST      |  5 +++--
 databases/sqlite3-docs/distinfo   |  8 ++++----
 databases/sqlite3-tcl/Makefile    |  4 ++--
 databases/sqlite3-tcl/distinfo    |  8 ++++----
 databases/sqlite3/Makefile.common |  6 +++---
 databases/sqlite3/distinfo        |  8 ++++----
 devel/lemon/distinfo              |  8 ++++----
 7 files changed, 24 insertions(+), 23 deletions(-)

diffs (124 lines):

diff -r cb10d23d2d8d -r dbeb28f7c446 databases/sqlite3-docs/PLIST
--- a/databases/sqlite3-docs/PLIST      Fri Jul 01 17:32:18 2022 +0000
+++ b/databases/sqlite3-docs/PLIST      Fri Jul 01 17:49:39 2022 +0000
@@ -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_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/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_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 -r cb10d23d2d8d -r dbeb28f7c446 databases/sqlite3-docs/distinfo
--- a/databases/sqlite3-docs/distinfo   Fri Jul 01 17:32:18 2022 +0000
+++ b/databases/sqlite3-docs/distinfo   Fri Jul 01 17:49:39 2022 +0000
@@ -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 -r cb10d23d2d8d -r dbeb28f7c446 databases/sqlite3-tcl/Makefile
--- a/databases/sqlite3-tcl/Makefile    Fri Jul 01 17:32:18 2022 +0000
+++ b/databases/sqlite3-tcl/Makefile    Fri Jul 01 17:49:39 2022 +0000
@@ -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 @@
 
 # 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 -r cb10d23d2d8d -r dbeb28f7c446 databases/sqlite3-tcl/distinfo
--- a/databases/sqlite3-tcl/distinfo    Fri Jul 01 17:32:18 2022 +0000
+++ b/databases/sqlite3-tcl/distinfo    Fri Jul 01 17:49:39 2022 +0000
@@ -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 -r cb10d23d2d8d -r dbeb28f7c446 databases/sqlite3/Makefile.common
--- a/databases/sqlite3/Makefile.common Fri Jul 01 17:32:18 2022 +0000
+++ b/databases/sqlite3/Makefile.common Fri Jul 01 17:49:39 2022 +0000
@@ -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 -r cb10d23d2d8d -r dbeb28f7c446 databases/sqlite3/distinfo
--- a/databases/sqlite3/distinfo        Fri Jul 01 17:32:18 2022 +0000
+++ b/databases/sqlite3/distinfo        Fri Jul 01 17:49:39 2022 +0000
@@ -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 -r cb10d23d2d8d -r dbeb28f7c446 devel/lemon/distinfo
--- a/devel/lemon/distinfo      Fri Jul 01 17:32:18 2022 +0000
+++ b/devel/lemon/distinfo      Fri Jul 01 17:49:39 2022 +0000
@@ -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