CVS commit: pkgsrc/databases

To: pkgsrc-changes%NetBSD.org@localhost
Subject: CVS commit: pkgsrc/databases
From: "Adam Ciarcinski" <adam%netbsd.org@localhost>
Date: Wed, 24 May 2017 19:41:03 +0000

Module Name:    pkgsrc
Committed By:   adam
Date:           Wed May 24 19:41:03 UTC 2017

Modified Files:
        pkgsrc/databases/sqlite3: Makefile Makefile.version PLIST distinfo
        pkgsrc/databases/sqlite3-docs: PLIST distinfo
        pkgsrc/databases/sqlite3-tcl: Makefile distinfo

Log Message:
SQLite Release 3.19.0
---------------------
The SQLITE_READ authorizer callback is invoked once with a column name that is an empty string for every table referenced in a query from which no columns are extracted.
When using an index on an expression, try to use expression values already available in the index, rather than loading the original columns and recomputing the expression.
Enhance the flattening optimization so that it is able to flatten views on the right-hand side of a LEFT JOIN.
Use replace() instead of char() for escaping newline and carriage-return characters embedded in strings in the .dump output from the command-line shell.
Avoid unnecessary foreign key processing in UPDATE statements that do not touch the columns that are constrained by the foreign keys.
On a DISTINCT query that uses an index, try to skip ahead to the next distinct entry using the index rather than stepping through rows, when an appropriate index is available.
Avoid unnecessary invalidation of sqlite3_blob handles when making changes to unrelated tables.
Transfer any terms of the HAVING clause that use only columns mentioned in the GROUP BY clause over to the WHERE clause for faster processing.
Reuse the same materialization of a VIEW if that VIEW appears more than once in the same query.
Enhance PRAGMA integrity_check so that it identifies tables that have two or more rows with the same rowid.
Enhance the FTS5 query syntax so that column filters may be applied to arbitrary expressions.
Enhance the json_extract() function to cache and reuse parses of JSON input text.
Added the anycollseq.c loadable extension that allows a generic SQLite database connection to read a schema that contains unknown and/or application-specific collating sequences.

Bug Fixes:
----------
Fix a problem in REPLACE that can result in a corrupt database containing two or more rows with the same rowid.
Fix a problem in PRAGMA integrity_check that was causing a subsequent VACUUM to behave suboptimally.
Fix the PRAGMA foreign_key_check command so that it works correctly with foreign keys on WITHOUT ROWID tables.
Disallow leading zeros in numeric constants in JSON.
Disallow control characters inside of strings in JSON.
Limit the depth of recursion for JSON objects and arrays in order to avoid excess stack usage in the recursive descent parser.


To generate a diff of this commit:
cvs rdiff -u -r1.116 -r1.117 pkgsrc/databases/sqlite3/Makefile
cvs rdiff -u -r1.31 -r1.32 pkgsrc/databases/sqlite3/Makefile.version
cvs rdiff -u -r1.4 -r1.5 pkgsrc/databases/sqlite3/PLIST
cvs rdiff -u -r1.133 -r1.134 pkgsrc/databases/sqlite3/distinfo
cvs rdiff -u -r1.67 -r1.68 pkgsrc/databases/sqlite3-docs/PLIST
cvs rdiff -u -r1.68 -r1.69 pkgsrc/databases/sqlite3-docs/distinfo
cvs rdiff -u -r1.85 -r1.86 pkgsrc/databases/sqlite3-tcl/Makefile
cvs rdiff -u -r1.81 -r1.82 pkgsrc/databases/sqlite3-tcl/distinfo

Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.

Modified files:

