git: 5b8f768c5f76 - 2022Q3 - databases/sqlite3: Update to 3.39

From: Cy Schubert <cy_at_FreeBSD.org>
Date: Tue, 30 Aug 2022 23:16:57 UTC
The branch 2022Q3 has been updated by cy:

URL: https://cgit.FreeBSD.org/ports/commit/?id=5b8f768c5f76dfc97084a5a0cbe0075fdd3a6bbc

commit 5b8f768c5f76dfc97084a5a0cbe0075fdd3a6bbc
Author:     Pavel Volkov <pavelivolkov@gmail.com>
AuthorDate: 2022-07-05 05:52:02 +0000
Commit:     Cy Schubert <cy@FreeBSD.org>
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 <ijliao@FreeBSD.org>
 
 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