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

To: pkgsrc-changes-hg%NetBSD.org@localhost
Subject: [pkgsrc/trunk]: pkgsrc/databases Changes 3.7.12:
From: adam <adam%pkgsrc.org@localhost>
Date: Thu, 14 Oct 2021 12:24:01 +0000
details:   https://anonhg.NetBSD.org/pkgsrc/rev/59518d473e72
branches:  trunk
changeset: 603856:59518d473e72
user:      adam <adam%pkgsrc.org@localhost>
date:      Tue May 15 08:09:25 2012 +0000

description:
Changes 3.7.12:
* Add the SQLITE_DBSTATUS_CACHE_WRITE option for sqlite3_db_status().
* Optimize the typeof() and length() SQL functions so that they avoid unnecessary reading of database content from disk.
* Add the FTS4 "merge" command, the FTS4 "automerge" command, and the FTS4 "integrity-check" command.
* Report the name of specific CHECK constraints that fail.
* In the command-line shell, use popen() instead of fopen() if the first character of the argument to the ".output" command is "|".
* Make use of OVERLAPPED in the windows VFS to avoid some system calls and thereby obtain a performance improvement.
* More aggressive optimization of the AND operator when one side or the other is always false.
* Improved performance of queries with many OR-connected terms in the WHERE clause that can all be indexed.
* Add the SQLITE_RTREE_INT_ONLY compile-time option to force the R*Tree Extension Module to use integer instead of floating point values for both storage and computation.
* Enhance the PRAGMA integrity_check command to use much less memory when processing multi-gigabyte databases.
* New interfaces added to the test_quota.c add-on module.
* Added the ".trace" dot-command to the command-line shell.
* Allow virtual table constructors to be invoked recursively.
* Improved optimization of ORDER BY clauses on compound queries.
* Improved optimization of aggregate subqueries contained within an aggregate query.
* Bug fix: Fix the RELEASE command so that it does not cancel pending queries. This repairs a problem introduced in 3.7.11.
* Bug fix: Do not discard the DISTINCT as superfluous unless a subset of the result set is subject to a UNIQUE constraint and it none of the columns in that subset can be NULL.
* Bug fix: Do not optimize away an ORDER BY clause that has the same terms as a UNIQUE index unless those terms are also NOT NULL.

diffstat:

 databases/sqlite3-docs/Makefile |  6 +++---
 databases/sqlite3-docs/PLIST    |  3 ++-
 databases/sqlite3-docs/distinfo |  8 ++++----
 databases/sqlite3-tcl/Makefile  |  7 +++----
 databases/sqlite3-tcl/distinfo  |  8 ++++----
 databases/sqlite3/Makefile      |  7 +++----
 databases/sqlite3/distinfo      |  8 ++++----
 7 files changed, 23 insertions(+), 24 deletions(-)

diffs (102 lines):

diff -r 9be472448a86 -r 59518d473e72 databases/sqlite3-docs/Makefile
--- a/databases/sqlite3-docs/Makefile   Tue May 15 07:18:04 2012 +0000
+++ b/databases/sqlite3-docs/Makefile   Tue May 15 08:09:25 2012 +0000
@@ -1,7 +1,7 @@
-# $NetBSD: Makefile,v 1.8 2012/03/20 21:00:47 adam Exp $
+# $NetBSD: Makefile,v 1.9 2012/05/15 08:09:25 adam Exp $
 
-DISTNAME=      sqlite-doc-3071100
-PKGNAME=       sqlite3-docs-3.7.11
+DISTNAME=      sqlite-doc-3071200
+PKGNAME=       sqlite3-docs-3.7.12
 CATEGORIES=    databases
 MASTER_SITES=  http://www.hwaci.com/sw/sqlite/ \
                http://www.sqlite.org/
diff -r 9be472448a86 -r 59518d473e72 databases/sqlite3-docs/PLIST
--- a/databases/sqlite3-docs/PLIST      Tue May 15 07:18:04 2012 +0000
+++ b/databases/sqlite3-docs/PLIST      Tue May 15 08:09:25 2012 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.8 2012/03/20 21:00:47 adam Exp $
+@comment $NetBSD: PLIST,v 1.9 2012/05/15 08:09:25 adam Exp $
 share/doc/sqlite3/34to35.html
 share/doc/sqlite3/35to36.html
 share/doc/sqlite3/about.html
@@ -559,6 +559,7 @@
 share/doc/sqlite3/releaselog/3_7_1.html
 share/doc/sqlite3/releaselog/3_7_10.html
 share/doc/sqlite3/releaselog/3_7_11.html
+share/doc/sqlite3/releaselog/3_7_12.html
 share/doc/sqlite3/releaselog/3_7_2.html
 share/doc/sqlite3/releaselog/3_7_3.html
 share/doc/sqlite3/releaselog/3_7_4.html
diff -r 9be472448a86 -r 59518d473e72 databases/sqlite3-docs/distinfo
--- a/databases/sqlite3-docs/distinfo   Tue May 15 07:18:04 2012 +0000
+++ b/databases/sqlite3-docs/distinfo   Tue May 15 08:09:25 2012 +0000
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.8 2012/03/20 21:00:47 adam Exp $
+$NetBSD: distinfo,v 1.9 2012/05/15 08:09:25 adam Exp $
 