Index: pkgsrc/databases/sqlite3/Makefile
diff -u pkgsrc/databases/sqlite3/Makefile:1.116 pkgsrc/databases/sqlite3/Makefile:1.117
--- pkgsrc/databases/sqlite3/Makefile:1.116     Sat Apr 22 21:03:08 2017
+++ pkgsrc/databases/sqlite3/Makefile   Wed May 24 19:41:03 2017
@@ -1,6 +1,5 @@
-# $NetBSD: Makefile,v 1.116 2017/04/22 21:03:08 adam Exp $
+# $NetBSD: Makefile,v 1.117 2017/05/24 19:41:03 adam Exp $
 
-PKGREVISION= 1
 .include "Makefile.common"
 
 PKGNAME=       sqlite3-${SQLITE3_VERSION}

Index: pkgsrc/databases/sqlite3/Makefile.version
diff -u pkgsrc/databases/sqlite3/Makefile.version:1.31 pkgsrc/databases/sqlite3/Makefile.version:1.32
--- pkgsrc/databases/sqlite3/Makefile.version:1.31      Thu Mar 30 15:55:12 2017
+++ pkgsrc/databases/sqlite3/Makefile.version   Wed May 24 19:41:03 2017
@@ -1,12 +1,12 @@
-# $NetBSD: Makefile.version,v 1.31 2017/03/30 15:55:12 adam Exp $
+# $NetBSD: Makefile.version,v 1.32 2017/05/24 19:41:03 adam Exp $
 #
 # used by databases/sqlite3/Makefile
 # used by databases/sqlite3-docs/Makefile
 # used by databases/sqlite3-tcl/Makefile
 # used by devel/lemon/Makefile
 
-SQLITE3_DISTVERSION=   3180000
-SQLITE3_VERSION=       3.18.0
+SQLITE3_DISTVERSION=   3190000
+SQLITE3_VERSION=       3.19.0
 
 MASTER_SITES=  http://www.hwaci.com/sw/sqlite/2017/
 MASTER_SITES+= http://www.sqlite.org/2017/

Index: pkgsrc/databases/sqlite3/PLIST
diff -u pkgsrc/databases/sqlite3/PLIST:1.4 pkgsrc/databases/sqlite3/PLIST:1.5
--- pkgsrc/databases/sqlite3/PLIST:1.4  Thu Jan 11 19:08:48 2007
+++ pkgsrc/databases/sqlite3/PLIST      Wed May 24 19:41:03 2017
@@ -1,5 +1,6 @@
-@comment $NetBSD: PLIST,v 1.4 2007/01/11 19:08:48 drochner Exp $
+@comment $NetBSD: PLIST,v 1.5 2017/05/24 19:41:03 adam Exp $
 bin/sqlite3
+include/msvc.h
 include/sqlite3.h
 include/sqlite3ext.h
 lib/libsqlite3.la

Index: pkgsrc/databases/sqlite3/distinfo
diff -u pkgsrc/databases/sqlite3/distinfo:1.133 pkgsrc/databases/sqlite3/distinfo:1.134
--- pkgsrc/databases/sqlite3/distinfo:1.133     Thu Mar 30 15:55:12 2017
+++ pkgsrc/databases/sqlite3/distinfo   Wed May 24 19:41:03 2017
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.133 2017/03/30 15:55:12 adam Exp $
+$NetBSD: distinfo,v 1.134 2017/05/24 19:41:03 adam Exp $
 
-SHA1 (sqlite-autoconf-3180000.tar.gz) = 74559194e1dd9b9d577cac001c0e9d370856671b
-RMD160 (sqlite-autoconf-3180000.tar.gz) = dca1a652fa28133f505daba50a021d90891f0ea2
-SHA512 (sqlite-autoconf-3180000.tar.gz) = 4c2efda1d63d1849f7a351cc57c02cc1820efe3c19f88460a131a1d6ae4f7411e4b7672a5581055e581093df29f65cebd9ff5b24125c18802523b17477dce1ef
-Size (sqlite-autoconf-3180000.tar.gz) = 2533004 bytes
+SHA1 (sqlite-autoconf-3190000.tar.gz) = 25f274e379362cbb17560e72ab886d50e0be2afe
+RMD160 (sqlite-autoconf-3190000.tar.gz) = 8f511284380db843e1f9600bdf4692953f9cbccf
+SHA512 (sqlite-autoconf-3190000.tar.gz) = 3aa8306e1cb26ad18e34a03ea8c1ddfbdf923d4064a64b61d28a11571339dfafa5ad57e65aad2b3fcc8a6a4faad364f5bda28e88fc67f1012229a506c3ced422
+Size (sqlite-autoconf-3190000.tar.gz) = 2542337 bytes

