[pkgsrc/trunk]: pkgsrc/databases Changes 3.8.8:

To: pkgsrc-changes-hg%NetBSD.org@localhost
Subject: [pkgsrc/trunk]: pkgsrc/databases Changes 3.8.8:
From: adam <adam%pkgsrc.org@localhost>
Date: Thu, 14 Oct 2021 17:07:22 +0000
details:   https://anonhg.NetBSD.org/pkgsrc/rev/a520fd1a6a3a
branches:  trunk
changeset: 644728:a520fd1a6a3a
user:      adam <adam%pkgsrc.org@localhost>
date:      Fri Jan 16 21:01:19 2015 +0000

description:
Changes 3.8.8:

New Features:
* Added the PRAGMA data_version command that can be used to determine if a database file has been modified by another process.
* Added the SQLITE_CHECKPOINT_TRUNCATE option to the sqlite3_wal_checkpoint_v2() interface, with corresponding enhancements to PRAGMA wal_checkpoint.
* Added the sqlite3_stmt_scanstatus() interface, available only when compiled with SQLITE_ENABLE_STMT_SCANSTATUS.
* The sqlite3_table_column_metadata() is enhanced to work correctly on WITHOUT ROWID tables and to check for the existence of a a table if the column name parameter is NULL. The interface is now also 
included in the build by default, without requiring the SQLITE_ENABLE_COLUMN_METADATA compile-time option.
* Added the SQLITE_ENABLE_API_ARMOR compile-time option.
* Added the SQLITE_REVERSE_UNORDERED_SELECTS compile-time option.
* Added the SQLITE_SORTER_PMASZ compile-time option and SQLITE_CONFIG_PMASZ start-time option.
* Added the SQLITE_CONFIG_PCACHE_HDRSZ option to sqlite3_config() which makes it easier for applications to determine the appropriate amount of memory for use with SQLITE_CONFIG_PAGECACHE.
* The number of rows in a VALUES clause is no longer limited by SQLITE_LIMIT_COMPOUND_SELECT.
* Added the eval.c loadable extension that implements an eval() SQL function that will recursively evaluate SQL.

Performance Enhancements:
* Reduce the number of memcpy() operations involved in balancing a b-tree, for 3.2% overall performance boost.
* Improvements to cost estimates for the skip-scan optimization.
* The automatic indexing optimization is now capable of generating a partial index if that is appropriate.

Bug fixes:
* Ensure durability following a power loss with "PRAGMA journal_mode=TRUNCATE" by calling fsync() right after truncating the journal file.
* The query planner now recognizes that any column in the right-hand table of a LEFT JOIN can be NULL, even if that column has a NOT NULL constraint. Avoid trying to optimize out NULL tests in those 
cases.
* Make sure ORDER BY puts rows in ascending order even if the DISTINCT operator is implemented using a descending index.
* Fix data races that might occur under stress when running with many threads in shared cache mode where some of the threads are opening and closing connections.
* Fix obscure crash bugs found by american fuzzy lop.
* Work around a GCC optimizer bug (for gcc 4.2.1 on MacOS 10.7) that caused the R-Tree extension to compute incorrect results when compiled with -O3.

Other changes:
* Disable the use of the strchrnul() C-library routine unless it is specifically enabled using the -DHAVE_STRCHRNULL compile-time option.
* Improvements to the effectiveness and accuracy of the likelihood(), likely(), and unlikely() SQL hint functions.

diffstat:

 databases/sqlite3-docs/Makefile |  10 +++++-----
 databases/sqlite3-docs/PLIST    |   6 +++++-
 databases/sqlite3-docs/distinfo |   8 ++++----
 databases/sqlite3-tcl/Makefile  |  10 +++++-----
 databases/sqlite3-tcl/distinfo  |   8 ++++----
 databases/sqlite3/Makefile      |  10 +++++-----
 databases/sqlite3/distinfo      |   8 ++++----
 7 files changed, 32 insertions(+), 28 deletions(-)

diffs (131 lines):

diff -r 4282a8158713 -r a520fd1a6a3a databases/sqlite3-docs/Makefile
--- a/databases/sqlite3-docs/Makefile   Fri Jan 16 19:34:44 2015 +0000
+++ b/databases/sqlite3-docs/Makefile   Fri Jan 16 21:01:19 2015 +0000
@@ -1,10 +1,10 @@
-# $NetBSD: Makefile,v 1.36 2014/12/10 10:39:08 adam Exp $
+# $NetBSD: Makefile,v 1.37 2015/01/16 21:01:19 adam Exp $
 
-DISTNAME=      sqlite-doc-3080704
-PKGNAME=       sqlite3-docs-3.8.7.4
+DISTNAME=      sqlite-doc-3080800
+PKGNAME=       sqlite3-docs-3.8.8
 CATEGORIES=    databases
