CVS commit: pkgsrc

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

Module Name:    pkgsrc
Committed By:   adam
Date:           Fri Jul  1 17:49:39 UTC 2022

Modified Files:
        pkgsrc/databases/sqlite3: 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.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%.


To generate a diff of this commit:
cvs rdiff -u -r1.90 -r1.91 pkgsrc/databases/sqlite3/Makefile.common
cvs rdiff -u -r1.183 -r1.184 pkgsrc/databases/sqlite3/distinfo
cvs rdiff -u -r1.113 -r1.114 pkgsrc/databases/sqlite3-docs/PLIST
cvs rdiff -u -r1.116 -r1.117 pkgsrc/databases/sqlite3-docs/distinfo
cvs rdiff -u -r1.111 -r1.112 pkgsrc/databases/sqlite3-tcl/Makefile
cvs rdiff -u -r1.128 -r1.129 pkgsrc/databases/sqlite3-tcl/distinfo
cvs rdiff -u -r1.57 -r1.58 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.common
diff -u pkgsrc/databases/sqlite3/Makefile.common:1.90 pkgsrc/databases/sqlite3/Makefile.common:1.91
--- pkgsrc/databases/sqlite3/Makefile.common:1.90       Sun May  8 08:10:26 2022
+++ pkgsrc/databases/sqlite3/Makefile.common    Fri Jul  1 17:49:39 2022
@@ -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/

Index: pkgsrc/databases/sqlite3/distinfo
diff -u pkgsrc/databases/sqlite3/distinfo:1.183 pkgsrc/databases/sqlite3/distinfo:1.184
--- pkgsrc/databases/sqlite3/distinfo:1.183     Sun May  8 08:10:26 2022
+++ pkgsrc/databases/sqlite3/distinfo   Fri Jul  1 17:49:39 2022
@@ -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

Index: pkgsrc/databases/sqlite3-docs/PLIST
diff -u pkgsrc/databases/sqlite3-docs/PLIST:1.113 pkgsrc/databases/sqlite3-docs/PLIST:1.114
--- pkgsrc/databases/sqlite3-docs/PLIST:1.113   Sun May  8 08:10:27 2022
+++ pkgsrc/databases/sqlite3-docs/PLIST Fri Jul  1 17:49:39 2022
@@ -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/dr
 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

Index: pkgsrc/databases/sqlite3-docs/distinfo
diff -u pkgsrc/databases/sqlite3-docs/distinfo:1.116 pkgsrc/databases/sqlite3-docs/distinfo:1.117
--- pkgsrc/databases/sqlite3-docs/distinfo:1.116        Sun May  8 08:10:27 2022
+++ pkgsrc/databases/sqlite3-docs/distinfo      Fri Jul  1 17:49:39 2022
@@ -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

Index: pkgsrc/databases/sqlite3-tcl/Makefile
diff -u pkgsrc/databases/sqlite3-tcl/Makefile:1.111 pkgsrc/databases/sqlite3-tcl/Makefile:1.112
--- pkgsrc/databases/sqlite3-tcl/Makefile:1.111 Wed Apr 27 17:12:17 2022
+++ pkgsrc/databases/sqlite3-tcl/Makefile       Fri Jul  1 17:49:39 2022
@@ -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>
 
 # 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"
 

Index: pkgsrc/databases/sqlite3-tcl/distinfo
diff -u pkgsrc/databases/sqlite3-tcl/distinfo:1.128 pkgsrc/databases/sqlite3-tcl/distinfo:1.129
--- pkgsrc/databases/sqlite3-tcl/distinfo:1.128 Sun May  8 08:10:27 2022
+++ pkgsrc/databases/sqlite3-tcl/distinfo       Fri Jul  1 17:49:39 2022
@@ -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

Index: pkgsrc/devel/lemon/distinfo
diff -u pkgsrc/devel/lemon/distinfo:1.57 pkgsrc/devel/lemon/distinfo:1.58
--- pkgsrc/devel/lemon/distinfo:1.57    Sun May  8 08:10:27 2022
+++ pkgsrc/devel/lemon/distinfo Fri Jul  1 17:49:39 2022
@@ -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