-SHA1 (sqlite-doc-3071100.zip) = 87cbed1918c2604daefd3588a8555067e55e53cf
-RMD160 (sqlite-doc-3071100.zip) = 388bbcccb69d458f48f044bd65d282d9cf48dbe2
-Size (sqlite-doc-3071100.zip) = 4069512 bytes
+SHA1 (sqlite-doc-3071200.zip) = a5a71f0440816d731d30ad080429c971497b068d
+RMD160 (sqlite-doc-3071200.zip) = ad50b126669bb04b1a69b56d967201c7c716f52a
+Size (sqlite-doc-3071200.zip) = 4083373 bytes
diff -r 9be472448a86 -r 59518d473e72 databases/sqlite3-tcl/Makefile
--- a/databases/sqlite3-tcl/Makefile    Tue May 15 07:18:04 2012 +0000
+++ b/databases/sqlite3-tcl/Makefile    Tue May 15 08:09:25 2012 +0000
@@ -1,8 +1,7 @@
-# $NetBSD: Makefile,v 1.32 2012/04/27 12:31:40 obache Exp $
+# $NetBSD: Makefile,v 1.33 2012/05/15 08:09:25 adam Exp $
 
-DISTNAME=      sqlite-autoconf-3071100
-PKGNAME=       sqlite3-tcl-3.7.11
-PKGREVISION=   1
+DISTNAME=      sqlite-autoconf-3071200
+PKGNAME=       sqlite3-tcl-3.7.12
 CATEGORIES=    databases
 MASTER_SITES=  http://www.hwaci.com/sw/sqlite/ \
                http://www.sqlite.org/
diff -r 9be472448a86 -r 59518d473e72 databases/sqlite3-tcl/distinfo
--- a/databases/sqlite3-tcl/distinfo    Tue May 15 07:18:04 2012 +0000
+++ b/databases/sqlite3-tcl/distinfo    Tue May 15 08:09:25 2012 +0000
@@ -1,7 +1,7 @@
-$NetBSD: distinfo,v 1.20 2012/03/20 21:00:47 adam Exp $
+$NetBSD: distinfo,v 1.21 2012/05/15 08:09:25 adam Exp $
 
-SHA1 (sqlite-autoconf-3071100.tar.gz) = a768f76b10df84d6a2c66178544d42725a8fdaf0
-RMD160 (sqlite-autoconf-3071100.tar.gz) = 09df3232f4eb7032c0a6081670b2bdcb6d80e865
-Size (sqlite-autoconf-3071100.tar.gz) = 1807754 bytes
+SHA1 (sqlite-autoconf-3071200.tar.gz) = 30e6b0912f074cff5563697367c2ba9608d83bd3
+RMD160 (sqlite-autoconf-3071200.tar.gz) = 395d8d137a8d5627bd85a91c4751b0a24933cee2
+Size (sqlite-autoconf-3071200.tar.gz) = 1827241 bytes
 SHA1 (patch-aa) = d4d0424eec39ede995c2c408dcf51876072d3fea
 SHA1 (patch-ab) = 64a4352b9a8ed0518784837e390541cd4e1bc9aa
diff -r 9be472448a86 -r 59518d473e72 databases/sqlite3/Makefile
--- a/databases/sqlite3/Makefile        Tue May 15 07:18:04 2012 +0000
+++ b/databases/sqlite3/Makefile        Tue May 15 08:09:25 2012 +0000
@@ -1,8 +1,7 @@
-# $NetBSD: Makefile,v 1.50 2012/04/27 12:31:40 obache Exp $
+# $NetBSD: Makefile,v 1.51 2012/05/15 08:09:25 adam Exp $
 
-DISTNAME=      sqlite-autoconf-3071100
-PKGNAME=       sqlite3-3.7.11
-PKGREVISION=   1
+DISTNAME=      sqlite-autoconf-3071200
+PKGNAME=       sqlite3-3.7.12
 CATEGORIES=    databases
 MASTER_SITES=  http://www.hwaci.com/sw/sqlite/ \
                http://www.sqlite.org/
diff -r 9be472448a86 -r 59518d473e72 databases/sqlite3/distinfo
--- a/databases/sqlite3/distinfo        Tue May 15 07:18:04 2012 +0000
+++ b/databases/sqlite3/distinfo        Tue May 15 08:09:25 2012 +0000
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.67 2012/03/20 21:00:47 adam Exp $
+$NetBSD: distinfo,v 1.68 2012/05/15 08:09:25 adam Exp $
 
-SHA1 (sqlite-autoconf-3071100.tar.gz) = a768f76b10df84d6a2c66178544d42725a8fdaf0
-RMD160 (sqlite-autoconf-3071100.tar.gz) = 09df3232f4eb7032c0a6081670b2bdcb6d80e865
-Size (sqlite-autoconf-3071100.tar.gz) = 1807754 bytes
+SHA1 (sqlite-autoconf-3071200.tar.gz) = 30e6b0912f074cff5563697367c2ba9608d83bd3
+RMD160 (sqlite-autoconf-3071200.tar.gz) = 395d8d137a8d5627bd85a91c4751b0a24933cee2
+Size (sqlite-autoconf-3071200.tar.gz) = 1827241 bytes
Prev by Date: [pkgsrc/trunk]: pkgsrc/chat/meanwhile Bump PKGREVISION, last patches for late...
Next by Date: [pkgsrc/trunk]: pkgsrc/audio/pulseaudio fix borked __NetBSD_Version__ in last
Previous by Thread: [pkgsrc/trunk]: pkgsrc/chat/meanwhile Bump PKGREVISION, last patches for late...
Next by Thread: [pkgsrc/trunk]: pkgsrc/audio/pulseaudio fix borked __NetBSD_Version__ in last
Indexes:
Home | Main Index | Thread Index | Old Index