-MASTER_SITES=  http://www.hwaci.com/sw/sqlite/2014/ \
-               http://www.sqlite.org/2014/
+MASTER_SITES=  http://www.hwaci.com/sw/sqlite/2015/ \
+               http://www.sqlite.org/2015/
 EXTRACT_SUFX=  .zip
 
 MAINTAINER=    pkgsrc-users%NetBSD.org@localhost
diff -r 4282a8158713 -r a520fd1a6a3a databases/sqlite3-docs/PLIST
--- a/databases/sqlite3-docs/PLIST      Fri Jan 16 19:34:44 2015 +0000
+++ b/databases/sqlite3-docs/PLIST      Fri Jan 16 21:01:19 2015 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.34 2014/12/10 10:39:08 adam Exp $
+@comment $NetBSD: PLIST,v 1.35 2015/01/16 21:01:19 adam Exp $
 share/doc/sqlite3/34to35.html
 share/doc/sqlite3/35to36.html
 share/doc/sqlite3/about.html
@@ -50,6 +50,7 @@
 share/doc/sqlite3/c3ref/c_lock_exclusive.html
 share/doc/sqlite3/c3ref/c_mutex_fast.html
 share/doc/sqlite3/c3ref/c_open_autoproxy.html
+share/doc/sqlite3/c3ref/c_scanstat_est.html
 share/doc/sqlite3/c3ref/c_shm_exclusive.html
 share/doc/sqlite3/c3ref/c_shm_nlock.html
 share/doc/sqlite3/c3ref/c_source_id.html
@@ -148,6 +149,8 @@
 share/doc/sqlite3/c3ref/stmt.html
 share/doc/sqlite3/c3ref/stmt_busy.html
 share/doc/sqlite3/c3ref/stmt_readonly.html
+share/doc/sqlite3/c3ref/stmt_scanstatus.html
+share/doc/sqlite3/c3ref/stmt_scanstatus_reset.html
 share/doc/sqlite3/c3ref/stmt_status.html
 share/doc/sqlite3/c3ref/strglob.html
 share/doc/sqlite3/c3ref/stricmp.html
@@ -630,6 +633,7 @@
 share/doc/sqlite3/releaselog/3_8_7_2.html
 share/doc/sqlite3/releaselog/3_8_7_3.html
 share/doc/sqlite3/releaselog/3_8_7_4.html
+share/doc/sqlite3/releaselog/3_8_8.html
 share/doc/sqlite3/releaselog/current.html
 share/doc/sqlite3/requirements.html
 share/doc/sqlite3/rescode.html
diff -r 4282a8158713 -r a520fd1a6a3a databases/sqlite3-docs/distinfo
--- a/databases/sqlite3-docs/distinfo   Fri Jan 16 19:34:44 2015 +0000
+++ b/databases/sqlite3-docs/distinfo   Fri Jan 16 21:01:19 2015 +0000
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.34 2014/12/10 10:39:08 adam Exp $
+$NetBSD: distinfo,v 1.35 2015/01/16 21:01:19 adam Exp $
 
-SHA1 (sqlite-doc-3080704.zip) = 734908373118d61338ca020e3c7dcbd1e0ccd985
-RMD160 (sqlite-doc-3080704.zip) = f4475f85cbdb98c53494f8eb28b21f7e85be246d
-Size (sqlite-doc-3080704.zip) = 4918739 bytes
+SHA1 (sqlite-doc-3080800.zip) = d1192d3fd38ca1c68da537eeb87faf7c3071a5fd
+RMD160 (sqlite-doc-3080800.zip) = db001b60a5f0c86616ba773de339249587c231b2
+Size (sqlite-doc-3080800.zip) = 4945996 bytes
diff -r 4282a8158713 -r a520fd1a6a3a databases/sqlite3-tcl/Makefile
--- a/databases/sqlite3-tcl/Makefile    Fri Jan 16 19:34:44 2015 +0000
+++ b/databases/sqlite3-tcl/Makefile    Fri Jan 16 21:01:19 2015 +0000
@@ -1,10 +1,10 @@
-# $NetBSD: Makefile,v 1.67 2014/12/10 10:39:08 adam Exp $
+# $NetBSD: Makefile,v 1.68 2015/01/16 21:01:19 adam Exp $
 
-DISTNAME=      sqlite-autoconf-3080704
-PKGNAME=       sqlite3-tcl-3.8.7.4
+DISTNAME=      sqlite-autoconf-3080800
+PKGNAME=       sqlite3-tcl-3.8.8
 CATEGORIES=    databases
