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

To: pkgsrc-changes-hg%NetBSD.org@localhost
Subject: [pkgsrc/trunk]: pkgsrc/databases Changes 3.8.5:
From: adam <adam%pkgsrc.org@localhost>
Date: Thu, 14 Oct 2021 15:58:44 +0000
details:   https://anonhg.NetBSD.org/pkgsrc/rev/3785ee1d0a05
branches:  trunk
changeset: 635418:3785ee1d0a05
user:      adam <adam%pkgsrc.org@localhost>
date:      Thu Jun 05 15:10:20 2014 +0000

description:
Changes 3.8.5:
Added support for partial sorting by index.
Enhance the query planner so that it always prefers an index that uses a superset of WHERE clause terms relative to some other index.
Improvements to the automerge command of FTS4 to better control the index size for a full-text index that is subject to a large number of updates.
Added the sqlite3_rtree_query_callback() interface to R-Tree extension
Added new URI query parameters "nolock" and "immutable".
Use less memory by not remembering CHECK constraints on read-only database connections.
Enable the OR optimization for WITHOUT ROWID tables.
Render expressions of the form "x IN (?)" (with a single value in the list on the right-hand side of the IN operator) as if they where "x==?", Similarly optimize "x NOT IN (?)"
Add the ".system" and ".once" commands to the command-line shell.
Added the SQLITE_IOCAP_IMMUTABLE bit to the set of bits that can be returned by the xDeviceCharacteristics method of a VFS.
Added the SQLITE_TESTCTRL_BYTEORDER test control.


Bug Fixes:
----------
OFFSET clause ignored on queries without a FROM clause.
Assertion fault on queries involving expressions of the form "x IN (?)".
Incorrect column datatype reported.
Duplicate row returned on a query against a table with more than 16 indices, each on a separate column, and all used via OR-connected constraints.
Partial index causes assertion fault on UPDATE OR REPLACE.
Crash when calling undocumented SQL function sqlite_rename_parent() with NULL parameters.
ORDER BY ignored if the query has an identical GROUP BY.
The group_concat(x,'') SQL function returns NULL instead of an empty string when all inputs are empty strings.
Fix a bug in the VDBE code generator that caused crashes when doing an INSERT INTO ... SELECT statement where the number of columns being inserted is larger than the number of columns in the 
destination table.
Fix a problem in CSV import in the command-line shell where if the leftmost field of the first row in the CSV file was both zero bytes in size and unquoted no data would be imported.
Fix a problem in FTS4 where the left-most column that contained the notindexed column name as a prefix was not indexed rather than the column whose name matched exactly.
Fix the sqlite3_db_readonly() interface so that it returns true if the database is read-only due to the file format write version number being too large.

diffstat:

 databases/sqlite3-docs/Makefile |  6 +++---
 databases/sqlite3-docs/PLIST    |  6 +++++-
 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, 26 insertions(+), 24 deletions(-)

diffs (125 lines):

diff -r 968c98688396 -r 3785ee1d0a05 databases/sqlite3-docs/Makefile
--- a/databases/sqlite3-docs/Makefile   Thu Jun 05 13:36:38 2014 +0000
+++ b/databases/sqlite3-docs/Makefile   Thu Jun 05 15:10:20 2014 +0000
@@ -1,7 +1,7 @@
-# $NetBSD: Makefile,v 1.30 2014/04/03 19:44:42 adam Exp $
+# $NetBSD: Makefile,v 1.31 2014/06/05 15:10:20 adam Exp $
 
-DISTNAME=      sqlite-doc-3080403
-PKGNAME=       sqlite3-docs-3.8.4.3
+DISTNAME=      sqlite-doc-3080500
+PKGNAME=       sqlite3-docs-3.8.5
 CATEGORIES=    databases
 MASTER_SITES=  http://www.hwaci.com/sw/sqlite/2014/ \
                http://www.sqlite.org/2014/
