Received: by mail.netbsd.org (Postfix, from userid 605) id 779E784F00; Fri, 1 Jul 2022 17:47:21 +0000 (UTC) Received: from localhost (localhost [127.0.0.1]) by mail.netbsd.org (Postfix) with ESMTP id B28DB84EFC for ; Fri, 1 Jul 2022 17:47:20 +0000 (UTC) X-Virus-Scanned: amavisd-new at netbsd.org Received: from mail.netbsd.org ([IPv6:::1]) by localhost (mail.netbsd.org [IPv6:::1]) (amavisd-new, port 10025) with ESMTP id rP6a130MXtvJ for ; Fri, 1 Jul 2022 17:47:19 +0000 (UTC) Received: from cvs.NetBSD.org (ivanova.NetBSD.org [IPv6:2001:470:a085:999:28c:faff:fe03:5984]) by mail.netbsd.org (Postfix) with ESMTP id 6799E84CEE for ; Fri, 1 Jul 2022 17:47:19 +0000 (UTC) Received: by cvs.NetBSD.org (Postfix, from userid 500) id B579CFB1A; Fri, 1 Jul 2022 17:49:39 +0000 (UTC) Content-Transfer-Encoding: 7bit Content-Type: multipart/mixed; boundary="_----------=_1656697779177440" MIME-Version: 1.0 Date: Fri, 1 Jul 2022 17:49:39 +0000 From: "Adam Ciarcinski" Subject: CVS commit: pkgsrc To: pkgsrc-changes@NetBSD.org Reply-To: adam@netbsd.org X-Mailer: log_accum Message-Id: <20220701174939.B579CFB1A@cvs.NetBSD.org> Sender: pkgsrc-changes-owner@NetBSD.org List-Id: Precedence: bulk List-Unsubscribe: This is a multi-part message in MIME format. --_----------=_1656697779177440 Content-Disposition: inline Content-Transfer-Encoding: 8bit Content-Type: text/plain; charset="US-ASCII" 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. --_----------=_1656697779177440 Content-Disposition: inline Content-Length: 7507 Content-Transfer-Encoding: binary Content-Type: text/x-diff; charset=us-ascii 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 --_----------=_1656697779177440--