-MASTER_SITES=  http://www.hwaci.com/sw/sqlite/2014/ \
-               http://www.sqlite.org/2014/
+MASTER_SITES=  http://www.hwaci.com/sw/sqlite/2015/ \
+               http://www.sqlite.org/2015/
 
 MAINTAINER=    pkgsrc-users%NetBSD.org@localhost
 HOMEPAGE=      http://www.sqlite.org/
diff -r 4282a8158713 -r a520fd1a6a3a databases/sqlite3-tcl/distinfo
--- a/databases/sqlite3-tcl/distinfo    Fri Jan 16 19:34:44 2015 +0000
+++ b/databases/sqlite3-tcl/distinfo    Fri Jan 16 21:01:19 2015 +0000
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.47 2014/12/10 10:39:08 adam Exp $
+$NetBSD: distinfo,v 1.48 2015/01/16 21:01:19 adam Exp $
 
-SHA1 (sqlite-autoconf-3080704.tar.gz) = 70ca0b8884a6b145b7f777724670566e2b4f3cde
-RMD160 (sqlite-autoconf-3080704.tar.gz) = 8a265def35641bc3b3e327c0ec3de352ddb1fb38
-Size (sqlite-autoconf-3080704.tar.gz) = 1999230 bytes
+SHA1 (sqlite-autoconf-3080800.tar.gz) = abb7570b7e331ffede7f40f0037be6e0c03b73af
+RMD160 (sqlite-autoconf-3080800.tar.gz) = 9787b14624dcb9f413b94a388c7f85bf703b9f8d
+Size (sqlite-autoconf-3080800.tar.gz) = 2020708 bytes
 SHA1 (patch-aa) = 4a12a16498d04e1031dc0802fda731b73e98a32d
diff -r 4282a8158713 -r a520fd1a6a3a databases/sqlite3/Makefile
--- a/databases/sqlite3/Makefile        Fri Jan 16 19:34:44 2015 +0000
+++ b/databases/sqlite3/Makefile        Fri Jan 16 21:01:19 2015 +0000
@@ -1,10 +1,10 @@
-# $NetBSD: Makefile,v 1.88 2014/12/10 10:39:08 adam Exp $
+# $NetBSD: Makefile,v 1.89 2015/01/16 21:01:19 adam Exp $
 
-DISTNAME=      sqlite-autoconf-3080704
-PKGNAME=       sqlite3-3.8.7.4
+DISTNAME=      sqlite-autoconf-3080800
+PKGNAME=       sqlite3-3.8.8
 CATEGORIES=    databases
-MASTER_SITES=  http://www.hwaci.com/sw/sqlite/2014/ \
-               http://www.sqlite.org/2014/
+MASTER_SITES=  http://www.hwaci.com/sw/sqlite/2015/ \
+               http://www.sqlite.org/2015/
 
 MAINTAINER=    pkgsrc-users%NetBSD.org@localhost
 HOMEPAGE=      http://www.sqlite.org/
diff -r 4282a8158713 -r a520fd1a6a3a databases/sqlite3/distinfo
--- a/databases/sqlite3/distinfo        Fri Jan 16 19:34:44 2015 +0000
+++ b/databases/sqlite3/distinfo        Fri Jan 16 21:01:19 2015 +0000
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.97 2014/12/10 10:39:08 adam Exp $
+$NetBSD: distinfo,v 1.98 2015/01/16 21:01:19 adam Exp $
 
-SHA1 (sqlite-autoconf-3080704.tar.gz) = 70ca0b8884a6b145b7f777724670566e2b4f3cde
-RMD160 (sqlite-autoconf-3080704.tar.gz) = 8a265def35641bc3b3e327c0ec3de352ddb1fb38
-Size (sqlite-autoconf-3080704.tar.gz) = 1999230 bytes
+SHA1 (sqlite-autoconf-3080800.tar.gz) = abb7570b7e331ffede7f40f0037be6e0c03b73af
+RMD160 (sqlite-autoconf-3080800.tar.gz) = 9787b14624dcb9f413b94a388c7f85bf703b9f8d
+Size (sqlite-autoconf-3080800.tar.gz) = 2020708 bytes
Prev by Date: [pkgsrc/trunk]: pkgsrc/www/trac Note that patch was again sent upstream.
Next by Date: [pkgsrc/trunk]: pkgsrc/doc Note update of www/ruby-rack package to 1.6.1.
Previous by Thread: [pkgsrc/trunk]: pkgsrc/www/trac Note that patch was again sent upstream.
Next by Thread: [pkgsrc/trunk]: pkgsrc/doc Note update of www/ruby-rack package to 1.6.1.
Indexes:
Home | Main Index | Thread Index | Old Index