From nobody Thu Jul 07 05:35:36 2022 X-Original-To: dev-commits-ports-main@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id 598951D02C07; Thu, 7 Jul 2022 05:35:37 +0000 (UTC) (envelope-from git@FreeBSD.org) Received: from mxrelay.nyi.freebsd.org (mxrelay.nyi.freebsd.org [IPv6:2610:1c1:1:606c::19:3]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (4096 bits) client-digest SHA256) (Client CN "mxrelay.nyi.freebsd.org", Issuer "R3" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4LdlVx1s7Lz3Mmq; Thu, 7 Jul 2022 05:35:37 +0000 (UTC) (envelope-from git@FreeBSD.org) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1657172137; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding; bh=sIWWnhan0u3ZNFV/OWgkRl68Z4YqrXrLKIjZ6VnHTOE=; b=H10Zo0Gxyu0FH994GfKnV8Om4pvBdv/nZuruahugUoESjgAZGx4PX7prDrzkEcfEGqhe99 JcTUREUtKoGtv6+jXSYZvS2WVlb6lZjKopbc8CMytbNwdr5aX1OnR6ishsJKTkd7+LRujz /EfxYnbcL5/a1jEJ4h/GLDDbyIDFUOJ30aTYlFxozAtwBqJStXl/gOEaQP343noIR/tYGz G31444V6vPjzmnBuPy7amiVf6Txn9XEX4RNYkKbp8s13i2IrsckxSih0rQJx1JCva00QQ3 gJ26AyUKAHmSRWB5VEQA9yiLANZR84LP7FCBO/cWRjmMxCWeo91m5AaKvvSLTw== Received: from gitrepo.freebsd.org (gitrepo.freebsd.org [IPv6:2610:1c1:1:6068::e6a:5]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256) (Client did not present a certificate) by mxrelay.nyi.freebsd.org (Postfix) with ESMTPS id 4LdlVx0plJzXR0; Thu, 7 Jul 2022 05:35:37 +0000 (UTC) (envelope-from git@FreeBSD.org) Received: from gitrepo.freebsd.org ([127.0.1.44]) by gitrepo.freebsd.org (8.16.1/8.16.1) with ESMTP id 2675ZaLn099397; Thu, 7 Jul 2022 05:35:36 GMT (envelope-from git@gitrepo.freebsd.org) Received: (from git@localhost) by gitrepo.freebsd.org (8.16.1/8.16.1/Submit) id 2675ZaGs099396; Thu, 7 Jul 2022 05:35:36 GMT (envelope-from git) Date: Thu, 7 Jul 2022 05:35:36 GMT Message-Id: <202207070535.2675ZaGs099396@gitrepo.freebsd.org> To: ports-committers@FreeBSD.org, dev-commits-ports-all@FreeBSD.org, dev-commits-ports-main@FreeBSD.org From: =?utf-8?Q?Fernando=20Apestegu=C3=ADa?= Subject: git: 5bf2947fce86 - main - databases/sqlite3: Update to 3.39 List-Id: Commits to the main branch of the FreeBSD ports repository List-Archive: https://lists.freebsd.org/archives/dev-commits-ports-main List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-dev-commits-ports-main@freebsd.org X-BeenThere: dev-commits-ports-main@freebsd.org MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit X-Git-Committer: fernape X-Git-Repository: ports X-Git-Refname: refs/heads/main X-Git-Reftype: branch X-Git-Commit: 5bf2947fce86388fd612492f980540c07d41f0b2 Auto-Submitted: auto-generated ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1657172137; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding; bh=sIWWnhan0u3ZNFV/OWgkRl68Z4YqrXrLKIjZ6VnHTOE=; b=snTETYEGZKtsETS5kCnthWyUSlYlIFKKSSq0odVWuy5wSeGIhpeA9oU8Nrun+Xlgu+CbxV wbCmJWr/AdvCbMR3bRNx3j5QaLNpxjJNmNTEzuD5G+cuNGUhruQTcx1exwBVYfhbS0BQVS 5ZwJRl76CSPo8RmVTDIiEdNB5sRswmMdxz/ZWW39ibx9mWmJXm6OUbULJWDJfsFqfbYwHF Z6RXDnbiIRZTc2Y9+GMuT/Blf4SWBeMdhcacRRy1wHvEbyAB0wm7mGGIyx0O0YcVm/eEPy Vy0P2kNptxGMrP1q9cVpgd1cUJ2ZnuKLk+CfTZhzs8Ko3KpGdmDoA2b/l8T5Hg== ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1657172137; a=rsa-sha256; cv=none; b=YlQwdjAqL6VyjsrhRHPuFTZe/RPfEw2Qqs3JDnq2bjHnledXc+nQyBLg5gnCog4quUQ23K V+CYpE+VPJD/540RxkCNJS3rXfMIAk+C3nqjVAivpTKy6sFx6hlVjBWX5v61zc5r+kA8aU 1uR7BeQOxMhNG3EuFrN9k44/8LDtTDQry2vllMXmbquobWzKQNSrJWkaHfAhhE9V/6fryM xAOjZnYA6HeT9pi/FhaNMQwmSE3r5nH7HpXZaecKmo5Xphp+grIko/KJ3K7j6llP8lLpoq 7Zlh9YIsKqzfF0AgWYP/6+/qkhIhLXIoBzLzTg76NaWUrvx0JrOPKW04UWO7Mg== ARC-Authentication-Results: i=1; mx1.freebsd.org; none X-ThisMailContainsUnwantedMimeParts: N The branch main has been updated by fernape: URL: https://cgit.FreeBSD.org/ports/commit/?id=5bf2947fce86388fd612492f980540c07d41f0b2 commit 5bf2947fce86388fd612492f980540c07d41f0b2 Author: Pavel Volkov AuthorDate: 2022-07-05 05:52:02 +0000 Commit: Fernando Apesteguía CommitDate: 2022-07-07 05:32:47 +0000 databases/sqlite3: Update to 3.39 ChangeLog: https://www.sqlite.org/releaselog/3_39_0.html * 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%. PR: 264974 Reported by: pavelivolkov@gmail.com (maintainer) --- databases/sqlite3/Makefile | 6 +++--- databases/sqlite3/distinfo | 6 +++--- 2 files changed, 6 insertions(+), 6 deletions(-) diff --git a/databases/sqlite3/Makefile b/databases/sqlite3/Makefile index 25e3cf073334..0e7c51ea1043 100644 --- a/databases/sqlite3/Makefile +++ b/databases/sqlite3/Makefile @@ -1,7 +1,7 @@ # Created by: Ying-Chieh Liao PORTNAME= sqlite3 -DISTVERSION= 3.38.5 +DISTVERSION= 3.39.0 PORTEPOCH= 1 CATEGORIES= databases MASTER_SITES= https://www.sqlite.org/${YEAR}/ https://www2.sqlite.org/${YEAR}/ https://www3.sqlite.org/${YEAR}/ @@ -43,8 +43,6 @@ INSTALL_TARGET= tcl_install .endif TEST_TARGET= test -CONFLICTS_INSTALL= sqlite3 sqlite3-icu sqlite3-tcl tcl-sqlite3 # include/sqlite3.h share/examples/sqlite3/example.tcl - # The default numeric file permissions for newly created database files under unix. # If not specified, the default is 0644 which means that the files is globally # readable but only writable by the creator. @@ -52,6 +50,8 @@ CONFLICTS_INSTALL= sqlite3 sqlite3-icu sqlite3-tcl tcl-sqlite3 # include/sqlite3 CPPFLAGS+= -DSQLITE_DEFAULT_FILE_PERMISSIONS=${DEFAULT_FILE_PERMISSIONS} .endif +CONFLICTS_INSTALL= sqlite3 sqlite3-icu sqlite3-tcl tcl-sqlite3 # include/sqlite3.h share/examples/sqlite3/example.tcl + SUB_FILES= example.tcl SUB_LIST= TCLSH_CMD="${TCLSH}" diff --git a/databases/sqlite3/distinfo b/databases/sqlite3/distinfo index 8ecc298ce729..c9f3554ca014 100644 --- a/databases/sqlite3/distinfo +++ b/databases/sqlite3/distinfo @@ -1,3 +1,3 @@ -TIMESTAMP = 1653202606 -SHA256 (sqlite-src-3380500.zip) = 6503bb59e39ec8663083696940ec818cd5555196e6ca543d4029440cca7b00d9 -SIZE (sqlite-src-3380500.zip) = 13245057 +TIMESTAMP = 1656667427 +SHA256 (sqlite-src-3390000.zip) = b3585f37dd106dbb3d46c8c17a2d275f9a4b87df8c4509bd2d6a5b40032426e6 +SIZE (sqlite-src-3390000.zip) = 13400405