Index: pkgsrc/databases/sqlite3-docs/PLIST
diff -u pkgsrc/databases/sqlite3-docs/PLIST:1.67 pkgsrc/databases/sqlite3-docs/PLIST:1.68
--- pkgsrc/databases/sqlite3-docs/PLIST:1.67    Tue Apr  4 17:12:22 2017
+++ pkgsrc/databases/sqlite3-docs/PLIST Wed May 24 19:41:03 2017
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.67 2017/04/04 17:12:22 adam Exp $
+@comment $NetBSD: PLIST,v 1.68 2017/05/24 19:41:03 adam Exp $
 share/doc/sqlite3/34to35.html
 share/doc/sqlite3/35to36.html
 share/doc/sqlite3/about.html
@@ -233,6 +233,7 @@ share/doc/sqlite3/errlog.html
 share/doc/sqlite3/expridx.html
 share/doc/sqlite3/famous.html
 share/doc/sqlite3/faq.html
+share/doc/sqlite3/fasterthanfs.html
 share/doc/sqlite3/favicon.ico
 share/doc/sqlite3/features.html
 share/doc/sqlite3/fileformat.html
@@ -579,6 +580,7 @@ share/doc/sqlite3/releaselog/3_16_1.html
 share/doc/sqlite3/releaselog/3_16_2.html
 share/doc/sqlite3/releaselog/3_17_0.html
 share/doc/sqlite3/releaselog/3_18_0.html
+share/doc/sqlite3/releaselog/3_19_0.html
 share/doc/sqlite3/releaselog/3_1_0.html
 share/doc/sqlite3/releaselog/3_1_1.html
 share/doc/sqlite3/releaselog/3_1_2.html
@@ -854,5 +856,6 @@ share/doc/sqlite3/vfs.html
 share/doc/sqlite3/vtab.html
 share/doc/sqlite3/wal.html
 share/doc/sqlite3/whentouse.html
+share/doc/sqlite3/whyc.html
 share/doc/sqlite3/withoutrowid.html
 share/doc/sqlite3/zeroconf.html

Index: pkgsrc/databases/sqlite3-docs/distinfo
diff -u pkgsrc/databases/sqlite3-docs/distinfo:1.68 pkgsrc/databases/sqlite3-docs/distinfo:1.69
--- pkgsrc/databases/sqlite3-docs/distinfo:1.68 Thu Mar 30 15:55:12 2017
+++ pkgsrc/databases/sqlite3-docs/distinfo      Wed May 24 19:41:03 2017
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.68 2017/03/30 15:55:12 adam Exp $
+$NetBSD: distinfo,v 1.69 2017/05/24 19:41:03 adam Exp $
 
-SHA1 (sqlite-doc-3180000.zip) = 36fac5aa864683d186410c75d2f6e3176beddc7d
-RMD160 (sqlite-doc-3180000.zip) = c45758f9a0d9997eb370599b15e781912a6b1ff9
-SHA512 (sqlite-doc-3180000.zip) = 7b65130cb2174d823842cddc912432d206044a8b276fdc2eef437854de7d0b05b8eb5d7aec0ead5c3f88bb7788ae5f1c42ffb1e43ab00774a68f6f7fea72d517
-Size (sqlite-doc-3180000.zip) = 5552381 bytes
+SHA1 (sqlite-doc-3190000.zip) = ee1166d7457f2c918fc0068512d9d7275f5f4866
+RMD160 (sqlite-doc-3190000.zip) = 405ff3bd8275549b0dbfc0181b09da7c5285b161
+SHA512 (sqlite-doc-3190000.zip) = 88db4b0c6a2a9373a40cb14ab3d7c5d4cb7d1854cb67bed281ad17048a7976262d81866a15b4bb8f221e14416337a0fc2955503cf42a5e373a22a7849b0ebbba
+Size (sqlite-doc-3190000.zip) = 5569300 bytes

