From nobody Tue Aug 30 23:16:57 2022 X-Original-To: dev-commits-ports-branches@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 4MHNVd2WLDz4bXhW; Tue, 30 Aug 2022 23:16:57 +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 4MHNVd1yWpz3phK; Tue, 30 Aug 2022 23:16:57 +0000 (UTC) (envelope-from git@FreeBSD.org) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1661901417; 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=zfBVMaENtwilmKVlvq85+o/25YNwZV0VI1zHs6J02js=; b=emoVgBHQWqN0orgjAfn4Q6NKzibN5i3+189xM9w1fD32TZ03/Av5INbetG2E0ERQYHd/55 xc7Xay39DumBdcuJiphHlNvQHhKPF5O3FXTBC0hvhBmzxAnW30dQqD7psMwj3meGARTmpq gXEH4d5rfBHpYkBuzPOwk/ag6rgSUPztD9pZgNrRy+KoprxewMhmy2a8NlZj64WjHeTu27 ixReD3dThxHzxCAw4UCQEjkENfMPekI1VyaP30cQTshnvm6qYedlndAR4BonMR5NdyDSyL baoBTXOrloyyh8ybrparD8gNSOF6GcuL2v5JX8Vws8ZfAYSRB6uAEPGl+vXYOw== 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 4MHNVd111CzwR0; Tue, 30 Aug 2022 23:16:57 +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 27UNGv4q061462; Tue, 30 Aug 2022 23:16:57 GMT (envelope-from git@gitrepo.freebsd.org) Received: (from git@localhost) by gitrepo.freebsd.org (8.16.1/8.16.1/Submit) id 27UNGvAM061461; Tue, 30 Aug 2022 23:16:57 GMT (envelope-from git) Date: Tue, 30 Aug 2022 23:16:57 GMT Message-Id: <202208302316.27UNGvAM061461@gitrepo.freebsd.org> To: ports-committers@FreeBSD.org, dev-commits-ports-all@FreeBSD.org, dev-commits-ports-branches@FreeBSD.org From: Cy Schubert Subject: git: 5b8f768c5f76 - 2022Q3 - databases/sqlite3: Update to 3.39 List-Id: Commits to the quarterly branches of the FreeBSD ports repository List-Archive: https://lists.freebsd.org/archives/dev-commits-ports-branches List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-dev-commits-ports-branches@freebsd.org X-BeenThere: dev-commits-ports-branches@freebsd.org MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit X-Git-Committer: cy X-Git-Repository: ports X-Git-Refname: refs/heads/2022Q3 X-Git-Reftype: branch X-Git-Commit: 5b8f768c5f76dfc97084a5a0cbe0075fdd3a6bbc Auto-Submitted: auto-generated ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1661901417; 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=zfBVMaENtwilmKVlvq85+o/25YNwZV0VI1zHs6J02js=; b=H0bh3YHRebxnXQZzIvsj35EOJAjP8N1UmXrSWAzraBjmd56+LJTcHSRsnx0iIRAGvDXOTi +XNUFQ0SueRrCtPVlYQlh1mjpu2pVQ9QsSoAYFRNK++hwnteYxHts+/IH6N88Eto01UBfO TV3mQYXkW2gbRc3L1aQDHctzhczhx4t1hmdilnv29wSk0AyvQ+uZDwb5PyNZ0ErIU/Bwfd ChQwIEdHZJMMjDnDOUg+ZepsDQB3Z00A6z4xJPfqsI7gkMtjlHQ7mi/LjmOM3Z9s6IkZwS MBU2jZQixtJ1j4OmxDYPXobx7pMxbTHCzy8NrLXBcYmMSFDHtM3c6uCgxYVROQ== ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1661901417; a=rsa-sha256; cv=none; b=gyRYxHoqMZfPzAxQrWy5efri69nK560eqWhlOdoVKJ5se7vHckXzskghqu1t+agrMxYsIh TFAyaJI5zv9wL23sctmY6zb6Mlx8EK66/E1Dj6EetGyOt7Bqe9uY/amu+PBRD+dUK7gzku ZxACGzB06W+V6nG786YofJlLkKRHGHahr8r76xASNlhme0tGZwMlJw6urZyEzk8vfjkuyw Mt9nLV5M9QPhIIt2g0vSexGzYbArI7ZgiKkRf95ryWfv/+Eq688/DJ9WYtVs3yuRS+Q9Ev jFhhk9KSePMfYh7LOOF0ixIgfvAKx0Ln5bV/BCQBGVZntlxkNb1V7M91y9K2IQ== ARC-Authentication-Results: i=1; mx1.freebsd.org; none X-ThisMailContainsUnwantedMimeParts: N The branch 2022Q3 has been updated by cy: URL: https://cgit.FreeBSD.org/ports/commit/?id=5b8f768c5f76dfc97084a5a0cbe0075fdd3a6bbc commit 5b8f768c5f76dfc97084a5a0cbe0075fdd3a6bbc Author: Pavel Volkov AuthorDate: 2022-07-05 05:52:02 +0000 Commit: Cy Schubert CommitDate: 2022-08-30 23:15:42 +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) (cherry picked from commit 5bf2947fce86388fd612492f980540c07d41f0b2) --- 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