diff -r 968c98688396 -r 3785ee1d0a05 databases/sqlite3-docs/PLIST
--- a/databases/sqlite3-docs/PLIST      Thu Jun 05 13:36:38 2014 +0000
+++ b/databases/sqlite3-docs/PLIST      Thu Jun 05 15:10:20 2014 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.28 2014/04/03 19:44:42 adam Exp $
+@comment $NetBSD: PLIST,v 1.29 2014/06/05 15:10:20 adam Exp $
 share/doc/sqlite3/34to35.html
 share/doc/sqlite3/35to36.html
 share/doc/sqlite3/about.html
@@ -176,6 +176,7 @@
 share/doc/sqlite3/capi3ref.html
 share/doc/sqlite3/changes.html
 share/doc/sqlite3/cintro.html
+share/doc/sqlite3/cli.html
 share/doc/sqlite3/compile.html
 share/doc/sqlite3/conflict.html
 share/doc/sqlite3/consortium.html
@@ -203,6 +204,7 @@
 share/doc/sqlite3/faq.html
 share/doc/sqlite3/favicon.ico
 share/doc/sqlite3/features.html
+share/doc/sqlite3/fileformat.html
 share/doc/sqlite3/fileformat2.html
 share/doc/sqlite3/fileio.html
 share/doc/sqlite3/footprint.html
@@ -356,6 +358,7 @@
 share/doc/sqlite3/images/qp/obfruitnoidx.gif
 share/doc/sqlite3/images/qp/obrowid.gif
 share/doc/sqlite3/images/qp/orquery.gif
+share/doc/sqlite3/images/qp/partial-sort.gif
 share/doc/sqlite3/images/qp/rowidlu.gif
 share/doc/sqlite3/images/qp/tab.gif
 share/doc/sqlite3/images/qp/tpchq8.gif
@@ -616,6 +619,7 @@
 share/doc/sqlite3/releaselog/3_8_4_1.html
 share/doc/sqlite3/releaselog/3_8_4_2.html
 share/doc/sqlite3/releaselog/3_8_4_3.html
+share/doc/sqlite3/releaselog/3_8_5.html
 share/doc/sqlite3/releaselog/current.html
 share/doc/sqlite3/requirements.html
 share/doc/sqlite3/robots.txt
diff -r 968c98688396 -r 3785ee1d0a05 databases/sqlite3-docs/distinfo
--- a/databases/sqlite3-docs/distinfo   Thu Jun 05 13:36:38 2014 +0000
+++ b/databases/sqlite3-docs/distinfo   Thu Jun 05 15:10:20 2014 +0000
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.28 2014/04/03 19:44:42 adam Exp $
+$NetBSD: distinfo,v 1.29 2014/06/05 15:10:20 adam Exp $
 
-SHA1 (sqlite-doc-3080403.zip) = ce8615799a9da7fc9d2cbcd2774d77da4ba72417
-RMD160 (sqlite-doc-3080403.zip) = e2da646e75747de5e2becf3ca943487cd649b891
-Size (sqlite-doc-3080403.zip) = 4628472 bytes
+SHA1 (sqlite-doc-3080500.zip) = c5655a4004095c50dc8403661e0ed02fd4191d57
+RMD160 (sqlite-doc-3080500.zip) = eb17f2bc94b3253f64080cc983946b54e1a05872
+Size (sqlite-doc-3080500.zip) = 4446454 bytes
diff -r 968c98688396 -r 3785ee1d0a05 databases/sqlite3-tcl/Makefile
--- a/databases/sqlite3-tcl/Makefile    Thu Jun 05 13:36:38 2014 +0000
+++ b/databases/sqlite3-tcl/Makefile    Thu Jun 05 15:10:20 2014 +0000
@@ -1,8 +1,7 @@
-# $NetBSD: Makefile,v 1.60 2014/04/09 07:27:04 obache Exp $
+# $NetBSD: Makefile,v 1.61 2014/06/05 15:10:20 adam Exp $
 
-DISTNAME=      sqlite-autoconf-3080403
-PKGNAME=       sqlite3-tcl-3.8.4.3
-PKGREVISION=   1
+DISTNAME=      sqlite-autoconf-3080500
+PKGNAME=       sqlite3-tcl-3.8.5
 CATEGORIES=    databases
 MASTER_SITES=  http://www.hwaci.com/sw/sqlite/2014/ \
                http://www.sqlite.org/2014/