Index: pkgsrc/databases/sqlite3-tcl/Makefile
diff -u pkgsrc/databases/sqlite3-tcl/Makefile:1.85 pkgsrc/databases/sqlite3-tcl/Makefile:1.86
--- pkgsrc/databases/sqlite3-tcl/Makefile:1.85  Sat Apr 22 21:03:29 2017
+++ pkgsrc/databases/sqlite3-tcl/Makefile       Wed May 24 19:41:03 2017
@@ -1,6 +1,5 @@
-# $NetBSD: Makefile,v 1.85 2017/04/22 21:03:29 adam Exp $
+# $NetBSD: Makefile,v 1.86 2017/05/24 19:41:03 adam Exp $
 
-PKGREVISION= 1
 .include "../../databases/sqlite3/Makefile.common"
 
 PKGNAME=       sqlite3-tcl-${SQLITE3_VERSION}

Index: pkgsrc/databases/sqlite3-tcl/distinfo
diff -u pkgsrc/databases/sqlite3-tcl/distinfo:1.81 pkgsrc/databases/sqlite3-tcl/distinfo:1.82
--- pkgsrc/databases/sqlite3-tcl/distinfo:1.81  Thu Mar 30 15:55:12 2017
+++ pkgsrc/databases/sqlite3-tcl/distinfo       Wed May 24 19:41:03 2017
@@ -1,7 +1,7 @@
-$NetBSD: distinfo,v 1.81 2017/03/30 15:55:12 adam Exp $
+$NetBSD: distinfo,v 1.82 2017/05/24 19:41:03 adam Exp $
 
-SHA1 (sqlite-autoconf-3180000.tar.gz) = 74559194e1dd9b9d577cac001c0e9d370856671b
-RMD160 (sqlite-autoconf-3180000.tar.gz) = dca1a652fa28133f505daba50a021d90891f0ea2
-SHA512 (sqlite-autoconf-3180000.tar.gz) = 4c2efda1d63d1849f7a351cc57c02cc1820efe3c19f88460a131a1d6ae4f7411e4b7672a5581055e581093df29f65cebd9ff5b24125c18802523b17477dce1ef
-Size (sqlite-autoconf-3180000.tar.gz) = 2533004 bytes
+SHA1 (sqlite-autoconf-3190000.tar.gz) = 25f274e379362cbb17560e72ab886d50e0be2afe
+RMD160 (sqlite-autoconf-3190000.tar.gz) = 8f511284380db843e1f9600bdf4692953f9cbccf
+SHA512 (sqlite-autoconf-3190000.tar.gz) = 3aa8306e1cb26ad18e34a03ea8c1ddfbdf923d4064a64b61d28a11571339dfafa5ad57e65aad2b3fcc8a6a4faad364f5bda28e88fc67f1012229a506c3ced422
+Size (sqlite-autoconf-3190000.tar.gz) = 2542337 bytes
 SHA1 (patch-aa) = 4a12a16498d04e1031dc0802fda731b73e98a32d

Prev by Date: CVS commit: pkgsrc/audio/arts
Next by Date: CVS commit: pkgsrc/devel/py-attrs
Previous by Thread: CVS commit: pkgsrc/audio/arts
Next by Thread: CVS commit: pkgsrc/devel/py-attrs
Indexes:

Home | Main Index | Thread Index | Old Index