aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorPavel Volkov <pavelivolkov@gmail.com>2022-07-05 05:52:02 +0000
committerFernando ApesteguĂ­a <fernape@FreeBSD.org>2022-07-07 05:32:47 +0000
commit5bf2947fce86388fd612492f980540c07d41f0b2 (patch)
tree0e1ff2cd366fcec7a731a5c559f5b2bf6802c02a
parent10384bcd755807ac5793789d5aa781d01c775fa5 (diff)
downloadports-5bf2947fce86388fd612492f980540c07d41f0b2.tar.gz
ports-5bf2947fce86388fd612492f980540c07d41f0b2.zip
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)
-rw-r--r--databases/sqlite3/Makefile6
-rw-r--r--databases/sqlite3/distinfo6
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