diff -r 968c98688396 -r 3785ee1d0a05 databases/sqlite3-tcl/distinfo
--- a/databases/sqlite3-tcl/distinfo    Thu Jun 05 13:36:38 2014 +0000
+++ b/databases/sqlite3-tcl/distinfo    Thu Jun 05 15:10:20 2014 +0000
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.41 2014/04/03 19:44:42 adam Exp $
+$NetBSD: distinfo,v 1.42 2014/06/05 15:10:20 adam Exp $
 
-SHA1 (sqlite-autoconf-3080403.tar.gz) = 70f3b100fa22e5bfebfe1b0a2102612e3c6c53fb
-RMD160 (sqlite-autoconf-3080403.tar.gz) = 1122787dd19f45f73ed06a0b936e65f040062968
-Size (sqlite-autoconf-3080403.tar.gz) = 1937379 bytes
+SHA1 (sqlite-autoconf-3080500.tar.gz) = 7f667e10ccebc26ab2086b8a30cb0a600ca0acae
+RMD160 (sqlite-autoconf-3080500.tar.gz) = b8da5ec594ac808da85469349c7506bd343946bf
+Size (sqlite-autoconf-3080500.tar.gz) = 1957050 bytes
 SHA1 (patch-aa) = 4a12a16498d04e1031dc0802fda731b73e98a32d
diff -r 968c98688396 -r 3785ee1d0a05 databases/sqlite3/Makefile
--- a/databases/sqlite3/Makefile        Thu Jun 05 13:36:38 2014 +0000
+++ b/databases/sqlite3/Makefile        Thu Jun 05 15:10:20 2014 +0000
@@ -1,8 +1,7 @@
-# $NetBSD: Makefile,v 1.78 2014/04/09 07:26:56 obache Exp $
+# $NetBSD: Makefile,v 1.79 2014/06/05 15:10:20 adam Exp $
 
-DISTNAME=      sqlite-autoconf-3080403
-PKGNAME=       sqlite3-3.8.4.3
-PKGREVISION=   1
+DISTNAME=      sqlite-autoconf-3080500
+PKGNAME=       sqlite3-3.8.5
 CATEGORIES=    databases
 MASTER_SITES=  http://www.hwaci.com/sw/sqlite/2014/ \
                http://www.sqlite.org/2014/
diff -r 968c98688396 -r 3785ee1d0a05 databases/sqlite3/distinfo
--- a/databases/sqlite3/distinfo        Thu Jun 05 13:36:38 2014 +0000
+++ b/databases/sqlite3/distinfo        Thu Jun 05 15:10:20 2014 +0000
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.88 2014/04/03 19:44:42 adam Exp $
+$NetBSD: distinfo,v 1.89 2014/06/05 15:10:20 adam Exp $
 
-SHA1 (sqlite-autoconf-3080403.tar.gz) = 70f3b100fa22e5bfebfe1b0a2102612e3c6c53fb
-RMD160 (sqlite-autoconf-3080403.tar.gz) = 1122787dd19f45f73ed06a0b936e65f040062968
-Size (sqlite-autoconf-3080403.tar.gz) = 1937379 bytes
+SHA1 (sqlite-autoconf-3080500.tar.gz) = 7f667e10ccebc26ab2086b8a30cb0a600ca0acae
+RMD160 (sqlite-autoconf-3080500.tar.gz) = b8da5ec594ac808da85469349c7506bd343946bf
+Size (sqlite-autoconf-3080500.tar.gz) = 1957050 bytes
Prev by Date: [pkgsrc/trunk]: pkgsrc/databases/p5-DBD-SQLite Update to 1.42. From the chang...
Next by Date: [pkgsrc/trunk]: pkgsrc/devel/p5-FindBin-libs Update to 1.9. From the changelog:
Previous by Thread: [pkgsrc/trunk]: pkgsrc/databases/p5-DBD-SQLite Update to 1.42. From the chang...
Next by Thread: [pkgsrc/trunk]: pkgsrc/devel/p5-FindBin-libs Update to 1.9. From the changelog:
Indexes:
Home | Main Index | Thread Index | Old Index